library-seat-management
Tables (6)
Untitled (location)
- Key (location_id) — Primary key — NOT NULL
- Field (name)
- Field (sector)
- Field (floor)
Untitled (manager)
- Key (manager_id) — Primary key — NOT NULL
- Field (name)
room
- Key (room_id) — Primary key — NOT NULL
- Key (location_id) — Foreign key → Untitled.Key — NOT NULL
- seat_number (total_seat_number) — int
- Field (use_seat_number) — int
- Field (availabe_user_type) — string
- Field (end_time)
- Field (start_time)
seat
- seat_id — int — Primary key — NOT NULL
- Key (room_id) — Foreign key → room.Key — NOT NULL
- Key (location_id) — Foreign key → room.Key — NOT NULL
- Field (is_full) — boolean
- Field (avaialbe_number) — int
- Field (seat_type) — int
user
- user_id — int — Primary key — NOT NULL
- name — string
- age (user_type) — string — 학생, 일반인, 관리자
- type (state) — bolean — 좌석을 사용중인지 여부
user_seat
- user_id — int — Foreign key → user.user_id — NOT NULL
- seat_id — int — Foreign key → seat.seat_id — NOT NULL
- Key — Foreign key → seat.Key — NOT NULL
- Key (location_id) — Foreign key → seat.Key — NOT NULL
- Field (start_time) — datetime
- Field (end_time) — datetime
- Field (extend_number) — int — 3회까지 가능
- Field (is_seated) — boolean — 착석했는지 여부
- Field (is_fisished)
- Field