test

Tables (4)

Untitled2

  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • userid (Key) — varchar2 — Foreign key → user.userid — NOT NULL

goods (Untitled)

  • goodsnum (Key) — number — Primary key — NOT NULL
  • goodsname (Field) — varchar2
  • price (Field2) — number
  • imege (Field3) — varchar2

order (Untitled3)

  • goodsnum (Key) — number — Foreign key → goods.goodsnum — NOT NULL
  • ordernum (Field) — number
  • phone (Field3)
  • price (Field4) — number
  • goodsname (Field6) — varchar2
  • userid (Field7) — varchar2
  • Field8
  • Field9
  • Field10
  • Field11
  • userid (Key2) — varchar2 — Foreign key → user.userid — NOT NULL

user (CopyOfUntitled3)

  • userid (Key) — varchar2 — Primary key — NOT NULL
  • pwd (Field2) — varchar2
  • address (Field3) — varchar2
  • birth (Field4) — varchar2
  • gender (Field5) — varchar2
  • goodsnum (Key2) — number — Foreign key → order.goodsnum — NOT NULL