SchemaSpy Analysis of odyssey_test._oat - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Wed Feb 19 10:31 EST 2014
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

odyssey_test._oat contains 92 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
ins_schedule_prefs accomodations text 2147483647  √  null
ins_schedule_prefs additional_info text 2147483647  √  null
std_permission_number assigned_by text 2147483647  √  null
std_permission_number assigned_date timestamp 29,6  √  null
mappings bio_id int4 10  √  null
std_note body text 2147483647  √  null
pps_plan_core_cs career_code quest_career 2147483647  √  null
qry_parameter_type convert_to text 2147483647  √  null
pps_plan_core_cs degree_code text 2147483647  √  null
oat_tag description text 2147483647  √  null
qry_parameter description text 2147483647  √  null
qry_parameter_type examples text 2147483647  √  null
pps_plan_core_cs first_valid_term_id quest_term_id 2147483647  √  null
pps_plan_core_cs last_admit_term_id quest_term_id 2147483647  √  null
mappings new_id int4 10  √  null
mappings pix_id int4 10  √  null
pps_plan_core_cs plan_active bool 1  √  null
pps_plan_core_cs plan_as_of date 13  √  null
pps_plan_core_cs plan_code text 2147483647  √  null
pps_plan_core_cs plan_comment text 2147483647  √  null
pps_plan_core_cs plan_diploma_description text 2147483647  √  null
pps_plan_core_cs plan_short_title text 2147483647  √  null
pps_plan_core_cs plan_title text 2147483647  √  null
pps_plan_core_cs plan_transcript_description text 2147483647  √  null
pps_plan_core_cs plan_type_code text 2147483647  √  null
pps_plan_core_cs program_code text 2147483647  √  null
std_permission_number reason text 2147483647  √  null
pps_plan_core_cs unit_code text 2147483647  √  null
std_permission_number uw_id quest_uw_id 2147483647  √  null
qry_parameter_type value_list _text 2147483647  √  null
mappings acad_id int4 10
usr_user acad_record_sort_order oat_sort_order 2147483647 'ASC'::_oat.oat_sort_order
usr_user added_by quest_userid 2147483647
usr_user added_when timestamp 29,6 now()
std_advisor_view advisor_userid quest_userid 2147483647
usr_permission assigned_by quest_userid 2147483647
usr_permission assigned_when timestamp 29,6 now()
usr_user auth_group text 2147483647
ins_schedule_prefs back_to_back bool 1 true
std_permission_number catalog text 2147483647
std_permission_number class_id int4 10
oat_xlate code text 2147483647
usr_user col1_prefixes regex 2147483647 ''::text
usr_user col2_prefixes regex 2147483647 ''::text
std_advisor_view date_viewed timestamp 29,6 now()
oat_permission description text 2147483647
qry_query description text 2147483647
ins_schedule_prefs emailed_accomodations bool 1 false
std_permission_number expiry_date date 13
ins_schedule_prefs faculty text 2147483647
oat_xlate field text 2147483647
ins_schedule_prefs five_days bool 1 true
oat_unit_groups group_code text 2147483647
oat_tag group_id text 2147483647
oat_tag_content group_id text 2147483647
oat_tag_content id int4 10
oat_tag label text 2147483647
usr_user last_change timestamp 29,6 now()
oat_xlate meaning text 2147483647
qry_parameter name text 2147483647
ins_schedule_prefs need_data_projector bool 1 false
std_note note_category std_note_category 2147483647
std_note note_id serial 10  √  nextval('_oat.std_note_note_id_seq'::regclass)
usr_user notes_sort_order oat_sort_order 2147483647 'DESC'::_oat.oat_sort_order
std_note origin text 2147483647
qry_parameter param_num int4 10
qry_parameter param_type text 2147483647
qry_parameter_type param_type text 2147483647
oat_permission parent permission 2147483647
oat_permission permission permission 2147483647
usr_permission permission permission 2147483647
std_permission_number permission_num int4 10
ins_schedule_prefs pref_time text 2147483647 'NoPref'::text
qry_query query text 2147483647
qry_parameter query_id int4 10
qry_query query_id serial 10  √  nextval('_oat.qry_query_query_id_seq'::regclass)
qry_parameter_type regex regex 2147483647
std_permission_number section_code text 2147483647
std_note subject text 2147483647
std_permission_number subject_code text 2147483647
oat_tag tag text 2147483647
oat_tag_content tag text 2147483647
std_permission_number term_id quest_term_id 2147483647
qry_query title text 2147483647
ins_schedule_prefs unit text 2147483647
oat_unit_groups unit_description text 2147483647
ins_schedule_prefs userid text 2147483647
usr_permission userid quest_userid 2147483647
usr_user userid quest_userid 2147483647
std_advisor_view uw_id quest_uw_id 2147483647
std_note uw_id quest_uw_id 2147483647
std_note when_added timestamp 29,6 now()