db기말
테이블 (4)
Data
- movie_id (movie_id2) — INT — 외래 키 → Movie.movie_id — NOT NULL
- user_id (User_id) — INT — 외래 키 → User.user_id — NOT NULL
- rating — INT
- timestamp — TIMESTAMP
Genre
- movie_id — INT — 외래 키 → Movie.movie_id — NOT NULL
- genre — varchar(12)
Movie
- movie_id — INT — 기본 키 — NOT NULL
- title (titile) — VARCHAR(50)
- release_date (releaseDate) — DATE
- url (URL) — CARCHAR(50)
User
- user_id (User_id) — INT — 기본 키 — NOT NULL
- age (Field2) — INT
- gender — CHAR(1)
- region_code (Field) — CHAR(5)
- occupation (Field3) — VARCHAR(20)