uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

fin_contract

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	con_id	Integer			nextval('"URX_PUBLIC".fin_contract_id_seq'::regclass)	Identificador
	con_customer_id	Integer				Cliente
	con_unit_id	Integer				Unidade
	con_start_date	Date				Data de Início da Vigência
	con_final_date	Date				Data de Término - Calculado
	con_carencia	SmallInt				Prazo de Validade - Número de dias
	con_interval	SmallInt				Intervalo - Número de dias para Repetição do Serviço
	con_week_day	SmallInt				Dia da Semana
	con_day_time	SmallInt				Hora de Início do Serviço
	con_status_id	SmallInt			1	Situação do Contrato
	con_delete_bit	SmallInt			0	Bit de Exclusão
	con_number	VarChar(10)				Número do Contrato
	con_value	Numeric(10, 2)			0	Valor do Serviço

Indexes
Name	Table	Columns	Unique	Clustered
ix_fin_contract_sel_customer	URX_PUBLIC.fin_contract	con_customer_id

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_fin_contract_sel_customer	URX_PUBLIC.sel_customer	URX_PUBLIC.fin_contract	cus_id	con_customer_id
fk_fin_contract_unit	URX_PUBLIC.adm_unit	URX_PUBLIC.fin_contract	uni_person_id	con_unit_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ope_service_fin_contract	URX_PUBLIC.fin_contract	URX_PUBLIC.ope_service	con_id	ser_contract_id

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

Used in Diagrams

Diagram Name

diagramA