NhnBoard
Tables (15)
Blog
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → User.ID — NOT NULL
- Name (name) — varchar(255) — NOT NULL
- Url (url) — varchar(255) — NOT NULL
Category
- id — bigint — Primary key — NOT NULL
- value — varchar(255) — NOT NULL
Comment
- id — bigint — Primary key — NOT NULL
- post_id — bigint — Foreign key → Post.id — NOT NULL
- 댓글내용 (content) — text — NOT NULL
- updated_at — datetime — NOT NULL
- level — int — NOT NULL
- parent — bigint — Foreign key → Comment.id
- is_public — NOT NULL
GuestBook
- id — int — Primary key — NOT NULL
- blog_id — int — Foreign key → Blog.id — NOT NULL
- updated_at — text — NOT NULL
NotUserComment
- comment_id — bigint — Foreign key → Comment.id — NOT NULL
- nickname — varchar(255)
- password — varchar(255)
NotUserGuestBook
- id — int — Foreign key → GuestBook.id — NOT NULL
- nickname — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
Post
- id — bigint — Primary key — NOT NULL
- user_id — int — Foreign key → User.ID — NOT NULL
- blog_id — int — Foreign key → Blog.id — NOT NULL
- title — varchar(255) — NOT NULL
- contents — text — NOT NULL
- updated_at — datetime — NOT NULL
- is_public — boolean — NOT NULL
- id (id2) — bigint — Foreign key → Category.id — NOT NULL
PostToTag
- post_id — bigint — Foreign key → Post.id — NOT NULL
- tag_id — bigint — Foreign key → Tag.id — NOT NULL
SubCategory
- id — bigint — Foreign key → Category.id — NOT NULL
SuperCategory
- id — bigint — Foreign key → Category.id — NOT NULL
Tag
- id — bigint — Primary key — NOT NULL
- value — varchar(255) — NOT NULL
User
- ID (id) — int — Primary key — NOT NULL
- nickname — varchar(255) — NOT NULL
- 프로필이미지 (profile_img) — varchar(255) — NOT NULL
UserComment
- comment_id — bigint — Foreign key → Comment.id — NOT NULL
- user_id — int — Foreign key → User.ID — NOT NULL
UserGuestBook
- id — int — Foreign key → GuestBook.id — NOT NULL
- ID (id2) — int — Foreign key → User.ID — NOT NULL
ViewCnt
- 날짜 (date) — varchar(255) — NOT NULL
- view_cnt — int — NOT NULL
- blog_id — int — Foreign key → Blog.id — NOT NULL