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