Table: Invoice_Office | |||
Columns | |||
Name | Type | Constraints | Description |
ledger_entry_KEY | int | NOT NULL | Key of the Ledger Entry. |
office_KEY | int | NOT NULL | Key of the Office of the Staff who billed this invoice. |
Primary key | |||
Name | Columns | Description | |
PK_Invoice_Office$ledger_entry_KEY | ledger_entry_KEY | CLUSTERED | |
Indexes | |||
Name | Columns | Description | |
IX_Invoice_Office$office_KEY | office_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Invoice_Office__Invoice__ledger_entry_KEY | ledger_entry_KEY | Invoice | on delete cascade; |
FK_Invoice_Office__Office__office_KEY | office_KEY | Office |