bud

테이블 (25)

게시글 좋아요 (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

게시물 (CopyOfpost)

  • 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
  • status (Field6) — varchar(15)
  • type (Field7) — varchar(15)
  • Field9

게시물 (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_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)

  • 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_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

이미지 (CopyOfimage)

  • id (Key) — big int — 기본 키 — NOT NULL
  • image_path (Field3) — varchar(255)
  • created_at (Field) — datetime
  • modified_at (Field2) — datetime
  • id (Key2) — big int — 외래 키 → 게시물.id — NOT NULL

좋아요 (like)

  • id (Key) — big int — 기본 키 — NOT NULL
  • created_at (Field) — datetime
  • modified_at (Field2) — datetime
  • user_id (Field3) — big int
  • post_id (Key2) — big int — 외래 키 → 게시물.id — NOT NULL

채팅룸 (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