create type survey_objtyp as object (
	survey_id number(5),
	attraction_id ref attraction_objtyp, /* Which attraction the survey is about */
	member_id ref member_objtyp, /* Which member filled out this survey */
	speed number(2), /* A series of 1-10 values scoring the stats of the ride */
	loops number(2),
	thrill number(2),
	survey_date date /* What date the survey was filled out on */
);
/

create table survey_objtab of survey_objtyp (survey_id primary key)
object identifier is system generated;