abc
Tables (16)
Attendance
- AttendanceId — BIGINT
- EmployeeId — UNIQUEIDENTIFIER — NOT NULL
- WorkModalityId — BIGINT — NOT NULL
- Date — DATE — NOT NULL
- WorkShiftId — BIGINT
- ContractId — UNIQUEIDENTIFIER
- WorkShiftEmployeeId — BIGINT
- WorkType — NVARCHAR(50) — NOT NULL
- Status — NVARCHAR(50) — NOT NULL
- Observations — NVARCHAR(255)
- CalendarId — BIGINT
- DeviceId — BIGINT
- CheckInTime — DATETIME2(7)
- CheckOutTime — DATETIME2(7)
- PermissionId — BIGINT
- LocationId — BIGINT
- MarkLat — DECIMAL(9,6)
- MarkLon — DECIMAL(9,6)
- MarkLocation — NVARCHAR(255)
- ToleranceInMin — INT
- ToleranceOutMin — INT
- RealStartTime — DATETIME2(7)
- RealEndTime — DATETIME2(7)
- InZone — BIT
- MarkDeviceId — NVARCHAR(255)
- DeviceTimeStamp — DATETIME2(7)
- SyncStatus — TINYINT — NOT NULL
- SyncedAt — DATETIME2(7)
- Offline — BIT
- ConfigurationId — BIGINT
- ResolutionSource — NVARCHAR(50)
- ResolutionSnapshot — NVARCHAR(MAX)
- CreatedBy — NVARCHAR(255)
- CreatedDate — DATETIME2(7)
- LastModifiedBy — NVARCHAR(255)
- LastModifiedDate — DATETIME2(7)
Configuration
- ConfigurationId — BIGINT
- Name — NVARCHAR(255) — NOT NULL
- StartDate — DATETIME2(7) — NOT NULL
- EndDate — DATETIME2(7)
- Description — NVARCHAR(255)
- Active — BIT — NOT NULL
- CreatedBy — NVARCHAR(255)
- CreatedDate — DATETIME2(7)
- LastModifiedBy — NVARCHAR(255)
- LastModifiedDate — DATETIME2(7)
Device
- DeviceId — BIGINT
- Code — NVARCHAR(255) — NOT NULL
- Type — NVARCHAR(50) — NOT NULL
- Status — NVARCHAR(50) — NOT NULL
- Ip — NVARCHAR(45)
- EmployeeId — UNIQUEIDENTIFIER
- ConfigurationId — BIGINT — NOT NULL
- LastMaintenance — DATETIME2(7)
- QueueSize — INT
- LastSyncAt — DATETIME2(7)
- LastSyncStatus — NVARCHAR(50)
- CreatedBy — NVARCHAR(255)
- CreatedDate — DATETIME2(7)
- LastModifiedBy — NVARCHAR(255)
- LastModifiedDate — DATETIME2(7)
GlobalParameters
- GlobalId — BIGINT
- Name — NVARCHAR(255) — NOT NULL
- Value — NVARCHAR(255) — NOT NULL
- Unit — NVARCHAR(255)
- ConfigurationId — BIGINT — NOT NULL
- CreatedBy — NVARCHAR(255)
- CreatedDate — DATETIME2(7)
- LastModifiedBy — NVARCHAR(255)
- LastModifiedDate — DATETIME2(7)
Incident
- IncidentId — BIGINT
- IncidentTypeId — BIGINT — NOT NULL
- AttendanceId — BIGINT — NOT NULL
- Status — NVARCHAR(50) — NOT NULL
- DetectionDate — DATETIME2(7) — NOT NULL
- Observations — NVARCHAR(255)
- JustificationId — BIGINT
- CreatedBy — NVARCHAR(255)
- CreatedDate — DATETIME2(7)
- LastModifiedBy — NVARCHAR(255)
- LastModifiedDate — DATETIME2(7)
IncidentType
- IncidentTypeId — BIGINT
- Name — NVARCHAR(255) — NOT NULL
- Description — NVARCHAR(255)
- CreatedBy — NVARCHAR(255)
- CreatedDate — DATETIME2(7)
- LastModifiedBy — NVARCHAR(255)
- LastModifiedDate — DATETIME2(7)
Location
- LocationId — BIGINT
- LocationType — NVARCHAR(50) — NOT NULL
- ConnectionMode — NVARCHAR(50) — NOT NULL
- LocationName — NVARCHAR(255) — NOT NULL
- Latitude — DECIMAL(9,6) — NOT NULL
- Longitude — DECIMAL(9,6) — NOT NULL
- AllowRadius — DECIMAL(9,2) — NOT NULL
- Address — NVARCHAR(255)
- CreatedBy — NVARCHAR(255)
- CreatedDate — DATETIME2(7)
- LastModifiedBy — NVARCHAR(255)
- LastModifiedDate — DATETIME2(7)
OverTime
- OverTimeId — BIGINT
- AttendanceId — BIGINT — NOT NULL
- Status — NVARCHAR(50) — NOT NULL
- TotalHours — DECIMAL(10,2) — NOT NULL
- StartTime — DATETIME2(7) — NOT NULL
- EndTime — DATETIME2(7) — NOT NULL
- ApprovedBy — NVARCHAR(255)
- CreatedBy — NVARCHAR(255)
- CreatedDate — DATETIME2(7)
- LastModifiedBy — NVARCHAR(255)
- LastModifiedDate — DATETIME2(7)
Permission
- PermissionId — BIGINT
- EmployeeId — UNIQUEIDENTIFIER — NOT NULL
- PermissionTypeId — BIGINT — NOT NULL
- Reason — NVARCHAR(255)
- StartDate — DATE — NOT NULL
- EndDate — DATE — NOT NULL
- Status — NVARCHAR(50) — NOT NULL
- RequestDate — DATETIME2(7) — NOT NULL
- ApprovedBy — NVARCHAR(255)
- CreatedBy — NVARCHAR(255)
- CreatedDate — DATETIME2(7)
- LastModifiedBy — NVARCHAR(255)
- LastModifiedDate — DATETIME2(7)
PermissionType
- PermissionTypeId — BIGINT
- Name — NVARCHAR(255) — NOT NULL
- Description — NVARCHAR(255)
- CreatedBy — NVARCHAR(255)
- CreatedDate — DATETIME2(7)
- LastModifiedBy — NVARCHAR(255)
- LastModifiedDate — DATETIME2(7)
ValidationParameters
- ValidationId — BIGINT
- Name — NVARCHAR(255) — NOT NULL
- Condition — NVARCHAR(255) — NOT NULL
- Action — NVARCHAR(255) — NOT NULL
- ConfigurationId — BIGINT — NOT NULL
- CreatedBy — NVARCHAR(255)
- CreatedDate — DATETIME2(7)
- LastModifiedBy — NVARCHAR(255)
- LastModifiedDate — DATETIME2(7)
WorkCalendar
- CalendarId — BIGINT
- Name — NVARCHAR(255) — NOT NULL
- Description — NVARCHAR(255)
- StartDate — DATE — NOT NULL
- EndDate — DATE
- IsHoliday — BIT — NOT NULL
- IsWorkDay — BIT — NOT NULL
- CreatedBy — NVARCHAR(255)
- CreatedDate — DATETIME2(7)
- LastModifiedBy — NVARCHAR(255)
- LastModifiedDate — DATETIME2(7)
WorkModality
- WorkModalityId — BIGINT
- Name — NVARCHAR(255) — NOT NULL
- Description — NVARCHAR(255)
- RequiresLocation — BIT — NOT NULL
- RequiresFixedDevice — BIT — NOT NULL
- CreatedBy — NVARCHAR(255)
- CreatedDate — DATETIME2(7)
- LastModifiedBy — NVARCHAR(255)
- LastModifiedDate — DATETIME2(7)
WorkShift
- WorkShiftId — BIGINT
- WorkDayId — UNIQUEIDENTIFIER
- Name — NVARCHAR(200)
- CompanyId — UNIQUEIDENTIFIER
- IsActive — BIT — NOT NULL
- CreatedBy — NVARCHAR(255)
- CreatedDate — DATETIME2(7)
- LastModifiedBy — NVARCHAR(255)
- LastModifiedDate — DATETIME2(7)
WorkShiftDetail
- WorkShiftDetailId — BIGINT
- WorkShiftId — BIGINT — NOT NULL
- DayOfWeek — TINYINT — NOT NULL
- StartTime — TIME(7) — NOT NULL
- EndTime — TIME(7) — NOT NULL
- StartUtc — DATETIME2(7)
- EndUtc — DATETIME2(7)
- CreatedBy — NVARCHAR(255)
- CreatedDate — DATETIME2(7)
- LastModifiedBy — NVARCHAR(255)
- LastModifiedDate — DATETIME2(7)
WorkShiftEmployee
- WorkShiftEmployeeId — BIGINT
- WorkDayId — UNIQUEIDENTIFIER
- EmployeeId — UNIQUEIDENTIFIER — NOT NULL
- FromDate — DATE — NOT NULL
- ToDate — DATE
- IsActive — BIT — NOT NULL
- CreatedBy — NVARCHAR(255)
- CreatedDate — DATETIME2(7)
- LastModifiedBy — NVARCHAR(255)
- LastModifiedDate — DATETIME2(7)