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)