별에 별 일

테이블 (18)

constellation

  • constellationId — BIGINT — 기본 키 — NOT NULL
  • createdAt — DATETIME(6) — NOT NULL
  • userId — BIGINT — NOT NULL

constellation_line

  • lineId — BIGINT — 기본 키 — NOT NULL
  • endX — INT — NOT NULL
  • endY — INT — NOT NULL
  • startX — INT — NOT NULL
  • startY — INT — NOT NULL
  • constellation_id — BIGINT — 외래 키 → constellation.constellationId — NOT NULL
  • INDEX — `FKd8esjpx9ajt142j0n6hta957r`

diary

  • diary_id — BIGINT — 기본 키 — NOT NULL
  • diary_date — DATE — NOT NULL
  • createdAt — DATETIME(6)
  • user_id — BIGINT — 외래 키 → user.user_id
  • INDEX — `FKf0xms46ulxc36096k9gg6j9ip`

diary_content

  • diary_content_id — BIGINT — 기본 키 — NOT NULL
  • createdAt — DATETIME(6)
  • diary_id — BIGINT — 외래 키 → diary.diary_id
  • updatedAt — DATETIME(6)
  • content — VARCHAR(255)
  • title — VARCHAR(255)

diary_emotion

  • diary_emotion_id — BIGINT — 기본 키 — NOT NULL
  • xValue — FLOAT
  • yValue — FLOAT
  • createdAt — DATETIME(6)
  • diary_id — BIGINT — 외래 키 → diary.diary_id
  • INDEX — `FKr5ovjdxh85b2e6vmu39ed4uq4`

diary_hashtag

  • diary_hashtag_id — BIGINT — 기본 키 — NOT NULL
  • diary_id — BIGINT — 외래 키 → diary.diary_id
  • hashtag — ENUM('감동적인', '고민되는', '궁금한', '그저그런', '기쁜', '느긋한', '담담한', '답답한', '만족스러운', '멍한', '무기력한', '무심한', '불안한', '설레는', '속상한', '슬픈', '신나는', '심심한', '우울한', '조용한', '졸린', '지친', '짜증나는', '차분한', '초조한', '편안한', '평온한', '행복한', '화난', '후련한')
  • INDEX — `FK914quowc6fwrt3u6nl8tv934y`

diary_image

  • diary_image_id — BIGINT — 기본 키 — NOT NULL
  • created_at — DATETIME(6)
  • diary_id — BIGINT — 외래 키 → diary.diary_id — NOT NULL
  • updated_at — DATETIME(6)
  • save_file_path — VARCHAR(255) — NOT NULL

hashtag

  • tagId — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255)

hashtag_stats

  • hashtag_type — ENUM('감동적인', '고민되는', '궁금한', '그저그런', '기쁜', '느긋한', '담담한', '답답한', '만족스러운', '멍한', '무기력한', '무심한', '불안한', '설레는', '속상한', '슬픈', '신나는', '심심한', '우울한', '조용한', '졸린', '지친', '짜증나는', '차분한', '초조한', '편안한', '평온한', '행복한', '화난', '후련한') — 기본 키 — NOT NULL
  • last_updated_at — DATETIME(6)
  • usage_count — BIGINT

passwordresettoken

  • id — BIGINT — 기본 키 — NOT NULL
  • expiryDate — DATETIME(6)
  • token — VARCHAR(255)
  • user_id — BIGINT — 외래 키 → user.user_id — NOT NULL

personal_univ

  • universe_id — BIGINT — 기본 키 — NOT NULL
  • x_coord — FLOAT
  • y_coord — FLOAT
  • diary_emotion_id — BIGINT — 외래 키 → diary_emotion.diary_emotion_id — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

profile_image

  • image_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
  • save_file_path — VARCHAR(255) — 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
  • interest — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

refresh_token

  • id — BIGINT — 기본 키 — NOT NULL
  • expiration — BIGINT — NOT NULL
  • token — VARCHAR(255) — NOT NULL
  • user_id — BIGINT — 외래 키 → user.user_id — NOT NULL

starline_coord

  • starline_coord_id — BIGINT — 기본 키 — NOT NULL
  • month — INT — NOT NULL
  • year — INT — NOT NULL
  • endEmotionId — BIGINT
  • startEmotionId — BIGINT

token_blacklist

  • id — BIGINT — 기본 키 — NOT NULL
  • expiration — BIGINT — NOT NULL
  • token — VARCHAR(255) — NOT NULL

user

  • user_id — BIGINT — 기본 키 — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • gender — ENUM('FEMALE', 'MALE', 'OTHER') — NOT NULL
  • is_active — BIT(1) — NOT NULL
  • nickname — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • role — ENUM('manager', 'member') — NOT NULL
  • sns_account — BIT(1) — NOT NULL
  • updated_at — DATETIME(6)