PriceisChina

Tables (4)

client (table1)

  • id (PK) — Primary key — NOT NULL
  • pw (varchar2)
  • gender (Field3)
  • age (Field4)

ordered (table3)

  • orderNo (PK) — Primary key — NOT NULL
  • id (PK2) — Foreign key → client.id — NOT NULL
  • productID (PK3) — Foreign key → product.productId — NOT NULL
  • orderedQuantity (Field3)
  • timestamp (Field5)

product (table2)

  • productId (PK) — Primary key — NOT NULL
  • productName (Field2)
  • quantity (Field3)
  • price (Field4)

product2 (CopyOftable2)

  • productId2 (PK) — Primary key — NOT NULL
  • productName (Field2)
  • quantity (Field3)
  • price (Field4)