blog

Tables (9)

b_category

  • blog_category_id (b_categroy_id) — varchar — Primary key — NOT NULL
  • blog_category_name (b_category_name) — varchar — NOT NULL
  • parent_id — varchar — StringBuilder

blog

  • blog_key — autoIncrement — Primary key — NOT NULL
  • blog_name — varchar — NOT NULL
  • blog_context — varchar
  • notification — varchar — 공지사항
  • user_email — varchar — Foreign key → user.user_email
  • post_key — AutoIncrement — Foreign key → post.post_key — NOT NULL

blog_Category (blog_category)

  • blog_category_id (blog_categroy_id) — varchar — Foreign key → b_category.blog_category_id — NOT NULL
  • blog_key — autoIncrement — Foreign key → blog.blog_key — NOT NULL

comment

  • comment_key — auto_increment — Primary key — NOT NULL
  • comment — nvarchar(500) — NOT NULL — 댓글 내용
  • parent_id — varchar — NOT NULL — StringBuilder
  • user_email — varchar — Foreign key → user.user_email
  • post_key — AutoIncrement — Foreign key → post.post_key — NOT NULL
  • blog_key — autoIncrement — Foreign key → blog.blog_key — NOT NULL

image

  • image_id — autoIncrement — Primary key — NOT NULL
  • image_root — varchar — NOT NULL — 이미지를 가져올 수 있는 위치
  • locate — varchar — NOT NULL — 이미지가 삽입된 위치 (blog or post0
  • type — varchar — NOT NULL — 확장자 명
  • post_key — AutoIncrement — Foreign key → post.post_key — NOT NULL
  • blog_key — autoIncrement — Foreign key → blog.blog_key — NOT NULL

p_category

  • category_id — AutoIncrement — Primary key — NOT NULL
  • category_name — varchar — NOT NULL
  • parent_id — varchar — StringBuilder

post

  • post_key — AutoIncrement — Primary key — NOT NULL
  • content — text — NOT NULL — 포스트 내용
  • 제목 (title) — varchar — NOT NULL

post_category

  • category_id — varchar — Foreign key → p_category.category_id — NOT NULL
  • post_key — Foreign key → post.post_key — NOT NULL

user

  • user_email — varchar — Primary key — NOT NULL
  • user_password — varchar — NOT NULL
  • user_nickname — varchar — NOT NULL — 닉네임
  • created_at — dateTime — NOT NULL — // 사용한 이유에 대해서
  • state — Boolean — 회원 탈퇴 ox