Test
Tables (6)
Comment (Untitled7)
- id (Key) — Integer — Primary key — NOT NULL
- content (Field2)
- created_at (Field3)
- updated_at (Field4)
- user (Key2) — 1:N — Foreign key → User.id — NOT NULL
- community (Key3) — 1:N — Foreign key → Community.id — NOT NULL
Community (Untitled)
- id (Key) — Integer — Primary key — NOT NULL
- title (Field)
- content (Field3)
- rank (Field2)
- created_at (Field4)
- updated_at (Field5)
- user (Key2) — 1:N — Foreign key → User.id — NOT NULL
- movie (Key3) — 1:N — Foreign key → Movie.id — NOT NULL
- find_users (Key4) — M:N — Foreign key → User.id — NOT NULL
Genre (Untitled3)
- id (Key) — Primary key — NOT NULL
- genre_name (Field2)
Movie (Untitled4)
- id (Key) — Primary key — NOT NULL
- title (Field)
- poster_path (Field2)
- overview (Field3)
- release_date (Field4)
- vote_average (Field5)
- popularity (Field6)
- id (Field7)
- original_title (Field12)
- adult (Field11)
- vote_count (Field10)
- genres (Key3) — M:N — Foreign key → Genre.id — NOT NULL
- like_users (Key2) — M:N — Foreign key → User.id — NOT NULL
Review (Untitled6)
- id (Key) — Integer — Primary key — NOT NULL
- content (Field)
- rank (Field2)
- created_at (Field3)
- updated_at (Field5)
- user (Key2) — 1:N — Foreign key → User.id — NOT NULL
- community (Key3) — 1:N — Foreign key → Community.id — NOT NULL
User (Untitled2)
- id (Key) — Primary key — NOT NULL
- username (Field)
- mbti_partner (Field2)
- mbti_keywords (Field3)