Training App Schema - Dataverse (PsuedoSQL Style)

-- Employee Table
CREATE TABLE Employee (
    EmployeeID PRIMARY KEY,
    Name TEXT,
    Position TEXT,
    Department TEXT,
    Email TEXT,
    Shift TEXT,
    HireDate DATE,
    Status CHOICE
);

-- TrainingRole Table
CREATE TABLE TrainingRole (
    RoleID PRIMARY KEY,
    RoleName TEXT
);

-- UserRole Table
CREATE TABLE UserRole (
    UserRoleID PRIMARY KEY,
    UserID LOOKUP(Employee.EmployeeID),
    RoleID LOOKUP(TrainingRole.RoleID)
);

-- TrainingSchedule Table
CREATE TABLE TrainingSchedule (
    ScheduleID PRIMARY KEY,
    EmployeeID LOOKUP(Employee.EmployeeID),
    TrainingStartTime DATETIME,
    TrainingEndTime DATETIME
);

-- TrainingFeedback Table
CREATE TABLE TrainingFeedback (
    FeedbackID PRIMARY KEY,
    ScheduleID LOOKUP(TrainingSchedule.ScheduleID),
    FeedbackText MULTILINE TEXT,
    Grade NUMBER
);

-- InactiveEmployee Table
CREATE TABLE InactiveEmployee (
    InactiveEmployeeID PRIMARY KEY,
    EmployeeID LOOKUP(Employee.EmployeeID),
    InactiveDate DATE,
    Reason TEXT
);

-- GlobalSchedule Table
CREATE TABLE GlobalSchedule (
    EventID PRIMARY KEY,
    EventName TEXT,
    StartDate DATE,
    EndDate DATE
);

-- ManagerOverride Table
CREATE TABLE ManagerOverride (
    OverrideID PRIMARY KEY,
    ScheduleID LOOKUP(TrainingSchedule.ScheduleID),
    ManagerID LOOKUP(Employee.EmployeeID),
    BackupTrainerID LOOKUP(Employee.EmployeeID),
    OverrideReason TEXT
);

-- TrainerQualification Table
CREATE TABLE TrainerQualification (
    [Define columns and primary key]
    TrainerID LOOKUP(Employee.EmployeeID)
);

-- QualificationAppIntegration Table
CREATE TABLE QualificationAppIntegration (
    [Define columns and primary key]
    IntegrationID LOOKUP(TrainerQualification.[Appropriate Column])
);