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