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)