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