SQLize | PHPize | SQLtest

CREATE TABLE PROJECTS ( PROJID NUMBER(4) NOT NULL, PRIMARY KEY, P_DESC VARCHAR2(20), P_START_DATE DATE, P_END_DATE DATE, BUDJET_AMOUNT NUMBER (7, 2), MAX_NO_STAFF NUMBER (4, 0), CHECK (P_END_DATE >= P_START_DATE) ); CREATE TABLE ASSIGMENTS2 ( PROJID NUMBER(4,0) NOT NULL, CONSTRAINT ASSIGMENTS2_PROJID_FK FOREIGN KEY (PROJID) REFERENCES PROJECTS (PROJID), EMPNO NUMBER(4,0) NOT NULL, CONSTRAINT ASSIGMENTS2_EMPNO_FK FOREIGN KEY (EMPNO) REFERENCES EMP (EMPNO), A_START_DATE DATE, A_END_DATE DATE, BILL_RATE NUMBER(4,2), ASSIGN_TYPE VARCHAR2(2 BYTE), HOURS NUMBER ); CREATE TABLE hr_men2 ( id NUMBER(8)CONSTRAINT hr_men_pk PRIMARY KEY, name VARCHAR2(30) NOT NULL, birthday DATE ); CREATE TABLE hr_women2 ( id NUMBER(8) CONSTRAINT hr_women_pk PRIMARY KEY, name VARCHAR2(30) NOT NULL, birthday DATE ); CREATE TABLE HR_FAMILY_Traditional ( husband_id NUMBER(8), CONSTRAINT fk_husband_id FOREIGN KEY (husband_id) REFERENCES hr_men2 (id), wife_id NUMBER(8), CONSTRAINT fk_wife_id FOREIGN KEY (wife_id) REFERENCES hr_women2 (id), CONSTRAINT pk_family_traditional PRIMARY KEY (husband_id, wife_id) ); CREATE TABLE HR_FAMILY_Polygamy ( husband_id NUMBER(8), CONSTRAINT hr_family_polygamy_husband_fk REFERENCES hr_men(id), wife_id NUMBER(8), CONSTRAINT hr_family_polygamy_wife_fk REFERENCES hr_women(id), CONSTRAINT hr_family_polygamy_pk PRIMARY KEY (wife_id) );