first_prj

Tables (7)

Comment (댓글)

  • comment_id (Key) — PK — Primary key — NOT NULL
  • user_id (Key2) — FK — Foreign key → accounts_CustomUser.user_id — NOT NULL
  • content (Field) — TEXT
  • updated_at (Field2) — DATETIME
  • created_at (Field3) — DATETIME

Game_record (게임기록)

  • record_id (Key) — PK — Primary key — NOT NULL
  • movie_id (Key2) — FK — Foreign key → moveis_movie.movie_id — NOT NULL
  • user_id (Key22) — PK — Foreign key → moveis_movie.creator — NOT NULL
  • Key (Key3) — Foreign key → moveis_movie.Key — NOT NULL
  • user_id (Key222) — PK — Foreign key → moveis_movie.user_id — NOT NULL
  • history (게임 정보 종합 객체) — JSON
  • is_single (싱글/멀티여부) — BOOL
  • end_status (종료 코드) — CHAR
  • recommend_movie (엔딩기반 추천영화) — TEXT
  • recommend_movie_reason (추천 이유) — TEXT
  • recommend_theme (추천 영화 장르) — TEXT
  • emotion (유저 심리) — TEXT
  • start_time (시작시간) — DATETIME
  • end_time (종료시간) — DATETIME

User - Game_record (중간테이블)

  • id (Key) — PK — Primary key — NOT NULL
  • user_id (Key2) — FK — Foreign key → accounts_CustomUser.user_id — NOT NULL
  • record_id (Key3) — FK — Foreign key → Game_record.record_id — NOT NULL
  • movie_id (Key22) — FK — Foreign key → Game_record.movie_id — NOT NULL
  • user_id (Key222) — PK — Foreign key → Game_record.user_id — NOT NULL
  • Key (Key32) — Foreign key → Game_record.Key — NOT NULL
  • user_id (Key2222) — PK — Foreign key → Game_record.user_id — NOT NULL

accounts_CustomUser (유저정보)

  • user_id (Key) — PK — Primary key — NOT NULL
  • email (이메일) — TEXT
  • password (비밀번호) — TEXT
  • name (닉네임) — TEXT
  • age (나이) — INT
  • sex (성별) — TEXT
  • profile_path (프로필 이미지 주소) — TEXT
  • created_at (생성날짜) — DATETIME
  • last_login (마지막로그인) — DATETIME
  • is_superuser (관리자여부) — BOOL

moveis_movie (영화정보)

  • movie_id (Key) — PK — Primary key — NOT NULL
  • creator (Key2) — PK — Foreign key → accounts_CustomUser.user_id — NOT NULL
  • Key (Key3) — Foreign key → Comment.comment_id — NOT NULL
  • user_id (Key22) — PK — Foreign key → Comment.user_id — NOT NULL
  • title (영화명) — TEXT
  • content (줄거리) — TEXT
  • poster_path (Field3) — IMAGE
  • initial_questions (Field4) — TEXT

movies_InitialQuestion (시나리오 목록)

  • question_ID (Key) — PK — Primary key — NOT NULL
  • question (시작 시나리오) — TEXT

movies_movie_scenario (관계테이블)

  • Key — PK — Primary key — NOT NULL
  • scenario_id (Key2) — FK — Foreign key → movies_InitialQuestion.question_ID — NOT NULL
  • movie_id (Key3) — FK — Foreign key → moveis_movie.movie_id — NOT NULL
  • user_id (Key22) — PK — Foreign key → moveis_movie.creator — NOT NULL
  • Key (Key32) — Foreign key → moveis_movie.Key — NOT NULL
  • user_id (Key222) — PK — Foreign key → moveis_movie.user_id — NOT NULL