talk-taka

Tables (5)

apps_chatroom (채팅방)

  • id — INT — Primary key — NOT NULL
  • 감정 (mood) — VARCHAR(10) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • delete_at — DATETIME
  • summary — VARCHAR(300)
  • image_url — VARCHAR(500)
  • user_id — VARCHAR(255) — Foreign key → users_user.id — NOT NULL

apps_gptquestion (gpt_질문)

  • id — INT — Primary key — NOT NULL
  • 내용 (content) — LONGTEXT — NOT NULL
  • 생성일 (created_at) — DATETIME — NOT NULL
  • 수정일 (updated_at) — DATETIME — NOT NULL
  • 삭제일 (delete_at) — DATETIME
  • chatroom_id_id — INT — Foreign key → apps_chatroom.id — NOT NULL

apps_useranswer (사용자_답변)

  • id — INT — Primary key — NOT NULL
  • 내용 (content) — LONGTEXT — NOT NULL
  • 비디오URL (audio_url) — VARCHAR(500)
  • 생성일 (created_at) — DATETIME — NOT NULL
  • 삭제일 (delete_at) — DATETIME — NOT NULL
  • 수정일 (updated_at) — DATETIME
  • question_id_id — INT — Foreign key → apps_gptquestion.id — NOT NULL

diary_diary (다이어리)

  • id — INT — Primary key — NOT NULL
  • content — LONGTEXT — NOT NULL
  • image_url — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted_at — DATETIME
  • mood — VARCHAR(10) — NOT NULL
  • capture_url — VARCHAR(500)
  • chat_room_id — INT — Foreign key → apps_chatroom.id
  • user_id — VARCHAR(255) — Foreign key → users_user.id — NOT NULL
  • image_status — VARCHAR(10) — NOT NULL

users_user (사용자)

  • id — VARCHAR(255) — Primary key — NOT NULL
  • password — VARCHAR(128) — NOT NULL
  • is_superuser — TINYINT(1) — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL
  • username — VARCHAR(30) — NOT NULL
  • profile_picture — VARCHAR(200)
  • age — DATE
  • gender — VARCHAR(10)
  • date_joined — DATETIME — NOT NULL
  • last_login — DATETIME — NOT NULL
  • is_admin — TINYINT(1) — NOT NULL
  • is_staff — TINYINT(1) — NOT NULL