ERD
Tables (9)
movie
- movie_id — BIGINT — Primary key — NOT NULL — PK
- running_time — TIME — NOT NULL
- director — VARCHAR(20)
- description — VARCHAR(200)
- movie_image — VARCHAR(200)
- movie_name — VARCHAR(100)
reservationinformation
- reservation_id — BIGINT — Primary key — NOT NULL — PK
- schedule_id — BIGINT — NOT NULL
- theater_id — BIGINT — NOT NULL
- screen_id — BIGINT — NOT NULL
- movie_id — BIGINT — NOT NULL
- seat_id — BIGINT — NOT NULL
- reservation_date — DATETIME — NOT NULL
reviews
- review_id — BIGINT — Primary key — NOT NULL — PK
- rating — INT
- content — TEXT
- created_at — DATETIME
- updated_at — DATETIME
- is_deleted — BOOLEAN
- deleted_at — DATETIME
- user_id — BIGINT — NOT NULL
schedule
- schedule_id — BIGINT — Primary key — NOT NULL
- start_at — DATETIME — NOT NULL
- end_at — DATETIME — NOT NULL
- screen_id — BIGINT — NOT NULL
screen
- screen_id — BIGINT — Primary key — NOT NULL — PK
- name — VARCHAR(20) — NOT NULL
- address — VARCHAR(200)
- theater_id — BIGINT — NOT NULL
seat
- seat_id — BIGINT — Primary key — NOT NULL
- screen_id — BIGINT — NOT NULL
- seat_name — VARCHAR(20)
theater
- theater_id — BIGINT — Primary key — NOT NULL — PK
- name — VARCHAR(200) — NOT NULL
- location — VARCHAR(200)
tokens
- token_id — BIGINT — Primary key — NOT NULL — PK
- token — VARCHAR(255)
- created_at — DATETIME
- expired_at — DATETIME
- is_deleted — BOOLEAN
- user_id — BIGINT — NOT NULL
user
- user_id — BIGINT — Primary key — NOT NULL — PK
- email — VARCHAR(255)
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- is_deleted — BOOLEAN — NOT NULL
- deleted_at — DATETIME