CK_project
Tables (4)
order (Untitled3)
- order_id (Key) — long — Primary key — NOT NULL
- user_id (Key2) — varchar — Foreign key → users.user_id — NOT NULL
- order_at (Field) — date
- total_price (Field2) — int
order_info (Untitled4)
- order_info_id (Key) — long — Primary key — NOT NULL
- count (Field) — int
- price (Field2) — int
- total_price (Field3)
- order_id (Key2) — long — Foreign key → order.order_id — NOT NULL
- post_id (Key3) — long — Foreign key → post.post_id — NOT NULL
post (Untitled2)
- post_id (Key) — long — Primary key — NOT NULL
- title (Field) — varchar
- price (Field3) — int
- content (Field6) — varchar
- photo (Field2) — varchar
- user_id (Key3) — varchar — Foreign key → users.user_id — NOT NULL
users (Untitled)
- user_id (Key) — varchar — Primary key — NOT NULL
- birth (Field3) — date
- created_at (Field4) — int
- password (Field5) — varchar