|
|
|
|
|
Name |
Type |
Not Null |
P/K |
Unique |
Code |
varchar(16) |
Yes |
Yes |
Yes |
Member |
varchar(16) |
|
|
|
Assoc master |
varchar(16) |
|
|
|
Membership number |
varchar(10) |
|
|
|
Type |
varchar(16) |
|
|
|
Subtype |
varchar(16) |
|
|
|
Status |
varchar(16) |
|
|
|
Start |
datetime |
|
|
|
Expire |
datetime |
|
|
|
Cancel date |
datetime |
|
|
|
Cancel reason |
varchar(16) |
|
|
|
Location |
varchar(16) |
|
|
|
Misc |
ntext |
|
|
|