PMO
Tables (13)
ADP_PLM_Mapping (Untitled2)
Actual_Project_PLM (ProjectMaster)
- PLM_Code (Key) — VARCHAR(100) — Primary key — NOT NULL
- Status_id (Key2) — INT — Foreign key → Status.Status_id — NOT NULL
- Dev_ID (Devtype_id) — INT — Foreign key → Devtype.ID — NOT NULL
- PLM_Project (Field) — VARCHAR(300)
- GBM_ID (Key3) — INT — Foreign key → GBM.GBM_ID — NOT NULL
- CostcenterID (Key4) — INT — Foreign key → Cost_Center.CostcenterID — NOT NULL
Cost_Center (Cost_master)
- CostcenterID (Key) — INT — Primary key — NOT NULL
- Costcenter (Field) — VARCHAR(100)
- GBM_ID (Key2) — INT — Foreign key → GBM.GBM_ID — NOT NULL
Devtype (DevType)
- ID (Devtype_id) — INT — Primary key — NOT NULL
- Name (Devname) — VARCHAR(200)
Employee (Untitled3)
- ID (Field) — INT — Primary key
- Name (Field2) — VARCHAR(100)
- KNOXID (Field3) — VARCHAR(100)
- Joining_Date (Field4) — Date
- Resign_Date (Field5) — Date
- Relieving_Date (Field6) — Date
- Career_Level (Field7)
- Qualification (Field8) — VARCHAR(100)
- HQ_Team (Field9) — VARCHAR(100)
- HQ_Lab (Field10) — VARCHAR(100)
- PLM_Allocation (Field11) — VARCHAR(100)
- Person_Month_PLM (Field12)
- SWC info(Needs clarity) (Field13)
- Field14
- CostcenterID (Key) — INT — Foreign key → Cost_Center.CostcenterID — NOT NULL
- ID (Restype_id) — INT — Foreign key → Resourcetype.ID — NOT NULL
GBM (GBM_master)
- GBM_ID (Key) — INT — Primary key — NOT NULL
- GBMname (Field) — VARCHAR(100)
Organisation (OrgMaster)
- Dept_id (Key) — INT — Primary key — NOT NULL
- Dname (Field) — VARCHAR(300)
- Team_id (Key2) — INT — Foreign key → Team.Team_id — NOT NULL
Planned_Project_ADP (ADP_Master)
- ADP _Code (Key) — VARCHAR(50) — Primary key — NOT NULL
- PLM_Code (Key2) — VARCHAR(100) — Foreign key → Actual_Project_PLM.PLM_Code — NOT NULL
- Status_id (Key22) — INT — Foreign key → Actual_Project_PLM.Status_id — NOT NULL
- Dev_ID (Devtype_id) — INT — Foreign key → Actual_Project_PLM.Dev_ID — NOT NULL
- ADPname (Field) — VARCHAR(100)
- ADPstatus (Field2) — VARCHAR(100)
- DevPlant (Field3) — VARCHAR(50)
- Scheduled from date (Field4) — DATE
- Scheduled to date (Field5) — DATE
- ADP_HeadCount (Field6) — INT
ProjectMapping (Mapping_master)
- ProjectMap_ID (Key3) — INT — Primary key — NOT NULL
- ProjectCode(PLM) (Key2) — VARCHAR(100) — Foreign key → Actual_Project_PLM.PLM_Code — NOT NULL
- Status_id (Key22) — INT — Foreign key → Actual_Project_PLM.Status_id — NOT NULL
- Dev_ID (Devtype_id) — INT — Foreign key → Actual_Project_PLM.Dev_ID — NOT NULL
Resourcetype (ResourceType)
- ID (Restype_id) — INT — Primary key — NOT NULL
- Name (ResourceTypename) — VARCHAR(100)
- Field
Status (StatusMaster)
- Status_id (Key) — INT — Primary key — NOT NULL
- Statusname (Field) — VARCHAR(200)
Team (Team_master)
- Team_id (Key) — INT — Primary key — NOT NULL
- Teamname (Field) — VARCHAR(100)
Tech_Domain (Untitled)
- ID (Key) — INT — Primary key — NOT NULL
- Name (Field)