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