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)