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)