| commit | author | age | ||
| 4e90f5 | 1 | --liquibase formatted sql |
| MH | 2 | |
| 3 | -- ============================================================================ | |
| 4 | --changeset hs-office-person-MAIN-TABLE:1 endDelimiter:--// | |
| 5 | -- ---------------------------------------------------------------------------- | |
| 6 | ||
| 23a81a | 7 | CREATE TYPE HsOfficePersonType AS ENUM ('UNKNOWN', 'NATURAL', 'LEGAL', 'SOLE_REPRESENTATION', 'JOINT_REPRESENTATION'); |
| 4e90f5 | 8 | |
| MH | 9 | CREATE CAST (character varying as HsOfficePersonType) WITH INOUT AS IMPLICIT; |
| 10 | ||
| 11 | create table if not exists hs_office_person | |
| 12 | ( | |
| 13 | uuid uuid unique references RbacObject (uuid) initially deferred, | |
| 14 | personType HsOfficePersonType not null, | |
| 15 | tradeName varchar(96), | |
| 16 | givenName varchar(48), | |
| 17 | familyName varchar(48) | |
| 18 | ); | |
| 19 | --// | |
| 472734 | 20 | |
| MH | 21 | |
| 22 | -- ============================================================================ | |
| 23 | --changeset hs-office-person-MAIN-TABLE-JOURNAL:1 endDelimiter:--// | |
| 24 | -- ---------------------------------------------------------------------------- | |
| 25 | ||
| 26 | call create_journal('hs_office_person'); | |
| 27 | --// | |
