clean.public contains 861 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
permission	access_parameters	varchar	1000	√		null
permission	access_url	varchar	1000	√		null
user_account	account_non_locked	bool	1			true
audit_event	action_message	varchar	4000	√		null
rule_action	action_type	int4	10
rule_action_run_log	action_type	int4	10	√		null
user_account	active_study	int4	10	√		null
rule_action_run	administrative_data_entry	bool	1	√		null
dn_age_days	age	int4	10	√		null
study	age_max	varchar	3	√		null
study	age_min	varchar	3	√		null
study	allocation	varchar	64	√		null
event_crf	annotations	varchar	4000	√		null
dataset	approver_id	int4	10	√		null
archived_dataset_file	archived_dataset_file_id	serial	10		√	nextval('archived_dataset_file_archived_dataset_file_id_seq'::regclass)
discrepancy_note	assigned_user_id	int4	10	√		null
study	assignment	varchar	30	√		null
audit_event	audit_date	timestamptz	35,6
audit_log_event	audit_date	timestamptz	35,6
audit_event	audit_id	serial	10		√	nextval('audit_event_audit_id_seq'::regclass)
audit_event_context	audit_id	int4	10	√		null
audit_event_values	audit_id	int4	10	√		null
audit_log_event	audit_id	serial	10		√	nextval('audit_log_event_audit_id_seq'::regclass)
audit_log_event	audit_log_event_type_id	int4	10	√		null
audit_log_event_type	audit_log_event_type_id	serial	10		√	nextval('audit_log_event_type_audit_log_event_type_id_seq'::regclass)
audit_event	audit_table	varchar	500
audit_log_event	audit_table	varchar	500
databasechangelog	author	varchar	63
authorities	authority	varchar	50
rule_action_run	batch	bool	1	√		null
oc_qrtz_blob_triggers	blob_data	bytea	2147483647	√		null
dc_send_email_event	body	varchar	4000	√		null
item_group_metadata	borders	int4	10	√		null
section	borders	int4	10	√		null
openclinica_version	build_number	varchar	1000	√		null
oc_qrtz_calendars	calendar	bytea	2147483647
oc_qrtz_calendars	calendar_name	varchar	200
oc_qrtz_triggers	calendar_name	varchar	200	√		null
study_event_definition	category	varchar	2000	√		null
oc_qrtz_scheduler_state	checkin_interval	int8	19
item_data_type	code	varchar	20	√		null
null_value_type	code	varchar	20	√		null
thesaurus	code	varchar	500	√		null
thesaurus	code_details	varchar	2000	√		null
rule_action_property	codelist_oid	varchar	500	√		null
item_data	coding_status_id	int4	10	√		11
study	collaborators	varchar	1000	√		null
audit_event_values	column_name	varchar	255	√		null
dn_event_crf_map	column_name	varchar	255	√		null
dn_item_data_map	column_name	varchar	255	√		null
dn_study_event_map	column_name	varchar	255	√		null
dn_study_subject_map	column_name	varchar	255	√		null
dn_subject_map	column_name	varchar	255	√		null
item_form_metadata	column_number	int4	10	√		null
databasechangelog	comments	varchar	255	√		null
decision_condition	comments	varchar	3000
dc_primitive	comparison	varchar	3
completion_status	completion_status_id	serial	10		√	nextval('completion_status_completion_status_id_seq'::regclass)
event_crf	completion_status_id	int4	10	√		null
study	conditions	varchar	500	√		null
dc_primitive	constant_value	varchar	4000	√		null
rule_expression	context	int4	10
study	control	varchar	30	√		null
scd_item_metadata	control_item_form_metadata_id	int4	10	√		null
scd_item_metadata	control_item_name	varchar	255	√		null
study_module_status	crf	int4	10	√		1
audit_event_context	crf_id	int4	10	√		null
crf	crf_id	serial	10		√	nextval('crf_crf_id_seq'::regclass)
crf_version	crf_id	int4	10
event_definition_crf	crf_id	int4	10	√		null
item_group	crf_id	int4	10
rule_set	crf_id	int4	10	√		null
audit_event_context	crf_version_id	int4	10	√		null
crf_version	crf_version_id	serial	10		√	nextval('crf_version_crf_version_id_seq'::regclass)
decision_condition	crf_version_id	int4	10	√		null
dyn_item_form_metadata	crf_version_id	int4	10	√		null
event_crf	crf_version_id	int4	10	√		null
filter_crf_version_map	crf_version_id	int4	10	√		null
item_form_metadata	crf_version_id	int4	10	√		null
item_group_metadata	crf_version_id	int4	10
rule_set	crf_version_id	int4	10	√		null
section	crf_version_id	int4	10
versioning_map	crf_version_id	int4	10	√		null
oc_qrtz_cron_triggers	cron_expression	varchar	120
coding_dictionary	data_type_id	int4	10	√		null
archived_dataset_file	dataset_id	int4	10	√		null
dataset	dataset_id	serial	10		√	nextval('dataset_dataset_id_seq'::regclass)
dataset_crf_version_map	dataset_id	int4	10	√		null
dataset_filter_map	dataset_id	int4	10	√		null
dataset_study_group_class_map	dataset_id	int4	10
dataset	dataset_item_status_id	int4	10	√		null
dataset_item_status	dataset_item_status_id	serial	10		√	nextval('dataset_item_status_dataset_item_status_id_seq'::regclass)
event_crf	date_completed	timestamptz	35,6	√		null
archived_dataset_file	date_created	timestamp	29,6	√		null
crf	date_created	date	13	√		null
crf_version	date_created	date	13	√		null
dataset	date_created	date	13	√		null
decision_condition	date_created	date	13	√		null
discrepancy_note	date_created	date	13	√		null
event_crf	date_created	date	13	√		null
event_definition_crf	date_created	date	13	√		null
filter	date_created	date	13	√		null
item	date_created	date	13	√		null
item_data	date_created	date	13	√		null
item_group	date_created	date	13	√		null
role	date_created	date	13	√		'2012-02-01'::date
rule	date_created	date	13	√		null
rule_action	date_created	date	13	√		null
rule_expression	date_created	date	13	√		null
rule_set	date_created	date	13	√		null
rule_set_rule	date_created	date	13	√		null
section	date_created	date	13	√		null
study	date_created	date	13	√		null
study_event	date_created	date	13	√		null
study_event_definition	date_created	date	13	√		null
study_group_class	date_created	date	13	√		null
study_module_status	date_created	date	13	√		null
study_subject	date_created	date	13	√		null
study_user_role	date_created	date	13	√		null
subject	date_created	date	13	√		null
subject_group_map	date_created	date	13	√		null
user_account	date_created	date	13	√		null
user_role_access	date_created	date	13	√		'2012-02-01'::date
dataset	date_end	date	13	√		null
study_event	date_end	timestamptz	35,6	√		null
event_crf	date_interviewed	date	13	√		null
dataset	date_last_run	date	13	√		null
user_account	date_lastvisit	timestamptz	35,6	√		null
subject	date_of_birth	date	13	√		null
study	date_planned_end	date	13	√		null
study	date_planned_start	date	13	√		null
dataset	date_start	date	13	√		null
study_event	date_start	timestamptz	35,6	√		null
crf	date_updated	date	13	√		null
crf_version	date_updated	date	13	√		null
dataset	date_updated	date	13	√		null
decision_condition	date_updated	date	13	√		null
event_crf	date_updated	date	13	√		null
event_definition_crf	date_updated	date	13	√		null
filter	date_updated	date	13	√		null
item	date_updated	date	13	√		null
item_data	date_updated	date	13	√		null
item_group	date_updated	date	13	√		null
role	date_updated	date	13	√		'2012-02-01'::date
rule	date_updated	date	13	√		null
rule_action	date_updated	date	13	√		null
rule_expression	date_updated	date	13	√		null
rule_set	date_updated	date	13	√		null
rule_set_audit	date_updated	date	13	√		null
rule_set_rule	date_updated	date	13	√		null
rule_set_rule_audit	date_updated	date	13	√		null
section	date_updated	date	13	√		null
study	date_updated	date	13	√		null
study_event	date_updated	date	13	√		null
study_event_definition	date_updated	date	13	√		null
study_group_class	date_updated	date	13	√		null
study_module_status	date_updated	date	13	√		null
study_subject	date_updated	date	13	√		null
study_user_role	date_updated	date	13	√		null
subject	date_updated	date	13	√		null
subject_group_map	date_updated	date	13	√		null
thesaurus	date_updated	timestamptz	35,6	√		null
user_account	date_updated	date	13	√		null
user_role_access	date_updated	date	13	√		null
event_crf	date_validate	date	13	√		null
event_crf	date_validate_completed	timestamptz	35,6	√		null
databasechangelog	dateexecuted	timestamptz	35,6
dn_age_days	days	int4	10	√		null
dc_computed_event	dc_event_id	int4	10
dc_event	dc_event_id	serial	10		√	nextval('dc_event_dc_event_id_seq'::regclass)
dc_section_event	dc_event_id	serial	10		√	nextval('dc_section_event_dc_event_id_seq'::regclass)
dc_send_email_event	dc_event_id	serial	10		√	nextval('dc_send_email_event_dc_event_id_seq'::regclass)
dc_substitution_event	dc_event_id	serial	10		√	nextval('dc_substitution_event_dc_event_id_seq'::regclass)
dc_primitive	dc_primitive_id	serial	10		√	nextval('dc_primitive_dc_primitive_id_seq'::regclass)
dc_computed_event	dc_summary_event_id	serial	10		√	nextval('dc_computed_event_dc_summary_event_id_seq'::regclass)
dc_summary_item_map	dc_summary_event_id	int4	10	√		null
dc_event	decision_condition_id	int4	10	√		null
dc_primitive	decision_condition_id	int4	10	√		null
decision_condition	decision_condition_id	serial	10		√	nextval('decision_condition_decision_condition_id_seq'::regclass)
item_form_metadata	decision_condition_id	int4	10	√		null
event_definition_crf	decision_conditions	bool	1	√		null
item_form_metadata	default_value	varchar	4000	√		null
study_parameter	default_value	varchar	50	√		null
event_definition_crf	default_version_id	int4	10	√		null
item_data_type	definition	varchar	1000	√		null
null_value_type	definition	varchar	1000	√		null
coding_dictionary	description	varchar	500	√		null
completion_status	description	varchar	1000	√		null
configuration	description	varchar	512	√		null
crf	description	varchar	2048	√		null
crf_version	description	varchar	4000	√		null
databasechangelog	description	varchar	255	√		null
dataset	description	varchar	2000	√		null
dataset_item_status	description	varchar	255	√		null
discrepancy_note	description	varchar	255	√		null
discrepancy_note_type	description	varchar	255	√		null
entity_type	description	varchar	500	√		null
export_format	description	varchar	1000	√		null
filter	description	varchar	2000	√		null
group_class_types	description	varchar	1000	√		null
item	description	varchar	4000	√		null
item_reference_type	description	varchar	1000	√		null
measurement_unit	description	varchar	255	√		null
oc_qrtz_job_details	description	varchar	250	√		null
oc_qrtz_triggers	description	varchar	250	√		null
resolution_status	description	varchar	255	√		null
response_type	description	varchar	1000	√		null
rule	description	varchar	255	√		null
status	description	varchar	1000	√		null
study_event_definition	description	varchar	2000	√		null
study_group	description	varchar	1000	√		null
study_parameter	description	varchar	255	√		null
study_type	description	varchar	1000	√		null
subject_event_status	description	varchar	1000	√		null
discrepancy_note	detailed_notes	varchar	1000	√		null
thesaurus	dictionary_id	int4	10	√		null
coding_dictionary	dictionary_version	varchar	300	√		null
discrepancy_note	discrepancy_note_id	serial	10		√	nextval('discrepancy_note_discrepancy_note_id_seq'::regclass)
dn_age_days	discrepancy_note_id	int4	10	√		null
dn_event_crf_map	discrepancy_note_id	int4	10	√		null
dn_item_data_map	discrepancy_note_id	int4	10	√		null
dn_study_event_map	discrepancy_note_id	int4	10	√		null
dn_study_subject_map	discrepancy_note_id	int4	10	√		null
dn_subject_map	discrepancy_note_id	int4	10	√		null
discrepancy_note	discrepancy_note_type_id	int4	10	√		null
discrepancy_note_type	discrepancy_note_type_id	serial	10		√	nextval('discrepancy_note_type_discrepancy_note_type_id_seq'::regclass)
subject	dob_collected	bool	1	√		null
rule_action_run	double_data_entry	bool	1	√		null
event_definition_crf	double_entry	bool	1	√		null
study	duration	varchar	30	√		null
dc_primitive	dynamic_value_item_id	int4	10	√		null
event_definition_crf	electronic_signature	bool	1	√		false
event_crf	electronic_signature_status	bool	1	√		false
study	eligibility	varchar	500	√		null
user_account	email	varchar	120	√		null
rule_action	email_to	varchar	255	√		null
rule	enabled	bool	1	√		null
user_account	enabled	bool	1			true
oc_qrtz_triggers	end_time	int8	19	√		null
study_event	end_time_flag	bool	1	√		null
study	endpoint	varchar	64	√		null
study_subject	enrollment_date	date	13	√		null
audit_event	entity_id	int4	10	√		null
audit_log_event	entity_id	int4	10	√		null
audit_log_event	entity_name	varchar	500	√		null
discrepancy_note	entity_type	varchar	30	√		null
oc_qrtz_fired_triggers	entry_id	varchar	95
audit_event_context	event_crf_id	int4	10	√		null
audit_log_event	event_crf_id	int4	10	√		null
dn_event_crf_map	event_crf_id	int4	10	√		null
dyn_item_form_metadata	event_crf_id	int4	10	√		null
dyn_item_group_metadata	event_crf_id	int4	10	√		null
event_crf	event_crf_id	serial	10		√	nextval('event_crf_event_crf_id_seq'::regclass)
item_data	event_crf_id	int4	10	√		null
audit_log_event	event_crf_version_id	int4	10	√		null
study_module_status	event_definition	int4	10	√		1
dataset_crf_version_map	event_definition_crf_id	int4	10	√		null
event_definition_crf	event_definition_crf_id	serial	10		√	nextval('event_definition_crf_event_definition_crf_id_seq'::regclass)
study	expected_total_enrollment	int4	10	√		null
archived_dataset_file	export_format_id	int4	10	√		null
export_format	export_format_id	serial	10		√	nextval('export_format_export_format_id_seq'::regclass)
rule_action	expression_evaluates_to	bool	1
study	facility_city	varchar	255	√		null
study	facility_contact_degree	varchar	255	√		null
study	facility_contact_email	varchar	255	√		null
study	facility_contact_name	varchar	255	√		null
study	facility_contact_phone	varchar	255	√		null
study	facility_country	varchar	64	√		null
study	facility_name	varchar	255	√		null
study	facility_recruitment_status	varchar	60	√		null
study	facility_state	varchar	20	√		null
study	facility_zip	varchar	64	√		null
subject	father_id	int4	10	√		null
archived_dataset_file	file_reference	varchar	1000	√		null
archived_dataset_file	file_size	int4	10	√		null
databasechangelog	filename	varchar	200
dataset_filter_map	filter_id	int4	10	√		null
filter	filter_id	serial	10		√	nextval('filter_filter_id_seq'::regclass)
filter_crf_version_map	filter_id	int4	10	√		null
oc_qrtz_fired_triggers	fired_time	int8	19
user_account	first_name	varchar	50	√		null
study	gender	varchar	30	√		null
subject	gender	bpchar	1	√		null
group_class_types	group_class_type_id	serial	10		√	nextval('group_class_types_group_class_type_id_seq'::regclass)
study_group_class	group_class_type_id	int4	10	√		null
user_role_access	group_id	int4	10	√		null
group_auth_definition	group_type	varchar	1000	√		null
group_auth_definition	grp_parent_id	int4	10	√		null
study_parameter	handle	varchar	50	√		null
item_form_metadata	header	varchar	2000	√		null
item_group_metadata	header	varchar	255	√		null
study	healthy_volunteer_accepted	bool	1	√		null
event_definition_crf	hide_crf	bool	1	√		false
audit_user_login	id	serial	10		√	nextval('audit_user_login_id_seq'::regclass)
authorities	id	serial	10		√	nextval('authorities_id_seq'::regclass)
coding_dictionary	id	serial	10		√	nextval('coding_dictionary_id_seq'::regclass)
configuration	id	serial	10		√	nextval('configuration_id_seq'::regclass)
databasechangelog	id	varchar	63
databasechangeloglock	id	int4	10
dyn_item_form_metadata	id	serial	10		√	nextval('dyn_item_form_metadata_id_seq'::regclass)
dyn_item_group_metadata	id	serial	10		√	nextval('dyn_item_group_metadata_id_seq'::regclass)
entity_type	id	int4	10
group_auth_definition	id	serial	10		√	nextval('group_auth_definition_id_seq'::regclass)
locale_based_description	id	serial	10		√	nextval('locale_based_description_id_seq'::regclass)
measurement_unit	id	serial	10		√	nextval('measurement_unit_id_seq'::regclass)
openclinica_version	id	serial	10		√	nextval('openclinica_version_id_seq'::regclass)
permission	id	serial	10		√	nextval('permission_id_seq'::regclass)
role	id	serial	10		√	nextval('role_id_seq'::regclass)
role_permission	id	serial	10		√	nextval('role_permission_id_seq'::regclass)
rule	id	serial	10		√	nextval('rule_id_seq'::regclass)
rule_action	id	serial	10		√	nextval('rule_action_id_seq'::regclass)
rule_action_property	id	serial	10		√	nextval('rule_action_property_id_seq'::regclass)
rule_action_run	id	serial	10		√	nextval('rule_action_run_id_seq'::regclass)
rule_action_run_log	id	serial	10		√	nextval('rule_action_run_log_id_seq'::regclass)
rule_expression	id	serial	10		√	nextval('rule_expression_id_seq'::regclass)
rule_set	id	serial	10		√	nextval('rule_set_id_seq'::regclass)
rule_set_audit	id	serial	10		√	nextval('rule_set_audit_id_seq'::regclass)
rule_set_rule	id	serial	10		√	nextval('rule_set_rule_id_seq'::regclass)
rule_set_rule_audit	id	serial	10		√	nextval('rule_set_rule_audit_id_seq'::regclass)
scd_item_metadata	id	serial	10		√	nextval('scd_item_metadata_id_seq'::regclass)
study_module_status	id	serial	10		√	nextval('study_module_status_id_seq'::regclass)
thesaurus	id	serial	10		√	nextval('thesaurus_id_seq'::regclass)
usage_statistics_data	id	serial	10		√	nextval('usage_statistics_data_id_seq'::regclass)
user_role_access	id	serial	10		√	nextval('user_role_access_id_seq'::regclass)
rule_action_run	import_data_entry	bool	1	√		null
study_parameter	inheritable	bool	1	√		true
rule_action_run	initial_data_entry	bool	1	√		null
oc_qrtz_fired_triggers	instance_name	varchar	200
oc_qrtz_scheduler_state	instance_name	varchar	200
user_account	institutional_affiliation	varchar	255	√		null
section	instructions	varchar	2000	√		null
study	interventions	varchar	1000	√		null
event_crf	interviewer_name	varchar	255	√		null
permission	is_admin	bool	1	√		false
oc_qrtz_job_details	is_durable	bool	1
role	is_locked	bool	1			false
oc_qrtz_fired_triggers	is_stateful	bool	1	√		null
oc_qrtz_job_details	is_stateful	bool	1
role	is_used_with_auth_group_allstudies	bool	1	√		false
role	is_used_with_auth_group_crf	bool	1	√		false
role	is_used_with_auth_group_eventcrf	bool	1	√		false
role	is_used_with_auth_group_site	bool	1	√		false
role	is_used_with_auth_group_study	bool	1	√		false
oc_qrtz_fired_triggers	is_volatile	bool	1
oc_qrtz_job_details	is_volatile	bool	1
oc_qrtz_triggers	is_volatile	bool	1
dn_item_data_map	item_data_id	int4	10	√		null
dyn_item_form_metadata	item_data_id	int4	10	√		null
item_data	item_data_id	serial	10		√	nextval('item_data_item_data_id_seq'::regclass)
rule_action_run_log	item_data_id	int4	10	√		null
item	item_data_type_id	int4	10	√		null
item_data_type	item_data_type_id	serial	10		√	nextval('item_data_type_item_data_type_id_seq'::regclass)
dyn_item_form_metadata	item_form_metadata_id	int4	10	√		null
item_form_metadata	item_form_metadata_id	serial	10		√	nextval('item_form_metadata_item_form_metadata_id_seq'::regclass)
dyn_item_group_metadata	item_group_id	int4	10	√		null
item_group	item_group_id	serial	10		√	nextval('item_group_item_group_id_seq'::regclass)
item_group_metadata	item_group_id	int4	10
rule_set	item_group_id	int4	10	√		null
dyn_item_group_metadata	item_group_metadata_id	int4	10	√		null
item_group_metadata	item_group_metadata_id	serial	10		√	nextval('item_group_metadata_item_group_metadata_id_seq'::regclass)
audit_event_context	item_id	int4	10	√		null
dc_primitive	item_id	int4	10	√		null
dc_substitution_event	item_id	int4	10	√		null
dc_summary_item_map	item_id	int4	10	√		null
dyn_item_form_metadata	item_id	int4	10	√		null
item	item_id	serial	10		√	nextval('item_item_id_seq'::regclass)
item_data	item_id	int4	10
item_form_metadata	item_id	int4	10
item_group_metadata	item_id	int4	10
rule_set	item_id	int4	10	√		null
versioning_map	item_id	int4	10	√		null
item	item_reference_type_id	int4	10	√		null
item_reference_type	item_reference_type_id	serial	10		√	nextval('item_reference_type_item_reference_type_id_seq'::regclass)
dc_computed_event	item_target_id	int4	10	√		null
oc_qrtz_job_details	job_class_name	varchar	250
oc_qrtz_job_details	job_data	bytea	2147483647	√		null
oc_qrtz_triggers	job_data	bytea	2147483647	√		null
oc_qrtz_fired_triggers	job_group	varchar	200	√		null
oc_qrtz_job_details	job_group	varchar	200
oc_qrtz_job_listeners	job_group	varchar	200
oc_qrtz_triggers	job_group	varchar	200
oc_qrtz_job_listeners	job_listener	varchar	200
oc_qrtz_fired_triggers	job_name	varchar	200	√		null
oc_qrtz_job_details	job_name	varchar	200
oc_qrtz_job_listeners	job_name	varchar	200
oc_qrtz_triggers	job_name	varchar	200
configuration	key	varchar	255	√		null
study	keywords	varchar	255	√		null
decision_condition	label	varchar	1000
response_set	label	varchar	80	√		null
section	label	varchar	2000	√		null
study_subject	label	varchar	30	√		null
oc_qrtz_scheduler_state	last_checkin_time	int8	19
user_account	last_name	varchar	50	√		null
item_group_metadata	layout	varchar	100	√		null
item_form_metadata	left_item_text	varchar	4000	√		null
databasechangelog	liquibase	varchar	10	√		null
locale_based_description	locale_name	varchar	255	√		null
locale_based_description	localized_description	varchar	255	√		null
study_event	location	varchar	2000	√		null
user_account	lock_counter	int4	10			0
oc_qrtz_locks	lock_name	varchar	40
databasechangeloglock	locked	bool	1
databasechangeloglock	lockedby	varchar	255	√		null
databasechangeloglock	lockgranted	timestamptz	35,6	√		null
audit_user_login	login_attempt_date	timestamptz	35,6	√		null
audit_user_login	login_status_code	int4	10	√		null
study	masking	varchar	30	√		null
databasechangelog	md5sum	varchar	32	√		null
study	medline_identifier	varchar	255	√		null
rule_action	message	varchar	255	√		null
scd_item_metadata	message	varchar	3000	√		null
export_format	mime_type	varchar	255	√		null
oc_qrtz_triggers	misfire_instr	int2	5	√		null
subject	mother_id	int4	10	√		null
archived_dataset_file	name	varchar	255	√		null
audit_log_event_type	name	varchar	255	√		null
coding_dictionary	name	varchar	500	√		null
completion_status	name	varchar	255	√		null
crf	name	varchar	255	√		null
crf_version	name	varchar	255	√		null
dataset	name	varchar	255	√		null
dataset_item_status	name	varchar	50	√		null
discrepancy_note_type	name	varchar	50	√		null
export_format	name	varchar	255	√		null
filter	name	varchar	255	√		null
group_class_types	name	varchar	255	√		null
item	name	varchar	255	√		null
item_data_type	name	varchar	255	√		null
item_group	name	varchar	255	√		null
item_reference_type	name	varchar	255	√		null
measurement_unit	name	varchar	100
null_value_type	name	varchar	255	√		null
openclinica_version	name	varchar	255	√		null
resolution_status	name	varchar	50	√		null
response_type	name	varchar	255	√		null
rule	name	varchar	255	√		null
status	name	varchar	255	√		null
study	name	varchar	255	√		null
study_event_definition	name	varchar	2000	√		null
study_group	name	varchar	255	√		null
study_group_class	name	varchar	30	√		null
study_parameter	name	varchar	50	√		null
study_type	name	varchar	255	√		null
subject_event_status	name	varchar	255	√		null
permission	name_in_navbar	varchar	200	√		null
audit_event_values	new_value	varchar	2000	√		null
audit_log_event	new_value	varchar	4000	√		null
oc_qrtz_triggers	next_fire_time	int8	19	√		null
subject_group_map	notes	varchar	255	√		null
null_value_type	null_value_type_id	serial	10		√	nextval('null_value_type_null_value_type_id_seq'::regclass)
event_definition_crf	null_values	varchar	255	√		null
dataset	num_runs	int4	10	√		null
coding_dictionary	oc_oid	varchar	40
crf	oc_oid	varchar	40
crf_version	oc_oid	varchar	40
item	oc_oid	varchar	40
item_group	oc_oid	varchar	40
measurement_unit	oc_oid	varchar	40
rule	oc_oid	varchar	40	√		null
rule_action_property	oc_oid	varchar	512	√		null
study	oc_oid	varchar	40
study_event_definition	oc_oid	varchar	40
study_subject	oc_oid	varchar	40
group_auth_definition	oc_oid_reference_list	varchar	1000	√		null
dataset	odm_metadataversion_name	varchar	255	√		null
dataset	odm_metadataversion_oid	varchar	255	√		null
dataset	odm_prior_metadataversion_oid	varchar	255	√		null
dataset	odm_prior_study_oid	varchar	255	√		null
study	official_title	varchar	255	√		null
event_crf	old_status_id	int4	10	√		1
item_data	old_status_id	int4	10	√		null
study	old_status_id	int4	10	√		1
audit_event_values	old_value	varchar	2000	√		null
audit_log_event	old_value	varchar	4000	√		null
scd_item_metadata	option_value	varchar	500	√		null
response_set	options_text	varchar	4000	√		null
response_set	options_values	varchar	4000	√		null
dataset_filter_map	ordinal	int4	10	√		null
dc_event	ordinal	int4	10
dc_summary_item_map	ordinal	int4	10	√		null
event_definition_crf	ordinal	int4	10	√		null
item_data	ordinal	int4	10	√		null
item_form_metadata	ordinal	int4	10
item_group_metadata	ordinal	int4	10
section	ordinal	int4	10	√		null
study_event_definition	ordinal	int4	10	√		null
study_parameter	overridable	bool	1	√		null
archived_dataset_file	owner_id	int4	10	√		null
crf	owner_id	int4	10	√		null
crf_version	owner_id	int4	10	√		null
dataset	owner_id	int4	10	√		null
decision_condition	owner_id	int4	10	√		null
discrepancy_note	owner_id	int4	10	√		null
event_crf	owner_id	int4	10	√		null
event_definition_crf	owner_id	int4	10	√		null
filter	owner_id	int4	10
item	owner_id	int4	10	√		null
item_data	owner_id	int4	10	√		null
item_group	owner_id	int4	10	√		null
role	owner_id	int4	10	√		null
rule	owner_id	int4	10	√		null
rule_action	owner_id	int4	10	√		null
rule_expression	owner_id	int4	10	√		null
rule_set	owner_id	int4	10	√		null
rule_set_rule	owner_id	int4	10	√		null
section	owner_id	int4	10
study	owner_id	int4	10	√		null
study_event	owner_id	int4	10	√		null
study_event_definition	owner_id	int4	10	√		null
study_group_class	owner_id	int4	10	√		null
study_module_status	owner_id	int4	10	√		null
study_subject	owner_id	int4	10	√		null
study_user_role	owner_id	int4	10	√		null
subject	owner_id	int4	10	√		null
subject_group_map	owner_id	int4	10	√		null
user_account	owner_id	int4	10	√		null
user_role_access	owner_id	int4	10	√		null
item_form_metadata	page_number_label	varchar	5	√		null
section	page_number_label	varchar	5	√		null
usage_statistics_data	param_key	varchar	255	√		null
usage_statistics_data	param_value	varchar	1000	√		null
study_parameter_value	parameter	varchar	50	√		null
discrepancy_note	parent_dn_id	int4	10	√		null
event_definition_crf	parent_id	int4	10	√		null
item_form_metadata	parent_id	int4	10	√		null
role	parent_id	int4	10	√		null
section	parent_id	int4	10	√		null
user_role	parent_id	int4	10	√		null
item_form_metadata	parent_label	varchar	120	√		null
study	parent_study_id	int4	10	√		null
dyn_item_form_metadata	passed_dde	int4	10	√		0
dyn_item_group_metadata	passed_dde	int4	10	√		0
user_account	passwd	varchar	255	√		null
user_account	passwd_challenge_answer	varchar	255	√		null
user_account	passwd_challenge_question	varchar	64	√		null
user_account	passwd_timestamp	date	13	√		null
role_permission	permission_id	int4	10	√		null
study	phase	varchar	30	√		null
item	phi_status	bool	1	√		null
user_account	phone	varchar	64	√		null
oc_qrtz_triggers	prev_fire_time	int8	19	√		null
study	principal_investigator	varchar	255	√		null
oc_qrtz_fired_triggers	priority	int4	10
oc_qrtz_triggers	priority	int4	10	√		null
privilege	priv_desc	varchar	2000	√		null
privilege	priv_id	serial	10		√	nextval('privilege_priv_id_seq'::regclass)
role_privilege_map	priv_id	int4	10
privilege	priv_name	varchar	50	√		null
role_privilege_map	priv_value	varchar	50	√		null
locale_based_description	property_name	varchar	255	√		null
study	protocol_date_verification	date	13	√		null
study	protocol_description	varchar	1000	√		null
study	protocol_type	varchar	30	√		null
study	purpose	varchar	64	√		null
decision_condition	quantity	int4	10
item_form_metadata	question_number_label	varchar	20	√		null
audit_event	reason_for_change	varchar	1000	√		null
audit_log_event	reason_for_change	varchar	1000	√		null
item_data_type	reference	varchar	1000	√		null
null_value_type	reference	varchar	1000	√		null
item_form_metadata	regexp	varchar	1000	√		null
item_form_metadata	regexp_error_msg	varchar	255	√		null
item_group_metadata	repeat_array	varchar	255	√		null
oc_qrtz_simple_triggers	repeat_count	int8	19
oc_qrtz_simple_triggers	repeat_interval	int8	19
item_group_metadata	repeat_max	int4	10	√		null
item_group_metadata	repeat_number	int4	10	√		null
study_event_definition	repeating	bool	1	√		null
item_group_metadata	repeating_group	bool	1			true
oc_qrtz_fired_triggers	requests_recovery	bool	1	√		null
oc_qrtz_job_details	requests_recovery	bool	1
event_definition_crf	require_all_text_filled	bool	1	√		null
item_form_metadata	required	bool	1	√		null
event_definition_crf	required_crf	bool	1	√		null
discrepancy_note	resolution_status_id	int4	10	√		null
resolution_status	resolution_status_id	serial	10		√	nextval('resolution_status_resolution_status_id_seq'::regclass)
item_form_metadata	response_layout	varchar	255	√		null
item_form_metadata	response_set_id	int4	10
response_set	response_set_id	serial	10		√	nextval('response_set_response_set_id_seq'::regclass)
response_set	response_type_id	int4	10	√		null
response_type	response_type_id	serial	10		√	nextval('response_type_response_type_id_seq'::regclass)
study	results_reference	bool	1	√		null
crf_version	revision_notes	varchar	255	√		null
item_form_metadata	right_item_text	varchar	2000	√		null
user_role	role_desc	varchar	2000	√		null
role_permission	role_id	int4	10	√		null
role_privilege_map	role_id	int4	10
user_role	role_id	serial	10		√	nextval('user_role_role_id_seq'::regclass)
user_role_access	role_id	int4	10	√		null
audit_event_context	role_name	varchar	200	√		null
role	role_name	varchar	255	√		null
study_user_role	role_name	varchar	40	√		null
user_role	role_name	varchar	50
item_group_metadata	row_start_number	int4	10	√		null
study_module_status	rule	int4	10	√		1
rule_action_property	rule_action_id	int4	10	√		null
rule_action	rule_action_run_id	int4	10	√		null
rule	rule_expression_id	int4	10
rule_action_property	rule_expression_id	int4	10	√		null
rule_set	rule_expression_id	int4	10
rule_set_rule	rule_id	int4	10
rule_action_run_log	rule_oc_oid	varchar	40	√		null
rule_set_audit	rule_set_id	int4	10
rule_set_rule	rule_set_id	int4	10
rule_action	rule_set_rule_id	int4	10
rule_set_rule_audit	rule_set_rule_id	int4	10
rule	rule_type_id	int4	10	√		1
archived_dataset_file	run_time	int4	10	√		null
user_account	run_webservices	bool	1			false
study_event	sample_ordinal	int4	10	√		null
scd_item_metadata	scd_item_form_metadata_id	int4	10	√		null
event_crf	sdv_status	bool	1			false
event_crf	sdv_update_id	int4	10	√		0
study	secondary_identifier	varchar	255	√		null
study_subject	secondary_label	varchar	30	√		null
dc_section_event	section_id	int4	10
item_form_metadata	section_id	int4	10
section	section_id	serial	10		√	nextval('section_section_id_seq'::regclass)
event_definition_crf	selected_version_ids	varchar	150	√		null
study	selection	varchar	30	√		null
dataset	show_crf_int_date	bool	1	√		false
dataset	show_crf_int_name	bool	1	√		false
dataset	show_crf_status	bool	1	√		false
dataset	show_crf_version	bool	1	√		false
dataset	show_disc_info	bool	1	√		false
dataset	show_event_end	bool	1	√		false
dataset	show_event_location	bool	1	√		false
dataset	show_event_start	bool	1	√		false
dataset	show_event_status	bool	1	√		false
dyn_item_group_metadata	show_group	bool	1	√		true
item_group_metadata	show_group	bool	1	√		true
dataset	show_group_info	bool	1	√		false
dyn_item_form_metadata	show_item	bool	1	√		true
item_form_metadata	show_item	bool	1	√		true
dataset	show_secondary_id	bool	1	√		false
dataset	show_subject_age_at_event	bool	1	√		false
dataset	show_subject_dob	bool	1	√		false
dataset	show_subject_gender	bool	1	√		false
dataset	show_subject_status	bool	1	√		false
dataset	show_subject_unique_id	bool	1	√		false
study_module_status	site	int4	10	√		1
event_definition_crf	source_data_verification_code	int4	10	√		null
crf	source_study_id	int4	10	√		null
study	sponsor	varchar	255	√		null
dataset	sql_statement	text	2147483647	√		null
filter	sql_statement	varchar	4000	√		null
oc_qrtz_triggers	start_time	int8	19
study_event	start_time_flag	bool	1	√		null
oc_qrtz_fired_triggers	state	varchar	16
coding_dictionary	status_id	int4	10	√		null
completion_status	status_id	int4	10	√		null
crf	status_id	int4	10	√		null
crf_version	status_id	int4	10	√		null
dataset	status_id	int4	10	√		null
decision_condition	status_id	int4	10	√		null
event_crf	status_id	int4	10	√		null
event_definition_crf	status_id	int4	10	√		null
filter	status_id	int4	10	√		null
item	status_id	int4	10	√		null
item_data	status_id	int4	10	√		null
item_group	status_id	int4	10	√		null
role	status_id	int4	10	√		1
rule	status_id	int4	10	√		null
rule_action	status_id	int4	10	√		null
rule_expression	status_id	int4	10	√		null
rule_set	status_id	int4	10	√		null
rule_set_audit	status_id	int4	10	√		null
rule_set_rule	status_id	int4	10	√		null
rule_set_rule_audit	status_id	int4	10	√		null
section	status_id	int4	10	√		null
status	status_id	serial	10		√	nextval('status_status_id_seq'::regclass)
study	status_id	int4	10	√		null
study_event	status_id	int4	10	√		null
study_event_definition	status_id	int4	10	√		null
study_group_class	status_id	int4	10	√		null
study_module_status	status_id	int4	10	√		null
study_subject	status_id	int4	10	√		null
study_user_role	status_id	int4	10	√		null
subject	status_id	int4	10	√		null
subject_group_map	status_id	int4	10	√		null
user_account	status_id	int4	10	√		null
user_role_access	status_id	int4	10	√		null
study_module_status	study	int4	10	√		1
audit_event_context	study_crf_id	int4	10	√		null
audit_event_context	study_event_definition_id	int4	10	√		null
event_definition_crf	study_event_definition_id	int4	10	√		null
rule_set	study_event_definition_id	int4	10	√		null
study_event	study_event_definition_id	int4	10	√		null
study_event_definition	study_event_definition_id	serial	10		√	nextval('study_event_definition_study_event_definition_id_seq'::regclass)
audit_event_context	study_event_id	int4	10	√		null
audit_log_event	study_event_id	int4	10	√		null
dn_study_event_map	study_event_id	int4	10	√		null
event_crf	study_event_id	int4	10	√		null
study_event	study_event_id	serial	10		√	nextval('study_event_study_event_id_seq'::regclass)
dataset_study_group_class_map	study_group_class_id	int4	10
study_group	study_group_class_id	int4	10	√		null
study_group_class	study_group_class_id	serial	10		√	nextval('study_group_class_study_group_class_id_seq'::regclass)
subject_group_map	study_group_class_id	int4	10	√		null
study_group	study_group_id	serial	10		√	nextval('study_group_study_group_id_seq'::regclass)
subject_group_map	study_group_id	int4	10	√		null
audit_event_context	study_id	int4	10	√		null
dataset	study_id	int4	10	√		null
discrepancy_note	study_id	int4	10	√		null
event_definition_crf	study_id	int4	10	√		null
rule	study_id	int4	10	√		null
rule_set	study_id	int4	10
study	study_id	serial	10		√	nextval('study_study_id_seq'::regclass)
study_event_definition	study_id	int4	10	√		null
study_group_class	study_id	int4	10	√		null
study_module_status	study_id	int4	10	√		null
study_parameter_value	study_id	int4	10	√		null
study_subject	study_id	int4	10	√		null
study_user_role	study_id	int4	10	√		null
thesaurus	study_id	int4	10	√		null
study_parameter	study_parameter_id	serial	10		√	nextval('study_parameter_study_parameter_id_seq'::regclass)
study_parameter_value	study_parameter_value_id	serial	10		√	nextval('study_parameter_value_study_parameter_value_id_seq'::regclass)
audit_event_context	study_subject_id	int4	10	√		null
dn_item_data_map	study_subject_id	int4	10	√		null
dn_study_subject_map	study_subject_id	int4	10	√		null
event_crf	study_subject_id	int4	10	√		null
study_event	study_subject_id	int4	10	√		null
study_subject	study_subject_id	serial	10		√	nextval('study_subject_study_subject_id_seq'::regclass)
subject_group_map	study_subject_id	int4	10	√		null
study_type	study_type_id	serial	10		√	nextval('study_type_study_type_id_seq'::regclass)
entity_type	sub_type_name	varchar	300	√		null
item_form_metadata	subheader	varchar	240	√		null
item_group_metadata	subheader	varchar	255	√		null
dc_send_email_event	subject	varchar	1000	√		null
study_group_class	subject_assignment	varchar	30	√		null
study_event	subject_event_status_id	int4	10	√		null
subject_event_status	subject_event_status_id	serial	10		√	nextval('subject_event_status_subject_event_status_id_seq'::regclass)
study_module_status	subject_group	int4	10	√		1
subject_group_map	subject_group_map_id	serial	10		√	nextval('subject_group_map_subject_group_map_id_seq'::regclass)
audit_event_context	subject_id	int4	10	√		null
dn_subject_map	subject_id	int4	10	√		null
study_subject	subject_id	int4	10	√		null
subject	subject_id	serial	10		√	nextval('subject_subject_id_seq'::regclass)
section	subtitle	varchar	2000	√		null
study	summary	varchar	255	√		null
dc_computed_event	summary_type	varchar	255	√		null
databasechangelog	tag	varchar	255	√		null
oc_qrtz_cron_triggers	time_zone_id	varchar	80	√		null
oc_qrtz_simple_triggers	times_triggered	int8	19
study	timing	varchar	30	√		null
section	title	varchar	2000	√		null
dc_send_email_event	to_address	varchar	1000
oc_qrtz_blob_triggers	trigger_group	varchar	200
oc_qrtz_cron_triggers	trigger_group	varchar	200
oc_qrtz_fired_triggers	trigger_group	varchar	200
oc_qrtz_paused_trigger_grps	trigger_group	varchar	200
oc_qrtz_simple_triggers	trigger_group	varchar	200
oc_qrtz_trigger_listeners	trigger_group	varchar	200
oc_qrtz_triggers	trigger_group	varchar	200
oc_qrtz_trigger_listeners	trigger_listener	varchar	200
oc_qrtz_blob_triggers	trigger_name	varchar	200
oc_qrtz_cron_triggers	trigger_name	varchar	200
oc_qrtz_fired_triggers	trigger_name	varchar	200
oc_qrtz_simple_triggers	trigger_name	varchar	200
oc_qrtz_trigger_listeners	trigger_name	varchar	200
oc_qrtz_triggers	trigger_name	varchar	200
oc_qrtz_triggers	trigger_state	varchar	16
oc_qrtz_triggers	trigger_type	varchar	8
dc_event	type	varchar	256
decision_condition	type	varchar	3
study_event_definition	type	varchar	20	√		null
study	type_id	int4	10	√		null
entity_type	type_name	varchar	300	√		null
study	unique_identifier	varchar	30	√		null
subject	unique_identifier	varchar	255	√		null
item	units	varchar	64	√		null
crf	update_id	int4	10	√		null
crf_version	update_id	int4	10	√		null
dataset	update_id	int4	10	√		null
decision_condition	update_id	int4	10	√		null
event_crf	update_id	int4	10	√		null
event_definition_crf	update_id	int4	10	√		null
filter	update_id	int4	10	√		null
item	update_id	int4	10	√		null
item_data	update_id	int4	10	√		null
item_group	update_id	int4	10	√		null
role	update_id	int4	10	√		null
rule	update_id	int4	10	√		null
rule_action	update_id	int4	10	√		null
rule_expression	update_id	int4	10	√		null
rule_set	update_id	int4	10	√		null
rule_set_rule	update_id	int4	10	√		null
section	update_id	int4	10	√		null
study	update_id	int4	10	√		null
study_event	update_id	int4	10	√		null
study_event_definition	update_id	int4	10	√		null
study_group_class	update_id	int4	10	√		null
study_module_status	update_id	int4	10	√		null
study_subject	update_id	int4	10	√		null
study_user_role	update_id	int4	10	√		null
subject	update_id	int4	10	√		null
subject_group_map	update_id	int4	10	√		null
user_account	update_id	int4	10	√		null
user_role_access	update_id	int4	10	√		null
openclinica_version	update_timestamp	timestamptz	35,6	√		null
usage_statistics_data	update_timestamp	timestamptz	35,6	√		null
rule_set_audit	updater_id	int4	10	√		null
rule_set_rule_audit	updater_id	int4	10	√		null
coding_dictionary	url	varchar	500	√		null
study	url	varchar	255	√		null
study	url_description	varchar	255	√		null
audit_user_login	user_account_id	int4	10	√		null
audit_event	user_id	int4	10	√		null
audit_log_event	user_id	int4	10	√		null
user_account	user_id	serial	10		√	nextval('user_account_user_id_seq'::regclass)
user_role_access	user_id	int4	10	√		null
audit_user_login	user_name	varchar	255	√		null
study_user_role	user_name	varchar	40	√		null
user_account	user_name	varchar	64	√		null
user_type	user_type	varchar	50	√		null
user_account	user_type_id	int4	10	√		null
user_type	user_type_id	serial	10		√	nextval('user_type_user_type_id_seq'::regclass)
authorities	username	varchar	50
study_module_status	users	int4	10	√		1
event_crf	validate_string	varchar	256	√		null
event_crf	validator_annotations	varchar	4000	√		null
event_crf	validator_id	int4	10	√		null
configuration	value	varchar	255	√		null
dc_substitution_event	value	varchar	1000
item_data	value	varchar	4000	√		null
rule_action_property	value	varchar	512	√		null
rule_action_run_log	value	varchar	4000	√		null
rule_expression	value	varchar	1025
study_parameter_value	value	varchar	50	√		null
thesaurus	verbatim_term	varchar	4000	√		null
audit_user_login	version	int4	10	√		null
authorities	version	int4	10	√		null
coding_dictionary	version	int4	10	√		null
configuration	version	int4	10	√		null
dyn_item_form_metadata	version	int4	10	√		null
dyn_item_group_metadata	version	int4	10	√		null
entity_type	version	int4	10	√		null
group_auth_definition	version	int4	10	√		0
locale_based_description	version	int4	10	√		0
measurement_unit	version	int4	10	√		null
openclinica_version	version	int4	10	√		null
permission	version	int4	10	√		0
role	version	int4	10	√		0
role_permission	version	int4	10	√		0
rule	version	int4	10	√		null
rule_action	version	int4	10	√		null
rule_action_property	version	int4	10	√		null
rule_action_run	version	int4	10	√		null
rule_action_run_log	version	int4	10	√		null
rule_expression	version	int4	10	√		null
rule_set	version	int4	10	√		null
rule_set_audit	version	int4	10	√		null
rule_set_rule	version	int4	10	√		null
rule_set_rule_audit	version	int4	10	√		null
scd_item_metadata	version	int4	10	√		null
study_module_status	version	int4	10	√		null
thesaurus	version	int4	10	√		null
usage_statistics_data	version	int4	10	√		null
user_role_access	version	int4	10	√		0
response_set	version_id	int4	10	√		null
item_form_metadata	width_decimal	varchar	10	√		null