MOODCAST

Tables (30)

admin_action_logs

  • log_id — BIGINT — Primary key — NOT NULL
  • admin_id — BIGINT — Foreign key → members.member_id — NOT NULL
  • action_type — varchar(50)
  • target_type — varchar(100)
  • target_id — BIGINT
  • created_at — DATETIME
  • action_detail — varchar(500)

auth_codes

  • auth_code_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.member_id
  • target_type — VARCHAR(20) — NOT NULL
  • target_value — VARCHAR(255) — NOT NULL
  • purpose — VARCHAR(30) — NOT NULL
  • code_hash — VARCHAR(255) — NOT NULL
  • expires_at — DATETIME(6) — NOT NULL
  • verified_at — DATETIME(6)
  • used_at — DATETIME(6)
  • attempt_count — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

chat_tbl

  • chat_id — INT
  • sender_id — INT — NOT NULL
  • receiver_id — INT — NOT NULL
  • content — TEXT — NOT NULL
  • is_read — TINYINT
  • created_at — DATETIME
  • deleted_yn — TINYINT

comment_tbl

  • comment_id — NUMBER — Primary key — NOT NULL
  • post_id — NUMBER — Foreign key → post_tbl.post_id — NOT NULL
  • member_id — NUMBER — Foreign key → members.member_id — NOT NULL
  • parent_id — NUMBER — Foreign key → comment_tbl.comment_id
  • content — VARCHAR2(200)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP
  • deleted_yn — CHAR(1) — NOT NULL

emotion

  • emotion_id — NUMBER — Primary key — NOT NULL
  • emotion_code — VARCHAR2(30) — NOT NULL
  • emotion_name — VARCHAR2(30) — NOT NULL
  • emotion_icon — VARCHAR2(50)
  • emotion_color — VARCHAR2(20)
  • sort_order — NUMBER
  • is_active — CHAR(1) — NOT NULL

follow_tbl

  • follow_id — NUMBER — Primary key — NOT NULL
  • follower_member_id — NUMBER — Foreign key → members.member_id — NOT NULL
  • following_member_id — NUMBER — Foreign key → members.member_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

hashtag

  • hashtag_id — NUMBER — Primary key — NOT NULL
  • hashtag — VARCHAR2(30) — NOT NULL

interest

  • interest_id — NUMBER — Primary key — NOT NULL
  • interest_name — VARCHAR2(50) — NOT NULL
  • category — VARCHAR2(50)
  • interest_icon — VARCHAR2(50)
  • is_active — CHAR(1) — NOT NULL

member_oauth_accounts

  • oauth_account_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.member_id — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • provider_email — VARCHAR(255)
  • provider_nickname — VARCHAR(100)
  • connected_at — DATETIME(6) — NOT NULL
  • last_login_at — DATETIME(6)

member_terms_agreements

  • agreement_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.member_id — NOT NULL
  • terms_id — BIGINT — Foreign key → terms.terms_id — NOT NULL
  • agreed — TINYINT — NOT NULL
  • agreed_at — DATETIME(6)
  • withdrawn_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL

members

  • member_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • name — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(50)
  • phone — VARCHAR(30) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • bio — VARCHAR(300)
  • email_verified — TINYINT(1) — NOT NULL
  • phone_verified — TINYINT(1) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • last_login_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted_at — DATETIME
  • suspended_until — DATETIME
  • suspension_count — BIGINT
  • warning_count — BIGINT

