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