| 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) not null, | |
| STREET VARCHAR(255), | |
| CODE NUMERIC(38), | |
| CITY VARCHAR(255), | |
| STATE VARCHAR(255), | |
| constraint ADDR_CT primary key (ADDRESSID) | |
| ) | |
| create table ACCOUNT ( | |
| ACCOUNTID VARCHAR(255) not null, | |
| FEESPAID NUMERIC(38,2), | |
| FEESDUE NUMERIC(38,2), | |
| DUEDATE DATETIME, | |
| constraint ACC_CT primary key (ACCOUNTID) | |
| ) | |
| create table DEPT ( | |
| DEPTID NUMERIC(38) not null, | |
| DEPTNAME VARCHAR(255), | |
| constraint DEPT_CT primary key (DEPTID) | |
| ) | |
| create table STUDENT ( | |
| STUDENTID NUMERIC(38) not null, | |
| 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) not null, | |
| 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) not null, | |
| STUDENTID NUMERIC(38) not null, | |
| constraint STCO_CT primary key (COURSEID, STUDENTID), | |
| foreign key (COURSEID) references COURSE (COURSEID), | |
| foreign key (STUDENTID) references STUDENT (STUDENTID) | |
| ) | |
| go | |