Re: Complex Database Creation
The First Table
Shift1SecName_ID BigInt Not Null Auto Increment,
Bus_UUID CHAR(36),
Shift1SectionName Varchar(255),
Shift1MaxNumEmp Int,
Shift1Day1SecEarTime Varchar (10),
Val_Shift1SecDay1EarTime Int,
Shift1Day1SecLatTime Varchar (10),
Shift1Day1SecLatTime Int,
Shift1Day1NumEmpEar Int,
Shift1Day1NumEmpBusOpen Int,
Shift1Day1NumEmpBusBusiest Int,
Shift1Day1SecEarBusiest Varchar (10),
Val_Shift1Day1SecEarBusiest Int,
Shift1Day1SecLatBusiest Varchar(10),
Val_Shift1Day1SecLatBusiest Int,
Shift1Day1SecNumEmpBusClose Int,
Shift1Day1SecNumEmpBusLatest Int,
...,
Primary Key (Shift1SecName_ID);
(... is the rest of days in week)
The Second Table
Shift1EmpInfo_ID BigInt Not Null Auto Increment,
Bus_UUID Char(36)
Shift1BusEmp_ID Varchar(255), (this is the business identification used, not internal)
Shift1EmpLast Varchar(255),
Shift1EmpFirst Varchar(255),
Shift1EmpEmail Varchar(255),
Shift1EmpFullPart Varchar(255),
Shift1EmpSetHours Varchar(3),
Shift1EmpNumWeekSetHours Int,
Shift1Day1EmpEar Varchar(255),
Val_Shift1Day1EmpEar Int,
...,
Primary Key (Shift1EmpInfo_ID);
In a new table, be able to gather the information from a check-box listed on web form that includes Shift1SecName and Shift1EmpInfo.
I am using a table for Shift1Emp Information so the business can select which Employee to update. It is setup to copy to new table the Shift1EmpInfo_ID and Shift1BusEmp_ID and will only display the name of the employee once update is selected.
Once Section Selection occurs for employee, need the information put in the table.