Previous: employee_type | Unanet Data Model | Next: employee_type_expense_type |
Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
1. | PK | employee_type_key | decimal(15) | employee_type | fk_employee_type_account1 | |
2. | PK | category | tinyint | |||
3. | account_key | decimal(15) | account | fk_employee_type_account2 |
Column | References | Foreign Key Name | |
Table | Column | ||
account_key | account | account_key | fk_employee_type_account2 |
employee_type_key | employee_type | employee_type_key | fk_employee_type_account1 |
Name | Definition |
cc_employee_type_account_cat | ([category]>=(1) AND [category]<=(99)) |
Index Name | Unique | Column Name | Asc Or Desc |
pk_employee_type_account | true | employee_type_key | Asc |
category | |||
idx_employee_type_account1 | false | account_key | Asc |