uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

tel_followup

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	fol_dt	TimeStamp				Data-Hora do Último Contato
	fol_id	Integer			nextval('"URX_PUBLIC".tel_followup_id_seq'::regclass)	Identificador
	fol_customer	Integer				Cliente
	fol_employee_id	Integer				Atendente
	fol_service_id	Integer				Serviço
	fol_type_id	SmallInt				Outros Motivos
	fol_status_id	SmallInt				Situação
	fol_delete_bit	SmallInt			0	Bit de Exclusão
	fol_remarks	VarChar(255)				Observações
	fol_next_call	Date				Data do Próximo Contato

Indexes
Name	Table	Columns	Unique	Clustered
ix_tel_followup_employee	URX_PUBLIC.tel_followup	fol_employee_id
ix_tel_followup_sel_customer	URX_PUBLIC.tel_followup	fol_customer
ix_tel_followup_tel_followup_status	URX_PUBLIC.tel_followup	fol_status_id
ix_tel_followup_tel_followup_type	URX_PUBLIC.tel_followup	fol_type_id

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_tel_followup_customer	URX_PUBLIC.sel_customer	URX_PUBLIC.tel_followup	cus_id	fol_customer
fk_tel_followup_employee	URX_PUBLIC.abi_employee	URX_PUBLIC.tel_followup	emp_id	fol_employee_id
fk_tel_followup_service	URX_PUBLIC.ope_service	URX_PUBLIC.tel_followup	ser_id	fol_service_id
fk_tel_followup_status_list	URX_PUBLIC.tel_followup_status_list	URX_PUBLIC.tel_followup	fol_status_id	fol_status_id
fk_tel_followup_type	URX_PUBLIC.tel_followup_type	URX_PUBLIC.tel_followup	fol_type_id	fol_type_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_tel_evaluation_followup	URX_PUBLIC.tel_followup	URX_PUBLIC.tel_evaluation	fol_id	eva_followup_id
fk_tel_followup_call_followup	URX_PUBLIC.tel_followup	URX_PUBLIC.tel_followup_call	fol_id	fol_call_followup_id

Triggers
Name	Table	On Delete	On Insert	On Update	Execute	For Each	SQL
tg_fol_dt	URX_PUBLIC.tel_followup				BEFORE	FOR EACH ROW	"URX_PUBLIC"."_u ...
tg_tel_followup_create	URX_PUBLIC.tel_followup				AFTER	FOR EACH ROW	"URX_PUBLIC"."_u ...

Used in Diagrams

Diagram Name

diagramA