| id |
integer |
Yes |
Yes |
nextval('email_templates_id_seq'::regclass) |
Unique identifier |
| name |
character varying(40) |
No |
No |
''::character varying |
Template name |
| subject |
character varying(80) |
No |
No |
''::character varying |
Subject to be used on email |
| assigned_to |
character varying(12) |
No |
No |
''::character varying |
Username assigned to if template was marked private, blank is available to all users |
| body |
text |
No |
No |
''::text |
Content of email body |
| _dbversion |
integer |
No |
No |
|
Program version that last modified this record |
| _created |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |
| _created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
| _modified |
timestamp without time zone |
No |
No |
|
UTC Date and time record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that modified this record |