Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 4.02 » View Incident Report |
Serious |
Reported By: Allan Brocklehurst Reported On: 12/16/2003 For: Version 4.01 Build 1 |
CREATE TABLE IF NOT EXISTS "ProcedureMGR" ( "OID" GUID DEFAULT CURRENT_GUID, "Code" VARCHAR(10), "Version" VARCHAR(10), "Description" VARCHAR(30), "Active" BOOLEAN DEFAULT True, "Facility" VARCHAR(10), "Setup Hours" FLOAT DEFAULT 0, "Procedure Hours" FLOAT DEFAULT 0, "Cleanup Hours" FLOAT DEFAULT 0, "End Time" TIMESTAMP DEFAULT CURRENT_TIMESTAMP, "Notes" MEMO, "CreatedBy" VARCHAR(30), "Created" TIMESTAMP DEFAULT CURRENT_TIMESTAMP, "EventCount" INTEGER DEFAULT 0, "First Performed" DATE DEFAULT CURRENT_DATE, "Last Performed" DATE DEFAULT CURRENT_DATE, "Actual Setup Hours" FLOAT, "Actual Procedure Hours" FLOAT, "Actual CleanUp Hours" FLOAT, "Surgeon" VARCHAR(10), "Anestelsiolist" VARCHAR(10), "Patient Type" VARCHAR(10), PRIMARY KEY ("OID") COMPRESS NONE LOCALE CODE 0 USER MAJOR VERSION 1 ); CREATE INDEX IF NOT EXISTS "Code" ON "ProcedureMGR" ("Code"); CREATE INDEX IF NOT EXISTS "Active" ON "ProcedureMGR" ("Active"); CREATE INDEX IF NOT EXISTS "MainKey" ON "ProcedureMGR" ("Code", "Version"); CREATE INDEX IF NOT EXISTS "Surgeon" ON "ProcedureMGR" ("Surgeon"); CREATE INDEX IF NOT EXISTS "Type" ON "ProcedureMGR" ("Patient Type"); CREATE INDEX IF NOT EXISTS "Description" ON "ProcedureMGR" ("Description");
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |