| id |
INT UNSIGNED |
10 |
|
√ |
null |
|
|
|
| membership_id |
INT UNSIGNED |
10 |
|
|
null |
|
|
FK to Membership table |
| status_id |
INT UNSIGNED |
10 |
|
|
null |
|
|
New status assigned to membership by this action. FK to Membership Status |
| start_date |
DATE |
10 |
√ |
|
null |
|
|
New membership period start date |
| end_date |
DATE |
10 |
√ |
|
null |
|
|
New membership period expiration date. |
| modified_id |
INT UNSIGNED |
10 |
√ |
|
null |
|
|
FK to Contact ID of person under whose credentials this data modification was made. |
| modified_date |
DATE |
10 |
√ |
|
null |
|
|
Date this membership modification action was logged. |
| membership_type_id |
INT UNSIGNED |
10 |
√ |
|
null |
|
|
FK to Membership Type. |
| max_related |
INT |
10 |
√ |
|
null |
|
|
Maximum number of related memberships. |
