1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| CREATE TABLE DetailsCpt (
IdDetails INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
IdCpt INTEGER NULL,
DateEnregistre DATE NOT NULL,
Types VARCHAR(50) NOT NULL,
NumChq VARCHAR(7) NULL,
Tiers VARCHAR(80) NOT NULL,
-- Categories VARCHAR(50) NOT NULL CHECK (id_Categories FOREIGN KEY (Id_Categories) REFERENCES Categories),
id_SousCat INTEGER NOT NULL,
Debit NUMERIC(7,2) NULL DEFAULT 0,
Credit NUMERIC(7,2) NULL DEFAULT 0,
Pointeur VARCHAR(3) NULL,
IdBudget INTEGER NOT NULL,
CONSTRAINT Comptes_DetailsCpt FOREIGN KEY (IdCpt) REFERENCES Comptes (IdCpt) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT Budgets_DetailsCpt FOREIGN KEY (IdBudget) REFERENCES Budgets (IdBudget) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT Details_Categorie FOREIGN KEY(id_SousCat) REFERENCES Souscategories(id_SousCat) ON DELETE RESTRICT ON UPDATE RESTRICT
); |
Partager