Guest User

Untitled

a guest
Apr 24th, 2018
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. CREATE TABLE CashBox(ID INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY
  2. KEY, Operation VARCHAR(1000), Income DOUBLE PRECISION, Consumption DOUBLE
  3. PRECISION, Balance DOUBLE PRECISION, DateTime TIMESTAMP);
  4.  
  5. CREATE TABLE IntCashBox (ID INTEGER GENERATED BY DEFAULT AS IDENTITY
  6. PRIMARY KEY, SourcePatientID INTEGER NOT NULL, SourceGoodsID INTEGER NOT
  7. NULL, CONSTRAINT fk_SourcePatientID(SourcePatientID) references
  8. Patients(id), CONSTRAINT fk_SourceGoodID references
  9. fk_SourceGoodID(SourceGoodsID));
  10.  
  11. CREATE TABLE IntCashBox (ID INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY
  12. KEY, SourceID INTEGER, TableName VARCHAR(50));
  13.  
  14. SELECT SourceID, TableName FROM IntCashBox WHERE SourceID = old.ID into
  15. :intSourceID, :sourceTableName;
  16.  
  17. if (new.PaymentType = 'Наличная оплата') then
  18. BEGIN
  19. INSERT INTO IntCashBox ...
  20. --и собственно определялась таблица и вставлялось/обновлялось
  21. --там были поля SourceID и TableName, по которым и определял
  22. END
  23. ELSE
  24. BEGIN
  25. INSERT INTO Cashless
  26. END
Add Comment
Please, Sign In to add comment