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