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