ERD

Tables (3)

Comment (Untitled3)

  • comment_id (Key) — int — Primary key — NOT NULL
  • user_id (Key5) — int — Foreign key → User.user_id
  • post_id (Key32) — int — Foreign key → Post.user_id
  • content (Field2) — String
  • created_at (Field3) — DataTime
  • pick (Field4) — boolean

Post (Untitled2)

  • post_id (Key) — int — Primary key — NOT NULL
  • user_id (Key3) — int — Foreign key → User.user_id
  • skill (Field) — String
  • progress (Field4) — String
  • people_num (Field5) — String
  • deadline (Field6) — String
  • content (Field7) — String
  • created_at (Field8) — DataTime
  • type (Field9) — String
  • done (Field10) — boolean
  • title (Field2) — String
  • place (Field3) — String
  • latitude (Field11) — Float
  • longitude (Field12) — Float

User (Untitled)

  • user_id (Key) — int — Primary key
  • loginid (Field6) — String
  • password (Field) — String
  • name (Field2) — String
  • age (Field3) — int
  • email (Field4) — String
  • phone_num (Field5) — String
  • introduction (Field7) — String
  • image (Field8) — String