tetst

Tables (5)

BugerInfo (BI)

  • ID — INTEGER — Primary key — NOT NULL
  • CGI (CategoryID) — INTEGER — Foreign key → ProductData.CGI — NOT NULL
  • NM (NAME) — VAECHAR(20)
  • PC (PRICE) — INTEGER

CategoryData (CD)

  • CGI (ID) — INTEGER — Primary key — NOT NULL
  • CGN (NAME) — VARCHAR(20)

DrankInfo (DI)

  • ID — INTEGER — Primary key — NOT NULL
  • CGI (CategoryID) — INTEGER — Foreign key → ProductData.CGI — NOT NULL
  • NM (NAME) — VAECHAR(20)
  • PC (PRICE) — INTEGER

ProductData (PD)

  • CGI (CategoryID) — INTEGER — Foreign key → CategoryData.CGI — NOT NULL
  • PDI (ProductID) — INTEGER

SideInfo (SI)

  • ID — INTEGER — Primary key — NOT NULL
  • CGI (CategoryID) — INTEGER — Foreign key → ProductData.CGI — NOT NULL
  • NM (NAME) — VAECHAR(20)
  • PC (PRICE) — INTEGER