pears.PushNotificationTemplate
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Columns
| Column | Type | Null | Default | Comment |
|---|---|---|---|---|
| PushNotificationTemplateID | char(20) | NOT NULL | ||
| Description | char(50) | NULL | ||
| PushIcon | char(200) | NULL | ||
| PushGroup | char(20) | NULL | ||
| PushURL | char(200) | NULL | ||
| Sound | char(50) | NULL | 'default' | |
| Badge | char(50) | NULL | 1 | |
| NotificationForeground | tinyint | NULL | 1 | |
| Priority | tinyint | NULL | 1 | |
| Colour | integer | NULL | 16777215 |
Primary Key
- PushNotificationTemplateID
Foreign Keys
- No outgoing foreign keys found.
Referenced By
| Table | Constraint | Columns | Referenced columns |
|---|---|---|---|
| pears.NotificationTemplate | PushNotificationTemplate | PushNotificationTemplateID | PushNotificationTemplateID |
Indexes
- No indexes found.
Triggers
- No triggers found.
Original SQL
-- IQX database structure split by table -- Source: IQXDatabaseStructure - with comments.sql -- Table: "pears"."PushNotificationTemplate" -- Table comment: -- Statement count: 1 CREATE TABLE "pears"."PushNotificationTemplate" ( "PushNotificationTemplateID" CHAR(20) NOT NULL ,"Description" CHAR(50) NULL ,"PushIcon" CHAR(200) NULL ,"PushGroup" CHAR(20) NULL ,"PushURL" CHAR(200) NULL ,"Sound" CHAR(50) NULL DEFAULT 'default' ,"Badge" CHAR(50) NULL DEFAULT 1 ,"NotificationForeground" tinyint NULL DEFAULT 1 ,"Priority" tinyint NULL DEFAULT 1 ,"Colour" INTEGER NULL DEFAULT 16777215 ,PRIMARY KEY ("PushNotificationTemplateID" ASC) ) GO
127.0.0.1