1
Tables (7)
admin
- admin_id — TEXT
- admin_pw — TEXT
benefit
- defid — INT(11) — Primary key — NOT NULL
- poster_path — TEXT
- poster_name — VARCHAR(100)
event
- defid — INT(11) — Primary key — NOT NULL
- poster_path — TEXT
- poster_name — TEXT
movie_info
- movie_id — INT(11) — Primary key — NOT NULL
- screen_number — INT(11)
- title — TEXT — NOT NULL
- description — TEXT
- short_description — TEXT
- poster — TEXT
- runtime — INT(11)
- reserv_count — INT(11)
- start_time1 — TEXT
- start_time2 — TEXT
- start_time3 — TEXT
- start_time4 — TEXT
- start_time5 — TEXT
- start_time6 — TEXT
- start_time7 — TEXT
- start_time8 — TEXT
- start_time9 — TEXT
seat
- seat_id — INT(11) — Primary key — NOT NULL
- user_defid — INT(11) — Foreign key → user.defid — NOT NULL
- movie_id — INT(11) — Foreign key → movie_info.movie_id — NOT NULL
- screen_num — INT(11) — NOT NULL
- seat_num — TEXT — NOT NULL
- user_id — VARCHAR(50)
- date — TEXT
- time — TEXT
- movie_name — TEXT
- userName — TEXT
- pickcount — INT(11)
- card_num — VARCHAR(50)
- card_bank — VARCHAR(50)
- card_date — VARCHAR(50)
user
- defid — INT(11) — Primary key — NOT NULL
- id — VARCHAR(50) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- pw — VARCHAR(50) — NOT NULL
- profile — VARCHAR(50)
- point — INT(11)
user_card
- card_defid — INT(11) — Primary key — NOT NULL
- defid (defid2) — INT(11) — Foreign key → user.defid — NOT NULL
- user_id — VARCHAR(50)
- card_num — VARCHAR(50)
- card_date — VARCHAR(50)
- card_bank — VARCHAR(50)
- card_name — VARCHAR(100)