bud erd
테이블 (22)
게시글 좋아요 (post_like)
- id (Key) — big int — 기본 키 — NOT NULL
- created_at (Field) — datetime
- modified_at (Field2) — datetime
- member_id (Key3) — big int — 외래 키 → 멤버.id — NOT NULL
- post_id (Key2) — big int — 외래 키 → 게시물.id — NOT NULL
chat
- id (Key) — big int — 기본 키 — NOT NULL
- created_at (Field) — datetime
- modified_at (Field2) — datetime
- chat_room_id (Key2) — big int — 외래 키 → 채팅룸.id — NOT NULL
- member_id (Key3) — big int — 외래 키 → 멤버.id — NOT NULL
- deleted_at (Field3) — datetime
- content (Field4) — varchar(255)
- status (Field5) — varchar(15)
게시글 스크랩 (post_scrap)
- id (Key) — big int — 기본 키 — NOT NULL
- created_at (Field) — datetime
- modified_at (Field2) — datetime
- member_id (Key3) — big int — 외래 키 → 멤버.id — NOT NULL
- post_id (Key2) — big int — 외래 키 → 게시물.id — NOT NULL
게시물 (post)
- id (Key) — big int — 기본 키 — NOT NULL
- title (Field) — varchar(100)
- content (Field2) — blob
- comment_count (Field4) — int
- like_count (Field3) — int
- scrap_count (Field5) — int
- hit_count (Field8) — int
- member_id (Key2) — big int — 외래 키 → 멤버.id — NOT NULL
- status (Field6) — varchar(15)
- type (Field7) — varchar(15)
깃헙정보 (github_info)
- id (Key) — big int — 기본 키 — NOT NULL
- userId (Key3) — varchar(255) — 기본 키 — NOT NULL — UniqueKey
- username (Field2) — varchar(40)
- access_token (Field8) — varchar(255)
- created_at (Field4) — datetime
- modified_at (Field5) — datetime
- member_id (Key2) — big int — 외래 키 → 멤버.id — NOT NULL
뉴스 (news)
- id (Key) — big int — 기본 키 — NOT NULL
- title (Field2) — varchar(255)
- content (Field3) — blob
- comment_count (Field4) — varchar(255)
- company (Field) — varchar(15)
- reporter (Field5) — varchar(10)
- date (Field6) — datetime
- link (Field7) — text
- hit_count (Field8) — int
답변 (qna_answer)
- id (Key) — big int — 기본 키 — NOT NULL
- post_id (Key3) — big int — 외래 키 → 게시물.id — NOT NULL
- member_id (Key2) — big int — 외래 키 → 멤버.id — NOT NULL
- content (Field2) — blob
- comment_count (Field4) — int
- like_count (Field3) — int
- status (Field6) — varchar(15)
답변 핀 (qna_answer_pin)
- id (Key) — big int — 기본 키 — NOT NULL
- created_at (Field) — datetime
- modified_at (Field2) — datetime
- post_id (Key3) — big int — 외래 키 → 게시물.id — NOT NULL
- qna_answer_id (Key2) — big int — 외래 키 → 답변.id — NOT NULL
답변_댓글 (qna_answer_comment)
- id (Key) — big int — 기본 키 — NOT NULL
- qna_answer_id (Key3) — big int — 외래 키 → 답변.id — NOT NULL
- member_id (Key2) — big int — 외래 키 → 멤버.id — NOT NULL
- content (Field2) — varchar(255)
- like_count (Field3) — int
- comment_count (Field4) — int
- parent_comment_id (Key4) — big int
- status (Field) — varchar(15)
답변_댓글_좋아요 (qna_answer_comment_like)
- id (Key) — big int — 기본 키 — NOT NULL
- qna_answer_comment_id (Key2) — big int — 외래 키 → 답변_댓글.id — NOT NULL
- member_id (Key3) — big int — 외래 키 → 멤버.id — NOT NULL
- created_at (Field) — datetime
- modified_at (Field2) — datetime
답변_이미지 (qna_answer_image)
- id (Key) — big int — 기본 키 — NOT NULL
- qna_answer_id (Key2) — big int — 외래 키 → 답변.id — NOT NULL
- image_path (Field3) — varchar(255)
- created_at (Field) — datetime
- modified_at (Field2) — datetime
댓글 (comment)
- id (Key) — big int — 기본 키 — NOT NULL
- content (Field2) — varchar(255)
- like_count (Field3) — int
- comment_count (Field4) — int
- member_id (Key2) — big int — 외래 키 → 멤버.id — NOT NULL
- post_id (Key3) — big int — 외래 키 → 게시물.id — NOT NULL
- parent_comment_id (Key4) — big int
- status (Field) — varchar(15)
댓글 좋아요 (comment_like)
- id (Key) — big int — 기본 키 — NOT NULL
- created_at (Field) — datetime
- modified_at (Field2) — datetime
- member_id (Key3) — big int — 외래 키 → 멤버.id — NOT NULL
- comment_id (Key2) — big int — 외래 키 → 댓글.id — NOT NULL
댓글핀 (CopyOfcomment_like)
- id (Key) — big int — 기본 키 — NOT NULL
- created_at (Field) — datetime
- modified_at (Field2) — datetime
- comment_id (Key2) — big int — 외래 키 → 댓글.id — NOT NULL
- post_id (Key3) — big int — 외래 키 → 게시물.id — NOT NULL
레벨 (level)
- id (Key) — big int — 기본 키 — NOT NULL
- level_number (Field) — big int
- level_code (Field2) — varChar(255)
- level_start_commit_count (Field3) — big int
- next_level_start_commit_count (Field4) — big int
- image_path (Field7) — varchar(255)
- blank_image_path (Field8) — varchar(255)
- created_at (Field5) — datetime
- modified_at (Field6) — datetime
멤버 (Member)
- id (Key) — big int — 기본 키 — NOT NULL
- level_id (Key2) — big int — 외래 키 → 레벨.id — NOT NULL
- user_id (Field) — varchar(255)
- password (Field4) — varchar(255)
- created_at (Field5) — datetime
- modified_at (Field6) — datetime
- level (Field7) — varchar(20)
- nickname (Field9) — varchar(40)
- profile_img (Field10) — varchar(255)
- job (Field11) — varchar(50)
- status (Field12) — varchar(10)
- introduceMessage (Field2) — varchar(255)
알림 (notification)
- id (Key) — big int — 기본 키 — NOT NULL
- receiver_id (Key2) — big int — 외래 키 → 멤버.id — NOT NULL
- sender_id (Field5) — big int
- notification_id (Field8) — varchar(50)
- notification_type (Field) — varchar(15)
- page_type (Field2) — big int
- page_id (Field3) — datetime
- notification_detail_type (Field9) — varchar(30)
- notification_status (Field10) — varchar(20)
- notifed_at (Field11) — datetime
- created_at (Field6) — datetime
- updated_at (Field4) — datetime
알림 정보 (notification_info)
- id (Key) — big int — 기본 키 — NOT NULL
- fcm_token (Field5) — varchar(255)
- member_id (Key2) — big int — 외래 키 → 멤버.id — NOT NULL
- is_post_push_available (Field) — boolean
- is_follow_push_available (Field2) — boolean
이미지 (image)
- id (Key) — big int — 기본 키 — NOT NULL
- post_id (Key2) — big int — 외래 키 → 게시물.id — NOT NULL
- image_path (Field3) — varchar(255)
- created_at (Field) — datetime
- modified_at (Field2) — datetime
채팅룸 (chat_room)
- id (Key) — big int — 기본 키 — NOT NULL
- title (Field3) — varchar(30)
- created_at (Field) — datetime
- modified_at (Field2) — datetime
- status (Field5) — varchar(15)
커밋내역 (commit_history)
- id (Key) — big int — 기본 키 — NOT NULL
- github_info_id (Key3) — big int — 외래 키 → 깃헙정보.id — NOT NULL
- commit_date (Field2) — datetime
- commit_count (Field) — int
- consecutive_commit_days (Field3)
- created_at (Field4) — datetime
- modified_at (Field5) — datetime
팔로잉 (Following)
- id (Key) — big int — 기본 키 — NOT NULL
- target_member_id (Field) — big int
- created_at (Field3) — datetime
- modified_at (Field2) — datetime
- member_id (Key2) — big int — 외래 키 → 멤버.id — NOT NULL