[sql] kp
Viewer
- CREATE TABLE "Providers" (
- "IDPost" INTEGER NOT NULL,
- "Name" TEXT,
- "ZIP Code" NUMERIC,
- "Country" TEXT,
- "City" TEXT,
- "Address" TEXT,
- "Phone"NUMERIC,
- "Bank statements" NUMERIC,
- PRIMARY KEY("IDPost")
- );
- CREATE TABLE "Customers" (
- "IDCust" INTEGER NOT NULL,
- "FirstName" TEXT,
- "LastName" TEXT,
- "Address" TEXT,
- "Phone"NUMERIC,
- PRIMARY KEY("IDCust")
- );
- CREATE TABLE "PriceList" (
- "GoodsId" INTEGER NOT NULL,
- "GoodsName" TEXT,
- "Description" TEXT,
- "Unit " NUMERIC,
- "Price " NUMERIC,
- "IDPost" INTEGER,
- FOREIGN KEY("IDPost") REFERENCES "Providers",
- PRIMARY KEY("GoodsId")
- );
- CREATE TABLE "Sale" (
- "CodeChek" INTEGER NOT NULL,
- "SaleDate" DATE,
- "Quantity" NUMERIC,
- "GoodsId" INTEGER,
- "IDPost" INTEGER,
- "IDPersonal" INTEGER,
- FOREIGN KEY("GoodsId") REFERENCES "PriceList",
- FOREIGN KEY("IDPost") REFERENCES "Providers",
- FOREIGN KEY("IDCust") REFERENCES "Customers",
- PRIMARY KEY("CodeChek")
- );
Editor
You can edit this paste and save as new:
File Description
- kp
- Paste Code
- 28 Mar-2024
- 979 Bytes
You can Share it:
Latest Code Pastes