빅데응 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