MINISHOP
Tables (4)
ONECHANGE
- CNO — NUMBER — Primary key
- SNO — NVARCHAR2(20) — Foreign key → ONESELLER.SNO
- MID (MID2) — NVARCHAR2(20) — Foreign key
- ONO — NUMBER
- CAT2 — NVARCHAR2(4) — NOT NULL
- DELI — NVARCHAR2(10) — NOT NULL
ONEORDER
- ONO — NUMBER — Primary key
- SNO (SNO2) — NVARCHAR2(20) — Foreign key → ONESELLER.SNO
- PID — NVARCHAR2(20) — Foreign key → PRODUCT.PID
- ONO (ONO2) — NUMBER — Foreign key → PRODUCT.ONO
- OMID (MID2) — NVARCHAR2(20) — Foreign key → PRODUCT.OMID
- SNO (SNO22) — NVARCHAR2(20) — Foreign key → PRODUCT.SNO
- PID (PID2) — NVARCHAR2(20) — Foreign key → PRODUCT.PID
- MID (MID3) — NVARCHAR2(20) — Foreign key
- OID — NVARCHAR2(20)
- OCNT — NUMBER — NOT NULL
- OTOTAL — NUMBER
ONESELLER
- SNO — NVARCHAR2(20) — Primary key
- SADDR — NVARCHAR2(50) — NOT NULL
- SCNAME — NVARCHAR2(5) — NOT NULL
- SPHONE — NVARCHAR2(13)
PRODUCT
- PID — NVARCHAR2(20) — Primary key
- ONO — NUMBER — Foreign key → ONEORDER.ONO
- OMID (MID2) — NVARCHAR2(20) — Foreign key
- SNO (SNO2) — NVARCHAR2(20) — Foreign key → ONEORDER.SNO
- PID (PID2) — NVARCHAR2(20) — Foreign key → ONEORDER.PID
- PNAME — NVARCHAR2(50) — NOT NULL
- PRICE — NUMBER — NOT NULL
- IMG — NVARCHAR2(100)
- PCODE — NUMBER — NOT NULL
- CAT — NVARCHAR2(10)