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