Test

Tables (11)

Custom

  • member_id2 — char(20) — Foreign key → Member.member_id — NOT NULL
  • custom_name2 — char(20) — Foreign key → Member.custom_name — NOT NULL
  • person_no2 — char(20) — Foreign key → Member.person_no — NOT NULL
  • custom_tel2 — char(20) — Foreign key → Member.custom_tel — NOT NULL

Genre

  • genre_no — int — Primary key — NOT NULL
  • genre_name — char(20)

Grade

  • grade_co — char(20) — Primary key — NOT NULL
  • grade_type — char(20)

Hall

  • hall_no — int — Primary key — NOT NULL
  • number_seat — int
  • usable_hall — char(20) — NOT NULL

Member

  • member_id — char(20) — Primary key — NOT NULL
  • custom_name — char(20) — Primary key — NOT NULL
  • person_no — char(20) — Primary key — NOT NULL
  • custom_tel — char(20) — Primary key — NOT NULL
  • is_member — char(20) — NOT NULL
  • member_point — int

Movie

  • movie_no — int — Primary key — NOT NULL
  • movie_name — char(40)
  • running_time — int
  • director — char(40)
  • actor — char(20)
  • description — char(40)
  • movie_open — date
  • genre_no — int — NOT NULL
  • grade_co — char(40) — NOT NULL

Payment

  • payment_no — int — Primary key — NOT NULL
  • payment_type — char(30) — NOT NULL
  • payment_state — char(20) — NOT NULL
  • permit_no — int
  • payment_price — int
  • payment_date — date
  • custom_name — char(20) — NOT NULL
  • person_no — char(20) — NOT NULL
  • custom_tel — char(20) — NOT NULL

Pricelist

  • price_no — int — Primary key — NOT NULL
  • list_price — int — NOT NULL
  • price_typr — char(20)
  • discount — int — NOT NULL

Schedule

  • schedule_no — int — Primary key — NOT NULL
  • view_date — date
  • view_round — int
  • view_time — date
  • movie_no — int — NOT NULL
  • hall_no — int — NOT NULL

Seat

  • seat_no — int — Primary key — NOT NULL
  • hall_no — int — Foreign key → Hall.hall_no — NOT NULL
  • usable_seat — char(20) — NOT NULL

Ticket

  • ticket_no — int — Primary key — NOT NULL
  • issue_state — char(30) — NOT NULL
  • list_price — int
  • sell_price — int
  • schedule_no — int — NOT NULL
  • seat_no — int — NOT NULL
  • hall_no — int — NOT NULL
  • payment_no — int — NOT NULL