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