SET ECHO ON

CREATE TABLE EPAL 
	(email	VARCHAR(32)	NOT NULL,
	type	varchar(8)	NOT NULL,
	want	varchar(8)	NOT NULL,
	interest1	number(4),
	interest2	number(4),
	interest3	number(4),
	interest4	number(4),
	interest5	number(4),
	CONSTRAINT id_pkey PRIMARY KEY(email),
	CONSTRAINT type_check CHECK (type in ('MALE', 'FEMALE', 'EPERSON')),
	CONSTRAINT want_check CHECK (want in ('MALE', 'FEMALE', 'EPERSON', 'ANY'))
);

PAUSE Press RETURN to continue

INSERT INTO EPAL VALUES
       ('wjh034', 'EPERSON', 'ANY', 2, 4, 8, 16, 32 );
	
INSERT INTO EPAL VALUES
       ('pfk031', 'MALE', 'FEMALE', 1, 9, 20, 22, 32 );