srdb.srdb contains 161 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
recorder	address	varchar	1000	√		null
risfieldvalues	allowedvaluelong	varchar	200	√		null
risfieldvalues	allowedvalueshort	varchar	10	√		null
area	alternateareaname	varchar	50	√		null
reference_point_units_view	area	varchar	100	√		null
reference_point_values_view	area	varchar	100	√		null
area	areacode	varchar	50	√		null
stock	areaid	varchar	70	√		null
area	areaname	varchar	100	√		null
area	areatype	varchar	40	√		null
assessment	assess	int4	10	√		null
assessment	assesscomments	varchar	1000	√		null
bioparams	assessid	varchar	200	√		null
brptots	assessid	varchar	200	√		null
mostrecent	assessid	varchar	200	√		null
reference_point_units_view	assessid	varchar	200	√		null
reference_point_values_view	assessid	varchar	200	√		null
referencedoc	assessid	varchar	200	√		null
timeseries	assessid	varchar	200	√		null
timeseries_units_view	assessid	varchar	200	√		null
timeseries_values_view	assessid	varchar	200	√		null
tsrelative_explicit_view	assessid	varchar	200	√		null
assessment	assessmethod	varchar	200	√		null
assessor	assessorfull	varchar	200	√		null
assessment	assessorid	varchar	40	√		null
assessment	assesssource	varchar	1000	√		null
assessment	assessyear	varchar	9	√		null
bioparams	bioid	varchar	40	√		null
brptots	bioid	varchar	70	√		null
tsrelative_explicit_view	bioid	varchar	40	√		null
biometrics	biolong	varchar	300	√		null
bioparams	bionotes	varchar	1000	√		null
biometrics	bioshort	varchar	40	√		null
biometrics	biounitslong	varchar	200	√		null
biometrics	biounitsshort	varchar	40	√		null
bioparams	biovalue	varchar	200	√		null
tsrelative_explicit_view	biovalue	varchar	200	√		null
bioparams	bioyear	varchar	15	√		null
reference_point_values_view	blim	text	2147483647	√		null
reference_point_units_view	blim_unit	text	2147483647	√		null
reference_point_values_view	bmsy	text	2147483647	√		null
reference_point_units_view	bmsy_unit	text	2147483647	√		null
timeseries_values_view	catch_landings	float8	17,17	√		null
timeseries_units_view	catch_landings_unit	text	2147483647	√		null
assessmethod	category	varchar	100	√		null
biometrics	category	varchar	100	√		null
taxonomy	classname	varchar	200	√		null
reference_point_units_view	common	varchar	200	√		null
reference_point_values_view	common	varchar	200	√		null
fishbasesaupcodes	commonname	varchar	100	√		null
stock	commonname	varchar	200	√		null
taxonomy	commonname1	varchar	200	√		null
taxonomy	commonname2	varchar	200	√		null
assessment	contacts	varchar	300	√		null
timeseries_units_view	count	int8	19	√		null
area	country	varchar	50	√		null
assessor	country	varchar	50	√		null
management	country	varchar	50	√		null
timeseries_values_view	cpue	float8	17,17	√		null
timeseries_units_view	cpue_unit	text	2147483647	√		null
assessment	dateloaded	date	13	√		null
assessment	daterecorded	date	13	√		null
recorder	email	varchar	50	√		null
timeseries_values_view	f	float8	17,17	√		null
timeseries_units_view	f_unit	text	2147483647	√		null
taxonomy	family	varchar	200	√		null
recorder	firstname	varchar	50	√		null
reference_point_values_view	flim	text	2147483647	√		null
reference_point_units_view	flim_unit	text	2147483647	√		null
reference_point_values_view	fmsy	text	2147483647	√		null
reference_point_units_view	fmsy_unit	text	2147483647	√		null
taxonomy	genus	varchar	200	√		null
stock	inmyersdb	int4	10	√		null
recorder	institution	varchar	100	√		null
mostrecent	isduplicate	int4	10	√		null
mostrecent	ismostrecent	int4	10	√		null
taxonomy	kingdom	varchar	200	√		null
recorder	lastname	varchar	50	√		null
lmerefs	lme_name	varchar	70	√		null
lmetostocks	lme_number	int4	10	√		null
management	managementauthority	varchar	200	√		null
assessmethod	methodlong	varchar	200	√		null
assessor	mgmt	varchar	40	√		null
assessment	mostrecent	varchar	3	√		null
taxonomy	myersfamily	varchar	50	√		null
taxonomy	myersname	varchar	20	√		null
taxonomy	myersscientificname	varchar	200	√		null
stock	myersstockid	varchar	40	√		null
assessment	notes	varchar	1000	√		null
recorder	notes	varchar	1000	√		null
taxonomy	ordername	varchar	200	√		null
assessment	pdffile	varchar	300	√		null
recorder	phonenumber	varchar	50	√		null
taxonomy	phylum	varchar	200	√		null
reference_point_units_view	points_available	int8	19	√		null
reference_point_values_view	points_available	int8	19	√		null
timeseries_values_view	pt_avail	int8	19	√		null
timeseries_values_view	r	float8	17,17	√		null
timeseries_units_view	r_unit	text	2147483647	√		null
assessment	recorder	varchar	40	√		null
assessment	refpoints	int4	10	√		null
risfields	risdescription	varchar	200	√		null
referencedoc	risentry	varchar	300	√		null
referencedoc	risfield	varchar	50	√		null
risfieldvalues	risfield	varchar	50	√		null
fishbasesaupcodes	scientificname	varchar	200	√		null
stock	scientificname	varchar	200	√		null
taxonomy	scientificname	varchar	200	√		null
taxonomy	species	varchar	200	√		null
fishbasesaupcodes	specode	int4	10	√		null
timeseries_values_view	ssb	float8	17,17	√		null
timeseries_units_view	ssb_unit	text	2147483647	√		null
reference_point_values_view	ssblim	text	2147483647	√		null
reference_point_units_view	ssblim_unit	text	2147483647	√		null
reference_point_values_view	ssbmsy	text	2147483647	√		null
reference_point_units_view	ssbmsy_unit	text	2147483647	√		null
reference_point_values_view	ssbpa	text	2147483647	√		null
reference_point_units_view	ssbpa_unit	text	2147483647	√		null
reference_point_values_view	ssbtarget	text	2147483647	√		null
reference_point_units_view	ssbtarget_unit	text	2147483647	√		null
assessment	stockid	varchar	40	√		null
lmetostocks	stockid	varchar	40	√		null
mostrecent	stockid	varchar	40	√		null
stock	stocklong	varchar	200	√		null
lmetostocks	stocktolmerelation	varchar	10	√		null
biometrics	subcategory	varchar	100	√		null
fishbasesaupcodes	taxonkey	int4	10	√		null
fishbasesaupcodes	taxonnom_taxonname	varchar	200	√		null
timeseries_values_view	total	float8	17,17	√		null
timeseries_units_view	total_unit	text	2147483647	√		null
tsmetrics	tscategory	varchar	200	√		null
brptots	tsid	varchar	40	√		null
timeseries	tsid	varchar	40	√		null
tsrelative_explicit_view	tsid	varchar	40	√		null
tsmetrics	tslong	varchar	200	√		null
stock	tsn	int4	10	√		null
tsmetrics	tsshort	varchar	40	√		null
tsrelative_explicit_view	tstobrpratio	float8	17,17	√		null
tsmetrics	tsunitslong	varchar	300	√		null
tsmetrics	tsunitsshort	varchar	40	√		null
timeseries	tsvalue	float8	17,17	√		null
tsrelative_explicit_view	tsvalue	float8	17,17	√		null
timeseries	tsyear	int4	10	√		null
timeseries_values_view	tsyear	int4	10	√		null
tsrelative_explicit_view	tsyear	int4	10	√		null
reference_point_values_view	umsy	text	2147483647	√		null
reference_point_units_view	umsy_unit	text	2147483647	√		null
assessment	xlsfilename	varchar	100	√		null
area	areaid	varchar	70
assessment	assessid	varchar	200
assessor	assessorid	varchar	40
biometrics	biounique	varchar	70
brptots	brptotsunique	varchar	300
lmerefs	lme_number	int4	10
assessmethod	methodshort	varchar	20
management	mgmt	varchar	40
recorder	nameinxls	varchar	50
risfields	risfield	varchar	50
stock	stockid	varchar	40
taxonomy	tsn	int4	10
tsmetrics	tsunique	varchar	70