SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE [dbo].[Department]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](50) NOT NULL, [GroupName] [nvarchar](50) NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [varchar](6) NOT NULL, [UpdatedAt] [datetime] NULL, [UpdatedBy] [varchar](6) NOT NULL, [IsActive] [int] NOT NULL, CONSTRAINT [PK_Department] PRIMARY KEY CLUSTERED ( [Id] ASC )) ON [PRIMARY] GO CREATE TABLE [dbo].[Employee]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [PersonId] [bigint] NULL, [Login] [nvarchar](4000) NULL, [OrganizationLevel] [smallint] NULL, [JobTitle] [nvarchar](50) NOT NULL, [HireDate] [date] NOT NULL, [VacationHours] [smallint] NULL, [SickLeaveHours] [smallint] NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [varchar](256) NOT NULL, [UpdatedAt] [datetime] NULL, [UpdatedBy] [varchar](256) NULL, [IsActive] [int] NOT NULL, CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED ( [Id] ASC )) ON [PRIMARY] GO CREATE TABLE [dbo].[EmployeeDepartmentHistory]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [EmployeeId] [bigint] NULL, [DepartmentId] [bigint] NULL, [StartDate] [date] NOT NULL, [EndDate] [date] NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [varchar](6) NOT NULL, [UpdatedAt] [datetime] NULL, [UpdatedBy] [varchar](6) NOT NULL, [IsActive] [int] NOT NULL, CONSTRAINT [PK_EmployeeDepartmentHistory] PRIMARY KEY CLUSTERED ( [Id] ASC )) ON [PRIMARY] GO CREATE TABLE [dbo].[EmployeePayHistory]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [EmployeeId] [bigint] NULL, [RateChangeDate] [datetime] NOT NULL, [Rate] [money] NOT NULL, [PayFrequency] [tinyint] NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [varchar](6) NOT NULL, [UpdatedAt] [datetime] NULL, [UpdatedBy] [varchar](6) NOT NULL, [IsActive] [int] NOT NULL, CONSTRAINT [PK_EmployeePayHistory] PRIMARY KEY CLUSTERED ( [Id] ASC )) ON [PRIMARY] GO CREATE TABLE [dbo].[Person]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [NationalIDNumber] [nvarchar](15) NULL, [Title] [nvarchar](8) NULL, [FirstName] [nvarchar](50) NOT NULL, [MiddleName] [nvarchar](50) NULL, [LastName] [nvarchar](50) NOT NULL, [BirthDate] [date] NULL, [MaritalStatus] [nchar](1) NULL, [Gender] [nchar](1) NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [varchar](6) NOT NULL, [UpdatedAt] [datetime] NULL, [UpdatedBy] [varchar](6) NOT NULL, [IsActive] [int] NOT NULL, CONSTRAINT [PK_Person] PRIMARY KEY CLUSTERED ( [Id] ASC )) ON [PRIMARY] GO ALTER TABLE [dbo].[Employee] WITH CHECK ADD CONSTRAINT [FK_Employee_PersonId] FOREIGN KEY([PersonId]) REFERENCES [dbo].[Person] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[Employee] CHECK CONSTRAINT [FK_Employee_PersonId] GO ALTER TABLE [dbo].[EmployeeDepartmentHistory] WITH CHECK ADD CONSTRAINT [FK_EmployeeDepartmentHistory_DepartmentId] FOREIGN KEY([DepartmentId]) REFERENCES [dbo].[Department] ([Id]) GO ALTER TABLE [dbo].[EmployeeDepartmentHistory] CHECK CONSTRAINT [FK_EmployeeDepartmentHistory_DepartmentId] GO ALTER TABLE [dbo].[EmployeeDepartmentHistory] WITH CHECK ADD CONSTRAINT [FK_EmployeeDepartmentHistory_EmployeeId] FOREIGN KEY([EmployeeId]) REFERENCES [dbo].[Employee] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[EmployeeDepartmentHistory] CHECK CONSTRAINT [FK_EmployeeDepartmentHistory_EmployeeId] GO ALTER TABLE [dbo].[EmployeePayHistory] WITH CHECK ADD CONSTRAINT [FK_EmployeePayHistory_EmployeeId] FOREIGN KEY([EmployeeId]) REFERENCES [dbo].[Employee] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[EmployeePayHistory] CHECK CONSTRAINT [FK_EmployeePayHistory_EmployeeId] GO