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