movieapi
Tables (7)
accounts.User (Untitled4)
- id (Key) — INTEGER — Primary key — NOT NULL
- imageBase64 (Field) — IMAGE
- male (Field2) — FLOAT
- age (Field3) — FLOAT
community.CommunityComment (Untitled6)
- community (Key2) — INTEGER — Primary key — NOT NULL
- user (Key) — INTEGER — Foreign key → movies.Community.user — NOT NULL
- content (Field) — CHAR
- created_at (Field2) — DATETIME
- updated_at (Field3) — DATETIME
movies.Comment (Untitled3)
- id — INTEGER — Foreign key → movies.Review.id — NOT NULL — comment
- review (id2) — INTEGER — Foreign key → movies.Review.movie — NOT NULL — comment
- content (Field) — CHAR
- created_at (Field2) — DATETIME
- updated_at (Field3) — DATETIME
movies.Community (Untitled5)
- user (Key) — INTEGER — Primary key — NOT NULL
- id (Key2) — INTEGER — Foreign key → accounts.User.id — NOT NULL
- title (Field2) — CHAR
- content (Field3) — TEXT
- created_at (Field4) — DATETIME
- updated_at (Field5) — DATETIME
movies.Genre (Untitled)
- id — INTEGER — Foreign key → movies.Movie.id — NOT NULL — comment
- movie (id2) — CharField — Foreign key → movies.Movie.genres — NOT NULL — comment
- name (Field) — CHAR
movies.Movie (comment)
- id — INTEGER — Primary key — NOT NULL — comment
- genres (id2) — CharField — Foreign key → movies.Genre.id — NOT NULL — comment
- title (Field) — CharField — comment
- release_date (Field2) — DATE — NOT NULL
- popularity (Field3) — FLOAT
- vote_count (Field4) — INTEGER
- vote_average (Field5) — FLOAT
- overview (Field6) — TEXT
- poster_path (Field7) — CHAR
movies.Review (Untitled2)
- id — INTEGER — Foreign key → movies.Movie.id — NOT NULL — comment
- movie (id2) — INTEGER — Foreign key → movies.Movie.genres — NOT NULL — comment
- content (Field) — TEXT
- rank (Field2) — INTEGER