a

Tables (5)

comment (Untitled4)

  • id (Key) — Long — Primary key — NOT NULL
  • postID (Key2) — Long — Foreign key → post.postID — NOT NULL
  • content (Field) — Varchar

like (Untitled5)

  • id (Key) — Long — Primary key — NOT NULL
  • Id (Key2) — Long — Foreign key → member.Id — NOT NULL
  • type (Field) — Varchar
  • id (Field2) — Long

member (Untitled)

  • Id (Key) — Long — Primary key — NOT NULL
  • email (Field) — Varchar
  • Password (Field2) — varchar
  • vaildNum (Field3) — int
  • image (Field4) — varchar

post (Untitled2)

  • postID (Key) — Long — Primary key — NOT NULL
  • Id (Key2) — Long — Foreign key → member.Id — NOT NULL
  • title (Field) — Varchar
  • content (Field2) — Varchar
  • category (Field3) — Varchar
  • Image (Field4) — Varchar

subcomment (Untitled6)

  • commentid (Key) — Long — Foreign key → comment.id — NOT NULL
  • postID (Key2) — Long — Foreign key → comment.postID — NOT NULL
  • contnet (Field) — Varchar