Table: dbo.Tickmark
The table contains contains the tickmarks for the firm. It can store one of two types of tickmarks. Images or text.
Columns
Name | Type | Constraints | Description
tickmark_KEY | int (4) | NOT NULL | The primary key.
description | nvarchar (100) | NOT NULL | This is the main text descriptor for the tickmark.
hot_key | int (4) |  | This contains the number 0-9 that is given to this tickmark as a hot key. If this value is NULL then no hotkey is assigned to this Tickmark
transparent | bit (1) | NOT NULL | This specified if this tickmark will be displayed as transparent.
report_image_KEY | int (4) |  | This is the key to the image for the image tickmark.
text_color | int (4) | NOT NULL | This is the font color for the text tickmark.
text_font_family | nvarchar (100) | NOT NULL | This is the font family name for the text tickmark.
text_em_size | float (8) | NOT NULL | This is the font size for the text tickmark.
text_font_style | int (4) | NOT NULL | This is the font style for the text tickmark.
tickmark_text | nvarchar (100) | NOT NULL | This is the text for the text tickmark.

Primary key
Name | Columns | Description
PK_Tickmark | tickmark_KEY |
Unique constraints
Name | Columns | Description
UK_Tickmark$description | description |

Foreign keys
Name | Columns | Referenced table | Description
FK_Tickmark__Report_Image__report_image_KEY | report_image_KEY | Report_Image (report_image_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_GL_Account_Tickmark__Tickmark__tickmark_KEY | tickmark_KEY | GL_Account_Tickmark |