imgonna
Tables (9)
Article
- id — integer — Primary key — NOT NULL
- user_id — integer — Foreign key → User.id — NOT NULL
- title — varchar(100)
- content — text
- created_at — datetime
- updated_at — datetime
ArticleComment
- id — integer — Primary key — NOT NULL
- user_id — integer — Foreign key → User.id — NOT NULL
- article_id — integer — Foreign key → Article.id — NOT NULL
- review — text
- created_at — datetime
- updated_at — datetime
Genre
- id — integer — Primary key — NOT NULL
- name — varchar(100)
Movie
- id — integer — Primary key — NOT NULL
- title — varchar(100)
- original_title — varchar(100)
- release_date — date
- popularity — real
- vote_count — integer
- vote_average — real
- adult — bool
- video — bool
- overview — text
- original_language — varchar(100)
- poster_path — varchar(1000)
- backdrop_path — varchar(1000)
Movie_Genres
- id — integer — Primary key — NOT NULL
- movie_id — integer — Foreign key → Movie.id — NOT NULL
- genre_id — integer — Foreign key → Genre.id — NOT NULL
Rating
- id — integer — Primary key — NOT NULL
- user_id — integer — Foreign key → User.id — NOT NULL
- movie_id (movide_id) — integer — Foreign key → Movie.id — NOT NULL
- score — real
Review
- id — integer — Primary key — NOT NULL
- user_id — integer — Foreign key → User.id — NOT NULL
- movie_id — integer — Foreign key → Movie.id — NOT NULL
- title — varchar(100)
- content — text
- created_at — datetime
- updated_at — datetime
ReviewComment
- id — integer — Primary key — NOT NULL
- user_id — integer — Foreign key → User.id — NOT NULL
- review_id — integer — Foreign key → Review.id — NOT NULL
- review — text
- created_at — datetime
- updated_at — datetime
User
- id — integer — Primary key — NOT NULL
- password — varchar(128) — NOT NULL
- last_login — datetime — NOT NULL
- is_superuser — bool — NOT NULL
- username — varchar(150)
- first_name — varchar(30)
- last_name — varchar(150)
- email — varchar(254)
- is_staff — bool
- is_active — bool
- date_joined — datetime