1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| CREATE TABLE ENTREES
(
ID INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL,
DATE_ENTREE DATE NOT NULL,
IDARTICLE INTEGER NOT NULL,
FACTURE VARCHAR(10) NOT NULL,
QTE INTEGER DEFAULT 0,
CONSTRAINT PK_ENTREES PRIMARY KEY (ID)
);
INSERT INTO ENTREES (DATE_ENTREE, IDARTICLE, FACTURE, QTE) VALUES ('10.04.2023', '1', 'FACT1', '500');
INSERT INTO ENTREES (DATE_ENTREE, IDARTICLE, FACTURE, QTE) VALUES ('10.10.2023', '1', 'FACT2', '200');
CREATE TABLE SORTIES
(
ID INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL,
DATE_SORTIE DATE NOT NULL,
IDARTICLE INTEGER NOT NULL,
BON VARCHAR(10) NOT NULL,
QTE INTEGER DEFAULT 0,
CONSTRAINT PK_SORTIES PRIMARY KEY (ID)
);
INSERT INTO SORTIES (DATE_SORTIE, IDARTICLE, BON, QTE) VALUES ('10.04.2023', '1', 'BON001', '100');
INSERT INTO SORTIES (DATE_SORTIE, IDARTICLE, BON, QTE) VALUES ('11.04.2023', '1', 'BON002', '200');
INSERT INTO SORTIES (DATE_SORTIE, IDARTICLE, BON, QTE) VALUES ('12.10.2023', '1', 'BON002', '100'); |
Partager