uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

abi_employee

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	emp_id	Integer				Identificador
	emp_ramal_nr	Integer				Número do Ramal
	emp_image_id	Integer				Arquivo de Imagem da Fotografia
	emp_contract_date	Date				Data de Contratação
	emp_rescission_date	Date				Data de Rescisão
	emp_function_id	SmallInt				Função
	emp_delete_bit	SmallInt			0	Bit de Exclusão
	emp_number	VarChar(5)				Número Interno
	emp_title	VarChar(50)				Título
	emp_seller_goal	Numeric(10, 2)				Meta de Vendas Mensal
	emp_signature_id	Integer				Arquivo de Imagem da Assinatura
	emp_technical_council_label	VarChar(50)				Nome do Conselho de Classe
	emp_technical_council_number	VarChar(20)				Número do Conselho de Classe
	emp_technical_council_label_abbrev	VarChar(10)				Abreviatura do Conselho de Classe
	emp_technical_council_uf	VarChar(2)				Região do Conselho de Classe

Indexes
Name	Table	Columns	Unique	Clustered
ix_abi_employee_abi_function	URX_PUBLIC.abi_employee	emp_function_id
ix_abi_employee_sys_file	URX_PUBLIC.abi_employee	emp_image_id
ix_abi_employee_sys_person	URX_PUBLIC.abi_employee	emp_id

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_abi_employee_abi_function	URX_PUBLIC.abi_function	URX_PUBLIC.abi_employee	fun_id	emp_function_id
fk_abi_employee_image	URX_PUBLIC.sys_file	URX_PUBLIC.abi_employee	fil_id	emp_image_id
fk_abi_employee_signature	URX_PUBLIC.sys_file	URX_PUBLIC.abi_employee	fil_id	emp_signature_id
fk_abi_employee_sys_person	URX_PUBLIC.sys_person	URX_PUBLIC.abi_employee	per_id	emp_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_abi_driver_record_abi_employee	URX_PUBLIC.abi_employee	URX_PUBLIC.abi_driver_record	emp_id	dri_employee_id
fk_abi_employee_certificate_abi_employee	URX_PUBLIC.abi_employee	URX_PUBLIC.abi_employee_certificate	emp_id	emc_employee_id
fk_abi_record_abi_employee	URX_PUBLIC.abi_employee	URX_PUBLIC.abi_record	emp_id	rec_employee_id
fk_fin_bank_order_item_abi_employee	URX_PUBLIC.abi_employee	URX_PUBLIC.fin_bank_order_item	emp_id	ban_order_item_employee_id
fk_ope_service_attendant	URX_PUBLIC.abi_employee	URX_PUBLIC.ope_service	emp_id	ser_attendant
fk_ope_service_operator	URX_PUBLIC.abi_employee	URX_PUBLIC.ope_service	emp_id	ser_operator
fk_ope_service_recall_attendant	URX_PUBLIC.abi_employee	URX_PUBLIC.ope_service_recall	emp_id	ser_recall_attendant
fk_ope_service_seller_employee	URX_PUBLIC.abi_employee	URX_PUBLIC.ope_service_seller	emp_id	ser_seller_employee_id
fk_ope_team_item_abi_employee	URX_PUBLIC.abi_employee	URX_PUBLIC.ope_team_item	emp_id	tea_item_employee_id
fk_pro_activity_employee_abi_employee	URX_PUBLIC.abi_employee	URX_PUBLIC.pro_activity_employee	emp_id	act_emp_employee_id
fk_pro_project_abi_employee	URX_PUBLIC.abi_employee	URX_PUBLIC.pro_project	emp_id	pro_manager
fk_sel_commission_item_abi_employee	URX_PUBLIC.abi_employee	URX_PUBLIC.sel_commission_item	emp_id	com_item_employee_id
fk_sel_customer_attendant	URX_PUBLIC.abi_employee	URX_PUBLIC.sel_customer	emp_id	cus_attendant
fk_sel_customer_operator	URX_PUBLIC.abi_employee	URX_PUBLIC.sel_customer	emp_id	cus_operator
fk_sel_goal_abi_employee	URX_PUBLIC.abi_employee	URX_PUBLIC.sel_goal	emp_id	goa_employee_id
fk_sel_ranking_abi_employee	URX_PUBLIC.abi_employee	URX_PUBLIC.sel_ranking	emp_id	ran_employee_id
fk_tel_followup_employee	URX_PUBLIC.abi_employee	URX_PUBLIC.tel_followup	emp_id	fol_employee_id
fk_tel_followup_call_employee	URX_PUBLIC.abi_employee	URX_PUBLIC.tel_followup_call	emp_id	fol_call_employee_id

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

Used in Diagrams

Diagram Name

diagramA