| uranux_desenv [uranux.xml] |
| Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
| sel_commission_item | (Table) |
| Columns | ||||||||
| PK | Name | Data Type | NULLs | A/N | Default | Comment | FK | Unique |
|
| com_item_commission_id | Integer | Comissão |
| ||||
|
| com_item_employee_id | Integer | Funcionário |
| ||||
| com_item_type | SmallInt | Tipo: 1 => Atendente; 2 => Vendedor | ||||||
| com_item_value | Numeric(10, 2) | 0 | Valor | |||||
| Indexes | ||||
| Name | Table | Columns | Unique | Clustered |
| ix_sel_commission_item_fin_invoice | URX_PUBLIC.sel_commission_item | com_item_employee_id | ||
| ix_sel_commission_item_sel_commission | URX_PUBLIC.sel_commission_item | com_item_commission_id | ||
| Foreign Keys | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_sel_commission_item_abi_employee | URX_PUBLIC.abi_employee | URX_PUBLIC.sel_commission_item | emp_id | com_item_employee_id |
| fk_sel_commission_item_sel_commission | URX_PUBLIC.sel_commission | URX_PUBLIC.sel_commission_item | com_id | com_item_commission_id |
| Parent Relations (none) |
| Triggers (none) |
| Used in Diagrams |
| Diagram Name |
| diagramA |