fromhwpmoondb

Tables (11)

custom

  • custom_name — char(10) — Primary key — NOT NULL
  • person_no — char(15) — Primary key — NOT NULL
  • custom_tel — char(15) — Primary key — NOT NULL
  • member_id — char(10) — Foreign key → member.member_id — NOT NULL
  • Field2

genre

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

grade

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

hall

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

member

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

movie

  • movie_no — int — Primary key — NOT NULL
  • movie_name — char(20)
  • running_time — int
  • grade_co — char(01) — Foreign key → grade.grade_co — NOT NULL
  • director — char(20)
  • actor — char(50)
  • genre_no — int — Foreign key → genre.genre_no — NOT NULL
  • description — char(100)
  • movie_open — date

payment

  • payment_no — int — Primary key — NOT NULL
  • payment_type — char(1)
  • payment_state — char(1)
  • permit_no — int
  • payment_price — int
  • custom_name — char(10) — Foreign key → custom.custom_name — NOT NULL
  • person_no — char(15) — Foreign key → custom.person_no — NOT NULL
  • custom_tel — char(15) — Foreign key → custom.custom_tel — NOT NULL
  • payment_date (Field8) — date
  • Field9

priceandli

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

schedule

  • schedule_no — int — Primary key — NOT NULL
  • movie_no — int — Foreign key → movie.movie_no — NOT NULL
  • hall_no — int — Foreign key → hall.hall_no — NOT NULL
  • view_date — date
  • view_time — date
  • Field5

seat

  • seat_no — int — Primary key — NOT NULL
  • hall_no — int — Foreign key → hall.hall_no — NOT NULL
  • usable_seat — char(1)
  • Field3

ticket

  • ticket_no — int — Primary key — NOT NULL
  • payment_no — int — Foreign key → payment.payment_no — NOT NULL
  • schedule_no — int — Foreign key → schedule.schedule_no — NOT NULL
  • hall_no — int — Foreign key → seat.hall_no — NOT NULL
  • seat_no — int — Foreign key → seat.seat_no — NOT NULL
  • issue_state — char(1)
  • list_price — int
  • sell_price — int
  • Field8