소담소담

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