TableName	FieldName	Nulls	dataType	FieldSize	key	References	ClosedList	FieldNotes
datasetObs	datasetObs_ID	no	Long Integer	4	PK	n/a
datasetObs	userDataset_ID	yes	Long Integer	4	FK	userDataset.userDataset_ID
datasetObs	obsAccessionCode	yes	Text	100	n/a	n/a		accessionCode for observation that is part of dataset: used instead of observation_ID to allow observations from any database
datasetObs	datasetObsStart	yes	Date/Time	8	n/a	n/a
datasetObs	datasetObsStop	yes	Date/Time	8	n/a	n/a
datasetObs	notes	yes	Memo	0	n/a	n/a
embargo	embargo_ID	no	Long Integer	4	PK	n/a
embargo	plot_ID	yes	Long Integer	4	FK	plot.PLOT_ID
embargo	embargoReason	yes	Memo	0	n/a	n/a	yes	Author stipulation,Rare species,Landownership,Bad data,Other
embargo	embargoStart	yes	Date/Time	8	n/a	n/a
embargo	embargoStop	yes	Date/Time	8	n/a	n/a
embargo	defaultStatus	yes	Long Integer	4	n/a	n/a	yes	1-7, according to confidStatus values
user	user_ID	no	Long Integer	4	PK	n/a
user	party_ID	yes	Long Integer	4	FK	party.PARTY_ID
user	password	yes	Text	50	n/a	n/a
user	permission_type	yes	Text	50	n/a	n/a	yes	1=registered, 2= certified, 3=professional
user	begin_time	yes	Date/Time	8	n/a	n/a
user	last_connect	yes	Date/Time	8	n/a	n/a
user	ticket_count	yes	Long Integer	4	n/a	n/a		number of connects.
user	institution	yes	Text	100	n/a	n/a
user	email_address	yes	Text	100	n/a	n/a
user	preferred_name	yes	Text	100	n/a	n/a		name the user wishes to be called in correspondence
user	remote_address	yes	Text	100	n/a	n/a		ip address
userCertification	userCertification_id	no	Long Integer	4	PK	n/a
userCertification	user_ID	yes	Long Integer	4	FK	user.user_ID
userCertification	current_cert_level	yes	Text	50	n/a	n/a	yes	2= certified, 3=professional
userCertification	highest_degree	yes	Text	50	n/a	n/a
userCertification	degree_year	yes	Text	50	n/a	n/a
userCertification	degree_institution	yes	Text	50	n/a	n/a
userCertification	current_institution	yes	Text	50	n/a	n/a
userCertification	current_position	yes	Text	200	n/a	n/a
userCertification	esa_certified	yes	Text	50	n/a	n/a
userCertification	prof_experience_doc	yes	Memo	0	n/a	n/a
userCertification	relevant_pubs	yes	Memo	0	n/a	n/a
userCertification	veg_sampling_doc	yes	Memo	0	n/a	n/a
userCertification	veg_analysis_doc	yes	Memo	0	n/a	n/a
userCertification	usnvc_experience_doc	yes	Memo	0	n/a	n/a
userCertification	vegbank_experience_doc	yes	Memo	0	n/a	n/a
userCertification	plotdb_experience_doc	yes	Memo	0	n/a	n/a
userCertification	nvc_exp_region_a	yes	Text	50	n/a	n/a
userCertification	nvc_exp_vegetation_a	yes	Text	50	n/a	n/a
userCertification	nvc_exp_floristics_a	yes	Text	50	n/a	n/a
userCertification	nvc_exp_usnvc_a	yes	Text	50	n/a	n/a
userCertification	esa_sponsor_name_a	yes	Text	120	n/a	n/a
userCertification	esa_sponsor_email_a	yes	Text	120	n/a	n/a
userCertification	peer_review	yes	Text	10	n/a	n/a
userCertification	additional_statements	yes	Memo	0	n/a	n/a
userDataset	userDataset_ID	no	Long Integer	4	PK	n/a
userDataset	user_ID	yes	Long Integer	4	FK	user.user_ID
userDataset	datasetStart	yes	Date/Time	8	n/a	n/a
userDataset	datasetStop	yes	Date/Time	8	n/a	n/a
userDataset	AccessionCode	yes	Text	100	n/a	n/a		each dataset has an accession code to allow links to groups of plots (since URLs are limited in length)
userDataset	datasetName	yes	Text	100	n/a	n/a
userDataset	datasetDescription	yes	Memo	0	n/a	n/a
userDataset	datasetType	yes	Text	50	n/a	n/a	open	don't know what values might be here, but category seems useful
userDataset	datasetSharing	yes	Text	30	n/a	n/a	yes	public, private, password
userDataset	datasetPassword	yes	Text	50	n/a	n/a
userNotify	userNotify_ID	no	Long Integer	4	PK	n/a
userNotify	user_ID	yes	Long Integer	4	FK	user.user_ID
userNotify	notifyName	yes	Text	100	n/a	n/a
userNotify	notifyDescription	yes	Memo	0	n/a	n/a
userNotify	notifyStart	yes	Date/Time	8	n/a	n/a
userNotify	notifyStop	yes	Date/Time	8	n/a	n/a
userNotify	lastCheckDate	yes	Date/Time	8	n/a	n/a		date that user was last notified- only notify of information after this date
userNotify	notifySQL	yes	Memo	0	n/a	n/a		SQL to get information that user wants
userPermission	userPermission_ID	no	Long Integer	4	PK	n/a
userPermission	embargo_ID	yes	Long Integer	4	FK	embargo.embargo_ID
userPermission	user_ID	yes	Long Integer	4	FK	user.user_ID
userPermission	permissionStart	yes	Date/Time	8	n/a	n/a
userPermission	permissionStop	yes	Date/Time	8	n/a	n/a
userPermission	permissionStatus	yes	Long Integer	4	n/a	n/a	yes	0-6, according to confidStatus values
userPermission	permissionNotes	yes	Memo	0	n/a	n/a
userQuery	userQuery_ID	no	Long Integer	4	PK	n/a
userQuery	user_ID	yes	Long Integer	4	FK	user.user_ID
userQuery	queryStart	yes	Date/Time	8	n/a	n/a
userQuery	queryStop	yes	Date/Time	8	n/a	n/a
userQuery	accessionCode	yes	Text	100	n/a	n/a
userQuery	queryName	yes	Text	100	n/a	n/a
userQuery	queryDescription	yes	Memo	0	n/a	n/a
userQuery	querySQL	yes	Memo	0	n/a	n/a
userQuery	queryType	yes	Text	50	n/a	n/a	yes	seems useful, but I don't know what values
userQuery	querySharing	yes	Text	30	n/a	n/a
userQuery	queryPassword	yes	Text	50	n/a	n/a