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)