movie-crew

Tables (9)

Crew (크루)

  • id (Key) — INT — Primary key — NOT NULL
  • crewname (크루명) — VARHCAR(150) — NOT NULL
  • information (크루소개) — TEXT — NOT NULL

Review (리뷰)

  • id (Key) — INT — Primary key — NOT NULL
  • user_id (유저 Key) — INT — Foreign key → accounts_user.id — NOT NULL
  • movie_id (영화 Key) — INT — Foreign key → movies_movie.id — NOT NULL
  • title (제목) — VARCHAR(100) — NOT NULL
  • content (내용) — TEXT — NOT NULL
  • created_at (작성날짜) — DATETIME — NOT NULL
  • updated_at (수정날짜) — DATETIME — NOT NULL

accounts_user (사용자)

  • id (Key) — INT — Primary key — NOT NULL
  • username (유저 아이디) — VARCHAR(150) — NOT NULL
  • password (비밀번호) — VARCHAR(128) — NOT NULL
  • nickname (별명) — VARCHAR(45) — NOT NULL
  • last_login (마지막 로그인 날짜) — DATETIME
  • is_superuser (최고 관리자 여부) — BOOL — NOT NULL
  • first_name (이름) — VARCHAR(150) — NOT NULL
  • last_name (성) — VARCHAR(150) — NOT NULL
  • email (이메일 주소) — VARCHAR(254) — NOT NULL
  • is_staff (관리자 여부) — BOOL — NOT NULL
  • is_active (유저 활성화 여부) — BOOL — NOT NULL
  • date_joined (가입날짜) — DATETIME — NOT NULL
  • phone_number (핸드폰번호) — VARCHAR(20) — NOT NULL

movies_genre (장르)

  • id (Key) — INT — Primary key — NOT NULL
  • name (장르명) — VARCHAR(50) — NOT NULL

movies_movie (영화)

  • id (Key) — INT — Primary key — NOT NULL
  • title (제목) — VARCHAR(100) — NOT NULL
  • release_date (개봉 일자) — DATE — NOT NULL
  • popularity (인기도) — REAL — NOT NULL
  • overview (정보) — TEXT — NOT NULL
  • poster_path (포스터 경로) — VARCHAR(200) — NOT NULL

movies_movie_genres (영화-장르)

  • id (Key) — INT — Primary key — NOT NULL
  • movie_id (영화 Key) — INT — Foreign key → movies_movie.id — NOT NULL
  • genre_id (장르 Key) — INT — Foreign key → movies_genre.id — NOT NULL

movies_usermovielike (사용자-영화 찜)

  • id (Key) — INT — Primary key — NOT NULL
  • user_id (유저 Key) — INT — Foreign key → accounts_user.id — NOT NULL
  • movie_id (영화 Key) — INT — Foreign key → movies_movie.id — NOT NULL

movies_usermovievote (사용자-영화 평점)

  • id (Key) — INT — Primary key — NOT NULL
  • user_id (유저 Key) — INT — Foreign key → accounts_user.id — NOT NULL
  • movie_id (영화 Key) — INT — Foreign key → movies_movie.id — NOT NULL
  • vote (평점) — INT — NOT NULL

user_crew (사용자-크루)

  • id (Key) — INT — Primary key — NOT NULL
  • user_id (유저 Key) — INT — Foreign key → accounts_user.id — NOT NULL
  • crew_id (크루 Key) — INT — Foreign key → Crew.id — NOT NULL
  • is_superuser (크루 관리자 여부) — BOOL — NOT NULL