Table: Ledger_Entry_Subtype | |||
SYSTEM TABLE: Defines the subtypes of ledger_entrys that can be stored in the Ledger_Entry table. | |||
Columns | |||
Name | Type | Constraints | Description |
ledger_entry_subtype_KEY | int | NOT NULL | A unique value assigned to this row so that linking to this row uses only 1 byte. Stored as an Int8 to save storage space on the millions of Ledger_Entry rows. |
ledger_entry_type_KEY | int | NOT NULL | The granular ledger entry type that this subtype applies to. |
description | nvarchar (30) | NOT NULL | Description (unique per ledger_entry_type_KEY). |
Primary key | |||
Name | Columns | Description | |
PK_Ledger_Entry_Subtype$ledger_entry_subtype_KEY | ledger_entry_subtype_KEY | CLUSTERED |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Ledger_Entry_Subtype__Ledger_Entry_Type__ledger_entry_type_KEY | ledger_entry_type_KEY | Ledger_Entry_Type |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Ledger_Entry__Ledger_Entry_Subtype__ledger_entry_subtype_KEY | ledger_entry_subtype_KEY | Ledger_Entry |