Table: dbo.Journal | |||
Columns | |||
Name | Type | Constraints | Description |
journal_KEY | int (4) | NOT NULL | Primary key for this table |
client_KEY | int (4) | NOT NULL | Key of client that owns the journal |
description | nvarchar (60) | NOT NULL | Journal description |
gl_report_code | nvarchar (10) | The GL report code associated with each transaction | |
bank_transaction_type_KEY | int (4) | The type of bank transaction |
Primary key | |||
Name | Columns | Description | |
PK_Journal | journal_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Journal$description$client_KEY | description, client_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Journal__Bank_Transaction_Type__bank_transaction_type_KEY | bank_transaction_type_KEY | Bank_Transaction_Type (bank_transaction_type_KEY) | |
FK_Journal__Client__client_KEY | client_KEY | Client (client_KEY) |