istsos.demo contains 73 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default
offerings	active_off	bool	1			true
procedures	assignedid_prc	varchar	32
tran_log	begin_trl	timestamptz	35,6	√		null
observed_properties	constr_opr	varchar	2147483647	√		null
proc_obs	constr_pro	varchar	2147483647	√		null
tran_log	count	int4	10	√		null
cron_log	datetime_clo	timestamptz	35,6
observed_properties	def_opr	varchar	80
foi	desc_foi	text	2147483647	√		null
offerings	desc_off	text	2147483647	√		null
observed_properties	desc_opr	text	2147483647	√		null
obs_type	desc_oty	varchar	120	√		null
procedures	desc_prc	text	2147483647	√		null
quality_index	desc_qi	text	2147483647	√		null
uoms	desc_uom	text	2147483647	√		null
cron_log	details_clo	varchar	2147483647	√		null
cron_log	element_clo	varchar	2147483647
tran_log	end_trl	timestamptz	35,6	√		null
procedures	etime_prc	timestamptz	35,6	√		null
tran_log	etime_prc	timestamptz	35,6	√		null
offerings	expiration_off	timestamptz	35,6	√		null
foi	geom_foi	geometry	2147483647	√		null
positions	geom_pos	geometry	2147483647	√		null
cron_log	id_clo	serial	10		√	nextval('demo.cron_log_id_clo_seq'::regclass)
event_time	id_eti	bigserial	19		√	nextval('demo.event_time_id_eti_seq'::regclass)
measures	id_eti_fk	int8	19
positions	id_eti_fk	int8	19
foi	id_foi	serial	10		√	nextval('demo.foi_id_foi_seq'::regclass)
procedures	id_foi_fk	int4	10	√		null
feature_type	id_fty	serial	10		√	nextval('demo.feature_type_id_fty_seq'::regclass)
foi	id_fty_fk	int4	10
measures	id_msr	bigserial	19		√	nextval('demo.measures_id_msr_seq'::regclass)
offerings	id_off	serial	10		√	nextval('demo.offerings_id_off_seq'::regclass)
off_proc	id_off_fk	int4	10
off_proc	id_off_prc	serial	10		√	nextval('demo.off_proc_id_opr_seq'::regclass)
observed_properties	id_opr	serial	10		√	nextval('demo.obs_pr_id_opr_seq'::regclass)
proc_obs	id_opr_fk	int4	10
obs_type	id_oty	serial	10		√	nextval('demo.obs_type_id_oty_seq'::regclass)
procedures	id_oty_fk	int4	10	√		null
positions	id_pos	bigserial	19		√	nextval('demo.measures_mobile_id_mmo_seq'::regclass)
procedures	id_prc	serial	10		√	nextval('demo.procedures_id_prc_seq'::regclass)
cron_log	id_prc_fk	int4	10
event_time	id_prc_fk	int4	10
off_proc	id_prc_fk	int4	10
proc_obs	id_prc_fk	int4	10
proc_obs	id_pro	serial	10		√	nextval('demo.prc_obs_id_pro_seq'::regclass)
measures	id_pro_fk	int4	10
quality_index	id_qi	int4	10
measures	id_qi_fk	int4	10
positions	id_qi_fk	int4	10
tran_log	id_trl	serial	10		√	nextval('demo.tran_log_id_trl_seq'::regclass)
uoms	id_uom	serial	10		√	nextval('demo.uoms_id_uom_seq'::regclass)
proc_obs	id_uom_fk	int4	10
cron_log	message_clo	varchar	2147483647
foi	name_foi	varchar	25
feature_type	name_fty	varchar	25
offerings	name_off	varchar	64
observed_properties	name_opr	varchar	60
obs_type	name_oty	varchar	60
procedures	name_prc	varchar	30
quality_index	name_qi	varchar	25
uoms	name_uom	varchar	20
tran_log	operation_trl	varchar	2147483647
tran_log	procedure_trl	varchar	30
cron_log	process_clo	varchar	2147483647
cron_log	status_clo	status	2147483647	√		null
procedures	stime_prc	timestamptz	35,6	√		null
tran_log	stime_prc	timestamptz	35,6	√		null
procedures	time_acq_prc	int4	10	√		null
event_time	time_eti	timestamptz	35,6
procedures	time_res_prc	int4	10	√		null
tran_log	transaction_time_trl	timestamp	29,6	√		now()
measures	val_msr	numeric	10,6