MovieWave
Tables (9)
Genres
- genre_id — INT
- genre_name — VARCHAR(100) — NOT NULL
Movie_Genre
- movie_id — INT — Primary key — NOT NULL
- genre_id — INT — Primary key — NOT NULL
Payments
- payment_id — INT
- reserve_id — INT — NOT NULL
- amount — INT — NOT NULL
- method — VARCHAR(50)
- paid_at — DATETIME
Reservations
- reserve_id — INT
- user_id — VARCHAR(50) — NOT NULL
- screen_id — INT — NOT NULL
- seat_id — INT — NOT NULL
- reserve_date — DATETIME
- status — VARCHAR(20)
Reviews
- review_id — INT
- user_id — VARCHAR(50) — NOT NULL
- movie_id — INT — NOT NULL
- rating — INT
- content — TEXT
- created_at — DATETIME
Screens
- screen_id — INT
- movie_id — INT — NOT NULL
- theater_id — INT — NOT NULL
- start_time — DATETIME — NOT NULL
- price — INT — NOT NULL
- language — VARCHAR(50)
- screen_type — VARCHAR(50)
Seats
- seat_id — INT
- theater_id — INT — NOT NULL
- row — CHAR(1) — NOT NULL
- number — INT — NOT NULL
Theaters
- theater_id — INT
- name — VARCHAR(255) — NOT NULL
- address — VARCHAR(255)
- phone — VARCHAR(20)
- total_seats — INT
- description — TEXT
Users
- user_id — VARCHAR(50)
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- gender — CHAR(1)
- birth — DATE
- nickname — VARCHAR(100)
- email — VARCHAR(255)
- phone — VARCHAR(20)
- created_at — DATETIME