별에 별 일
테이블 (12)
chatbot_conversation
- conversation_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- persona_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
chatbot_persona
- persona_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- created_at — DATETIME — NOT NULL
diary
- diary_id — BIGINT — 기본 키 — NOT NULL
- diary_emotion_id — BIGINT — 외래 키 → diary_emotion.diary_emotion_id — NOT NULL
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
diary_emotion
- diary_emotion_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- x_value — FLOAT — NOT NULL
- y_value — FLOAT — NOT NULL
- created_at — DATETIME — NOT NULL
diary_hashtag
- diary_id — BIGINT — 외래 키 → diary.diary_id — NOT NULL
- hashtag_id — BIGINT — 외래 키 → hashtag.hashtag_id — NOT NULL
diary_image
- image_id — BIGINT — 기본 키 — NOT NULL
- diary_id2 — BIGINT — NOT NULL
- save_file_path — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
hashtag
- hashtag_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
profile_image
- image_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- save_file_path — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
radio
- radio_id — BIGINT — 기본 키 — NOT NULL
- host_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- status — ENUM('started','paused','stopped') — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME
- created_at — DATETIME — NOT NULL
radio_interest
- reaction_id — BIGINT — 기본 키 — NOT NULL
- radio_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- interest — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
universe_log
- universe_id — BIGINT — 기본 키 — NOT NULL
- diary_emotion_id — BIGINT — 외래 키 → diary_emotion.diary_emotion_id — NOT NULL
- log_month — DATE — NOT NULL
- x_coord — FLOAT
- y_coord — FLOAT
- updated_at — DATETIME — NOT NULL
user
- user_id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- nickname — VARCHAR(100) — NOT NULL
- gender — VARCHAR(10) — NOT NULL
- social_id — VARCHAR(255)
- role — ENUM('member', 'manager') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- is_active — TINYINT(1) — NOT NULL
- token — VARCHAR(255)