caboomlog

Tables (15)

Untitled (blogs)

  • Key (blog_id) — bigint — Primary key — NOT NULL — auto_increment
  • Field (blog_fid) — varchar(50) — NOT NULL — unique
  • Field (blog_name) — varchar(50) — NOT NULL
  • Field (blog_main) — varchar(100) — NOT NULL — 1 - 대표블로그, 2 - 일반블로그 (블로그 소유자의 대표블로그인지 여부)
  • Field (blog_description) — text
  • Field (blog_public) — tinyint — NOT NULL — 1 - public, 2- private
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime
  • Field (blog_main_img) — varchar(200)
  • Field (blog_type) — tinyint — NOT NULL — 1-개인블로그, 2-팀블로그

Untitled (blog_member_mappings)

  • Key (blog_member_mapping_id) — bigint — Primary key — NOT NULL — auto_increment
  • Key (mb_no) — bigint — Foreign key → members.Key — NOT NULL — mb_no + blog_id: unique
  • Key (blog_id) — bigint — Foreign key → Untitled.Key — NOT NULL — mb_no + blog_id: unique
  • Key (role_id) — varchar(50) — Foreign key → Untitled.Key — NOT NULL
  • Field (mb_nickname) — varchar(50) — NOT NULL
  • Field (created_at) — datetime — NOT NULL

Untitled (roles)

  • Key (role_id) — varchar(50) — Primary key — NOT NULL
  • Field (role_name) — varchar(50) — NOT NULL
  • Field (role_description) — varchar(200)

Untitled (topics)

  • Key (topic_id) — int — Primary key — NOT NULL — auto increment
  • Key (topic_pid) — int — Foreign key → Untitled.Key — auto increment
  • Field (topic_name) — varchar(100) — NOT NULL
  • Field (topic_seq) — int — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field2 (updated_at) — datetime

Untitled (team_blog_invites)

  • Key (team_blog_invite_id) — bigint — Primary key — NOT NULL — auto-increment
  • Key (blog_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (mb_no) — bigint — Foreign key → members.Key — NOT NULL
  • Field (status) — varchar(20) — NOT NULL — PENDING, ACCEPTED, REJECTED 중 하나
  • Field (invited_at) — datetime — NOT NULL — 초대 일시
  • Field (responded_at) — datetime — 응답 일시

Untitled (notifications)

  • Key (notification_id) — bigint — Primary key — NOT NULL — auto increment
  • Key (receiver_mb_no) — bigint — Foreign key → members.Key — NOT NULL — 알림을 받는 회원 번호
  • Key (notification_type_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (reference_id) — bigint — NOT NULL — 관련 아이디 (예: comment_id)
  • Field (read) — tinyint — NOT NULL — 0 - 안 읽음, 1 - 읽음
  • Field (message) — varchar(50) — 알림 메시지
  • Field (created_at) — datetime — NOT NULL — 생성일자

Untitled (notification_types)

  • Key (notification_type_id) — varchar(20) — Primary key — NOT NULL
  • Field (notification_type_name) — varchar(20) — NOT NULL
  • Field (notification_type_description) — varchar(50)

Untitled (team_blog_kicks)

  • Key (team_blog_kick_id) — bigint — Primary key — NOT NULL — auto-increment
  • Key (kicked_mb_no) — bigint — Foreign key → members.Key — NOT NULL — 추방당한 대상자 멤버 아이디,
  • Key (kicked_by_mb_no) — bigint — Foreign key → members.Key — NOT NULL — 추방한 멤버 아이디
  • Key (blog_id) — bigint — Foreign key → Untitled.Key — NOT NULL — 팀블로그 아이디.
  • Field3 (kicked_at) — datetime — NOT NULL

Untitled (categories)

  • Key (category_id) — bigint — Primary key — NOT NULL — auto-increment
  • Key (blog_id) — bigint — Foreign key → Untitled.Key — NOT NULL — auto_increment
  • Key (category_pid) — bigint — Foreign key → Untitled.Key — NOT NULL — auto-increment
  • Key (topic_id) — int — Foreign key → Untitled.Key — auto increment
  • Field (category_name) — varchar(30) — NOT NULL
  • Field (category_public) — tinyint — NOT NULL — 1 - public, 2 - private
  • Field (category_order) — bigint — NOT NULL — 카테고리 정렬 순서
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime

Untitled (posts)

  • Key (post_id) — bigint — Primary key — NOT NULL — auto increment
  • Key (blog_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (writer_mb_no) — bigint — Foreign key → members.Key — NOT NULL — 작성한 사람 회원 번호
  • Key (modifier_mb_no) — bigint — Foreign key → members.Key — 수정한 사람 회원 번호
  • Field (post_title) — varchar(30) — NOT NULL — 게시글 제목
  • Field2 (post_content) — text — 게시글 본문
  • Field3 (post_public) — tinyint — NOT NULL — 1 - 공개, 2 - 비공개
  • Field (created_at) — datetime — NOT NULL — 생성일자
  • Field (updated_at) — datetime — 수정일자
  • Field (view_count) — bigint — NOT NULL — 게시글 조회수
  • Field (thumbnail) — varchar(255) — 썸네일 이미지 url

Untitled (post_category_mappings)

  • Key (post_category_mapping_id) — bigint — Primary key — NOT NULL — auto increment
  • Key (category_id) — bigint — Foreign key → Untitled.Key — NOT NULL — category_id + post_id : unique
  • Key (post_id) — bigint — Foreign key → Untitled.Key — NOT NULL — category_id + post_id : unique

Untitled (images)

  • Key (image_id) — bigint — Primary key — NOT NULL — auto increment
  • Field (filename) — varchar(255) — NOT NULL
  • Field (size) — bigint — NOT NULL
  • Field (url) — varchar(512) — NOT NULL — unique
  • Field (created_at) — datetime — NOT NULL

Untitled (post_image_mappings)

  • Key (post_image_mapping_id) — bigint — Primary key — NOT NULL — auto increment
  • Key (post_id) — bigint — Foreign key → Untitled.Key — NOT NULL — 게시물 아이디
  • Key (image_id) — bigint — Foreign key → Untitled.Key — NOT NULL — 이미지 아이디
  • Field (width) — int
  • Field (height) — int
  • Field (image_order) — int

Untitled (comments)

  • Key (comment_id) — bigint — Primary key — NOT NULL — auto_increment
  • Key (parent_comment_id) — bigint — Foreign key → Untitled.Key
  • Key (post_id) — bigint — Foreign key → Untitled.Key — NOT NULL — auto increment
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime
  • Field (deleted_at) — datetime
  • Field (content) — varchar(200) — NOT NULL
  • Field (comment_public) — tinyint — NOT NULL — 1 - 공개, 2 - 비공개
  • Key (blog_member_mapping_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (mb_no) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (blog_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (role_id) — varchar(50) — Foreign key → Untitled.Key — NOT NULL

members

  • Key (mb_no) — bigint — Primary key — NOT NULL — auto_increment
  • Field (mb_email) — varchar(50) — NOT NULL — unique
  • Field (mb_name) — varchar(50) — NOT NULL
  • Field (mb_password) — varchar(200) — NOT NULL
  • Field (mb_mobile) — varchar(15)
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime
  • Field (withdrawal_at) — datetime
  • Field (mb_uuid) — varchar(36) — NOT NULL — 외부 노출용 식별자
  • Field (mb_description) — varchar(200)
  • Field (mb_profile_img) — varchar(200)