| drop table STUD_COURSE | |
| drop table COURSE | |
| drop table STUDENT | |
| drop table DEPT | |
| drop table ACCOUNT | |
| drop table ADDRESS | |
| go | |
| create table ADDRESS ( | |
| ADDRESSID NUMERIC(38), | |
| STREET VARCHAR(255), | |
| CODE NUMERIC(38), | |
| CITY VARCHAR(255), | |
| STATE VARCHAR(255), | |
| CONSTRAINT ADDR_CT PRIMARY KEY (ADDRESSID) | |
| ) | |
| create table ACCOUNT ( | |
| ACCOUNTID VARCHAR(255), | |
| FEESPAID NUMERIC(38,2), | |
| FEESDUE NUMERIC(38,2), | |
| DUEDATE DATETIME, | |
| CONSTRAINT ACC_CT PRIMARY KEY (ACCOUNTID) | |
| ) | |
| create table DEPT ( | |
| DEPTID NUMERIC(38), | |
| DEPTNAME VARCHAR(255), | |
| CONSTRAINT DEPT_CT PRIMARY KEY (DEPTID) | |
| ) | |
| create table STUDENT ( | |
| STUDENTID NUMERIC(38), | |
| STUDENTNAME VARCHAR(255), | |
| DEPTID NUMERIC(38), | |
| ADDRESSID NUMERIC(38), | |
| ACCOUNTID VARCHAR(255), | |
| CONSTRAINT ST_CT PRIMARY KEY (STUDENTID), | |
| FOREIGN KEY (DEPTID) REFERENCES DEPT (DEPTID), | |
| FOREIGN KEY (ADDRESSID) REFERENCES ADDRESS (ADDRESSID), | |
| FOREIGN KEY (ACCOUNTID) REFERENCES ACCOUNT (ACCOUNTID) | |
| ) | |
| create table COURSE ( | |
| COURSEID NUMERIC(38), | |
| DEPTID NUMERIC(38), | |
| COURSENAME VARCHAR(255), | |
| SYLABUS IMAGE, | |
| CONSTRAINT COURSE_CT PRIMARY KEY (COURSEID), | |
| FOREIGN KEY (DEPTID) REFERENCES DEPT (DEPTID) | |
| ) | |
| create table STUD_COURSE ( | |
| COURSEID NUMERIC(38), | |
| STUDENTID NUMERIC(38), | |
| CONSTRAINT STCO_CT PRIMARY KEY (COURSEID, STUDENTID), | |
| FOREIGN KEY (COURSEID) REFERENCES COURSE (COURSEID), | |
| FOREIGN KEY (STUDENTID) REFERENCES STUDENT (STUDENTID) | |
| ) | |
| go | |