Table of Contents



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

Foreign Keys

Referenced By

Table Constraint Columns Referenced columns
pears.NotificationTemplate PushNotificationTemplate PushNotificationTemplateID PushNotificationTemplateID

Indexes

Triggers

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