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