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 (소셜타입)