빅데응 ppt erd

테이블 (14)

academy_best_award (list of academy award records)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • year (Field) — int
  • round (Field2) — int
  • film_festival_id (Key2) — bigint — 외래 키 → film_festival.id — NOT NULL
  • film_id (Key3) — bigint — 외래 키 → film.id — NOT NULL

berlin_best_award (list of Golden Bear records)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • year (Field) — int
  • round (Field2) — int
  • film_festival_id (Key2) — bigint — 외래 키 → film_festival.id — NOT NULL
  • film_id (Key3) — bigint — 외래 키 → film.id — NOT NULL

cannes_best_award (list of Golden Palm records)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • year (Field) — int
  • round (Field2) — int
  • film_festival_id (Key2) — bigint — 외래 키 → film_festival.id — NOT NULL
  • film_id (Key3) — bigint — 외래 키 → film.id — NOT NULL

director (Untitled2)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(255)
  • nationality (Field2) — varchar(255)

film (Untitled)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(255)
  • director_id (Key2) — bigint — 외래 키 → director.id — NOT NULL

film_festival (major 4 film festivals)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(255)
  • country (Field2) — varchar(255)

film_gender (Untitled4)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • gender (Field) — char(1)
  • grade (Field2) — int
  • film_id (Key2) — bigint — 외래 키 → film.id — NOT NULL

film_hit (Untitled3)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • sales (Field) — bigint
  • film_id (Key2) — bigint — 외래 키 → film.id — NOT NULL

review_academy (list of reviews)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • grade (Field) — int
  • gender (Field2) — char(1)
  • user_id (Key2) — bigint — 외래 키 → user.id — NOT NULL
  • academy_award_id (Key3) — bigint — 외래 키 → academy_best_award.id — NOT NULL

review_berlin (CopyOflist of reviews)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • grade (Field) — int
  • gender (Field2) — char(1)
  • user_id (Key2) — bigint — 외래 키 → user.id — NOT NULL
  • berlin_award_id (Key3) — bigint — 외래 키 → berlin_best_award.id — NOT NULL

review_cannes (CopyOfCopyOflist of reviews)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • grade (Field) — int
  • gender (Field2) — char(1)
  • user_id (Key2) — bigint — 외래 키 → user.id — NOT NULL
  • cannes_award_id (Key3) — bigint — 외래 키 → cannes_best_award.id — NOT NULL

review_venice (CopyOfCopyOfCopyOflist of reviews)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • grade (Field) — int
  • gender (Field2) — char(1)
  • user_id (Key2) — bigint — 외래 키 → user.id — NOT NULL
  • venice_award_id (Key3) — bigint — 외래 키 → venice_best_award.id — NOT NULL

user (list of users)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • username (Field) — varchar(255)
  • password (Field2) — varchar(255)

venice_best_award (list of Golden Lion records)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • year (Field) — int
  • round (Field2) — int
  • film_festival_id (Key2) — bigint — 외래 키 → film_festival.id — NOT NULL
  • film_id (Key3) — bigint — 외래 키 → film.id — NOT NULL