 create table org_user
 (
     user_id           uuid                     not null,
+    user_extl_id      varchar                  not null,
     username          varchar                  not null,
     org_id            uuid                     not null,
     person_profile_id uuid                     not null,

        foreign key (update_user_id) references org_user
            deferrable initially deferred;

create unique index user_org_uindex
    on org_user (username, org_id);


);

comment on column org_user.user_id is 'The user ID is the unique ID for user (pk for table)';

comment on column org_user.user_extl_id is 'The unique user external ID to be given to outside callers.';

comment on column org_user.username is 'The username is a unique, human readable username.';

