db

Tables (4)

Comment (Untitled3)

  • id (코멘트 아이디) — Primary key — NOT NULL
  • post_id (포스트 아이디) — Foreign key → Member.id — NOT NULL
  • created_id (멤버 아이디) — Foreign key → Post.created_id — NOT NULL
  • content (댓글)

Member (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • email (Field2)

Post (Untitled)

  • id (Key) — Primary key — NOT NULL
  • created_id (Key2) — Foreign key → Member.id — NOT NULL
  • title (Field)
  • content (Field2)
  • create_at (Field3)

User Post (Untitled4)

  • id (아이디) — Primary key — NOT NULL
  • created_id (포스트 아이디) — Foreign key → Post.created_id — NOT NULL
  • post_id (Key) — Foreign key → Member.id — NOT NULL