teamPro
Tables (3)
Category (Untitled3)
- category_id (Key) — NOT NULL — Primary key — NOT NULL
- title (Field) — NOT NULL
- status (Field4) — NOT NULL
- created_at (Field2) — NOT NULL
- updated_at (Field3) — NOT NULL
Comment (Untitled2)
- comment_id (Key) — NOT NULL — Primary key — NOT NULL
- content (VARCHAR(255)) — NOT NULL
- created_at (Field) — NOT NULL
- status (VARCHAR(50)) — NOT NULL
- post_id — NOT NULL — Foreign key → Post.post_id — NOT NULL
- parent_id (Key2) — Foreign key → Comment.comment_id — NOT NULL
Post (Untitled)
- post_id — NOT NULL — Primary key — NOT NULL
- title — NOT NULL
- content — NOT NULL
- viewd_cnt — NOT NULL
- visibility (Field) — NOT NULL
- status (Field2) — NOT NULL
- created_at (Field3) — NOT NULL
- updated_at (Field4) — NOT NULL
- category_id (Key) — NOT NULL — Foreign key → Category.category_id — NOT NULL