last_pjt
Tables (7)
User (회원관리)
- user_id (id) — Primary key — NOT NULL
- username
- password (Field)
- is_superuser (Field2)
- grade (Field3)
article (Untitled3)
- article_id (Key2) — Primary key — NOT NULL
- community_id (Key) — Foreign key → community.community_id — NOT NULL
- user_id (id) — Foreign key → User.user_id — NOT NULL
- title (Field)
- content (Field2)
comment (Untitled4)
- article_id (Key2) — Foreign key → article.article_id — NOT NULL
- user_id (id) — Foreign key → User.user_id — NOT NULL
- content (Field)
community (Untitled6)
- community_id (Key) — Primary key — NOT NULL
- name (Field)
- rank (Field2)
genre (Untitled2)
- genre_id (Key) — Primary key — NOT NULL
- movie_id (Key2) — Foreign key → movie.movie_id — NOT NULL
- name (Field)
movie (Untitled)
- movie_id (Key) — Primary key — NOT NULL
- genre_id (Key2) — Foreign key → genre.genre_id — NOT NULL
- title (Field)
- original_title (Field2)
- release_date (Field3)
- popularity (Field4)
- vote_count (Field5)
- vote_average (Field6)
- adult (Field7)
- original_language (Field8)
- poster_path (Field9)
- backdrop_path (Field10)
movierank (Untitled5)
- Key — Primary key — NOT NULL
- user_id (id) — Foreign key → User.user_id — NOT NULL
- movie_id (Key2) — Foreign key → movie.movie_id — NOT NULL
- rank (Field)
- content (Field2)