====== pears.diaryextraday ====== Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. ===== Description ===== Global Temp Table used in rendering diary displays. ===== Columns ===== ^ Column ^ Type ^ Null ^ Default ^ Comment ^ | diaryid | char(20) | NULL | | | | diarydate | date | NULL | | | | diaryminutes | smallint | NULL | | | ===== Primary Key ===== * No primary key found in generated SQL. ===== Foreign Keys ===== * No outgoing foreign keys found. ===== Referenced By ===== * No incoming foreign keys found. ===== Indexes ===== * No indexes found. ===== Triggers ===== * No triggers found. ===== Original SQL ===== -- IQX database structure split by table -- Source: IQXDatabaseStructure - with comments.sql -- Table: "pears"."diaryextraday" -- Table comment: Global Temp Table used in rendering diary displays. -- Statement count: 2 CREATE GLOBAL TEMPORARY TABLE "pears"."diaryextraday" ( "diaryid" char(20) NULL ,"diarydate" date NULL ,"diaryminutes" smallint NULL ) ON COMMIT PRESERVE ROWS go COMMENT ON TABLE "pears"."diaryextraday" IS 'Global Temp Table used in rendering diary displays.' go