Table: dbo.GL_Account_Tickmark | |||
This table contains the connection between a GL account and a tickmark. | |||
Columns | |||
Name | Type | Constraints | Description |
gl_account_KEY | int (4) | NOT NULL | This points to a specific gl account. |
tickmark_KEY | int (4) | NOT NULL | This points to a specific tickmark that belongs to a GL account. |
gl_account_tickmark_KEY | int (4) | NOT NULL | The primary key. |
gl_period_KEY | int (4) | NOT NULL | Points to a specific GL period. |
Primary key | |||
Name | Columns | Description | |
PK_GL_Account_Tickmark | gl_account_tickmark_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_GL_Account_Tickmark$gl_period_KEY$gl_account_KEY | gl_period_KEY, gl_account_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_GL_Account_Tickmark__GL_Account__gl_account_KEY | gl_account_KEY | GL_Account (gl_account_KEY) | |
FK_GL_Account_Tickmark__GL_Period__gl_period_KEY | gl_period_KEY | GL_Period (gl_period_KEY) | |
FK_GL_Account_Tickmark__Tickmark__tickmark_KEY | tickmark_KEY | Tickmark (tickmark_KEY) |