uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

sys_cep_location

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	cep_location_number	Integer				CEP
	cep_location_neighbor_id	Integer				Bairro
	cep_location_type_id	SmallInt				Tipo de Logradouro
	cep_location_is_user_data	SmallInt			1	Dados foram inseridos pelo usuário
	cep_location_label	VarChar(65)				Localidade
	cep_location_extension	VarChar(50)				Complemento

Indexes
Name	Table	Columns	Unique	Clustered
ix_sys_cep_location_number	URX_PUBLIC.sys_cep_location	cep_location_number
ix_sys_cep_location_sys_cep_location_type	URX_PUBLIC.sys_cep_location	cep_location_type_id
ix_sys_cep_location_sys_cep_neighbor	URX_PUBLIC.sys_cep_location	cep_location_neighbor_id

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_sys_cep_location_sys_cep_location_type	URX_PUBLIC.sys_cep_location_type	URX_PUBLIC.sys_cep_location	cep_location_type_id	cep_location_type_id
fk_sys_cep_location_sys_cep_neighbor	URX_PUBLIC.sys_cep_neighbor	URX_PUBLIC.sys_cep_location	cep_neighbor_id	cep_location_neighbor_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_sys_address_sys_cep_location	URX_PUBLIC.sys_cep_location	URX_PUBLIC.sys_address	cep_location_number	add_cep

Triggers (none)

Used in Diagrams

Diagram Name

diagramA