helloworld
Tables (16)
COMMENTS
- comment_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key — NOT NULL
- user_id — BIGINT — Foreign key — NOT NULL — 작성자
- parent_comment_id — BIGINT — Foreign key → COMMENTS.comment_id — 대댓글 Self-Join
- content — TEXT — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
COMMENT_LIKES
- comment_like_id — BIGINT — Primary key — NOT NULL
- comment_id — BIGINT — Foreign key → COMMENTS.comment_id — NOT NULL
- user_id — BIGINT — Foreign key — NOT NULL
- created_at — DATETIME — NOT NULL
DM_MEMBERS
- member_id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- member_role — VARCHAR(20) — NOT NULL — OWNER, MEMBER
- last_read_message_id — BIGINT — 위임 처리
- is_accepted — BOOLEAN — NOT NULL
- is_muted — BOOLEAN — NOT NULL
- joined_at — DATETIME — NOT NULL
- left_at — DATETIME — 나가기 soft
DM_MESSAGES
- message_id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → DM_ROOMS.room_id — NOT NULL
- sender_id — BIGINT — Foreign key — NOT NULL
- message_type — VARCHAR(20) — NOT NULL — TEXT, IMAGE, VIDEO, SYSTEM
- content — TEXT — NOT NULL
- deleted_at — DATETIME — 삭제 soft
- created_at — DATETIME — NOT NULL
DM_ROOMS
- room_id — BIGINT — Primary key — NOT NULL
- room_type — VARCHAR(20) — NOT NULL — DIRECT, GROUP
- room_name — VARCHAR(255) — 그룹방명
- created_by — BIGINT — Foreign key — 개설자
- pair_key — VARCHAR(255) — DIRECT 중복방 방지
- created_at — DATETIME — NOT NULL
FOLLOWS
- follow_id — BIGINT — Primary key — NOT NULL
- follower_id — BIGINT — Foreign key — NOT NULL — 거는 사람
- following_id — BIGINT — Foreign key — NOT NULL — 받는 사람
- created_at — DATETIME — NOT NULL
NOTIFICATIONS
- notification_id — BIGINT — Primary key — NOT NULL
- recipient_id — BIGINT — Foreign key — NOT NULL — 알림 받는 사람, USERS
- actor_id — BIGINT — Foreign key — NOT NULL — 알림 발생시킨 사람, USERS
- type — VARCHAR(20) — NOT NULL — LIKE, COMMENT, FOLLOW
- target_post_id — BIGINT — Foreign key — 좋아요/댓글 알림의 대상 게시글
- target_comment_id — BIGINT — Foreign key → COMMENTS.comment_id — 댓글 알림의 대상 댓글
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
POSTS
- post_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USERS.user_id — NOT NULL — 작성자
- post_type — VARCHAR(20) — NOT NULL — PROJECT, CARD_NEWS
- content — TEXT — NOT NULL — Markdown
- thumbnail_url — VARCHAR(500)
- github_url — VARCHAR(500) — GitHub Repository URL, PROJECT
- project_link — VARCHAR(500) — = 배포 deploy_url, iframe 시연
- ai_summary — TEXT — AI 요약
- view_count — INT — NOT NULL
- like_count — INT — NOT NULL
- comment_count — INT — NOT NULL
- is_public — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
POST_BOOKMARKS
- bookmark_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key — NOT NULL
- user_id — BIGINT — Foreign key — NOT NULL
- created_at — DATETIME — NOT NULL
POST_LIKES
- like_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key — NOT NULL
- user_id — BIGINT — Foreign key — NOT NULL
- created_at — DATETIME — NOT NULL
POST_MEDIAS
- media_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key — NOT NULL
- media_type — VARCHAR(20) — NOT NULL — IMAGE, VIDEO, CODE_SNIPPET
- media_url — TEXT — NOT NULL — S3 또는 코드 원문
- display_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
POST_TAGS
- post_tag_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key — NOT NULL
- tag_id — BIGINT — Foreign key → TAGS.tag_id — NOT NULL
- created_at — DATETIME — NOT NULL
TAGS
- tag_id — BIGINT — Primary key — NOT NULL
- tag_type — VARCHAR(20) — NOT NULL — TECH, POSITION, DOMAIN
- tag_name — VARCHAR(100) — NOT NULL
USERS
- user_id — BIGINT — Primary key — NOT NULL
- auth_provider — VARCHAR(20) — NOT NULL — LOCAL, GOOGLE
- social_id — VARCHAR(255)
- login_id — VARCHAR(50) — 일반 가입 ID
- password — VARCHAR(255) — 암호화
- email — VARCHAR(255)
- nickname — VARCHAR(50) — 프로필 생성 단계 설정, 검색 대상
- profile_image_url — VARCHAR(500) — S3/CDN
- github_username — VARCHAR(100) — 깃허브 연동
- exp_point — INT — NOT NULL
- level — INT — NOT NULL
- role — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
USER_BADGES
- badge_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key — NOT NULL
- badge_name — VARCHAR(100) — NOT NULL
- badge_color — VARCHAR(7) — NOT NULL
- acquired_at — DATETIME — NOT NULL
USER_INTERESTS
- interest_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key — NOT NULL
- tag_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- user_id — BIGINT — NOT NULL
- keyword — VARCHAR(255) — NOT NULL
- search_type — VARCHAR(20) — NOT NULL — ALL, POST, USER, TECH_STACK
- searched_at — DATETIME — NOT NULL