Table: project_type

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK project_type_key decimal(15)      
2.   project_type varchar(10)      
3.   description varchar(100)      
4.   administrative char(1)      
5.   billable char(1)      
6.   last_project_code_seq decimal(15) ((0))    
7.   start_with_project_code_seq decimal(15) ((1))    
8.   active char(1) ('Y')    
Referenced from
Table Column Foreign Key Name
expense_data project_type_key fk_expense_data7
expense_data_allocation project_type_key fk_expense_data_allocation6
fin_document_detail_project project_type_key fk_fin_doc_detail_project4
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
project_type_account project_type_key fk_project_type_account1
project_type_exp_type_acct project_type_key fk_project_type_exp_type_acct1
task project_type_key fk_task3
Check Constraints
Name Definition
cc_pjtt_active ([active]='N' OR [active]='Y')
cc_pjtt_administrative ([administrative]='N' OR [administrative]='Y')
cc_pjtt_billable (([billable]='N' OR [billable]='Y') AND [billable] IS NOT NULL)
Indices
Index Name Unique Column Name Asc Or Desc
pk_project_type true project_type_key Asc
idx_project_type1 true project_type Asc