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