-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathschool_create.sql
More file actions
114 lines (98 loc) · 1.96 KB
/
school_create.sql
File metadata and controls
114 lines (98 loc) · 1.96 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
protocol 'jdbc:derby:';
connect 'school;create=true';
create table ADDRESS (
ADDRESS_ID INTEGER NOT NULL,
ADDRESS_TYPE INTEGER,
CITY CHAR(32),
PHONE CHAR(16),
STATE CHAR(32),
STREET VARCHAR(255),
ZIP CHAR(16)
);
create table BILLING_ADDRESS (
ACCOUNT_NUMBER CHAR(16),
ADDRESS_ID INTEGER NOT NULL,
EXPIRATION_DATE TIMESTAMP,
PAYMENT_METHOD CHAR(16)
);
create table CLASSROOM (
BUILDING CHAR(64),
CLASSROOM_ID INTEGER NOT NULL,
NAME CHAR(32)
);
create table COURSE (
COURSE_ID INTEGER NOT NULL,
DETAILS VARCHAR(256),
NAME CHAR(32),
SHORT_DESCRIPTION CHAR(64)
);
create table EMPLOYEE (
ADDRESS_ID INTEGER,
AGE INTEGER,
DATE_OF_BIRTH TIMESTAMP,
EMPLOYEE_TYPE INTEGER,
FIRST_NAME VARCHAR(255),
LAST_NAME VARCHAR(255),
LOGIN CHAR(8),
MANAGER_ID INTEGER,
OFFICE CHAR(32),
PASSWORD CHAR(8),
PERSON_ID INTEGER NOT NULL,
SALARY INTEGER,
STATUS INTEGER,
DEGREE CHAR(32),
DEPARTMENT CHAR(64),
SCHEDULED_CLASS_ID INTEGER
);
create table HOME_ADDRESS (
ADDRESS_ID INTEGER NOT NULL,
EMAIL_ADDRESS CHAR(64)
);
create table PARENT (
ADDRESS_ID INTEGER,
AGE INTEGER,
DATE_OF_BIRTH TIMESTAMP,
FIRST_NAME VARCHAR(255),
LAST_NAME VARCHAR(255),
LOGIN CHAR(8),
PASSWORD CHAR(8),
PERSON_ID INTEGER NOT NULL,
STATUS INTEGER
);
create table SCHEDULE (
DAY CHAR(32),
HOURS INTEGER,
SCHEDULE_ID INTEGER NOT NULL,
TIME TIMESTAMP
);
create table SCHEDULED_CLASS (
CLASSROOM_ID INTEGER NOT NULL,
COURSE_ID INTEGER NOT NULL,
SCHEDULE_ID INTEGER NOT NULL,
SCHEDULED_CLASS_ID INTEGER NOT NULL,
TEACHER_ID INTEGER NOT NULL
);
create table STUDENT (
ADDRESS_ID INTEGER,
AGE INTEGER,
DATE_OF_BIRTH TIMESTAMP,
FIRST_NAME VARCHAR(255),
LAST_NAME VARCHAR(255),
LOGIN CHAR(8),
PASSWORD CHAR(8),
PERSON_ID INTEGER NOT NULL,
STATUS INTEGER
);
create table STUDENT_SCHEDULED_CLASS (
SCHEDULED_CLASS_ID INTEGER NOT NULL,
STUDENT_ID INTEGER NOT NULL
);
create table STUDENTPARENT (
PARENT_ID INTEGER NOT NULL,
STUDENT_ID INTEGER NOT NULL
);
create table WORK_ADDRESS (
ADDRESS_ID INTEGER NOT NULL,
COMPANY CHAR(64),
MAIL_STOP CHAR(64)
);