ㅇㅇㅇㅇㅇㅇㅇㅇ

Tables (9)

category

  • category_id — NUMBER — Primary key — NOT NULL
  • category_name — VARCHAR(255)
  • 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)

files

  • file_No — number — NOT NULL
  • post_no — number — NOT NULL
  • file_url — VARCHAR(200)
  • file_alt — VARCHAR(200)
  • created_at — VARCHAR(255) — NOT NULL
  • updated_at — VARCHAR(255) — NOT NULL

like

  • like_no — NUMBER — Primary key — NOT NULL
  • member_no — NUMBER — Foreign key → member.member_no — NOT NULL
  • post_no — NUMBER — Foreign key → post.post_no — NOT NULL

member

  • member_no — number — Primary key — NOT NULL
  • member_id — varchar(100) — NOT NULL
  • member_pwd — varchar(200) — NOT NULL
  • member_email — VARCHAR(255) — NOT NULL
  • member_pic — VARCHAR(255)
  • role — VARCHAR(20) — NOT NULL
  • created_at — VARCHAR(255) — NOT NULL
  • updated_at — VARCHAR(255) — NOT NULL

post

  • post_no — number — Primary key — NOT NULL
  • category_id — number — Foreign key → category.category_id — NOT NULL
  • member_no — number — NOT NULL
  • post_title — VARCHAR(200) — NOT NULL
  • post_content — VARCHAR(4000) — NOT NULL
  • post_thumb_url — VARCHAR(255)
  • created_at — VARCHAR(255) — NOT NULL
  • updated_at — VARCHAR(255) — NOT NULL

post_tag

  • post_tag_no — number — Primary key — NOT NULL
  • post_no — number — Foreign key → post.post_no — 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 — NUMBER — Foreign key → member.member_no — NOT NULL
  • member_role — varchar(20)