Appearance
public.user_registration_position_role
Description
Tabela de associação entre vínculos funcionais (UserRegistrationPosition) e papéis (Role)
Columns
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | Identificador único do vínculo entre UserRegistrationPosition e Role | |||
| user_registration_position_id | uuid | false | public.user_registration_position | Identificador do vínculo funcional | ||
| role_id | uuid | false | public.role | Coluna de identificação do papel (Role) |
Constraints
| Name | Type | Definition |
|---|---|---|
| fk_npp_role_role | FOREIGN KEY | FOREIGN KEY (role_id) REFERENCES role(id) |
| fk_npp_role_npp | FOREIGN KEY | FOREIGN KEY (user_registration_position_id) REFERENCES user_registration_position(id) |
| user_registration_position_role_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| uc_user_registration_position_role | UNIQUE | UNIQUE (user_registration_position_id, role_id) |
Indexes
| Name | Definition |
|---|---|
| user_registration_position_role_pkey | CREATE UNIQUE INDEX user_registration_position_role_pkey ON public.user_registration_position_role USING btree (id) |
| uc_user_registration_position_role | CREATE UNIQUE INDEX uc_user_registration_position_role ON public.user_registration_position_role USING btree (user_registration_position_id, role_id) |
Relations
Generated by tbls