PROJECT_TYPE |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| project_type_key | decimal (15,0) | |||
| project_type | varchar (10) | |||
| description | varchar (100) | YES | ||
| administrative | varchar (1) | |||
| billable | varchar (1) | YES | ||
References made to PROJECT_TYPE |
||
| Table Name | Field Name | Foreign Key Name |
|---|---|---|
| DEFAULT_TIME_DATA | project_type_key | fk_default_time_data6 |
| EXPENSE_DATA | project_type_key | fk_expense_data7 |
| PERSON_TIME_DATA | project_type_key | fk_person_time_data4 |
| PERSON_TIME_DATA_HISTORY | project_type_key | fk_person_time_data_history4 |
| PROJECT | project_type_key | fk_project3 |
| PTD_AUDIT_TRAIL | project_type_key | fk_ptd_audit_trail4 |
Dependent Views |
|
| View Name | |
|---|---|
| MARGIN_VIEW | |
| DETAIL_DATA_VIEW | |
| SEARCH_PROJECT_VIEW | |
| TIME_DATA_VIEW | |
| TIMESHEET_DATA | |
| EXPORT_EXPENSE_VIEW | |
| TEST | |
| FINANCIAL_DATA_VIEW | |
Check Constraints for PROJECT_TYPE |
|
| Check Constraint Name | Definition |
|---|---|
| cc_pjtt_administrative | (administrative = 'N' or (administrative = 'Y')) |
| cc_pjtt_billable | (billable = 'N' or (billable = 'Y' and (billable is not null))) |
Indexes on PROJECT_TYPE |
|
| Index Name | Column(s) |
|---|---|
| idx_project_type1 | project_type |
| pk_project_type | project_type_key |