Previous: employee_type_expense_type | Unanet Data Model | Next: entertainment_detail |
Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
1. | PK | employee_type_key | decimal(15) | employee_type | fk_employee_type_pay_code1 | |
2. | PK | pay_code_key | decimal(15) | pay_code | fk_employee_type_pay_code2 |
Column | References | Foreign Key Name | |
Table | Column | ||
employee_type_key | employee_type | employee_type_key | fk_employee_type_pay_code1 |
pay_code_key | pay_code | pay_code_key | fk_employee_type_pay_code2 |
Index Name | Unique | Column Name | Asc Or Desc |
pk_employee_type_pay_code | true | employee_type_key | Asc |
pay_code_key | |||
idx_employee_type_pay_code1 | false | pay_code_key | Asc |