ㄴㄴ
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)