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 |