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