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