uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

sel_customer_tank

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	cus_tank_id	Integer			nextval('"URX_PUBLIC".sel_customer_tank_id_seq'::regclass)	Identificador
	cus_tank_customer_id	Integer				Cliente
	cus_tank_order	SmallInt				Ordenação
	cus_tank_type	SmallInt				Tipo de Reservatório
	cus_tank_material	SmallInt				Tipo de Material
	cus_tank_position	SmallInt				Situação em Relação ao Solo
	cus_tank_cover	SmallInt				Condições da Cobertura
	cus_tank_sink	SmallInt				Distância de Fossas, Sumidouros ou Rede de Esgoto
	cus_tank_vol	Numeric(10, 2)				Volume do Reservatório
	cus_tank_imported_line	Text				Conteúdo da linha que importou
	cus_tank_delete_bit	SmallInt			0	Bit de Exclusão

Indexes
Name	Table	Columns	Unique	Clustered
ix_sel_customer_tank_type	URX_PUBLIC.sel_customer_tank	cus_tank_type
ix_sel_customer_tank_vol	URX_PUBLIC.sel_customer_tank	cus_tank_vol

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_customer_tank_material	URX_PUBLIC.sel_customer_tank_material	URX_PUBLIC.sel_customer_tank	cus_tank_material_id	cus_tank_material
fk_customer_tank_type	URX_PUBLIC.sel_customer_tank_type	URX_PUBLIC.sel_customer_tank	cus_tank_type_id	cus_tank_type
fk_sel_customer_tank	URX_PUBLIC.sel_customer	URX_PUBLIC.sel_customer_tank	cus_id	cus_tank_customer_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ope_service_item_tank_sel_customer_tank	URX_PUBLIC.sel_customer_tank	URX_PUBLIC.ope_service_item_tank	cus_tank_id	ser_item_tank_tank_id
fk_ope_service_recall_item_tank_sel_customer_tank	URX_PUBLIC.sel_customer_tank	URX_PUBLIC.ope_service_recall_item_tank	cus_tank_id	ser_recall_item_tank_tank_id

Triggers
Name	Table	On Delete	On Insert	On Update	Execute	For Each	SQL
tg_sel_customer_tank_create	URX_PUBLIC.sel_customer_tank				AFTER	FOR EACH ROW	"URX_PUBLIC"."_u ...
tg_sel_customer_tank_order	URX_PUBLIC.sel_customer_tank				BEFORE	FOR EACH ROW	"URX_PUBLIC"."_u ...

Used in Diagrams

Diagram Name

diagramA