Table of Contents



pears.psHealthShift

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Description

REDUNDANT

Columns

Column Type Null Default Comment
psHealthShiftID char(20) NOT NULL
tempshiftid char(20) NULL
tempshiftplanid char(20) NULL
transferbatch smallint NOT NULL 0
tenantTaskId char(20) NULL shift or plan serialnumber
tenantBranchId char(20) NULL
taskTypeId char(20) NULL
tenantCarerId char(20) NULL Person appnumber
tenantCustomerId char(20) NULL Person appnumber
tenantCaseId char(20) NULL Vacancy ourref
name char(50) NULL
status char(50) NULL
startDateTime timestamp NULL
endDateTime timestamp NULL
updatedDateTime timestamp NULL
createdDateTime timestamp NULL
addressLineOne char(50) NULL
addressLineTwo char(50) NULL
addressCity char(50) NULL
addressPostcode char(50) NULL
addressCounty char(50) NULL
addressCountry char(50) NULL
addressLatitude double NULL
addressLongitude double NULL
checkInDateTime timestamp NULL
checkOutDateTime timestamp NULL
checkInGpsLatitude double NULL
checkInGpsLongitude double NULL
checkInGpsAltitude double NULL
checkInGpsAccuracy double NULL
checkInGpsAltitudeAccuracy double NULL
checkInNfcId char(50) NULL
checkInNfcContent char(50) NULL
checkOutGpsLatitude double NULL
checkOutGpsLongitude double NULL
checkOutGpsAltitude double NULL
checkOutGpsAltitudeAccuracy double NULL
checkOutNfcId char(50) NULL
checkOutNfcContent char(50) NULL
isDeleted smallint NULL 1 or 0 or null

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."psHealthShift"
-- Table comment: REDUNDANT
-- Statement count: 7
 
CREATE TABLE "pears"."psHealthShift" (
    "psHealthShiftID"                CHAR(20) NOT NULL
   ,"tempshiftid"                    CHAR(20) NULL
   ,"tempshiftplanid"                CHAR(20) NULL
   ,"transferbatch"                  SMALLINT NOT NULL DEFAULT 0
   ,"tenantTaskId"                   CHAR(20) NULL
   ,"tenantBranchId"                 CHAR(20) NULL
   ,"taskTypeId"                     CHAR(20) NULL
   ,"tenantCarerId"                  CHAR(20) NULL
   ,"tenantCustomerId"               CHAR(20) NULL
   ,"tenantCaseId"                   CHAR(20) NULL
   ,"name"                           CHAR(50) NULL
   ,"status"                         CHAR(50) NULL
   ,"startDateTime"                  TIMESTAMP NULL
   ,"endDateTime"                    TIMESTAMP NULL
   ,"updatedDateTime"                TIMESTAMP NULL
   ,"createdDateTime"                TIMESTAMP NULL
   ,"addressLineOne"                 CHAR(50) NULL
   ,"addressLineTwo"                 CHAR(50) NULL
   ,"addressCity"                    CHAR(50) NULL
   ,"addressPostcode"                CHAR(50) NULL
   ,"addressCounty"                  CHAR(50) NULL
   ,"addressCountry"                 CHAR(50) NULL
   ,"addressLatitude"                DOUBLE NULL
   ,"addressLongitude"               DOUBLE NULL
   ,"checkInDateTime"                TIMESTAMP NULL
   ,"checkOutDateTime"               TIMESTAMP NULL
   ,"checkInGpsLatitude"             DOUBLE NULL
   ,"checkInGpsLongitude"            DOUBLE NULL
   ,"checkInGpsAltitude"             DOUBLE NULL
   ,"checkInGpsAccuracy"             DOUBLE NULL
   ,"checkInGpsAltitudeAccuracy"     DOUBLE NULL
   ,"checkInNfcId"                   CHAR(50) NULL
   ,"checkInNfcContent"              CHAR(50) NULL
   ,"checkOutGpsLatitude"            DOUBLE NULL
   ,"checkOutGpsLongitude"           DOUBLE NULL
   ,"checkOutGpsAltitude"            DOUBLE NULL
   ,"checkOutGpsAltitudeAccuracy"    DOUBLE NULL
   ,"checkOutNfcId"                  CHAR(50) NULL
   ,"checkOutNfcContent"             CHAR(50) NULL
   ,"isDeleted"                      SMALLINT NULL
   ,PRIMARY KEY ("psHealthShiftID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."psHealthShift"."tenantTaskId" IS 
	'shift or plan serialnumber'
GO
 
 
COMMENT ON COLUMN "pears"."psHealthShift"."tenantCarerId" IS 
	'Person appnumber'
GO
 
 
COMMENT ON COLUMN "pears"."psHealthShift"."tenantCustomerId" IS 
	'Person appnumber'
GO
 
 
COMMENT ON COLUMN "pears"."psHealthShift"."tenantCaseId" IS 
	'Vacancy ourref'
GO
 
 
COMMENT ON COLUMN "pears"."psHealthShift"."isDeleted" IS 
	'1 or 0 or null'
GO
 
 
COMMENT ON TABLE "pears"."psHealthShift" IS 
	'REDUNDANT'
GO