ew

Tables (8)

Copy Of Untitled (극장(theater))

  • Key (id) — int — Primary key — NOT NULL
  • Field (location) — text
  • Field (type) — int
  • Field (num) — int

Copy Of Untitled2 (극장 좌석(m_seat))

  • Key (id) — int — Primary key — NOT NULL
  • Key (t_id) — int — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Field (row) — varchar(10)
  • Field2 (col) — varchar(10)
  • Field (name) — varchar(20)

Untitled (회원(member))

  • 회원아이디 (id) — int — Primary key — NOT NULL
  • 이름 (name) — varchar(20)
  • 전화번호 (phone) — varchar(20)
  • 이메일 (email) — varchar(20)
  • Field (password) — text
  • Field (region) — varchar(10)

Untitled (예매(booking))

  • Key (id) — int — Primary key — NOT NULL
  • 회원아이디 (m_id) — int — Foreign key → Untitled.회원아이디 — NOT NULL
  • Field (booking_date) — date
  • Field2 (payment) — varchar(10)

Untitled (좌석(seat))

  • Key (id) — int — Primary key — NOT NULL
  • Field (row) — varchar(10)
  • Field2 (col) — varchar(10)
  • Field (name) — varchar(20)

Untitled (영화(movie))

  • Key (id) — int — Primary key — NOT NULL
  • Field (title) — text
  • Field2 (category) — varchar(20)
  • Field3 (director) — varchar(20)
  • Field (start_date) — date
  • Field (making_company) — varchar(30)

Untitled (상영(screen))

  • Key (id) — int — Primary key — NOT NULL
  • Key (theater_id) — int — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Key (moovie_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (start_date) — date
  • Field2 (name) — varchar(20)
  • Field3 (time) — varchar(30)

Untitled (배우(act))

  • Key (id) — int — Primary key — NOT NULL
  • Field (start_date) — date
  • Key (screen_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (theater_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (moovie_id) — int — Foreign key → Untitled.Key — NOT NULL