Columns

Columns

AllTablesViewsComments

Search:

Table	Type	Column	Type	Size	Nullable	Auto	Default	Comments
user_map	Table	abstract	text	2147483647	√		null
sp_organization	Table	address	text	2147483647	√		null
sp_person	Table	address	text	2147483647	√		null
sp_papers	Table	author_list	text	2147483647	√		null
bac_status	Table	bac_id	int8	19	√		null
bac_status_log	Table	bac_id	int8	19	√		null
bac_status	Table	bac_status_id	bigserial	19		√	nextval('sgn_people.bac_status_bac_status_id_seq'::regclass)
bac_status_log	Table	bac_status_log_id	bigserial	19		√	nextval('sgn_people.bac_status_log_bac_status_log_id_seq'::regclass)
sp_person	Table	censor	int8	19	√		0
clone_il_mapping_bin_log	Table	chromosome	int4	10	√		null
clone_validation_log	Table	clone_id	int4	10	√		null
clone_verification_log	Table	clone_id	int4	10	√		null
clone_il_mapping_bin_log	Table	clone_id	int4	10	√		null
sp_clone_il_mapping_segment_log	Table	clone_id	int4	10	√		null
sp_project_il_mapping_clone_log	Table	clone_id	int4	10	√		null
clone_validation_log	Table	clone_validation_log_id	serial	10		√	nextval('sgn_people.clone_validation_log_clone_validation_log_id_seq'::regclass)
clone_verification_log	Table	clone_verification_log_id	serial	10		√	nextval('sgn_people.clone_verification_log_clone_verification_log_id_seq'::regclass)
sp_order	Table	comments	text	2147483647	√		null
sp_order	Table	completion_date	varchar	100	√		null
user_map_data	Table	confidence	varchar	20	√		null
sp_login_old	Table	confirm_code	varchar	20	√		null
sp_person	Table	confirm_code	varchar	20	√		null
sp_person	Table	contact_email	varchar	255	√		null
sp_organization	Table	contact_email	varchar	255	√		null
sp_person	Table	contact_update	date	13	√		null
list_item	Table	content	text	2147483647	√		null
sp_person	Table	cookie_string	text	2147483647	√		null
sp_token	Table	cookie_string	text	2147483647	√		null
sp_person	Table	country	varchar	255	√		null
sp_organization	Table	country	varchar	255	√		null
user_map_data	Table	create_date	timestamptz	35	√		null
user_map	Table	create_date	timestamptz	35	√		null
sp_order	Table	create_date	varchar	100	√		null
list	Table	create_date	timestamp	29	√		now()
clone_validation_log	Table	created	timestamp	29	√		now()
sp_clone_il_mapping_segment_log	Table	created	timestamp	29	√		now()
sp_project_il_mapping_clone_log	Table	created	timestamp	29	√		now()
clone_il_mapping_bin_log	Table	created	timestamp	29	√		now()
clone_verification_log	Table	created	timestamp	29	√		now()
sp_dataset	Table	dataset	jsonb	2147483647	√		null
list_dbxref	Table	dbxref_id	int4	10			null
sp_organization	Table	department	varchar	255	√		null
list	Table	description	text	2147483647	√		null
sp_project	Table	description	text	2147483647	√		null
sp_group	Table	description	text	2147483647	√		null
sp_dataset	Table	description	text	2147483647	√		null
sp_organization	Table	description	text	2147483647	√		null
sp_person	Table	developer_settings	varchar	4096	√		null
sp_login_old	Table	disabled	int8	19	√		null
sp_person	Table	disabled	varchar	20	√		null

Showing 1 to 50 of 221 entries

• Previous
• 1
• 2
• 3
• 4
• 5
• Next