Syntax error

CREATE TABLE STAFF
(
STAFF_ID    VARCHAR(20)
STAFF_TYPE  VARCHAR(30)
SCHOOL_ID     VARCHAR(20)
FIRST NAME     VARCHAR(100) NOT NULL
LAST NAME     vARCHAR(100) NOT NULL
AGE             INT
DOB             DATE
GENDER         VARCHAR(10) CHECK (GENDER IN ('M', 'F'))
JOIN_DATE      DATE
ADDRESS ID      VARCHAR(20)
CONSTRAINT PK_STF PRIMARY KEY (STAFF_ID)
CONSTRAINT FK_STAFF_SCHOOL FOREIGN KEY(SCHOOL_ID) REFERENCES SCHOOL(SCHOOL_ID)
CONSTRAINT FK_STAFF_ADDR FOREIGN KEY(ADDRESS_ID) REFERENCES ADDRESS(ADDRESS_ID)
);

0 0 54
0 REPLIES 0
Top Labels in this Space
Top Solution Authors