DAS Assignment
Tables (11)
advisor
- id — int — Primary key — NOT NULL
- name — string — NOT NULL
- position — string — NOT NULL
- department — string — NOT NULL
- contact_number — string — NOT NULL
- room_number — string — NOT NULL
course
- id — int — Primary key — NOT NULL
- code — string
- title — string — NOT NULL
- leader_name — string — NOT NULL
- contact_number — string — NOT NULL
- room_number — string — NOT NULL
- department — string — NOT NULL
flat
- id — int — Primary key — NOT NULL
- number — string — NOT NULL
- address — string — NOT NULL
- no_availability — string — NOT NULL
- monthly_rate — double — NOT NULL
inspection
- id — int — Primary key — NOT NULL
- residence_room_id — int — Foreign key → residence_room.id
- residence_hall_id — int — Foreign key → residence_hall.id — NOT NULL
- flat_id — int — Foreign key → flat.id
- staff_lodging_office_id — int — Foreign key → staff_lodging_office.id — NOT NULL
- date — date
- condition — boolean — NOT NULL
- comment — string
lease_agreement
- id — int — Primary key — NOT NULL
- student_id — int — Foreign key → student.id — NOT NULL
- flat_id — int — Foreign key → flat.id
- residence_room_id — int — Foreign key → residence_room.id
- lease_number — string — NOT NULL
- entry_date — datetime — NOT NULL
- exit_date — datetime — NOT NULL
- duration — string — NOT NULL
- status — string — NOT NULL
next_of_kin
- id — int — Primary key — NOT NULL
- student_id — int — Foreign key → student.id — NOT NULL
- name — string — NOT NULL
- address — string — NOT NULL
- contact_number — string — NOT NULL
- relationship — string — NOT NULL
residence_hall
- id — int — Primary key — NOT NULL
- hall_number — string — NOT NULL
- address — string — NOT NULL
- contact_number — string — NOT NULL
- manager_name — string — NOT NULL
residence_room
- id — int — Primary key — NOT NULL
- residence_hall_id — int — Foreign key → residence_hall.id — NOT NULL
- residence_room_number — string — NOT NULL
- monthly_rate — double — NOT NULL
staff_lodging_office
- id — int — Primary key — NOT NULL
- staff_number — string — NOT NULL
- name — string — NOT NULL
- address — string — NOT NULL
- dob — datetime
- sex — string — NOT NULL
- position — string — NOT NULL
- location — string — NOT NULL
student
- id — int — Primary key — NOT NULL
- advisor_id — int — Foreign key → advisor.id — NOT NULL
- matriculation_number — int — NOT NULL
- name — string — NOT NULL
- address — string — NOT NULL
- dob — datetime — NOT NULL
- sex — string — NOT NULL
- nationality — string — NOT NULL
- smoker_status — boolean
- category — int — NOT NULL
- status — string — NOT NULL
student_course
- id — int — Primary key — NOT NULL
- student_id — int — Foreign key → student.id — NOT NULL
- course_id — int — Foreign key → course.id — NOT NULL
- status — string — NOT NULL