hufs-studyroom

Tables (8)

Banner (Untitled8)

  • banner_id (Key) — Primary key — NOT NULL
  • banner_type (Field)
  • image_url (Field2)
  • image_url (Field3)
  • link_url (Field4)
  • active (Field5)
  • create_at (Field6)
  • update_at (Field7)

Department (Untitled4)

  • department_id (Key) — Primary key — NOT NULL
  • department_name (Field)

Reservation (Untitled)

  • reservation_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL
  • room_partition_id (Key3) — Foreign key → Room_Partition.room_partition_id — NOT NULL
  • room_id (Key22) — Foreign key → Room_Partition.room_id — NOT NULL
  • department_id (Key222) — Foreign key → Room_Partition.department_id — NOT NULL
  • department_id (Key23) — Foreign key → User.department_id — NOT NULL
  • user_id (Field)
  • room_partition_id (Field2)
  • reservation_start_time (Field3)
  • reservation_end_time (Field4)
  • state (Field5)
  • create_at (Field6)
  • update_at (Field7)

Room (Untitled3)

  • room_id (Key) — Primary key — NOT NULL
  • department_id (Key2) — Foreign key → Department.department_id — NOT NULL
  • room_name (Field)
  • department_id (Field2)

Room_Operation_Policy (Untitled7)

  • room_operation_policy_id (Key) — Primary key — NOT NULL
  • room_operation_policy_schedule_id (Key2) — Foreign key → Room_Operation_Policy_schedule.room_operation_policy_schedule_id — NOT NULL
  • room_id (Key22) — Foreign key → Room_Operation_Policy_schedule.room_id — NOT NULL
  • department_id (Key222) — Foreign key → Room_Operation_Policy_schedule.department_id — NOT NULL
  • department_id (Key3) — Foreign key → Room_Operation_Policy_schedule.department_id — NOT NULL
  • operation_start_time (Field)
  • operation_end_time (Field2)
  • each_max_minute (Field3)

Room_Operation_Policy_schedule (Untitled5)

  • room_operation_policy_schedule_id (Key) — Primary key — NOT NULL
  • room_id (Key2) — Foreign key → Room.room_id — NOT NULL
  • department_id (Key22) — Foreign key → Room.department_id — NOT NULL
  • department_id (Key3) — Foreign key → Department.department_id — NOT NULL
  • room_id (Field)
  • room_operation_policy_id (Field2)
  • policy_application_date (Field3)

Room_Partition (Untitled6)

  • room_partition_id (Key) — Primary key — NOT NULL
  • room_id (Key2) — Foreign key → Room.room_id — NOT NULL
  • department_id (Key22) — Foreign key → Room.department_id — NOT NULL
  • room_id (Field)
  • partition_number (Field2)

User (Untitled2)

  • user_id (Key) — Primary key — NOT NULL
  • department_id (Key2) — Foreign key → Department.department_id — NOT NULL
  • username (Field)
  • password (Field2)
  • serial (Field3)
  • email (Field4)
  • name (Field5)
  • service_role (Field6)
  • department_id (Field7)