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

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