Name

Type

Not Null

P/K

Unique

Code

varchar(16)

Yes

Yes

Yes

Kind

varchar(1)

Short Name

varchar(10)

Division

varchar(16)

Sex

varchar(1)

Name

nvarchar(80)

Name Prefix

nvarchar(20)

Name First

nvarchar(80)

Name Middle

nvarchar(30)

Name Last

nvarchar(80)

Name Suffix

varchar(30)

Company

nvarchar(80)

Company code

nvarchar(16)

DOB

datetime

Soc sec#

nvarchar(30)

Misc info

ntext

Athnum

float

Last changed

datetime

Placeholder

bit

Archived

bit

Reference

nvarchar(32)

Zip Code

varchar(5)

Is team

bit

Team name

nvarchar(80)

Active

varchar(16)

Date created

datetime

Date started

datetime