블로그

테이블 (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)