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)