uranux_desenv [uranux.xml] |
Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
sys_ticket_status_list | (Table) |
Columns | ||||||||
PK | Name | Data Type | NULLs | A/N | Default | Comment | FK | Unique |
| tic_status_id | SmallInt |
| nextval('"URX_PUBLIC".sys_ticket_status_list_id_seq'::regclass) | Identificador | |||
tic_status_comp | SmallInt | 1 | Complemento | |||||
tic_status_delete_bit | SmallInt | 0 | Bit de Exclusão |
|
||||
tic_status_label | VarChar(50) | Nome |
|
Indexes (none) |
Foreign Keys (none) |
Parent Relations | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
fk_sys_ticket_status_sys_ticket_status_list | URX_PUBLIC.sys_ticket_status_list | URX_PUBLIC.sys_ticket_status | tic_status_id | tic_status_id |
Triggers | |||||||
Name | Table | On Delete | On Insert | On Update | Execute | For Each | SQL |
tg_sys_ticket_status_list_create | URX_PUBLIC.sys_ticket_status_list |
| AFTER | FOR EACH ROW | "URX_PUBLIC"."_u ... |
Used in Diagrams |
Diagram Name |
diagramA |