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