Table: Ledger_Entry_Subtype
SYSTEM TABLE: Defines the subtypes of ledger_entrys that can be stored in the Ledger_Entry table.
Columns
NameTypeConstraintsDescription
ledger_entry_subtype_KEYintNOT NULLA 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_KEYintNOT NULLThe granular ledger entry type that this subtype applies to.
descriptionnvarchar (30)NOT NULLDescription (unique per ledger_entry_type_KEY).
Primary key
NameColumnsDescription
PK_Ledger_Entry_Subtype$ledger_entry_subtype_KEYledger_entry_subtype_KEYCLUSTERED
Foreign keys
NameColumnsReferenced tableDescription
FK_Ledger_Entry_Subtype__Ledger_Entry_Type__ledger_entry_type_KEYledger_entry_type_KEYLedger_Entry_Type
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Ledger_Entry__Ledger_Entry_Subtype__ledger_entry_subtype_KEYledger_entry_subtype_KEYLedger_Entry

Schema diagram