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