pjt

Tables (3)

mylike (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • fromid (Key2) — Foreign key → user.id — NOT NULL
  • toid (Key3) — Foreign key → user.id — NOT NULL
  • createdat (Field3)

review (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • toid (Key3) — Foreign key → user.id — NOT NULL
  • fromid (Key2) — Foreign key → user.id — NOT NULL
  • star (Field3)
  • content (Field4) — NOT NULL

user (Untitled)

  • id (Key) — Primary key — NOT NULL
  • userid (Field) — unique
  • userpassword (Field2)
  • usertype (Field6) — 0 : doguser 1 : walkuser
  • location (Field3)
  • action (Field4)
  • image (Field5)
  • point (Field7)
  • introduction (Field8) — NOT NULL