ssafy
Tables (9)
accounts_user
- id (user_id) — INTEGER — Primary key — NOT NULL
- password — VARCHAR(128) — NOT NULL
- last_login — TIMESTAMP
- is_superuser — BOOLEAN — NOT NULL
- username — VARCHAR(150) — NOT NULL
- first_name — VARCHAR(150) — NOT NULL
- last_name — VARCHAR(150) — NOT NULL
- email — VARCHAR(254) — NOT NULL
- is_staff — BOOLEAN — NOT NULL
- is_active — BOOLEAN — NOT NULL
- date_joined — TIMESTAMP — NOT NULL
- biography — VARCHAR(200) — NOT NULL
- profile_image — VARCHAR(100)
actor
- id (actor_id) — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- birthday — DATE
- place_of_birth — VARCHAR(150)
articles_article
- id (article_id) — INTEGER — Primary key — NOT NULL
- title — VARCHAR(128) — NOT NULL
- content — VARCHAR(1000) — NOT NULL
- image — VARCHAR(100)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- id (user_id) — INTEGER — Foreign key → accounts_user.id — NOT NULL
articles_articlelike
- id (user_id) — INTEGER — Foreign key → accounts_user.id — NOT NULL
- id (article_id) — INTEGER — Foreign key → articles_article.id — NOT NULL
genre
- id (genre_id) — INTEGER — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
movie
- tmdb_id — INTEGER — Primary key — NOT NULL
- original_title — VARCHAR(200) — NOT NULL
- description — TEXT — NOT NULL
- vote_average — NUMERIC(4,2) — NOT NULL
- release_date — DATE
- runtime — INTEGER — NOT NULL
- poster_path — VARCHAR(200)
movie_actor
- actor_id — Foreign key → actor.id — NOT NULL
- tmdb_id — INTEGER — Foreign key → movie.tmdb_id — NOT NULL
movie_genre
- genre_id — INTEGER — Foreign key → genre.id — NOT NULL
- tmdb_id — INTEGER — Foreign key → movie.tmdb_id — NOT NULL
movies_typingrecord
- id — SERIAL
- text — TEXT — NOT NULL
- time — DOUBLE — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- user_id — INTEGER