Table: manager_approval_status

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK person_time_key decimal(15)   person_time fk_manager_approval_status1
2. PK project_key decimal(15)   project fk_manager_approval_status2
3.   approved char(1)      
Foreign Keys
Column References Foreign Key Name
Table Column
person_time_key person_time person_time_key fk_manager_approval_status1
project_key project project_key fk_manager_approval_status2
Check Constraints
Name Definition
cc_mas_approved ([approved]='N' OR [approved]='Y')
Indices
Index Name Unique Column Name Asc Or Desc
pk_manager_approval_status true person_time_key Asc
    project_key