t

Tables (6)

Customer (Untitled4)

  • cust_id (Key) — Primary key — NOT NULL
  • phone (Field)
  • name (Field2)

Movie (Untitled3)

  • movie_id (Key) — INT — Primary key — NOT NULL
  • movie_name (Field) — VARCHAR(20)
  • start_date (Field2) — DATETIME
  • finish_date (Field3) — DATETIME
  • Field4

Screen (Untitled2)

  • screen_id (Key) — INT — Primary key — NOT NULL
  • seat_count (Field) — INT
  • screen_name (Field2) — VARCHAR(3)

Seat (좌석)

  • seat_id (Key) — INT — Primary key — NOT NULL
  • screen_id (Key2) — INT — Foreign key → Screen.screen_id — NOT NULL
  • status (Field) — VARCHAR(20)
  • seat_num (Field2) — VARCHAR(4)
  • price (Field3)

Ticket (Untitled5)

  • ticket_id (Key) — INT — Primary key — NOT NULL
  • id (Key3) — INT — Foreign key → screenPeriod.id — NOT NULL
  • seat_id (Key5) — INT — Foreign key → Seat.seat_id — NOT NULL
  • cust_id (Key4) — Foreign key → Customer.cust_id — NOT NULL
  • movie_id (Key2) — INT — Foreign key → screenPeriod.movie_id — NOT NULL
  • phone (Field) — VARCHAR(20)
  • price (Field3) — VARCHAR(20)

screenPeriod (Untitled)

  • id (Key) — INT — Primary key — NOT NULL
  • screen_id (Key4) — INT — Foreign key → Screen.screen_id — NOT NULL
  • movie_id (Key2) — INT — Foreign key → Movie.movie_id — NOT NULL
  • start_time (Field) — datetime
  • finish_time (Field2) — datetime
  • Field3