ㄴㄴ

Tables (8)

category

  • category_id — PK — Primary key — NOT NULL
  • category_name — NN
  • created_at — VARCHAR(255)
  • updated_atd — VARCHAR(255)

comment

  • member_no — VARCHAR(255) — Foreign key → member.member_no — NOT NULL
  • post_no — VARCHAR(255) — Foreign key → post.post_no — NOT NULL
  • comment_no — PK
  • AI — NOT — NOT NULL
  • comment_content — NN
  • comment_is_secret — "Y"
  • N — NULL
  • created_at — VARCHAR(255)
  • updated_at — VARCHAR(255)
  • comment_is_delete — VARCHAR(255)

like

  • member_no — NN — Foreign key → member.member_no — NOT NULL
  • post_no — NN — Foreign key → post.post_no — NOT NULL
  • like_no — PK
  • AI — NOT — NOT NULL

member

  • member_no — PK
  • AI — NOT — NOT NULL
  • member_id — NN
  • member_pwd — NN
  • member_email — VARCHAR(255)
  • member_pic_url — VARCHAR(255)
  • role — NN
  • created_at — VARCHAR(255)
  • updated_at — VARCHAR(255)

post

  • category_id — NN — Foreign key → category.category_id — NOT NULL
  • post_no — PK
  • AI — NOT — NOT NULL
  • member_no — NN
  • post_title — NN
  • post_content — NN
  • post_thumb_url — VARCHAR(255)
  • created_at — VARCHAR(255)
  • updated_at — VARCHAR(255)

post_tag

  • post_no — NN — Foreign key → post.post_no — NOT NULL
  • post_tag_no — PK
  • AI — NOT — NOT NULL
  • post_tag_name — VARCHAR(255)

reply

  • comment_no — NN — Foreign key → comment.comment_no — NOT NULL
  • member_no — NN — Foreign key → comment.member_no — NOT NULL
  • post_no — NN — Foreign key → comment.post_no — NOT NULL
  • reply_no — PK
  • AI — NOT — NOT NULL
  • reply_content — NN
  • reply_is_secret — "Y"
  • N — NULL
  • created_at — VARCHAR(255)
  • updated_at — VARCHAR(255)
  • reply_is_delete — VARCHAR(255)

role

  • member_no — bigint(20) — Foreign key → member.member_no — NOT NULL
  • role — varchar(20)