SchemaSpy Analysis of odyssey_test._oat - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Wed Feb 19 10:31 EST 2014 |
| ||||||
|
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() |