         foreign key (update_user_id) references org_user
             deferrable initially deferred;
 
-create unique index user_org_uindex
+create unique index org_user_extl_id_uindex
+    on org_user (user_extl_id);
+
+create unique index org_user_username_org_uindex
     on org_user (username, org_id);
 

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

);

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.';

