소담소담
테이블 (18)
ALARM
- alarm_id — BIGINT — 기본 키 — NOT NULL — auto increment
- user_id — varchar — 외래 키 → USER.user_id — NOT NULL — UUID
- type — VARCHAR — NOT NULL — ENUM
- target_id — BIGINT — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- modified_at — DATETIME — NOT NULL
CHAT_MESSAGE
- chat_message_id — BIGINT — 기본 키 — NOT NULL — auto increment
- chat_room_id — BIGINT — 외래 키 → CHAT_ROOM.chat_room_id — NOT NULL — auto increment
- content — TEXT — NOT NULL
- is_read — BOOLEAN — NOT NULL
- sender_id (user_id) — varchar — 외래 키 → USER.user_id — NOT NULL — UUID
- created_at — DATETIME — NOT NULL
- modified_at — DATETIME — NOT NULL
CHAT_ROOM
- chat_room_id — BIGINT — 기본 키 — NOT NULL — auto increment
- user_id (sender_id) — varchar — 외래 키 → USER.user_id — NOT NULL — UUID
- user2_id (recipient_id) — varchar — 외래 키 → USER.user_id — NOT NULL — UUID
- created_at — DATETIME — NOT NULL
- modified_at — DATETIME — NOT NULL
CHAT_SETTING
- chat_setting_id — BIGINT — 기본 키 — NOT NULL — auto increment
- chatroom_id — BIGINT — 외래 키 → CHAT_ROOM.chat_room_id — NOT NULL — auto increment
- user_id — varchar — 외래 키 → USER.user_id — NOT NULL — UUID
- alarm_enabled — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- modified_at — DATETIME — NOT NULL
COMMENT
- comment_id — biginteger — 기본 키 — NOT NULL — auto increment
- post_id — biginteger — 외래 키 → POST.post_id — NOT NULL
- user_id — varchar — 외래 키 → USER.user_id — NOT NULL
- content — varchar — NOT NULL
- likes — biginteger — NOT NULL
- is_deleted — boolean — NOT NULL
- created_at — datetime — NOT NULL
- modified_at — datetime — NOT NULL
EMAIL_AUTH
- email_auth_id — varchar — 기본 키 — NOT NULL — UUID
- user_id — varchar — 외래 키 → USER.user_id — NOT NULL
- email_auth_code — varchar — NOT NULL — 랜덤숫자(6)
- email_auth_status — varchar — NOT NULL — Y, N, P 인증, 미인증, 대기중 (협의필요)
- created_at — datetime — NOT NULL — 생성일시 기준으로 만료일시 판단
- modified_at — datetime — NOT NULL
MEDIA (미디어)
- media_id — biginteger — 기본 키 — NOT NULL — auto increment
- post_id — biginteger — 외래 키 → POST.post_id — NOT NULL
- original_name — varchar — NOT NULL
- saved_name — varchar — NOT NULL
- saved_url — varchar — NOT NULL
- created_at — datetime — NOT NULL
- modified_at — datetime — NOT NULL
MESSAGE
- message_id — BIGINT — 기본 키 — NOT NULL — auto increment
- content — TEXT — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- modified_at — DATETIME — NOT NULL
- sender_id — varchar — 외래 키 → USER.user_id — NOT NULL — UUID
- receiver_id — varchar — 외래 키 → USER.user_id — NOT NULL — UUID
POST
- post_id — biginteger — 기본 키 — NOT NULL — auto increment
- sereies_id — biginteger — 외래 키 → SERIES.sereies_id — NOT NULL — auto increment
- user_id — varchar — 외래 키 → USER.user_id — NOT NULL
- category — varchar — NOT NULL
- title — varchar — NOT NULL
- content — text — NOT NULL
- thumnail_url — varchar — 썸네일 이미지 주소
- is_secret — boolean — NOT NULL
- likes — biginteger — NOT NULL
- views — biginteger — NOT NULL
- created_at — datetime — NOT NULL
- modified_at — datetime — NOT NULL
POST_LIKE
- post_like_id — varchar — 기본 키 — NOT NULL — UUID
- post_id — biginteger — 외래 키 → POST.post_id — NOT NULL — auto increment
- user_id — varchar — 외래 키 → USER.user_id — NOT NULL
- created_at — datetime — NOT NULL
- modified_at — datetime — NOT NULL
POST_TAG
- post_tag_id — biginteger — 기본 키 — NOT NULL — auto increment
- post_id — biginteger — 외래 키 → POST.post_id — NOT NULL — auto increment
- tag_id — biginteger — 외래 키 → TAG.tag_id — NOT NULL — auto increment
- created_at — datetime — NOT NULL
- modified_at — datetime — NOT NULL
PROFILE
- profile_id — varchar — 기본 키 — NOT NULL — UUID
- user_id — varchar — 외래 키 → USER.user_id — NOT NULL
- profile_image_url — varchar — 프로필 이미지가 저장된 url 주소
- nickname — varchar — NOT NULL
- introduction — text
- created_at — datetime — NOT NULL
- modified_at — datatime — NOT NULL
REPLY
- child_comment_id — biginteger — 기본 키 — NOT NULL — auto increment
- comment_id — biginteger — 외래 키 → COMMENT.comment_id — NOT NULL
- user_id — varchar — 외래 키 → USER.user_id — NOT NULL
- content — varchar — NOT NULL
- likes — biginteger — NOT NULL
- is_deleted — boolean — NOT NULL
- created_at — datetime — NOT NULL
- modified_at — datetime — NOT NULL
SERIES
- sereies_id — biginteger — 기본 키 — NOT NULL — auto increment
- user_id — varchar — 외래 키 → USER.user_id — NOT NULL
- title — varchar — NOT NULL
- introduction — text
- thumnail_url
- views — biginteger — NOT NULL
- created_at — datetime — NOT NULL
- modified_at — datetime — NOT NULL
SERIES_LIKE
- series_like_id — varchar — 기본 키 — NOT NULL — UUID
- sereies_id — biginteger — 외래 키 → SERIES.sereies_id — NOT NULL — auto increment
- user_id — varchar — 외래 키 → USER.user_id — NOT NULL
- created_at — datetime — NOT NULL
- modified_at — datetime — NOT NULL
TAG
- tag_id — biginteger — 기본 키 — NOT NULL — auto increment
- tag_name — varchar
- created_at — datetime
- modified_at — datetime
USER
- user_id — varchar — 기본 키 — NOT NULL
- password — varchar — NOT NULL
- phone — varchar
- user_name — varchar
- date_of_birth — varchar
- is_consent — varchar — NOT NULL
- is_phone_auth — varchar — NOT NULL
- is_email_auth — varchar — NOT NULL
- created_at — datetime — NOT NULL
- modified_at — datetime — NOT NULL
팔로우관계 (FOLLOW_RELAITONSHIP)
- follow_relationship_id — 기본 키 — NOT NULL — UUID
- follower_profile_id — varchar — 외래 키 → PROFILE.profile_id — NOT NULL — UUID
- following_profile_id — varchar — NOT NULL — UUID
- created_at — DATETIME — NOT NULL
- modified_at — DATETIME — NOT NULL