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