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)