retro
Tables (5)
Likes (Untitled3)
- movie_id (Key2) — Foreign key → Movies.movie_id — NOT NULL
- user_id (Key22) — Foreign key → User.user_id — NOT NULL
Movies (Untitled2)
- movie_id (Key) — Primary key — NOT NULL
- Title (Field) — char
- openDt (Field2) — date
- Clip (Field3) — char
- Star (Field4) — float
- genre (Field5) — int
Review (Untitled4)
- movie_id (Key2) — Foreign key → Movies.movie_id — NOT NULL
- Star (Field6) — float
- Content (Field) — char
- Created_date (Field2) — date
- Modified_date (Field3) — date
- generation (Field4) — int
- Gender (Field5) — int
User (Untitled)
- user_id (Key2) — Primary key — NOT NULL
- Username (Field) — char
- Password (Field2) — char
- Birthday (Field3) — date
- Gender (Field4) — int
- Nickname (Field5) — char
- Email (Field6) — char
Views (Untitled5)
- user_id (Key2) — Foreign key → User.user_id — NOT NULL
- movie_id (Key) — Foreign key → Movies.movie_id — NOT NULL
- genre (장르)