m
Tables (9)
Untitled (movie)
- Key (mv_seq) — number — Primary key — NOT NULL
- Key (scr_seq) — number — Foreign key → Untitled.Key — NOT NULL
- Field (mv_name) — varchar2(200)
Untitled (screen)
- Key (scr_seq) — number — Primary key — NOT NULL
- cnm_seq — number — Foreign key → cinema.cnm_seq — NOT NULL
Untitled (member)
- Key (mb_seq) — number — Primary key — NOT NULL
- Field (mb_name) — varchar2(100)
- Field (mb_id) — varchar2(200)
- Field (mb_pw) — varchar2(100)
Untitled (ticketing)
- Key (tck_seq) — number — Primary key — NOT NULL
- Key (mb_seq) — number — Foreign key → Untitled.Key — NOT NULL
- Key (ss_seq) — number — Foreign key → Untitled.Key — NOT NULL
- Field (tck_pay) — number
Untitled (food)
- Key (fd_seq) — number — Primary key — NOT NULL
- Field (fd_name) — varchar2(200)
- Field (fd_price) — number
- Field (fd_categ) — number
Untitled (bill)
- Key (bl_seq) — number — Primary key — NOT NULL
- Key (mb_seq) — number — Foreign key → Untitled.Key — NOT NULL
- Key (fd_seq) — number — Foreign key → Untitled.Key — NOT NULL
- Field (bl_total) — number
Untitled (Screening Schedule)
- Key (ss_seq) — number — Primary key — NOT NULL
- Key (scr_seq) — number — Foreign key → Untitled.Key — NOT NULL
- Field (ss_time) — varchar2(100)
Untitled (loc)
- Key (loc_seq) — number — Primary key — NOT NULL
- Field (loc_name) — varchar2(100)
cinema
- cnm_seq — number — Primary key — NOT NULL
- Key (loc_seq) — number — Foreign key → Untitled.Key — NOT NULL
- cnm_name — varchar(200)