1 create sequence reference_types_seq start with 1000;
3 create table reference_types (
4 reference_type_id number(11) primary key,
5 type_label varchar2(50) default null,
6 abbreviation varchar2(50) default null,
7 description varchar2(50) default null
10 create table reference_codes (
11 reference_type_id number(11),
12 reference_code number(11),
13 code_label varchar2(50) default null,
14 abbreviation varchar2(50) default null,
15 description varchar2(50) default null
18 create sequence products_seq start with 1000;
20 create table products (
21 id number(11) primary key,
22 name varchar2(50) default null
25 create table tariffs (
28 amount number(11) default null,
29 constraint tariffs_pk primary key (tariff_id, start_date)
32 create table product_tariffs (
33 product_id number(11),
35 tariff_start_date date,
36 constraint product_tariffs_pk primary key (product_id, tariff_id, tariff_start_date)
39 create table suburbs (
42 name varchar2(50) not null,
43 constraint suburbs_pk primary key (city_id, suburb_id)
46 create sequence streets_seq start with 1000;
48 create table streets (
49 id number(11) primary key,
50 city_id number(11) not null,
51 suburb_id number(11) not null,
52 name varchar2(50) not null
55 create sequence users_seq start with 1000;
58 id number(11) primary key,
59 name varchar2(50) not null
62 create sequence articles_seq start with 1000;
64 create table articles (
65 id number(11) primary key,
66 name varchar2(50) not null
69 create sequence readings_seq start with 1000;
71 create table readings (
72 id number(11) primary key,
73 user_id number(11) not null,
74 article_id number(11) not null,
75 rating number(11) not null
78 create sequence groups_seq start with 1000;
81 id number(11) primary key,
82 name varchar2(50) not null
85 create table memberships (
86 user_id number(11) not null,
87 group_id number(11) not null,
88 constraint memberships_pk primary key (user_id, group_id)
91 create sequence membership_statuses_seq start with 1000;
93 create table membership_statuses (
94 id number(11) primary key,
95 user_id number(11) not null,
96 group_id number(11) not null,
97 status varchar2(50) not null
100 create table departments (
101 department_id number(11) not null,
102 location_id number(11) not null,
103 constraint departments_pk primary key (department_id, location_id)
106 create sequence employees_seq start with 1000;
108 create table employees (
109 id number(11) not null primary key,
110 department_id number(11) default null,
111 location_id number(11) default null
114 create sequence comments_seq start with 1000;
116 create table comments (
117 id number(11) not null primary key,
118 person_id varchar(100) default null,
119 person_type varchar(100) default null,
120 hack_id varchar(100) default null
124 name varchar(50) not null primary key
127 create table kitchen_sinks (
128 id_1 number(11) not null,
129 id_2 number(11) not null,
131 a_string varchar(100),
132 constraint kitchen_sinks_pk primary key (id_1, id_2)
135 create table restaurants (
136 franchise_id number(11) not null,
137 store_id number(11) not null,
139 constraint restaurants_pk primary key (franchise_id, store_id)
142 create table restaurants_suburbs (
143 franchise_id number(11) not null,
144 store_id number(11) not null,
145 city_id number(11) not null,
146 suburb_id number(11) not null
149 create sequence dorms_seq start with 1000;
152 id number(11) not null,
153 constraint dorms_pk primary key (id)
157 dorm_id number(11) not null,
158 room_id number(11) not null,
159 constraint rooms_pk primary key (dorm_id, room_id)
162 create sequence room_attributes_seq start with 1000;
164 create table room_attributes (
165 id number(11) not null,
167 constraint room_attributes_pk primary key (id)
170 create table room_attribute_assignments (
171 dorm_id number(11) not null,
172 room_id number(11) not null,
173 room_attribute_id number(11) not null
176 create sequence students_seq start with 1000;
178 create table students (
179 id number(11) not null,
180 constraint students_pk primary key (id)
183 create table room_assignments (
184 student_id number(11) not null,
185 dorm_id number(11) not null,
186 room_id number(11) not null