Sample

Tables (3)

Goods (Untitled3)

  • id — Sequnce — Primary key — NOT NULL
  • user_id — Varchar(255) — Foreign key → User.id — NOT NULL
  • name — Varchar(255)
  • price — Integer(4)
  • remains — Integer(4)

Order (Untitled2)

  • id — Sequnce — Primary key — NOT NULL
  • goods_id — Sequnce — Foreign key → Goods.id — NOT NULL
  • user_id — Varchar(255) — Foreign key → User.id — NOT NULL
  • price

User (Untitled)

  • id — Varchar(255) — Primary key — NOT NULL
  • name — Varchar(30)
  • password — Varchar(255)