pears.psHealthShift

REDUNDANT

• psHealthShiftID

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- 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