yanglog
Tables (11)
blog (블로그)
- id (블로그ID) — Primary key — NOT NULL
- title (블로그이름)
- created_at (생성일)
- updated_at (수정일)
- member_id (회원ID) — Foreign key → member.id — NOT NULL
category (카테고리)
- id (카테고리ID) — Primary key — NOT NULL
- parent_id (부모ID) — Foreign key → category.id — NOT NULL
- blog_id (블로그ID) — Foreign key → blog.id — NOT NULL
- name (이름)
- created_at (생성일)
- updated_at (수정일)
comment (댓글)
- id (댓글ID) — Primary key — NOT NULL
- post_id (게시물ID) — Foreign key → post.id — NOT NULL
- parrent_id (부모댓글) — Foreign key → comment.id — NOT NULL
- member_id (회원ID) — Foreign key → member.id — NOT NULL
- content (댓글내용)
- created_at (생성일)
- updated_at (수정일)
- depth (깊이)
- group (댓글그룹)
- order (순서)
file (파일)
- id (파일ID) — Primary key — NOT NULL
- path (경로)
- name (파일이름)
- created_at (생성일)
- updated_at (수정일)
- size (파일크기)
- type (파일종류)
member (회원)
- id (회원ID) — Primary key — NOT NULL
- name (이름)
- email (이메일)
- last_login_at (마지막로그인)
- created_at (생성일)
- updated_at (수정일)
- state (상태)
member_role (회원권한)
- member_id (회원ID) — Foreign key → member.id — NOT NULL
- role_id (권한ID) — Foreign key → role.id — NOT NULL
normal_member (일반회원)
- id (회원ID) — Foreign key → member.id — NOT NULL
- password (비밀번호)
post (게시물)
- id (게시물ID) — Primary key — NOT NULL
- blog_id (블로그ID) — Foreign key → blog.id — NOT NULL
- member_id (회원ID) — Foreign key → member.id — NOT NULL
- title (게시물이름)
- content (게시물내용)
- created_at (생성일)
- updated_at (수정일)
- is_public (공개여부)
post_file (게시물파일)
- post_id (게시물ID) — Foreign key → post.id — NOT NULL
- file_id (파일ID) — Foreign key → file.id — NOT NULL
role (권한)
- id (권한ID) — Primary key — NOT NULL
- name (권한이름)
- created_at (생성일)
- updated_at (수정일)
social_member (소셜회원)
- id (회원ID) — Foreign key → member.id — NOT NULL
- social_type (소셜타입)