블로그
테이블 (4)
comment (Untitled4)
- comment_id (Key) — number — 기본 키 — NOT NULL
- post_id (FK2) — number — 외래 키 → post.post_id — NOT NULL
- user_email (Key2) — number — 외래 키 → user.user_email — NOT NULL
- comment_content (Field) — VARCHAR(100)
- created_at (Field2) — timestamp
hashtag (Untitled2)
- hashtag_id (Key) — number — 기본 키 — NOT NULL
- post_id (FK) — number — 외래 키 → post.post_id — NOT NULL
- user_email (Key2) — VARCHR(100) — 외래 키 → user.user_email — NOT NULL
- hashtag_content (Field) — VARCHAR(20)
post (Untitled)
- post_id (Key) — number — 기본 키 — NOT NULL
- user_email (Key2) — VARCHR(100) — 외래 키 → user.user_email — NOT NULL
- title (Field4) — VARCHAR(100)
- post_content (Field) — VARCHAR(500)
- created_at (Field2) — timestamp
- update_at (Field3) — timestamp
- category (Field5) — VARCHAR(30)
user (Untitled3)
- user_email (Key) — VARCHR(100) — 기본 키 — NOT NULL
- password (Field) — VARCHAR(100)