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 |