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