1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
| --liquibase formatted sql
|
| -- ============================================================================
| --changeset hs-office-person-MAIN-TABLE:1 endDelimiter:--//
| -- ----------------------------------------------------------------------------
|
| CREATE TYPE HsOfficePersonType AS ENUM ('NATURAL', 'LEGAL', 'SOLE_REPRESENTATION', 'JOINT_REPRESENTATION');
|
| CREATE CAST (character varying as HsOfficePersonType) WITH INOUT AS IMPLICIT;
|
| create table if not exists hs_office_person
| (
| uuid uuid unique references RbacObject (uuid) initially deferred,
| personType HsOfficePersonType not null,
| tradeName varchar(96),
| givenName varchar(48),
| familyName varchar(48)
| );
| --//
|
|
