Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| method_of_payment_code | varchar | 3 | null |
|
|
A code describing various Method of Payments. |
|||||
| description | varchar | 120 | null |
|
|
A description for the affiliated code. |
|||||
| default_method_ind | bool | 1 | √ | null |
|
|
A flag that determines if the method is default. |
||||
| effective_date | date | 13 | null |
|
|
The effective date the code is in effect. |
|||||
| expiry_date | date | 13 | null |
|
|
The date the code expires on. |
|||||
| update_timestamp | timestamp | 29,6 | null |
|
|
The date and time of the last update. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| method_of_payment_list_pk | Primary key | Asc | method_of_payment_code |
| only_one_default_method | Must be unique | Asc | default_method_ind |
Relationships
Close relationships within degrees of separation
