eco

Tables (3)

Comment

  • commentid (Key) — Long — Primary key — NOT NULL
  • postid (Key2) — Long — Foreign key → post.postid — NOT NULL
  • contents (Field) — String
  • id (Field2) — String
  • writedAt (Field3) — String
  • modifiedAt (Field4) — String

post

  • postid (Key) — Long — Primary key — NOT NULL
  • Key (Key2) — Long — Foreign key → user.userid — NOT NULL
  • title (Field) — String
  • contents (Field2) — String
  • createdAt (Field3) — String
  • modifiedAt (Field4) — String
  • like (Field5) — int
  • fileURL (Field6) — String
  • category (Field7) — String

user (Untitled)

  • userid (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • id (Field2) — String
  • pw (Field3) — String
  • email (Field4) — String