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
NameTypeConstraintsDescription
tickmark_KEYint (4)NOT NULLThe primary key.
descriptionnvarchar (100)NOT NULLThis is the main text descriptor for the tickmark.
hot_keyint (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
transparentbit (1)NOT NULLThis specified if this tickmark will be displayed as transparent.
report_image_KEYint (4)This is the key to the image for the image tickmark.
text_colorint (4)NOT NULLThis is the font color for the text tickmark.
text_font_familynvarchar (100)NOT NULLThis is the font family name for the text tickmark.
text_em_sizefloat (8)NOT NULLThis is the font size for the text tickmark.
text_font_styleint (4)NOT NULLThis is the font style for the text tickmark.
tickmark_textnvarchar (100)NOT NULLThis is the text for the text tickmark.
Primary key
NameColumnsDescription
PK_Tickmarktickmark_KEY
Unique constraints
NameColumnsDescription
UK_Tickmark$descriptiondescription
Foreign keys
NameColumnsReferenced tableDescription
FK_Tickmark__Report_Image__report_image_KEYreport_image_KEYReport_Image (report_image_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_GL_Account_Tickmark__Tickmark__tickmark_KEYtickmark_KEYGL_Account_Tickmark

Schema diagram