| 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) | |