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