mood_log

  • mood_log_id — NUMBER — Primary key — NOT NULL
  • member_id — NUMBER — Foreign key → members.member_id — NOT NULL
  • emotion_id — NUMBER — Foreign key → emotion.emotion_id — NOT NULL
  • status_id — NUMBER — Foreign key → mood_status.status_id
  • log_date — DATE — NOT NULL
  • memo — VARCHAR2(500)
  • visibility — VARCHAR2(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

mood_status

  • status_id — NUMBER — Primary key — NOT NULL
  • status_code — VARCHAR2(30) — NOT NULL
  • status_name — VARCHAR2(30) — NOT NULL
  • status_icon — VARCHAR2(50)
  • status_color — VARCHAR2(20)
  • sort_order — NUMBER
  • is_active — CHAR(1) — NOT NULL

notices_tbl

  • notice_id — BIGINT — Primary key — NOT NULL
  • title — varchar(200)
  • content — varchar(500)
  • notice_type — varchar(30)
  • created_by_admin_id — BIGINT — Foreign key → members.member_id — NOT NULL
  • updated_by_admin_id — BIGINT — Foreign key → members.member_id — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

notification

  • notification_id — NUMBER — Primary key — NOT NULL
  • receiver_member_id — NUMBER — Foreign key → members.member_id — NOT NULL
  • sender_member_id — NUMBER — Foreign key → members.member_id
  • post_id — NUMBER — Foreign key → post_tbl.post_id
  • comment_id — NUMBER — Foreign key → comment_tbl.comment_id
  • notification_type — VARCHAR2(30) — NOT NULL
  • is_read — CHAR(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

post_hashtag

  • post_hashtag_id — NUMBER — Primary key — NOT NULL
  • post_id — NUMBER — Foreign key → post_tbl.post_id — NOT NULL
  • hashtag_id — NUMBER — Foreign key → hashtag.hashtag_id — NOT NULL

post_image

  • image_id — NUMBER — Primary key — NOT NULL
  • post_id — NUMBER — Foreign key → post_tbl.post_id — NOT NULL
  • file_name — VARCHAR2(200)
  • file_url — CLOB
  • sort_order — NUMBER
  • created_at — TIMESTAMP — NOT NULL

post_interest

  • post_interest_id — NUMBER — Primary key — NOT NULL
  • post_id — NUMBER — Foreign key → post_tbl.post_id — NOT NULL
  • interest_id — NUMBER — Foreign key → interest.interest_id — NOT NULL

post_tbl

  • post_id — NUMBER — Primary key — NOT NULL
  • member_id — NUMBER — Foreign key → members.member_id — NOT NULL
  • emotion_id — NUMBER — Foreign key → emotion.emotion_id
  • status_id — NUMBER — Foreign key → mood_status.status_id
  • content — CLOB
  • location — VARCHAR2(100)
  • visibility — VARCHAR2(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP
  • deleted_yn — CHAR(1) — NOT NULL

recommend_content

  • recommend_content_id — NUMBER — Primary key — NOT NULL
  • title — VARCHAR2(100) — NOT NULL
  • content — CLOB
  • content_type — VARCHAR2(30) — NOT NULL
  • content_url — CLOB
  • emotion_id — NUMBER — Foreign key → emotion.emotion_id
  • status_id — NUMBER — Foreign key → mood_status.status_id
  • is_active — CHAR(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

recommend_content_interest

  • recommend_content_interest_id — NUMBER — Primary key — NOT NULL
  • recommend_content_id — NUMBER — Foreign key → recommend_content.recommend_content_id — NOT NULL
  • interest_id — NUMBER — Foreign key → interest.interest_id — NOT NULL

report

  • report_id — NUMBER — Primary key — NOT NULL
  • reporter_member_id — NUMBER — Foreign key → members.member_id — NOT NULL
  • post_id — NUMBER — Foreign key → post_tbl.post_id
  • comment_id — NUMBER — Foreign key → comment_tbl.comment_id
  • reason — VARCHAR2(200) — NOT NULL
  • report_status — VARCHAR2(20) — NOT NULL
  • handled_memo — VARCHAR2(200)
  • created_at — TIMESTAMP — NOT NULL
  • handled_at — TIMESTAMP
  • handled_by_member_id — BIGINT — Foreign key → members.member_id — NOT NULL

saved_post

  • saved_post_id — NUMBER — Primary key — NOT NULL
  • member_id — NUMBER — Foreign key → members.member_id — NOT NULL
  • post_id — NUMBER — Foreign key → post_tbl.post_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

terms

  • terms_id — BIGINT — Primary key — NOT NULL
  • terms_type — VARCHAR(30) — NOT NULL
  • version — VARCHAR(20) — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — MEDIUMTEXT
  • is_required — TINYINT — NOT NULL
  • is_active — TINYINT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

user_comment_like

  • user_comment_like_id — NUMBER — Primary key — NOT NULL
  • member_id — NUMBER — Foreign key → members.member_id — NOT NULL
  • comment_id — NUMBER — Foreign key → comment_tbl.comment_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

user_comment_tag

  • user_comment_tag_id — NUMBER — Primary key — NOT NULL
  • member_id — NUMBER — Foreign key → members.member_id — NOT NULL
  • comment_id — NUMBER — Foreign key → comment_tbl.comment_id — NOT NULL

user_interest

  • user_interest_id — NUMBER — Primary key — NOT NULL
  • member_id — NUMBER — Foreign key → members.member_id — NOT NULL
  • interest_id — NUMBER — Foreign key → interest.interest_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

user_post_empathy

  • user_post_empathy_id — NUMBER — Primary key — NOT NULL
  • member_id — NUMBER — Foreign key → members.member_id — NOT NULL
  • post_id — NUMBER — Foreign key → post_tbl.post_id — NOT NULL
  • emotion_id — NUMBER — Foreign key → emotion.emotion_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

user_post_like

  • user_post_like_id — NUMBER — Primary key — NOT NULL
  • member_id — NUMBER — Foreign key → members.member_id — NOT NULL
  • post_id — NUMBER — Foreign key → post_tbl.post_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

user_post_tag

  • user_post_tag_id — NUMBER — Primary key — NOT NULL
  • member_id — NUMBER — Foreign key → members.member_id — NOT NULL
  • post_id — NUMBER — Foreign key → post_tbl.post_id — NOT NULL