Cinema

Tables (7)

Movie (영화)

  • id (Key) — bidint — Primary key — NOT NULL
  • Movie_Name (Field) — varchar(255)
  • Running_Time (Field2) — int

Movie_Time (상영 시간)

  • id (Key) — bigint — Primary key — NOT NULL
  • Movie_id (영화) — bidint — Foreign key → Movie.id — NOT NULL
  • Theater_id (상영관) — bigint — Foreign key → Theater.id — NOT NULL
  • Field
  • Field2

Payment (결제)

  • id (Key) — bigint — Primary key — NOT NULL
  • Ticket_id (티켓) — bigint — Foreign key → Ticket.id — NOT NULL
  • User_id (사용자) — bigint — Foreign key → User.id — NOT NULL
  • Field
  • Field2

Seat (좌석)

  • id (Key) — bigint — Primary key — NOT NULL
  • id (Key2) — bigint — Foreign key → Theater.id — NOT NULL
  • Field
  • Field2

Theater (상영관)

  • id (Key) — bigint — Primary key — NOT NULL
  • Theater_number (Field) — int
  • Seat_count (Field2) — int

Ticket (표)

  • id (Key) — bigint — Primary key — NOT NULL
  • Movie_time_id (상영시간) — bigint — Foreign key → Movie_Time.id — NOT NULL
  • Seat_id (좌석) — bigint — Foreign key → Seat.id — NOT NULL
  • Field
  • Field2
  • Field3

User (사용자)

  • id (Key) — bigint — Primary key — NOT NULL
  • Field
  • Field2