Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE CashBox(ID INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY
- KEY, Operation VARCHAR(1000), Income DOUBLE PRECISION, Consumption DOUBLE
- PRECISION, Balance DOUBLE PRECISION, DateTime TIMESTAMP);
- CREATE TABLE IntCashBox (ID INTEGER GENERATED BY DEFAULT AS IDENTITY
- PRIMARY KEY, SourcePatientID INTEGER NOT NULL, SourceGoodsID INTEGER NOT
- NULL, CONSTRAINT fk_SourcePatientID(SourcePatientID) references
- Patients(id), CONSTRAINT fk_SourceGoodID references
- fk_SourceGoodID(SourceGoodsID));
- CREATE TABLE IntCashBox (ID INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY
- KEY, SourceID INTEGER, TableName VARCHAR(50));
- SELECT SourceID, TableName FROM IntCashBox WHERE SourceID = old.ID into
- :intSourceID, :sourceTableName;
- if (new.PaymentType = 'Наличная оплата') then
- BEGIN
- INSERT INTO IntCashBox ...
- --и собственно определялась таблица и вставлялось/обновлялось
- --там были поля SourceID и TableName, по которым и определял
- END
- ELSE
- BEGIN
- INSERT INTO Cashless
- END
Add Comment
Please, Sign In to add comment