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