| commit | author | age | ||
| 7f5b23 | 1 | --liquibase formatted sql |
| MH | 2 | |
| 3 | -- ============================================================================ | |
| 4 | --changeset hs-office-sepamandate-MAIN-TABLE:1 endDelimiter:--// | |
| 5 | -- ---------------------------------------------------------------------------- | |
| 6 | ||
| 7 | create table if not exists hs_office_sepamandate | |
| 8 | ( | |
| 9 | uuid uuid unique references RbacObject (uuid) initially deferred, | |
| 10 | debitorUuid uuid not null references hs_office_debitor(uuid), | |
| 11 | bankAccountUuid uuid not null references hs_office_bankaccount(uuid), | |
| bece97 | 12 | reference varchar(96) not null, |
| 64461f | 13 | agreement date not null, |
| 7f5b23 | 14 | validity daterange not null |
| MH | 15 | ); |
| 16 | --// | |
| 17 | ||
| 18 | ||
| 19 | -- ============================================================================ | |
| 20 | --changeset hs-office-sepamandate-MAIN-TABLE-JOURNAL:1 endDelimiter:--// | |
| 21 | -- ---------------------------------------------------------------------------- | |
| 22 | ||
| 23 | call create_journal('hs_office_sepamandate'); | |
| 24 | --// | |
