uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

fin_transference

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	tra_id	Integer			nextval('"URX_PUBLIC".fin_transference_id_seq'::regclass)	Identificador
	tra_from_cell	Integer				Célula de Origem
	tra_to_cell	Integer				Célula de Destino
	tra_unit_id	Integer				Unidade
	tra_date	Date				Data
	tra_type_id	SmallInt				Tipo de Transação
	tra_mode	SmallInt			1	Modalidade
	tra_is_approved	SmallInt			0	Aprovado
	tra_is_loaded	SmallInt			0	Processado
	tra_value	Numeric(10, 2)				Valor
	tra_number_legacy	VarChar(6)				Nº. do Lançamento do Legado
	tra_description	VarChar(100)				Descrição

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_fin_transference_from_cell	URX_PUBLIC.fin_credit_cell	URX_PUBLIC.fin_transference	cre_id	tra_from_cell
fk_fin_transference_to_cell	URX_PUBLIC.fin_credit_cell	URX_PUBLIC.fin_transference	cre_id	tra_to_cell
fk_fin_transference_type	URX_PUBLIC.fin_transaction_type	URX_PUBLIC.fin_transference	tra_type_id	tra_type_id
fk_fin_transference_unit	URX_PUBLIC.adm_unit	URX_PUBLIC.fin_transference	uni_person_id	tra_unit_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_fin_cash_flow_transference	URX_PUBLIC.fin_transference	URX_PUBLIC.fin_cash_flow	tra_id	cas_flow_transference_id
fk_fin_transference_account	URX_PUBLIC.fin_transference	URX_PUBLIC.fin_transference_account	tra_id	tra_account_transference_id

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

Used in Diagrams

Diagram Name

diagramA