uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

ope_vehicle

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	veh_odometer	Integer			0	Kilometragem média
	veh_unit_id	Integer				Unidade
	veh_id	SmallInt			nextval('"URX_PUBLIC".ope_vehicle_id_seq'::regclass)	Identificador
	veh_year	SmallInt				Ano
	veh_fuel_id	SmallInt				Combustível
	veh_type_id	SmallInt				Tipo
	veh_license_state_id	SmallInt				Estado de Registro
	veh_license_city_id	SmallInt				Município de Registro
	veh_license_month	SmallInt				Mês do IPVA
	veh_month_survey	SmallInt				Mês da Vistoria
	veh_delete_bit	SmallInt			0	Bit de Exclusão
	veh_model_year	SmallInt				Ano do modelo
	veh_make	VarChar(50)				Marca
	veh_model	VarChar(50)				Modelo
	veh_license_label	VarChar(10)				Placa
	veh_color	VarChar(50)				Cor

Indexes
Name	Table	Columns	Unique	Clustered
ix_ope_vehicle_ope_fuel	URX_PUBLIC.ope_vehicle	veh_fuel_id
ix_ope_vehicle_ope_vehicle_type	URX_PUBLIC.ope_vehicle	veh_type_id
ix_ope_vehicle_sys_cep_city	URX_PUBLIC.ope_vehicle	veh_license_city_id
ix_ope_vehicle_sys_cep_state	URX_PUBLIC.ope_vehicle	veh_license_state_id

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ope_vehicle_ope_fuel	URX_PUBLIC.ope_fuel	URX_PUBLIC.ope_vehicle	fue_id	veh_fuel_id
fk_ope_vehicle_ope_vehicle_type	URX_PUBLIC.ope_vehicle_type	URX_PUBLIC.ope_vehicle	veh_type_id	veh_type_id
fk_ope_vehicle_sys_cep_city	URX_PUBLIC.sys_cep_city	URX_PUBLIC.ope_vehicle	cep_city_id	veh_license_city_id
fk_ope_vehicle_sys_cep_state	URX_PUBLIC.sys_cep_state	URX_PUBLIC.ope_vehicle	cep_state_id	veh_license_state_id
fk_ope_vehicle_unit	URX_PUBLIC.adm_unit	URX_PUBLIC.ope_vehicle	uni_person_id	veh_unit_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ope_team_ope_vehicle	URX_PUBLIC.ope_vehicle	URX_PUBLIC.ope_team	veh_id	tea_vehicle_id
fk_pro_activity_ope_vehicle	URX_PUBLIC.ope_vehicle	URX_PUBLIC.pro_activity	veh_id	act_vehicle_id

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

Used in Diagrams

Diagram Name

diagramA