tel_followup - Table
Home|Tables|Schemas|Diagrams|Foreign Keys|Indexes

tel_followup(Table)

PKNameData TypeNULLsA/NDefaultCommentFKUnique
fol_dtTimeStamp

Data-Hora do Último Contato

fol_idInteger

nextval('"URX_PUBLIC".tel_followup_id_seq'::regclass)Identificador
fol_customerInteger Cliente

fol_employee_idInteger Atendente

fol_service_idInteger

Serviço

fol_type_idSmallInt Outros Motivos

fol_status_idSmallInt

Situação

fol_delete_bitSmallInt 0Bit de Exclusão
fol_remarksVarChar(255)

Observações
fol_next_callDate

Data do Próximo Contato

NameTableColumnsUniqueClustered
ix_tel_followup_employeeURX_PUBLIC.tel_followupfol_employee_id
ix_tel_followup_sel_customerURX_PUBLIC.tel_followupfol_customer
ix_tel_followup_tel_followup_statusURX_PUBLIC.tel_followupfol_status_id
ix_tel_followup_tel_followup_typeURX_PUBLIC.tel_followupfol_type_id

NameParent TableChild TableParent ColumnsChild Columns
fk_tel_followup_customerURX_PUBLIC.sel_customerURX_PUBLIC.tel_followupcus_idfol_customer
fk_tel_followup_employeeURX_PUBLIC.abi_employeeURX_PUBLIC.tel_followupemp_idfol_employee_id
fk_tel_followup_serviceURX_PUBLIC.ope_serviceURX_PUBLIC.tel_followupser_idfol_service_id
fk_tel_followup_status_listURX_PUBLIC.tel_followup_status_listURX_PUBLIC.tel_followupfol_status_idfol_status_id
fk_tel_followup_typeURX_PUBLIC.tel_followup_typeURX_PUBLIC.tel_followupfol_type_idfol_type_id

NameParent TableChild TableParent ColumnsChild Columns
fk_tel_evaluation_followupURX_PUBLIC.tel_followupURX_PUBLIC.tel_evaluationfol_ideva_followup_id
fk_tel_followup_call_followupURX_PUBLIC.tel_followupURX_PUBLIC.tel_followup_callfol_idfol_call_followup_id

NameTableOn DeleteOn InsertOn UpdateExecuteFor EachSQL
tg_fol_dtURX_PUBLIC.tel_followup

BEFOREFOR EACH ROW"URX_PUBLIC"."_u ...
tg_tel_followup_createURX_PUBLIC.tel_followup

AFTERFOR EACH ROW"URX_PUBLIC"."_u ...

Diagram Name
diagramA