indiean
Tables (23)
Audit (심의)
- audit_id (id) — int — Primary key — NOT NULL
- audit_no (심의 번호) — varchar
- watch_grade (관람 등급) — varchar
Company (제작/배급사)
- company_id (id) — int — Primary key — NOT NULL
- company_cd (회사 코드) — varchar
- name (회사명) — varchar
- name_en (영문이름) — varchar
Genre (장르)
- genre_id (id) — int — Primary key — NOT NULL
- name (장르명) — varchar
Movie (영화)
- moovie_id (id) — Primary key — NOT NULL
- movie_cd (영화 코드) — varchar
- title (제목) — varchar
- title_en (영어 제목) — varchar
- title_org (원제) — varchar
- description (줄거리/설명) — text
- release_date (개봉일) — date
- runtime (상영시간) — int
- production_year (제작연도) — int
- status (제작상태(개봉/미개봉)) — varchar
- type (장편, 단편 등) — varchar
- poster_image (포스터 이미지) — varchar
- created_at — datetime
- updated_at — datetime
MovieAudit (영화 심의)
- id — int — Primary key — NOT NULL
- audit_id (심의) — int — Foreign key → Audit.audit_id — NOT NULL
- movie_id (영화) — int — Foreign key → Movie.moovie_id — NOT NULL
MovieCompany (영화 제작/배급사)
- id — int — Primary key — NOT NULL
- company_id (회사) — int — Foreign key → Company.company_id — NOT NULL
- movie_id (영화) — int — Foreign key → Movie.moovie_id — NOT NULL
MovieCredit (영화-영화인 크리딧)
- moviecredit_id (id) — int — Primary key — NOT NULL
- movie_id (영화) — int — Foreign key → Movie.moovie_id — NOT NULL
- movieperson_id (영화인) — int — Foreign key → MoviePerson.movieperson_id — NOT NULL
- role_id (역할) — int — Foreign key → Role.role_id — NOT NULL
- character (배역 이름 등) — varchar
MovieGenre (영화의 장르)
- moviegenre_id (id) — int — Primary key — NOT NULL
- movie_id (영화) — int — Foreign key → Movie.moovie_id — NOT NULL
- genre_id (장르) — int — Foreign key → Genre.genre_id — NOT NULL
MovieNation (영화 - 나라)
- id — int — Primary key — NOT NULL
- nation_id (국가 id) — int — Foreign key → nation.nation_id — NOT NULL
- movie_id (영화 id) — int — Foreign key → Movie.moovie_id — NOT NULL
MoviePerson (영화인)
- movieperson_id (id) — int — Primary key — NOT NULL
- people_cd (영화인 코드) — varchar
- name (영화인명) — varchar
- name_en (영어명) — varchar
- sex (성별) — varchar
- birthdate (생일) — date
MoviePersonLike (유저가 찜한 영화인)
- mplike_id (id) — int — Primary key — NOT NULL
- moviePerson_id (영화인) — int — Foreign key → MoviePerson.movieperson_id — NOT NULL
- user_id (유저) — int — Foreign key → User.user_id — NOT NULL
MovieShowtype (영화 상영 타입)
- id — int — Primary key — NOT NULL
- showtype_id (상영 타입) — int — Foreign key → ShowType.showtype_id — NOT NULL
- movie_id (영화) — int — Foreign key → Movie.moovie_id — NOT NULL
Movie_Like (유저가 찜한 영화)
- movielike_id (id) — int — Primary key — NOT NULL
- movie_id (영화) — int — Foreign key → Movie.moovie_id — NOT NULL
- user_id (유저) — int — Foreign key → User.user_id — NOT NULL
Review (리뷰)
- review_id (id) — int — Primary key — NOT NULL
- movie_id (영화) — int — Foreign key → Movie.moovie_id — NOT NULL
- user_id (유저) — int — Foreign key → User.user_id — NOT NULL
- rating (평점) — int
- content (리뷰 내용) — text
- spoiler_flag (스포 여부) — bool
- deleted (삭제 여부) — bool
- created_at (작성일) — datetime
- updated_at (수정일) — datetime
Review_Like (유저의 리뷰 좋아요)
- reviewlike_id (id) — int — Primary key — NOT NULL
- review_id (리뷰) — int — Foreign key → Review.review_id — NOT NULL
- user_id (유저) — int — Foreign key → User.user_id — NOT NULL
Role (역할)
- role_id (id) — int — Primary key — NOT NULL
- role (감독/배우) — varchar
Screening (영화관 별 상영 정보)
- screening_id (id) — int — Primary key — NOT NULL
- movie_id (영화) — int — Foreign key → Movie.moovie_id — NOT NULL
- theater_id (영화관) — int — Foreign key → Theater.theater_id — NOT NULL
- show_start (상영 시작 시간) — datetime
- show_end (상영 종료 시간) — datetime
- screen_name (상영관 이름/번호 (옵션)) — varchar
- screen_link (상영관 예매 링크) — varchar
ShowType (상영 타입)
- showtype_id (id) — int — Primary key — NOT NULL
- group_name (상영 타입 그룹) — varchar
- type_name (상영 타입 이름(2D, IMAX 등)) — varchar
Theater (영화관)
- theater_id (id) — int — Primary key — NOT NULL
- name (영화관 이름) — varchar
- address (주소) — varchar
- latitude (위도) — decimal
- longitude (경도) — decimal
- tel (전화번호) — varchar
TheaterLike (유저가 찜한 영화관)
- theaterlike_id (id) — int — Primary key — NOT NULL
- theater_id (영화관) — int — Foreign key → Theater.theater_id — NOT NULL
- user_id (유저) — int — Foreign key → User.user_id — NOT NULL
User (django abstruct user 확장)
- user_id (id) — int — Primary key — NOT NULL
- username (아이디) — varchar
- password (비밀번호) — varchar
- email (이메일) — varchar
- first_name (이름) — varchar
- last_name (성) — varchar
- nickname (별명) — varchar
- profile_image (프로필 사진) — varchar
- is_staff (관리자 여부) — bool
- is_active (활성 계정 여부) — bool
- is_superuser (슈퍼유저 여부) — bool
- last_login (마지막 로그인 시간) — datetime
- date_joined (회원 가입일) — datetime
- updated_at (회원 정보 수정일) — datetime
UserGenre (유저의 선호 장르)
- usergenre_id (id) — int — Primary key — NOT NULL
- genre_id (장르) — int — Foreign key → Genre.genre_id — NOT NULL
- user_id (유저) — int — Foreign key → User.user_id — NOT NULL
nation (국가)
- nation_id (id) — int — Primary key — NOT NULL
- name (국가명) — varchar