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