별에 별 일

테이블 (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)