final-pjt
Tables (5)
Accounts (user)
- ID (id) — int — Primary key — NOT NULL
- USERNAME (username) — str
- PASSWORD (password) — str
Article (article)
- ID (id) — int — Primary key — NOT NULL
- ID (id2) — int — Foreign key → Accounts.ID — NOT NULL
- TITLE (title) — str
- CONTENT (content) — str
- CREATED_AT (created_at) — datetime
- UPDATED_AT (updated_at) — datetime
Comment (comment)
- ID (id) — int — Primary key — NOT NULL
- ID (id2) — int — Foreign key → Accounts.ID — NOT NULL
- ID (id3) — int — Foreign key → Article.ID — NOT NULL
- CONTENT (content) — str
- CREATED_AT (created_at) — datetime
- UPDATED_AT (updated_at) — datetime
Movie (movies)
- ID (id) — int — Primary key — NOT NULL
- TITLE (title) — str
- ORIGINAL_TITLE (original_title) — str
- IMAGE (image) — str
- BACKDROP_PATH (backdrop_path) — str
- OVERVIEW (overview) — str
- RELEASE (release) — str
- RATING (rating) — float
- GENRES (genres) — str
- CREATED_AT (created_at) — datetime
- UPDATED_AT (updated_at) — datetime
Review (movie_review)
- ID (id) — int — Primary key — NOT NULL
- ID (id2) — int — Foreign key → Accounts.ID — NOT NULL
- ID (id3) — int — Foreign key → Movie.ID — NOT NULL
- CONTENT (content) — str
- RATINGS (ratings) — uint
- CREATED_AT (created_at) — datetime
- UPDATED_AT (updated_at) — datetime