pears.Chat
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Description
List of internal iqx chat messages
Columns
| Column | Type | Null | Default | Comment |
|---|---|---|---|---|
| ChatID | char(20) | NOT NULL | ||
| ChatTypeID | char(20) | NULL | ||
| ChatType | char(1) | NULL | ||
| Subject | char(60) | NULL | ||
| ChatDate | timestamp | NULL |
Primary Key
- ChatID
Foreign Keys
- No outgoing foreign keys found.
Referenced By
| Table | Constraint | Columns | Referenced columns |
|---|---|---|---|
| pears.ChatInvite | Chat | ChatID | ChatID |
| pears.ChatMessage | Chat | ChatID | ChatID |
Indexes
- No indexes found.
Triggers
- No triggers found.
Original SQL
-- IQX database structure split by table -- Source: IQXDatabaseStructure - with comments.sql -- Table: "pears"."Chat" -- Table comment: List of internal iqx chat messages -- Statement count: 2 CREATE TABLE "pears"."Chat" ( "ChatID" CHAR(20) NOT NULL ,"ChatTypeID" CHAR(20) NULL ,"ChatType" CHAR(1) NULL ,"Subject" CHAR(60) NULL ,"ChatDate" TIMESTAMP NULL ,PRIMARY KEY ("ChatID" ASC) ) GO COMMENT ON TABLE "pears"."Chat" IS 'List of internal iqx chat messages' GO