====== pears.PushNotificationTemplate ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== 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 ^
| [[database:tables:pears_notificationtemplate|pears.NotificationTemplate]] | PushNotificationTemplate | PushNotificationTemplateID | PushNotificationTemplateID |

===== Indexes =====
  * No indexes found.

===== Triggers =====
  * No triggers found.

===== Original SQL =====
<code 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
</code>