uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

pro_activity

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	act_id	Integer			nextval('"URX_PUBLIC".pro_activity_id_seq'::regclass)	Identificador
	act_project_id	Integer				Projeto
	act_team_id	Integer				Equipe
	act_service_id	Integer				Serviço
	act_unit_id	Integer				Unidade
	act_planned_start_date	Date				Data de Início Planejada
	act_planned_finish_date	Date				Data de Término Planejada
	act_effective_start_date	Date				Data de Início Efetiva
	act_effective_finish_date	Date				Data de Término Efetiva
	act_category_id	SmallInt				Categoria
	act_kind_id	SmallInt				Natureza da Atividade
	act_type_id	SmallInt				Atividade Padrão
	act_vehicle_id	SmallInt				Veículo
	act_status_id	SmallInt			1	Situação
	act_is_canceled	SmallInt			0	Cancelada
	act_sequence_nr	SmallInt			1	Nº Sequencial
	act_depends_on	SmallInt				Depende de
	act_depends_type	SmallInt				Tipo de Dependência
	act_depends_lag	SmallInt			0	Folga
	act_planned_work_ammount	SmallInt				Trabalho Planejado
	act_planned_duration	SmallInt				Duração Planejada
	act_effective_work_ammount	SmallInt				Trabalho Efetivo
	act_effective_duration	SmallInt				Duração Efetivo
	act_delete_bit	SmallInt			0	Bit de Exclusão
	act_planned_start_time	VarChar(5)				Hora de Início Planejada
	act_planned_finish_time	VarChar(5)				Hora de Término Planejada
	act_effective_start_time	VarChar(5)				Hora de Início Efetiva
	act_effective_finish_time	VarChar(5)				Hora de Término Efetiva
	act_planned_cost	Numeric(10, 2)			0	Custo Planejado
	act_effective_cost	Numeric(10, 2)			0	Custo Efetivo
	act_remarks	Text				Observações
	act_description	Text				Descrição
	act_desc_abbrev	Text				Texto para Roteiro

Indexes
Name	Table	Columns	Unique	Clustered
ix_pro_activity_ope_team	URX_PUBLIC.pro_activity	act_team_id
ix_pro_activity_ope_vehicle	URX_PUBLIC.pro_activity	act_vehicle_id
ix_pro_activity_pro_activity_kind	URX_PUBLIC.pro_activity	act_kind_id
ix_pro_activity_pro_activity_type	URX_PUBLIC.pro_activity	act_type_id
ix_pro_activity_pro_project	URX_PUBLIC.pro_activity	act_project_id
ix_pro_activity_service_id	URX_PUBLIC.pro_activity	act_service_id

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_pro_activity_ope_service	URX_PUBLIC.ope_service	URX_PUBLIC.pro_activity	ser_id	act_service_id
fk_pro_activity_ope_service_type_category	URX_PUBLIC.ope_service_type_category	URX_PUBLIC.pro_activity	ser_type_category_id	act_category_id
fk_pro_activity_ope_team	URX_PUBLIC.ope_team	URX_PUBLIC.pro_activity	tea_id	act_team_id
fk_pro_activity_ope_vehicle	URX_PUBLIC.ope_vehicle	URX_PUBLIC.pro_activity	veh_id	act_vehicle_id
fk_pro_activity_pro_activity_kind	URX_PUBLIC.pro_activity_kind	URX_PUBLIC.pro_activity	act_kind_id	act_kind_id
fk_pro_activity_pro_activity_type	URX_PUBLIC.pro_activity_type	URX_PUBLIC.pro_activity	act_type_id	act_type_id
fk_pro_activity_pro_project	URX_PUBLIC.pro_project	URX_PUBLIC.pro_activity	pro_id	act_project_id
fk_pro_activity_status_list	URX_PUBLIC.pro_activity_status_list	URX_PUBLIC.pro_activity	act_status_id	act_status_id
fk_pro_activity_unit	URX_PUBLIC.adm_unit	URX_PUBLIC.pro_activity	uni_person_id	act_unit_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ope_service_item_pro_activity	URX_PUBLIC.pro_activity	URX_PUBLIC.ope_service_item	act_id	ser_item_activity_id
fk_ope_service_recall_item_pro_activity	URX_PUBLIC.pro_activity	URX_PUBLIC.ope_service_recall_item	act_id	ser_recall_item_activity_id
fk_pro_activity_employee_pro_activity	URX_PUBLIC.pro_activity	URX_PUBLIC.pro_activity_employee	act_id	act_emp_activity_id
fk_pro_activity_status_pro_activity	URX_PUBLIC.pro_activity	URX_PUBLIC.pro_activity_status	act_id	act_status_activity_id
fk_tel_evaluation_activity	URX_PUBLIC.pro_activity	URX_PUBLIC.tel_evaluation	act_id	eva_activity_id

Triggers
Name	Table	On Delete	On Insert	On Update	Execute	For Each	SQL
tg_pro_activity_create	URX_PUBLIC.pro_activity				AFTER	FOR EACH ROW	"URX_PUBLIC"."_u ...
tg_pro_activity_sequence_number	URX_PUBLIC.pro_activity				BEFORE	FOR EACH ROW	"URX_PUBLIC"."_u ...

Used in Diagrams

Diagram Name

diagramA