public.position

Description

Entidade que representa os cargos

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false	public.position_assignment public.user_registration_position public.natural_person_position		Coluna de identificação da posição
name	varchar(255)		false			Nome do Cargo
description	varchar(255)		true			Descrição do Cargo
institution_id	uuid		true		public.institution	Instituição à qual o cargo pertence, caso seja externo
is_external	boolean		false			Flag que indica se o cargo é externa
default_role_id	uuid		true		public.role	Chave estrangeira que referencia o papel (Role)

Constraints

Name	Type	Definition
fk_position_on_institution	FOREIGN KEY	FOREIGN KEY (institution_id) REFERENCES institution(id)
pk_position	PRIMARY KEY	PRIMARY KEY (id)
uc_position_name	UNIQUE	UNIQUE (name)
fk_position_default_role	FOREIGN KEY	FOREIGN KEY (default_role_id) REFERENCES role(id)

Indexes

Name	Definition
pk_position	CREATE UNIQUE INDEX pk_position ON public."position" USING btree (id)
uc_position_name	CREATE UNIQUE INDEX uc_position_name ON public."position" USING btree (name)

Relations

---

Generated by tbls