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