pears.TSInbox

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

Used in the processing of Timesheet Images

Column Type Null Default Comment
TSInboxID char(20) NOT NULL
IMAPName char(254) NULL
UIName char(254) NULL
Username char(254) NULL
Password char(254) NULL
Port char(254) NULL
Host char(254) NULL
DivisionID char(20) NULL
  • TSInboxID
  • 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"."TSInbox"
-- Table comment: Used in the processing of Timesheet Images
-- Statement count: 2
 
CREATE TABLE "pears"."TSInbox" (
    "TSInboxID"                      CHAR(20) NOT NULL
   ,"IMAPName"                       CHAR(254) NULL
   ,"UIName"                         CHAR(254) NULL
   ,"Username"                       CHAR(254) NULL
   ,"Password"                       CHAR(254) NULL
   ,"Port"                           CHAR(254) NULL
   ,"Host"                           CHAR(254) NULL
   ,"DivisionID"                     CHAR(20) NULL
   ,PRIMARY KEY ("TSInboxID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."TSInbox" IS 
	'Used in the processing of Timesheet Images'
GO
  • database/tables/pears_tsinbox.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1