Avengers
Tables (3)
Member (Untitled)
- member_id (Key) — BIGINT — Primary key — NOT NULL
- registerted_AT (Field) — DATETIME
- email (Field2) — VARCHAR(255)
- nickname (Field3) — VARCHAR(255)
- password (Field4) — VARCHAR(255)
- role (Field5) — VARCHAR(255)
Movie (Untitled2)
- id (Key) — BIGINT — Primary key — NOT NULL
- tmdb_di (Field) — INT
- vate_average (Field2) — DOUBLE
- description (Field3) — VARCHAR(255)
- genre (Field4) — VARCHAR(255)
- poster_path (Field5) — VARCHAR(255)
- title (Field6) — VARCHAR(255)
- release_date (Field7) — DATE
Review (Untitled3)
- review_id (Key) — BIGINT — Primary key — NOT NULL
- title (Field) — VARCHAR(255)
- content (Field2) — TEXT
- nickname (Field3) — VARCHAR(255)
- post_date (Field4) — DATETIME(6)
- update_date (Field5) — DATETIME(6)
- member_rate (Field6) — BIGINT
- member_id (Field7) — BIGINT
- movie_id (Field8) — BIGINT
- id (Key2) — BIGINT — Foreign key → Movie.id — NOT NULL
- member_id (Key3) — BIGINT — Foreign key → Member.member_id — NOT NULL