deepseek 영화예매사이트
테이블 (9)
movie
- id — BIGINT
- name — VARCHAR(50) — NOT NULL
- summary — TEXT
- open_date — TIMESTAMP
movie_genre
- id — BIGINT
- movie_id — BIGINT — 외래 키 → movie.id — NOT NULL
- genre — VARCHAR(20) — NOT NULL
reservation
- id — BIGINT
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- screen_info_id — BIGINT — 외래 키 → screen_info.id — NOT NULL
- seat_id — BIGINT — 외래 키 → seat.id — NOT NULL
- reserve_name — VARCHAR(30) — NOT NULL
screen
- id — BIGINT
- theater_id — BIGINT — 외래 키 → theater.id — NOT NULL
- name — VARCHAR(30) — NOT NULL
- price — BIGINT
screen_info
- id — BIGINT
- movie_id — BIGINT — 외래 키 → movie.id — NOT NULL
- show_time_id — BIGINT — 외래 키 → show_time.id — NOT NULL
seat
- id — BIGINT
- screen_id — BIGINT — 외래 키 → screen.id — NOT NULL
- seat_number — VARCHAR(10) — NOT NULL
- reserve_status — BOOLEAN
show_time
- id — BIGINT
- theater_id — BIGINT — 외래 키 → theater.id — NOT NULL
- screen_id — BIGINT — 외래 키 → screen.id — NOT NULL
- start_time — TIMESTAMP — NOT NULL
- end_time — TIMESTAMP — NOT NULL
theater
- id — BIGINT
- name — VARCHAR(50) — NOT NULL
- location — VARCHAR(100) — NOT NULL
users
- id — BIGINT
- name — VARCHAR(50) — NOT NULL
- phone_number — VARCHAR(20)
- birth_date — DATE
- email — VARCHAR(100)
- created_at — TIMESTAMP
- grade — VARCHAR(20)
- password — VARCHAR(255) — NOT NULL