Project
Tables (5)
Comment (Untitled3)
- id — long — Primary key — NOT NULL
- text — varchar — NOT NULL
- post_id — long — Foreign key → Post.id — NOT NULL
- user_id — long — Foreign key → User.id — NOT NULL
Location (Untitled4)
- id — long — Primary key — NOT NULL
- location — varchar — NOT NULL
- code — varchar — NOT NULL
Post (Untitled2)
- id — long — Primary key — NOT NULL
- postname — varchar — NOT NULL
- content — varchar — NOT NULL
- createdAt — time — NOT NULL
- uset_id (user_id) — long — Foreign key → User.id — NOT NULL
- modifiedAt — time — NOT NULL
- img — varchar
Time (Untitled5)
- Key — Primary key — NOT NULL
- Field
- Field2
User (Untitled)
- id — long — Primary key — NOT NULL
- username — varchar(50) — NOT NULL
- password — varchar(50) — NOT NULL
- desc — varchar(100)
- location — varchar(100) — NOT NULL
- location_id — long — Foreign key → Location.id — NOT NULL
- nickname — varchar(200)