====== pears.TSInbox ======
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
===== Description =====
Used in the processing of Timesheet Images
===== Columns =====
^ 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 | | |
===== Primary Key =====
* TSInboxID
===== 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"."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