ERD_PMO_1stMeetingChanges
Tables (13)
Actual_Project_PLM (Project_Master)
- PLM_Code (P_Code) — Varchar(20) — Primary key
- ADP_Project_Code (Adp_Project_Code) — INT — Foreign key → Planned_Project_ADP.ADP_Project_Code — NOT NULL
- Dev_Type_Id (Dev_Id) — INT — Foreign key → DevType.Dev_Type_ID — NOT NULL
- Status_Id — INT — Foreign key → Status.Status_Id — NOT NULL
- Project_Name (P_Name) — Varchar(100)
- Actual_Start_Date (S_Date) — Date
- Actual_End_Date (E_Date) — Date
- HQ_PL_Name (HQPL_Id) — Varchar(50)
- HQ_PL_ SingleId (HQPL_Singleid) — Varchar(50)
Cost_Center (Cost_Center_Master)
- Cost_Id — INT — Primary key — NOT NULL
- Cost_Center_Name (Center_Name) — Varchar(100)
DevType (DevType_Master)
- Dev_Type_ID (Dev_Id) — INT — Primary key — NOT NULL
- Dev_Type (DevType_Name) — Varchar(50)
Employee (Employee_Master)
- Emp_Id — Varchar(10) — Primary key — NOT NULL
- Gbm_Id — INT — Foreign key → GBM.Gbm_Id — NOT NULL
- Resource_Type_Id (Resource_Id) — INT — Foreign key → ResourceType.Resource_Type_Id — NOT NULL
- Name (Emp_Name) — Varchar(50)
- Knox_Id (Emp_Singleid) — Varchar(50)
- Joining_Date — Date
- Resign_Date (Resigning_Date) — Date
- Relieving_Date (Releive_Date) — Date
- Career_Level — Varchar(10)
- Qualification (Qualfication) — Varchar(50)
- PLM_Allocation (Plm_Allocation) — Varchar(50)
- Title_Band — Varchar(20)
- Org_Id — INT — Foreign key → Organisation.Org_Id — NOT NULL
- Cost_Id — INT — Foreign key → Cost_Center.Cost_Id — NOT NULL
- SWC_Status_Id — INT — Foreign key → EmployeeSWCStatus.SWC_Status_Id — NOT NULL
EmployeeSWCStatus (Emp_Swc_Status)
- SWC_Status_Id — INT — Primary key — NOT NULL
- SWC_Status_Name — Varchar(100)
GBM (GBM_Master)
- Gbm_Id — INT — Primary key — NOT NULL
- GBM (Gbm_Name) — Varchar(20)
- HQ_Team (Hq_Team) — Varchar(100)
- HQ_Lab (Hq_Lab) — Varchar(100)
Organisation (Org_Master)
- Org_Id — INT — Primary key — NOT NULL
- SRID_Team (Org_Name) — Varchar(200)
- SRID_Group (Srid_Group) — Varchar(200)
- SRID_Part (Srid_Part) — Varchar(200)
Planned_Project_ADP (ADP_Master)
- ADP_Project_Code — INT — Primary key — NOT NULL
- ADP_Project_Name (Adp_Project_Name) — Varchar(100)
- Start_Date — Date
- End_Date — Date
- MonthlyHR _ADP_Count (ADP_Count) — INT
- HQ_PL_Name (HQPL_Name) — Varchar(20)
- HQ_PL_SingleId (HQPL_Singleid) — Varchar(50)
- SRID_PL_Name (PL_Name) — Varchar(50)
- SRID_PL_Singleid (PL_Singleid) — Varchar(50)
- Additional_Project — Varchar(100)
- ADP_Status — Varchar(100)
- Gbm_Id — INT — Foreign key → GBM.Gbm_Id — NOT NULL
Project Resource Mapping (Pro_Emp_Mapping_Master)
- Auto_Id — INT — Primary key — NOT NULL
- Emp_Id — Varchar(10) — Foreign key → Employee.Emp_Id — NOT NULL
- PLMCode (P_Code) — Varchar(20) — Foreign key → Actual_Project_PLM.PLM_Code
- Person_Month_PLM (Person_Month_Plm) — Varchar(100)
- SRID_PL_SingleID (PL_Singleid) — Varchar(50)
ProjectDomainMapping (Project_Domain_Mapping)
- Map_Id — INT — Primary key — NOT NULL
- Domain_Id — INT — Foreign key → Tech_Domain.Domain_Id — NOT NULL
- ADP_Project_Code — INT — Foreign key → Planned_Project_ADP.ADP_Project_Code — NOT NULL
ResourceType (ResourceType_Master)
- Resource_Type_Id (Resource_Id) — INT — Primary key — NOT NULL
- Resource_Type — Varchar(100)
Status (Status_Master)
- Status_Id — INT — Primary key — NOT NULL
- Status (Status_Type) — Varchar(50)
Tech_Domain (Tech_Domain_Master)
- Domain_Id — INT — Primary key — NOT NULL
- Name (Domain_Name) — VARCHAR(100)