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