Name  | 
Type  | 
Not Null  | 
P/K  | 
Unique  | 
Code  | 
varchar(16)  | 
Yes  | 
Yes  | 
Yes  | 
Parent  | 
varchar(16)  | 
  | 
  | 
  | 
Template  | 
varchar(16)  | 
  | 
  | 
  | 
Context  | 
varchar(16)  | 
  | 
  | 
  | 
Status  | 
varchar(16)  | 
  | 
  | 
  | 
Description  | 
nvarchar(60)  | 
  | 
  | 
  | 
Full Description  | 
nvarchar(60)  | 
  | 
  | 
  | 
Latitude  | 
float  | 
  | 
  | 
  | 
Longitude  | 
float  | 
  | 
  | 
  | 
Zip  | 
varchar(20)  | 
  | 
  | 
  | 
HC  | 
bit  | 
  | 
  | 
  | 
Misc  | 
ntext  | 
  | 
  | 
  |