uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

pro_project

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	pro_id	Integer			nextval('"URX_PUBLIC".pro_project_id_seq'::regclass)	Identificador
	pro_service_id	Integer				Serviço
	pro_manager	Integer				Responsável
	pro_unit_id	Integer				Unidade
	pro_start_date	Date				Data de Início
	pro_finish_date	Date				Data de Término
	pro_priority_id	SmallInt				Prioridade
	pro_project_type_id	SmallInt				Tipo
	pro_work_unit	SmallInt			1	Unidade de Tempo de Trabalho
	pro_working_hours	SmallInt			8	Nº de Horas Úteis Diárias
	pro_planned_work_ammount	SmallInt				Trabalho Planejado
	pro_planned_duration	SmallInt				Duração Planejada
	pro_effective_work_ammount	SmallInt				Trabalho Efetivo
	pro_effective_duration	SmallInt				Duração Efetivo
	pro_delete_bit	SmallInt			0	Bit de Exclusão
	pro_duration_unit	SmallInt			2	Unidade de Tempo de Duração
	pro_name	VarChar(50)				Nome
	pro_description	VarChar(255)				Descriçao
	pro_planned_cost	Numeric(10, 2)			0	Custo Planejado
	pro_effective_cost	Numeric(10, 2)			0	Custo Efetivo

Indexes
Name	Table	Columns	Unique	Clustered
ix_pro_project_abi_employee	URX_PUBLIC.pro_project	pro_manager
ix_pro_project_ope_service	URX_PUBLIC.pro_project	pro_service_id
ix_pro_project_pro_project_priority	URX_PUBLIC.pro_project	pro_priority_id
ix_pro_project_pro_project_type	URX_PUBLIC.pro_project	pro_project_type_id

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_pro_project_abi_employee	URX_PUBLIC.abi_employee	URX_PUBLIC.pro_project	emp_id	pro_manager
fk_pro_project_ope_service	URX_PUBLIC.ope_service	URX_PUBLIC.pro_project	ser_id	pro_service_id
fk_pro_project_pro_project_priority	URX_PUBLIC.pro_project_priority	URX_PUBLIC.pro_project	pro_priority_id	pro_priority_id
fk_pro_project_pro_project_type	URX_PUBLIC.pro_project_type	URX_PUBLIC.pro_project	pro_type_id	pro_project_type_id
fk_pro_project_unit	URX_PUBLIC.adm_unit	URX_PUBLIC.pro_project	uni_person_id	pro_unit_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_pro_activity_pro_project	URX_PUBLIC.pro_project	URX_PUBLIC.pro_activity	pro_id	act_project_id
fk_pro_project_status_pro_project	URX_PUBLIC.pro_project	URX_PUBLIC.pro_project_status	pro_id	pro_status_project_id

Triggers
Name	Table	On Delete	On Insert	On Update	Execute	For Each	SQL
tg_pro_project_create	URX_PUBLIC.pro_project				AFTER	FOR EACH ROW	"URX_PUBLIC"."_u ...

Used in Diagrams

Diagram Name

diagramA