Table: Online_Payment | |||
Information about Payments that have been received from the online bill pay service. | |||
Columns | |||
Name | Type | Constraints | Description |
ledger_entry_KEY | int | NOT NULL | Primary key for this row and the key of the associated Payment. |
online_payment_guid | uniqueidentifier | NOT NULL | A unique value that is used to identify this payment on the portal and in online payments. |
update__staff_KEY | int | NOT NULL | |
update_date_utc | datetime | NOT NULL | |
create_date_utc | datetime | NOT NULL |
Primary key | |||
Name | Columns | Description | |
PK_Online_Payment$ledger_entry_KEY | ledger_entry_KEY | CLUSTERED | |
Unique constraints | |||
Name | Columns | Description | |
UK_Online_Payment$online_payment_guid | online_payment_guid |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Online_Payment__Ledger_Entry__ledger_entry_KEY | ledger_entry_KEY | Ledger_Entry | on delete cascade; |