Skip to content

Instantly share code, notes, and snippets.

@lucasstark

lucasstark/cache.sql

Created May 3, 2023 15:06
Show Gist options
  • Save lucasstark/0d68c93d87be4f365ef095ace03ad986 to your computer and use it in GitHub Desktop.
Save lucasstark/0d68c93d87be4f365ef095ace03ad986 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
cache.sql
#
# SQL Export
# Created by Querious (303012)
# Created: May 3, 2023 at 11:04:47 AM EDT
# Encoding: Unicode (UTF-8)
#
SET @ORIG_TIME_ZONE = @@TIME_ZONE;
SET TIME_ZONE = '+00:00';
SET @ORIG_SQL_MODE = @@SQL_MODE;
SET SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';
CREATE TABLE `admissions_programs` (
`stvterm_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`prog` varchar(12) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`major` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`minor` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`program_description` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`concentration` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`major_description` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`minor_description` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvmajr_aid_eligibility_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`prog_oldway` varchar(12) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `concentration` (`concentration`),
KEY `prog` (`prog`),
KEY `stvterm_code` (`stvterm_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `cache_queries` (
`cache_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`cache_query` text COLLATE utf8mb3_unicode_ci NOT NULL,
`cache_query_context` varchar(25) COLLATE utf8mb3_unicode_ci NOT NULL,
`cache_table` varchar(100) COLLATE utf8mb3_unicode_ci NOT NULL,
`cache_table_engine` enum('MYISAM','INNODB') COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'MYISAM',
`cache_days` varchar(7) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`cache_times` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`cache_sched_username` varchar(25) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`cache_sched_time` datetime NOT NULL,
`cache_mod_username` varchar(25) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`cache_mod_time` datetime DEFAULT NULL,
PRIMARY KEY (`cache_id`),
UNIQUE KEY `cache_table` (`cache_table`)
) ENGINE=MyISAM AUTO_INCREMENT=108 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `cache_queries_indices` (
`index_id` mediumint(8) NOT NULL AUTO_INCREMENT,
`cache_id` mediumint(8) unsigned NOT NULL,
`index_type` enum('PRIMARY','INDEX','UNIQUE','FULLTEXT') COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'INDEX',
`index_fields` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
PRIMARY KEY (`index_id`),
UNIQUE KEY `cache_id` (`cache_id`,`index_type`,`index_fields`)
) ENGINE=MyISAM AUTO_INCREMENT=223 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `ge_program_data` (
`program_code` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`program_name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`program_cost` varchar(20) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`program_length` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`student_debt` varchar(20) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`debt_comments` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`licensure_state` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`warning_language` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`reporting_year` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `program_code` (`program_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `goremal` (
`goremal_pidm` int(8) DEFAULT NULL,
`goremal_email_address` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`goremal_emal_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`goremal_status_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`goremal_username` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `goremal_email_address` (`goremal_email_address`),
KEY `goremal_emal_code` (`goremal_emal_code`),
KEY `goremal_pidm` (`goremal_pidm`),
KEY `goremal_status_ind` (`goremal_status_ind`),
KEY `goremal_username` (`goremal_username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `legacy_classnotes` (
`term_code` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`subj_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`crse_numb` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`note` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `crse_numb` (`crse_numb`),
KEY `subj_code` (`subj_code`),
KEY `term_code` (`term_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `legacy_sectionnotes` (
`term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`crn` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`note` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `crn` (`crn`),
KEY `term_code` (`term_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `legacy_subjectnotes` (
`term_code` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`note` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `subj_code` (`subj_code`),
KEY `term_code` (`term_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `lwbcrse` (
`lwbcrse_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwbcrse_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwbcrse_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwbcrse_full_title` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwbcrse_tagline` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwbcrse_desc` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwbcrse_notes` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwbcrse_prereq` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwbcrse_graded` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwbcrse_activity_date` date DEFAULT NULL,
`lwbcrse_user` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwbcrse_edtogo_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwbcrse_online` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwbcrse_reg_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwbcrse_lock_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwbcrse_type` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwbcrse_keywords` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `lwbcrse_crse_numb` (`lwbcrse_crse_numb`),
KEY `lwbcrse_subj_code` (`lwbcrse_subj_code`),
KEY `lwbcrse_term_code` (`lwbcrse_term_code`),
FULLTEXT KEY `lwbcrse_full_title` (`lwbcrse_full_title`,`lwbcrse_tagline`,`lwbcrse_desc`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `lwbtype` (
`lwbtype_code` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwbtype_desc` varchar(20) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwbtype_instructor` varchar(40) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwbtype_location` varchar(40) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwbtype_url` varchar(200) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwbtype_activity` date DEFAULT NULL,
`lwbtype_user` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `lwbtype_code` (`lwbtype_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `lwrbaud` (
`lwrbaud_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrbaud_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrbaud_title` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrbaud_desc` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrbaud_activity_date` date DEFAULT NULL,
`lwrbaud_user` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `lwrbaud_code` (`lwrbaud_code`),
KEY `lwrbaud_term_code` (`lwrbaud_term_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `lwrbcat` (
`lwrbcat_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrbcat_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrbcat_title` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrbcat_desc` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrbcat_activity_date` date DEFAULT NULL,
`lwrbcat_user` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrbcat_online_desc` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrbcat_display_ind` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `lwrbcat_code` (`lwrbcat_code`),
KEY `lwrbcat_display_ind` (`lwrbcat_display_ind`),
KEY `lwrbcat_term_code` (`lwrbcat_term_code`),
KEY `lwrbcat_title` (`lwrbcat_title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `lwrbund` (
`lwrbund_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrbund_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrbund_title` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrbund_prof_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrbund_activity_date` date DEFAULT NULL,
`lwrbund_user` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `lwrbund_term_code` (`lwrbund_term_code`,`lwrbund_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `lwrcaud` (
`lwrcaud_baud_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrcaud_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrcaud_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrcaud_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrcaud_activity_date` date DEFAULT NULL,
`lwrcaud_user` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrcaud_form_no` bigint(30) DEFAULT NULL,
KEY `lwrcaud_baud_code` (`lwrcaud_baud_code`),
KEY `lwrcaud_term_code` (`lwrcaud_term_code`,`lwrcaud_subj_code`,`lwrcaud_crse_numb`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `lwrcbun` (
`lwrcbun_bund_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrcbun_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrcbun_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrcbun_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrcbun_activity_date` date DEFAULT NULL,
`lwrcbun_user` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrcbun_form_no` bigint(30) DEFAULT NULL,
KEY `lwrcbun_term_code` (`lwrcbun_term_code`,`lwrcbun_subj_code`,`lwrcbun_crse_numb`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `lwrccat` (
`lwrccat_bcat_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrccat_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrccat_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrccat_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrccat_activity_date` date DEFAULT NULL,
`lwrccat_user` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrccat_sort_order` int(3) DEFAULT NULL,
`lwrccat_primary_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrccat_form_no` bigint(30) DEFAULT NULL,
KEY `lwrccat_bcat_code` (`lwrccat_bcat_code`,`lwrccat_term_code`,`lwrccat_subj_code`,`lwrccat_crse_numb`),
KEY `lwrccat_term_code` (`lwrccat_term_code`,`lwrccat_subj_code`,`lwrccat_crse_numb`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `lwrprof` (
`lwrprof_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrprof_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrprof_title` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwrprof_activity_date` date DEFAULT NULL,
`lwrprof_user` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `lwrprof_term_code` (`lwrprof_term_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `lwvccat` (
`lwvccat_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvccat_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvccat_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvccat_bcat_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvccat_bcat_title` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvccat_bcat_desc` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvccat_bcat_online_desc` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvccat_sort_order` int(3) DEFAULT NULL,
`lwvccat_display_ind` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `lwvccat_bcat_code` (`lwvccat_bcat_code`,`lwvccat_term_code`,`lwvccat_subj_code`,`lwvccat_crse_numb`),
KEY `lwvccat_display_ind` (`lwvccat_display_ind`),
KEY `lwvccat_term_code` (`lwvccat_term_code`,`lwvccat_subj_code`,`lwvccat_crse_numb`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `lwvcpce` (
`lwvcpce_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvcpce_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvcpce_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvcpce_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvcpce_desc` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvcpce_units` decimal(5,2) DEFAULT NULL,
`lwvcpce_accd_stmt` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `lwvcpce_crse_numb` (`lwvcpce_crse_numb`),
KEY `lwvcpce_subj_code` (`lwvcpce_subj_code`),
KEY `lwvcpce_term_code` (`lwvcpce_term_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `lwvfees` (
`lwvfees_crn` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvfees_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvfees_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvfees_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvfees_detl_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvfees_detl_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvfees_amount` decimal(12,2) DEFAULT NULL,
KEY `lwvfees_term_code` (`lwvfees_term_code`,`lwvfees_crn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `lwvinst` (
`lwvinst_crn` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvinst_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvinst_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvinst_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvinst_last_name` varchar(60) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvinst_first_name` varchar(60) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `lwvinst_term_code` (`lwvinst_term_code`,`lwvinst_crn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `lwvmeet` (
`lwvmeet_crn` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvmeet_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvmeet_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvmeet_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvmeet_start_date` date DEFAULT NULL,
`lwvmeet_end_date` date DEFAULT NULL,
`lwvmeet_mon_day` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvmeet_tue_day` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvmeet_wed_day` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvmeet_thu_day` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvmeet_fri_day` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvmeet_sat_day` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvmeet_sun_day` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvmeet_begin_time` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvmeet_end_time` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvmeet_site_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvmeet_site_desc` varchar(11) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvmeet_bldg_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvmeet_room` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `lwvmeet_begin_time` (`lwvmeet_begin_time`),
KEY `lwvmeet_bldg_code` (`lwvmeet_bldg_code`),
KEY `lwvmeet_crn` (`lwvmeet_crn`),
KEY `lwvmeet_crse_numb` (`lwvmeet_crse_numb`),
KEY `lwvmeet_end_time` (`lwvmeet_end_time`),
KEY `lwvmeet_start_date` (`lwvmeet_start_date`),
KEY `lwvmeet_subj_code` (`lwvmeet_subj_code`),
KEY `lwvmeet_term_code` (`lwvmeet_term_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `lwvsect` (
`lwvsect_crn` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvsect_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvsect_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvsect_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvsect_seq_num` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvsect_title` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvsect_dept` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvsect_ceu` bigint(22) DEFAULT NULL,
`lwvsect_change` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvsect_gradable_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvsect_max_enrl` int(4) DEFAULT NULL,
`lwvsect_enrl` int(4) DEFAULT NULL,
`lwvsect_seats_avail` int(4) DEFAULT NULL,
`lwvsect_full_title` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvsect_tagline` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvsect_desc` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvsect_notes` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvsect_prereq` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvsect_graded` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvsect_edtogo_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvsect_online` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvsect_ssts_code` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvsect_reg_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvsect_sess_code` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`lwvsect_type` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `lwvsect_edtogo_code` (`lwvsect_edtogo_code`),
KEY `lwvsect_ssts_code` (`lwvsect_ssts_code`),
KEY `lwvsect_term_code` (`lwvsect_term_code`,`lwvsect_crn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `nwroffc` (
`nwroffc_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`nwroffc_pidm` int(8) DEFAULT NULL,
`nwroffc_con_no` int(4) DEFAULT NULL,
`nwroffc_from_date` date DEFAULT NULL,
`nwroffc_to_date` date DEFAULT NULL,
`nwroffc_from_time` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`nwroffc_to_time` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`nwroffc_sun` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`nwroffc_mon` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`nwroffc_tue` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`nwroffc_wed` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`nwroffc_thu` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`nwroffc_fri` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`nwroffc_sat` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`nwroffc_activity_date` date DEFAULT NULL,
`nwroffc_bldg_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`nwroffc_room_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `programs` (
`prog_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`maj_name` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `prog_code` (`prog_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `pwbwadr` (
`pwbwadr_pidm` int(8) DEFAULT NULL,
`pwbwadr_last_name` varchar(60) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_first_name` varchar(60) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_mi` varchar(60) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_name_suffix` varchar(20) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_pref_first_name` varchar(60) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_name` varchar(250) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_ecls_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_ecls_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_posn` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_suff` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_org_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_dept` varchar(200) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_job_title` varchar(120) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_supervisor_pidm` int(8) DEFAULT NULL,
`pwbwadr_sup_last_name` varchar(60) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_sup_first_name` varchar(60) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_sup_name` varchar(125) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_campus_addr` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_campus_area_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_campus_phone` varchar(12) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_phone_last4` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_email_address` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_dept_chair` date DEFAULT NULL,
`pwbwadr_library_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_last_paid` date DEFAULT NULL,
`pwbwadr_activity_date` date DEFAULT NULL,
`pwbwadr_ua_only` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_mail_drop` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_derived_supervisor` int(8) DEFAULT NULL,
`pwbwadr_derived_sup_last_name` varchar(60) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_derived_sup_first_name` varchar(60) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwbwadr_grade_step` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `pwbwadr_pidm` (`pwbwadr_pidm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `pwvwage` (
`pwvwage_category` varchar(29) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwvwage_ecls` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwvwage_sal_grade` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwvwage_title` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`pwvwage_count` bigint(22) DEFAULT NULL,
`pwvwage_low` bigint(22) DEFAULT NULL,
`pwvwage_high` bigint(22) DEFAULT NULL,
`pwvwage_per` char(16) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `pwvwage_category` (`pwvwage_category`),
KEY `pwvwage_title` (`pwvwage_title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `scbcrse` (
`scbcrse_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_eff_term` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_coll_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_divs_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_dept_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_csta_code` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_title` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_cipc_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_credit_hr_ind` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_credit_hr_low` decimal(7,3) DEFAULT NULL,
`scbcrse_credit_hr_high` decimal(7,3) DEFAULT NULL,
`scbcrse_lec_hr_ind` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_lec_hr_low` decimal(7,3) DEFAULT NULL,
`scbcrse_lec_hr_high` decimal(7,3) DEFAULT NULL,
`scbcrse_lab_hr_ind` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_lab_hr_low` decimal(7,3) DEFAULT NULL,
`scbcrse_lab_hr_high` decimal(7,3) DEFAULT NULL,
`scbcrse_oth_hr_ind` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_oth_hr_low` decimal(7,3) DEFAULT NULL,
`scbcrse_oth_hr_high` decimal(7,3) DEFAULT NULL,
`scbcrse_bill_hr_ind` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_bill_hr_low` decimal(7,3) DEFAULT NULL,
`scbcrse_bill_hr_high` decimal(7,3) DEFAULT NULL,
`scbcrse_aprv_code` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_repeat_limit` int(2) DEFAULT NULL,
`scbcrse_pwav_code` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_tuiw_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_add_fees_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_activity_date` date DEFAULT NULL,
`scbcrse_cont_hr_low` decimal(7,3) DEFAULT NULL,
`scbcrse_cont_hr_ind` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_cont_hr_high` decimal(7,3) DEFAULT NULL,
`scbcrse_ceu_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_reps_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_max_rpt_units` decimal(9,3) DEFAULT NULL,
`scbcrse_capp_prereq_test_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_dunt_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_number_of_units` decimal(7,2) DEFAULT NULL,
`scbcrse_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_prereq_chk_method_cde` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_surrogate_id` bigint(19) DEFAULT NULL,
`scbcrse_version` bigint(19) DEFAULT NULL,
`scbcrse_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_credit_status_code` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_crfm_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_mult_fam_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbcrse_repeat_cde` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `scbcrse_crse_numb` (`scbcrse_crse_numb`),
KEY `scbcrse_eff_term` (`scbcrse_eff_term`),
KEY `scbcrse_subj_code` (`scbcrse_subj_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `scbdesc` (
`scbdesc_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbdesc_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbdesc_term_code_eff` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scbdesc_text_narrative` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `scbdesc_crse_numb` (`scbdesc_crse_numb`),
KEY `scbdesc_subj_code` (`scbdesc_subj_code`),
KEY `scbdesc_term_code_eff` (`scbdesc_term_code_eff`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `scrattr` (
`scrattr_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrattr_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrattr_eff_term` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrattr_attr_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrattr_activity_date` date DEFAULT NULL,
`scrattr_surrogate_id` bigint(19) DEFAULT NULL,
`scrattr_version` bigint(19) DEFAULT NULL,
`scrattr_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrattr_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrattr_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `scrattr_attr_code` (`scrattr_attr_code`),
KEY `scrattr_crse_numb` (`scrattr_crse_numb`),
KEY `scrattr_eff_term` (`scrattr_eff_term`),
KEY `scrattr_subj_code` (`scrattr_subj_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `scrcorq` (
`scrcorq_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrcorq_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrcorq_eff_term` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrcorq_subj_code_corq` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrcorq_crse_numb_corq` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrcorq_activity_date` date DEFAULT NULL,
`scrcorq_surrogate_id` bigint(19) DEFAULT NULL,
`scrcorq_version` bigint(19) DEFAULT NULL,
`scrcorq_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrcorq_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrcorq_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `scrcorq_crse_numb` (`scrcorq_crse_numb`),
KEY `scrcorq_eff_term` (`scrcorq_eff_term`),
KEY `scrcorq_subj_code` (`scrcorq_subj_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `scrlevl` (
`scrlevl_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrlevl_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrlevl_eff_term` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrlevl_levl_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrlevl_activity_date` date DEFAULT NULL,
`scrlevl_surrogate_id` bigint(19) DEFAULT NULL,
`scrlevl_version` bigint(19) DEFAULT NULL,
`scrlevl_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrlevl_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrlevl_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `scrlevl_crse_numb` (`scrlevl_crse_numb`),
KEY `scrlevl_eff_term` (`scrlevl_eff_term`),
KEY `scrlevl_levl_code` (`scrlevl_levl_code`),
KEY `scrlevl_subj_code` (`scrlevl_subj_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `scrschd` (
`scrschd_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrschd_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrschd_eff_term` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrschd_schd_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrschd_activity_date` date DEFAULT NULL,
`scrschd_workload` decimal(9,3) DEFAULT NULL,
`scrschd_max_enrl` int(3) DEFAULT NULL,
`scrschd_adj_workload` decimal(9,3) DEFAULT NULL,
`scrschd_insm_code` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrschd_surrogate_id` bigint(19) DEFAULT NULL,
`scrschd_version` bigint(19) DEFAULT NULL,
`scrschd_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrschd_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrschd_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `scrschd_crse_numb` (`scrschd_crse_numb`),
KEY `scrschd_subj_code` (`scrschd_subj_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `scrsyln` (
`scrsyln_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrsyln_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrsyln_term_code_eff` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrsyln_activity_date` date DEFAULT NULL,
`scrsyln_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrsyln_term_code_end` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrsyln_long_course_title` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrsyln_course_url` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrsyln_surrogate_id` bigint(19) DEFAULT NULL,
`scrsyln_version` bigint(19) DEFAULT NULL,
`scrsyln_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`scrsyln_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `scrsyln_crse_numb` (`scrsyln_crse_numb`),
KEY `scrsyln_subj_code` (`scrsyln_subj_code`),
KEY `scrsyln_term_code_eff` (`scrsyln_term_code_eff`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `sfrctrl` (
`sfrctrl_term_code_host` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sfrctrl_begin_date` date DEFAULT NULL,
`sfrctrl_end_date` date DEFAULT NULL,
`sfrctrl_stud_type_1` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `sfrctrl_begin_date` (`sfrctrl_begin_date`),
KEY `sfrctrl_stud_type_1` (`sfrctrl_stud_type_1`),
KEY `sfrctrl_term_code_host` (`sfrctrl_term_code_host`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `sfrrsts` (
`sfrrsts_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sfrrsts_ptrm_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sfrrsts_rsts_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sfrrsts_start_date` date DEFAULT NULL,
`sfrrsts_end_date` date DEFAULT NULL,
`sfrrsts_eff_by_enrl_stat` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sfrrsts_activity_date` date DEFAULT NULL,
`sfrrsts_vr_elig_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sfrrsts_surrogate_id` bigint(19) DEFAULT NULL,
`sfrrsts_version` bigint(19) DEFAULT NULL,
`sfrrsts_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sfrrsts_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sfrrsts_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `sfrrsts_ptrm_code` (`sfrrsts_ptrm_code`),
KEY `sfrrsts_rsts_code` (`sfrrsts_rsts_code`),
KEY `sfrrsts_term_code` (`sfrrsts_term_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `sfrstcr` (
`sfrstcr_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sfrstcr_crn` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sfrstcr_pidm` int(8) DEFAULT NULL,
`sfrstcr_levl_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sfrstcr_credit_hr` decimal(7,3) DEFAULT NULL,
`sfrstcr_rsts_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sfrstcr_grde_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sfrstcr_grde_date` date DEFAULT NULL,
KEY `sfrstcr_crn` (`sfrstcr_crn`),
KEY `sfrstcr_grde_code` (`sfrstcr_grde_code`),
KEY `sfrstcr_grde_date` (`sfrstcr_grde_date`),
KEY `sfrstcr_pidm` (`sfrstcr_pidm`),
KEY `sfrstcr_rsts_code` (`sfrstcr_rsts_code`),
KEY `sfrstcr_term_code` (`sfrstcr_term_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `sgbstdn` (
`sgbstdn_pidm` int(8) DEFAULT NULL,
`sgbstdn_term_code_eff` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_stst_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_levl_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_styp_code` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_term_code_matric` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_term_code_admit` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_exp_grad_date` date DEFAULT NULL,
`sgbstdn_camp_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_full_part_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_sess_code` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_resd_code` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_coll_code_1` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_degc_code_1` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_majr_code_1` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_majr_code_minr_1` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_majr_code_minr_1_2` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_majr_code_conc_1` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_majr_code_conc_1_2` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_majr_code_conc_1_3` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_coll_code_2` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_degc_code_2` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_majr_code_2` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_majr_code_minr_2` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_majr_code_minr_2_2` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_majr_code_conc_2` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_majr_code_conc_2_2` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_majr_code_conc_2_3` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_orsn_code` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_prac_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_advr_pidm` int(8) DEFAULT NULL,
`sgbstdn_grad_credit_appr_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_capl_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_leav_code` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_leav_from_date` date DEFAULT NULL,
`sgbstdn_leav_to_date` date DEFAULT NULL,
`sgbstdn_astd_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_term_code_astd` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_rate_code` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_activity_date` date DEFAULT NULL,
`sgbstdn_majr_code_1_2` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_majr_code_2_2` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_edlv_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_incm_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_admt_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_emex_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_aprn_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_trcn_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_gain_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_voed_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_blck_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_term_code_grad` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_acyr_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_dept_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_site_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_dept_code_2` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_egol_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_degc_code_dual` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_levl_code_dual` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_dept_code_dual` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_coll_code_dual` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_majr_code_dual` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_bskl_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_prim_roll_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_program_1` varchar(12) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_term_code_ctlg_1` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_dept_code_1_2` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_majr_code_conc_121` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_majr_code_conc_122` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_majr_code_conc_123` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_secd_roll_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_term_code_admit_2` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_admt_code_2` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_program_2` varchar(12) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_term_code_ctlg_2` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_levl_code_2` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_camp_code_2` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_dept_code_2_2` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_majr_code_conc_221` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_majr_code_conc_222` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_majr_code_conc_223` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_curr_rule_1` int(8) DEFAULT NULL,
`sgbstdn_cmjr_rule_1_1` int(8) DEFAULT NULL,
`sgbstdn_ccon_rule_11_1` int(8) DEFAULT NULL,
`sgbstdn_ccon_rule_11_2` int(8) DEFAULT NULL,
`sgbstdn_ccon_rule_11_3` int(8) DEFAULT NULL,
`sgbstdn_cmjr_rule_1_2` int(8) DEFAULT NULL,
`sgbstdn_ccon_rule_12_1` int(8) DEFAULT NULL,
`sgbstdn_ccon_rule_12_2` int(8) DEFAULT NULL,
`sgbstdn_ccon_rule_12_3` int(8) DEFAULT NULL,
`sgbstdn_cmnr_rule_1_1` int(8) DEFAULT NULL,
`sgbstdn_cmnr_rule_1_2` int(8) DEFAULT NULL,
`sgbstdn_curr_rule_2` int(8) DEFAULT NULL,
`sgbstdn_cmjr_rule_2_1` int(8) DEFAULT NULL,
`sgbstdn_ccon_rule_21_1` int(8) DEFAULT NULL,
`sgbstdn_ccon_rule_21_2` int(8) DEFAULT NULL,
`sgbstdn_ccon_rule_21_3` int(8) DEFAULT NULL,
`sgbstdn_cmjr_rule_2_2` int(8) DEFAULT NULL,
`sgbstdn_ccon_rule_22_1` int(8) DEFAULT NULL,
`sgbstdn_ccon_rule_22_2` int(8) DEFAULT NULL,
`sgbstdn_ccon_rule_22_3` int(8) DEFAULT NULL,
`sgbstdn_cmnr_rule_2_1` int(8) DEFAULT NULL,
`sgbstdn_cmnr_rule_2_2` int(8) DEFAULT NULL,
`sgbstdn_prev_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_term_code_prev` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_cast_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_term_code_cast` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_scpc_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_surrogate_id` bigint(19) DEFAULT NULL,
`sgbstdn_version` bigint(19) DEFAULT NULL,
`sgbstdn_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sgbstdn_guid` varchar(36) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sorhsch_pidm` int(8) DEFAULT NULL,
`sorhsch_sbgi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sorhsch_graduation_date` date DEFAULT NULL,
`sorhsch_gpa` varchar(24) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sorhsch_class_rank` int(4) DEFAULT NULL,
`sorhsch_class_size` int(4) DEFAULT NULL,
`sorhsch_percentile` decimal(5,2) DEFAULT NULL,
`sorhsch_dplm_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sorhsch_coll_prep_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sorhsch_trans_recv_date` date DEFAULT NULL,
`sorhsch_activity_date` date DEFAULT NULL,
`sorhsch_admr_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sorhsch_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sorhsch_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sorhsch_surrogate_id` bigint(19) DEFAULT NULL,
`sorhsch_version` bigint(19) DEFAULT NULL,
`sorhsch_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sorhsch_guid` varchar(36) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sorhsch_cred_guid` varchar(36) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sorhsch_total_credits` decimal(7,3) DEFAULT NULL,
`sorhsch_grade_completed` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`maxeff` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `sibinst` (
`sibinst_pidm` int(8) DEFAULT NULL,
`sibinst_term_code_eff` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sibinst_fctg_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `sibinst_fctg_code` (`sibinst_fctg_code`),
KEY `sibinst_pidm` (`sibinst_pidm`),
KEY `sibinst_term_code_eff` (`sibinst_term_code_eff`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `sirasgn` (
`sirasgn_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sirasgn_crn` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sirasgn_pidm` int(8) DEFAULT NULL,
`sirasgn_category` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `sirasgn_crn` (`sirasgn_crn`),
KEY `sirasgn_pidm` (`sirasgn_pidm`),
KEY `sirasgn_term_code` (`sirasgn_term_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `slbbldg` (
`slbbldg_bldg_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_camp_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_capacity` int(5) DEFAULT NULL,
`slbbldg_maximum_capacity` int(5) DEFAULT NULL,
`slbbldg_rrcd_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_prcd_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_site_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_street_line1` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_street_line2` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_street_line3` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_city` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_stat_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_zip` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_cnty_code` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_phone_area` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_phone_number` varchar(12) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_phone_extension` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_activity_date` date DEFAULT NULL,
`slbbldg_sex` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_coll_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_dept_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_key_number` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_pars_code` varchar(7) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_ctry_code_phone` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_house_number` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_street_line4` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_surrogate_id` bigint(19) DEFAULT NULL,
`slbbldg_version` bigint(19) DEFAULT NULL,
`slbbldg_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_cent_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbbldg_leased_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `slbbldg_bldg_code` (`slbbldg_bldg_code`),
KEY `slbbldg_sex` (`slbbldg_sex`),
KEY `slbbldg_stat_code` (`slbbldg_stat_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `slbevnt` (
`slbevnt_crn` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_etyp_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_agency_pidm` int(8) DEFAULT NULL,
`slbevnt_contact_name` varchar(230) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_camp_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_site_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_coll_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_dept_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_activity_date` date DEFAULT NULL,
`slbevnt_phone_area` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_phone` varchar(12) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_phone_ext` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_contact_pidm` int(8) DEFAULT NULL,
`slbevnt_atyp_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_sysi_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_comm_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_dicd_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_ctry_code_phone` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_surrogate_id` bigint(19) DEFAULT NULL,
`slbevnt_version` bigint(19) DEFAULT NULL,
`slbevnt_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_contact_email` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_long_description` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_restricted_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_publish_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`slbevnt_limit_one` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `sobptrm` (
`sobptrm_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobptrm_ptrm_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobptrm_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobptrm_start_date` date DEFAULT NULL,
`sobptrm_end_date` date DEFAULT NULL,
`sobptrm_reg_allowed` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobptrm_weeks` int(3) DEFAULT NULL,
`sobptrm_census_date` date DEFAULT NULL,
`sobptrm_activity_date` date DEFAULT NULL,
`sobptrm_sect_over_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobptrm_census_2_date` date DEFAULT NULL,
`sobptrm_mgrd_web_upd_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobptrm_fgrd_web_upd_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobptrm_waitlst_web_disp_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobptrm_incomplete_ext_date` date DEFAULT NULL,
`sobptrm_surrogate_id` bigint(19) DEFAULT NULL,
`sobptrm_version` bigint(19) DEFAULT NULL,
`sobptrm_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobptrm_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobptrm_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobptrm_final_grde_pub_date` date DEFAULT NULL,
`sobptrm_det_grde_pub_date` date DEFAULT NULL,
`sobptrm_reas_grde_pub_date` date DEFAULT NULL,
`sobptrm_reas_det_grde_pub_date` date DEFAULT NULL,
`sobptrm_score_open_date` date DEFAULT NULL,
`sobptrm_score_cutoff_date` date DEFAULT NULL,
`sobptrm_reas_score_open_date` date DEFAULT NULL,
`sobptrm_reas_score_cutoff_date` date DEFAULT NULL,
`sobptrm_enrl_cutoff_date` date DEFAULT NULL,
`sobptrm_refund_cutoff_date` date DEFAULT NULL,
`sobptrm_acad_cutoff_date` date DEFAULT NULL,
`sobptrm_drop_cutoff_date` date DEFAULT NULL,
`sobptrm_acad_cut_off_date` date DEFAULT NULL,
`sobptrm_drop_cut_off_date` date DEFAULT NULL,
`sobptrm_enrl_cut_off_date` date DEFAULT NULL,
`sobptrm_refund_cut_off_date` date DEFAULT NULL,
KEY `sobptrm_ptrm_code` (`sobptrm_ptrm_code`),
KEY `sobptrm_term_code` (`sobptrm_term_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `soq_online_exceptions` (
`soq_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`soq_crn` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`soq_seq_numb` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`soq_instructor_pidm` int(8) DEFAULT NULL,
`soq_activity_date` date DEFAULT NULL,
`soq_activity_user` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `sorhsch` (
`sorhsch_pidm` int(8) DEFAULT NULL,
`sorhsch_sbgi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sorhsch_graduation_date` date DEFAULT NULL,
KEY `sorhsch_pidm` (`sorhsch_pidm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `sorrtrm` (
`sorrtrm_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sorrtrm_start_date` date DEFAULT NULL,
`sorrtrm_end_date` date DEFAULT NULL,
`sorrtrm_activity_date` date DEFAULT NULL,
`sorrtrm_surrogate_id` bigint(19) DEFAULT NULL,
`sorrtrm_version` bigint(19) DEFAULT NULL,
`sorrtrm_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sorrtrm_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sorrtrm_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `sorrtrm_term_code` (`sorrtrm_term_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `spriden` (
`spriden_pidm` int(8) DEFAULT NULL,
`spriden_id` varchar(9) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`spriden_last_name` varchar(60) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`spriden_first_name` varchar(60) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`spriden_mi` varchar(60) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `spriden_first_name` (`spriden_first_name`),
KEY `spriden_id` (`spriden_id`),
KEY `spriden_last_name` (`spriden_last_name`),
KEY `spriden_pidm` (`spriden_pidm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `ssbsect` (
`ssbsect_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssbsect_crn` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssbsect_ptrm_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssbsect_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssbsect_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssbsect_seq_numb` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssbsect_crse_title` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssbsect_credit_hrs` decimal(7,3) DEFAULT NULL,
`ssbsect_prnt_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssbsect_max_enrl` int(4) DEFAULT NULL,
`ssbsect_enrl` int(4) DEFAULT NULL,
`ssbsect_seats_avail` int(4) DEFAULT NULL,
`ssbsect_wait_capacity` int(4) DEFAULT NULL,
`ssbsect_wait_count` int(4) DEFAULT NULL,
`ssbsect_wait_avail` int(4) DEFAULT NULL,
`ssbsect_ssts_code` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssbsect_sapr_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssbsect_ptrm_start_date` date DEFAULT NULL,
`ssbsect_ptrm_end_date` date DEFAULT NULL,
`ssbsect_schd_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssbsect_link_ident` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `ssbsect_crn` (`ssbsect_crn`),
KEY `ssbsect_crse_numb` (`ssbsect_crse_numb`),
KEY `ssbsect_prnt_ind` (`ssbsect_prnt_ind`),
KEY `ssbsect_ptrm_code` (`ssbsect_ptrm_code`),
KEY `ssbsect_ssts_code` (`ssbsect_ssts_code`),
KEY `ssbsect_subj_code` (`ssbsect_subj_code`),
KEY `ssbsect_term_code` (`ssbsect_term_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `ssbxlst` (
`ssbxlst_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssbxlst_xlst_group` varchar(15) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssbxlst_max_enrl` int(4) DEFAULT NULL,
`ssbxlst_enrl` int(4) DEFAULT NULL,
`ssbxlst_seats_avail` int(4) DEFAULT NULL,
KEY `ssbxlst_term_code` (`ssbxlst_term_code`),
KEY `ssbxlst_xlst_group` (`ssbxlst_xlst_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `ssrattr` (
`ssrattr_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrattr_crn` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrattr_attr_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrattr_activity_date` date DEFAULT NULL,
`ssrattr_surrogate_id` bigint(19) DEFAULT NULL,
`ssrattr_version` bigint(19) DEFAULT NULL,
`ssrattr_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrattr_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrattr_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `ssrfees` (
`ssrfees_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrfees_crn` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrfees_detl_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrfees_amount` decimal(12,2) DEFAULT NULL,
`ssrfees_ftyp_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `ssrfees_crn` (`ssrfees_crn`),
KEY `ssrfees_detl_code` (`ssrfees_detl_code`),
KEY `ssrfees_ftyp_code` (`ssrfees_ftyp_code`),
KEY `ssrfees_term_code` (`ssrfees_term_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `ssrmeet` (
`ssrmeet_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrmeet_crn` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrmeet_start_date` date DEFAULT NULL,
`ssrmeet_end_date` date DEFAULT NULL,
`ssrmeet_begin_time` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrmeet_end_time` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrmeet_sun_day` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrmeet_mon_day` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrmeet_tue_day` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrmeet_wed_day` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrmeet_thu_day` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrmeet_fri_day` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrmeet_sat_day` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrmeet_bldg_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrmeet_room_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrmeet_func_code` varchar(12) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrmeet_catagory` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `ssrmeet_begin_time` (`ssrmeet_begin_time`),
KEY `ssrmeet_bldg_code` (`ssrmeet_bldg_code`),
KEY `ssrmeet_crn` (`ssrmeet_crn`),
KEY `ssrmeet_fri_day` (`ssrmeet_fri_day`),
KEY `ssrmeet_mon_day` (`ssrmeet_mon_day`),
KEY `ssrmeet_sat_day` (`ssrmeet_sat_day`),
KEY `ssrmeet_sun_day` (`ssrmeet_sun_day`),
KEY `ssrmeet_term_code` (`ssrmeet_term_code`),
KEY `ssrmeet_thu_day` (`ssrmeet_thu_day`),
KEY `ssrmeet_tue_day` (`ssrmeet_tue_day`),
KEY `ssrmeet_wed_day` (`ssrmeet_wed_day`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `ssrxlst` (
`ssrxlst_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrxlst_crn` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`ssrxlst_xlst_group` varchar(15) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `ssrxlst_crn` (`ssrxlst_crn`),
KEY `ssrxlst_term_code` (`ssrxlst_term_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `student_hs_info` (
`pidm` int(8) DEFAULT NULL,
`hs_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`hs_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`hs_grad_date` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `student_info` (
`sgbstdn_pidm` int(8) DEFAULT NULL,
`sgbstdn_program_1` varchar(12) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`prog_year` char(18) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`goremal_email_address` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `sgbstdn_program_1` (`sgbstdn_program_1`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `student_programs` (
`pidm` int(8) DEFAULT NULL,
`eff_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`program_code` varchar(12) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`concentration_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`program_title` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`concentration_title` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`degree_type` varchar(60) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `pidm` (`pidm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `stvattr` (
`stvattr_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvattr_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvattr_activity_date` date DEFAULT NULL,
`stvattr_surrogate_id` bigint(19) DEFAULT NULL,
`stvattr_version` bigint(19) DEFAULT NULL,
`stvattr_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvattr_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvattr_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvattr_inmate_sect_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvattr_guid` varchar(36) COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `stvbldg` (
`stvbldg_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvbldg_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvbldg_activity_date` date DEFAULT NULL,
`stvbldg_vr_msg_no` int(6) DEFAULT NULL,
`stvbldg_surrogate_id` bigint(19) DEFAULT NULL,
`stvbldg_version` bigint(19) DEFAULT NULL,
`stvbldg_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvbldg_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvbldg_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `stvbldg_code` (`stvbldg_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `stvcnty` (
`stvcnty_code` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvcnty_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvcnty_activity_date` date DEFAULT NULL,
`stvcnty_surrogate_id` bigint(19) DEFAULT NULL,
`stvcnty_version` bigint(19) DEFAULT NULL,
`stvcnty_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvcnty_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvcnty_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvcnty_scod_code_iso` varchar(8) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvcnty_guid` varchar(36) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `stvcnty_code` (`stvcnty_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `stvdept` (
`stvdept_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvdept_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvdept_activity_date` date DEFAULT NULL,
`stvdept_system_req_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvdept_vr_msg_no` int(6) DEFAULT NULL,
`stvdept_surrogate_id` bigint(19) DEFAULT NULL,
`stvdept_version` bigint(19) DEFAULT NULL,
`stvdept_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvdept_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvdept_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `stvdept_code` (`stvdept_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `stvdivs` (
`stvdivs_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvdivs_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvdivs_activity_date` date DEFAULT NULL,
`stvdivs_surrogate_id` bigint(19) DEFAULT NULL,
`stvdivs_version` bigint(19) DEFAULT NULL,
`stvdivs_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvdivs_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvdivs_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `stvdivs_code` (`stvdivs_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `stvethn` (
`stvethn_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvethn_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `stvethn_code` (`stvethn_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `stvmajr` (
`stvmajr_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvmajr_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvmajr_cipc_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvmajr_valid_major_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvmajr_valid_minor_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvmajr_valid_concentratn_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvmajr_activity_date` date DEFAULT NULL,
`stvmajr_occupation_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvmajr_aid_eligibility_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvmajr_system_req_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvmajr_vr_msg_no` int(6) DEFAULT NULL,
`stvmajr_disp_web_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvmajr_sevis_equiv` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvmajr_surrogate_id` bigint(19) DEFAULT NULL,
`stvmajr_version` bigint(19) DEFAULT NULL,
`stvmajr_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvmajr_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvmajr_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvmajr_tops_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvmajr_major_desc` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvmajr_minor_desc` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvmajr_concentration_desc` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `stvmajr_aid_eligibility_ind` (`stvmajr_aid_eligibility_ind`),
KEY `stvmajr_code` (`stvmajr_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `stvnatn` (
`stvnatn_code` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvnatn_nation` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvnatn_capital` varchar(20) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvnatn_area` bigint(22) DEFAULT NULL,
`stvnatn_population` bigint(22) DEFAULT NULL,
`stvnatn_activity_date` date DEFAULT NULL,
`stvnatn_edi_equiv` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvnatn_lms_equiv` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvnatn_postal_mask` varchar(15) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvnatn_tele_mask` varchar(15) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvnatn_statscan_cde` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvnatn_scod_code_iso` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvnatn_ssa_reporting_equiv` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvnatn_sevis_equiv` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvnatn_surrogate_id` bigint(19) DEFAULT NULL,
`stvnatn_version` bigint(19) DEFAULT NULL,
`stvnatn_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvnatn_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvnatn_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvnatn_guid` varchar(36) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `stvnatn_code` (`stvnatn_code`),
KEY `stvnatn_nation` (`stvnatn_nation`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `stvrsts` (
`stvrsts_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_enterable_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_incl_sect_enrl` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_incl_assess` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_auto_grade` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_gradable_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_activity_date` date DEFAULT NULL,
`stvrsts_wait_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_system_req_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_voice_type` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_sb_print_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_withdraw_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_web_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_extension_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_attempt_hr_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_incl_tmst_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_surrogate_id` bigint(19) DEFAULT NULL,
`stvrsts_version` bigint(19) DEFAULT NULL,
`stvrsts_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_action_desc` varchar(120) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_apport_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_audit_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvrsts_mis_bogw_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `stvrsts_code` (`stvrsts_code`),
KEY `stvrsts_incl_sect_enrl` (`stvrsts_incl_sect_enrl`),
KEY `stvrsts_withdraw_ind` (`stvrsts_withdraw_ind`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `stvschd` (
`stvschd_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvschd_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvschd_activity_date` date DEFAULT NULL,
`stvschd_instruct_method` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvschd_coop_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvschd_auto_scheduler_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvschd_insm_code` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvschd_vr_msg_no` int(6) DEFAULT NULL,
`stvschd_surrogate_id` bigint(19) DEFAULT NULL,
`stvschd_version` bigint(19) DEFAULT NULL,
`stvschd_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvschd_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvschd_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `stvschd_code` (`stvschd_code`),
KEY `stvschd_desc` (`stvschd_desc`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `stvstat` (
`stvstat_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvstat_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvstat_activity_date` date DEFAULT NULL,
`stvstat_edi_equiv` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvstat_statscan_cde` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvstat_ipeds_cde` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvstat_surrogate_id` bigint(19) DEFAULT NULL,
`stvstat_version` bigint(19) DEFAULT NULL,
`stvstat_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvstat_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvstat_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvstat_scod_code_iso` varchar(8) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvstat_guid` varchar(36) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `stvstat_code` (`stvstat_code`),
KEY `stvstat_desc` (`stvstat_desc`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `stvsubj` (
`stvsubj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsubj_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsubj_activity_date` date DEFAULT NULL,
`stvsubj_vr_msg_no` int(6) DEFAULT NULL,
`stvsubj_disp_web_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsubj_surrogate_id` bigint(19) DEFAULT NULL,
`stvsubj_version` bigint(19) DEFAULT NULL,
`stvsubj_user_id` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsubj_data_origin` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsubj_vpdi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `stvsubj_code` (`stvsubj_code`),
KEY `stvsubj_desc` (`stvsubj_desc`),
KEY `stvsubj_disp_web_ind` (`stvsubj_disp_web_ind`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `stvterm` (
`stvterm_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvterm_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvterm_start_date` date DEFAULT NULL,
`stvterm_end_date` date DEFAULT NULL,
`stvterm_fa_proc_yr` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvterm_acyr_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `stvterm_acyr_code` (`stvterm_acyr_code`),
KEY `stvterm_code` (`stvterm_code`),
KEY `stvterm_end_date` (`stvterm_end_date`),
KEY `stvterm_start_date` (`stvterm_start_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swbcrmt2` (
`swbcrmt2_id` bigint(10) DEFAULT NULL,
`swbcrmt2_author` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcrmt2_mtrl_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcrmt2_title` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcrmt2_publisher` varchar(70) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcrmt2_isbn_no` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcrmt2_edition` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcrmt2_paperback_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcrmt2_required` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcrmt2_optional` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcrmt2_notes` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcrmt2_created_date` date DEFAULT NULL,
`swbcrmt2_created_user_id` bigint(22) DEFAULT NULL,
`swbcrmt2_activity_date` date DEFAULT NULL,
`swbcrmt2_changed_user_id` bigint(22) DEFAULT NULL,
`swbcrmt2_materials` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `swbcrmt2_id` (`swbcrmt2_id`),
KEY `swbcrmt2_mtrl_code` (`swbcrmt2_mtrl_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swbcurrccrs` (
`swbcurrccrs_print_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrccrs_web_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrccrs_subj_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrccrs_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrccrs_eff_term` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrccrs_ncd` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrccrs_inactive_term` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrccrs_cond_term` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrccrs_reactive_term` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrccrs_leveli_prereq` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrccrs_levelii_prereq` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrccrs_honors_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrccrs_college_level_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrccrs_no_basic_skill_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrccrs_basic_skill_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrccrs_clin_hrs` decimal(6,2) DEFAULT NULL,
`swbcurrccrs_other` decimal(6,2) DEFAULT NULL,
`swbcurrccrs_activity_date` date DEFAULT NULL,
`swbcurrccrs_enter_user` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrccrs_modify_user` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrccrs_general_educ_notes` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrccrs_macrao_notes` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrccrs_dl_csdesc_addendum` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `swbcurrccrs_crse_numb` (`swbcurrccrs_crse_numb`),
KEY `swbcurrccrs_eff_term` (`swbcurrccrs_eff_term`),
KEY `swbcurrccrs_subj_subj_code` (`swbcurrccrs_subj_subj_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swbcurrprog` (
`swbcurrprog_prgt_code` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_degr_dlev_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_degt_degc_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_eff_term` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_majr_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_stat_code` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_orig_year` int(4) DEFAULT NULL,
`swbcurrprog_divi_divs_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_depi_dept_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_advis_name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_acrd_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_acrd_date` varchar(15) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_acrd_rev_date` varchar(15) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_stat_cip` varchar(7) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_stat_aprv_date` varchar(15) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_stat_last_rev_date` varchar(15) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_stat_next_rev_date` varchar(15) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_active_year` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_inactive_year` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_stat_pin` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_conc_credit` decimal(5,2) DEFAULT NULL,
`swbcurrprog_conc_option_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_degr_level` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_prog_desc` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_artic` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_admreq` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_admnotes` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_cereq` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_foot_notes` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_conc_state` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_prev_award_type` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_prev_major_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_prev_title` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_new_award_type` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_new_major_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_new_title` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_related_award_type` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_related_major_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_related_title` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_area_code` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_catalog_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_activity_date` date DEFAULT NULL,
`swbcurrprog_enter_user` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_modify_user` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_majr_code_artic` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_offrd_online` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_high_wage` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_high_demand` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_high_skill` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_artic_degree` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_gain_emp_cert` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swbcurrprog_gain_emp_active` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `swbcurrprog_degr_dlev_code` (`swbcurrprog_degr_dlev_code`,`swbcurrprog_majr_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swbnetid` (
`swbnetid_pidm` int(8) DEFAULT NULL,
`swbnetid_netid` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swrbkcost` (
`swrbkcost_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrbkcost_crn` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrbkcost_cost_option` varchar(15) COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swrbkcrn` (
`swrbkcrn_id` bigint(10) DEFAULT NULL,
`swrbkcrn_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrbkcrn_crn` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrbkcrn_estimated_cost` int(4) DEFAULT NULL,
`swrbkcrn_notes` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrbkcrn_cost_option` varchar(15) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `swrbkcrn_crn` (`swrbkcrn_crn`),
KEY `swrbkcrn_id` (`swrbkcrn_id`),
KEY `swrbkcrn_term_code` (`swrbkcrn_term_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swrcurrconc` (
`swrcurrconc_degr_dlev_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrconc_majr_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrconc_eff_term` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrconc_code` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrconc_name` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrconc_depi_dept_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrconc_advis` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrconc_foot_note` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrconc_order` int(2) DEFAULT NULL,
`swrcurrconc_activity_date` date DEFAULT NULL,
`swrcurrconc_enter_user` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrconc_modify_user` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `swrcurrconc_code` (`swrcurrconc_code`),
KEY `swrcurrconc_eff_term` (`swrcurrconc_eff_term`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swrcurrkwds` (
`rownum` int(11) DEFAULT NULL,
`swrcurrkwds_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrkwds_keyword` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `swrcurrkwds_code` (`swrcurrkwds_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swrcurrpcrs` (
`swrcurrpcrs_degr_dlev_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrpcrs_majr_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrpcrs_eff_term` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrpcrs_crst_code` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrpcrs_subj_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrpcrs_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrpcrs_foot_note` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrpcrs_aor` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrpcrs_seqc_code` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrpcrs_order` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrpcrs_elec_desc` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrpcrs_min_credit` decimal(5,2) DEFAULT NULL,
`swrcurrpcrs_max_credit` decimal(5,2) DEFAULT NULL,
`swrcurrpcrs_conc_code` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrpcrs_activity_date` date DEFAULT NULL,
`swrcurrpcrs_enter_user` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrpcrs_modify_user` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `swrcurrpcrs_conc_code` (`swrcurrpcrs_conc_code`),
KEY `swrcurrpcrs_crse_numb` (`swrcurrpcrs_crse_numb`),
KEY `swrcurrpcrs_degr_dlev_code` (`swrcurrpcrs_degr_dlev_code`),
KEY `swrcurrpcrs_eff_term` (`swrcurrpcrs_eff_term`),
KEY `swrcurrpcrs_majr_code` (`swrcurrpcrs_majr_code`),
KEY `swrcurrpcrs_subj_subj_code` (`swrcurrpcrs_subj_subj_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swrcurrprgs` (
`swrcurrprgs_award_type` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrprgs_major_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrprgs_eff_term` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrprgs_school_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrprgs_sub_school_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrprgs_activity_date` date DEFAULT NULL,
`swrcurrprgs_enter_user` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrcurrprgs_modify_user` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `swrcurrprgs_award_type` (`swrcurrprgs_award_type`),
KEY `swrcurrprgs_eff_term` (`swrcurrprgs_eff_term`),
KEY `swrcurrprgs_major_code` (`swrcurrprgs_major_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swrschdtrm` (
`swrschdtrm_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrschdtrm_disp_date` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swrsupply` (
`swrsupply_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrsupply_crn` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrsupply_quantity` int(5) DEFAULT NULL,
`swrsupply_item` varchar(25) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrsupply_desc` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrsupply_at_bkstore` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrsupply_est_price` varchar(35) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrsupply_required` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrsupply_store_notes` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swrsupply_stu_notes` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `swrsupply_crn` (`swrsupply_crn`),
KEY `swrsupply_term_code` (`swrsupply_term_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swvcoll` (
`stvsbgi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_type_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_srce_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_desc` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_activity_date` date DEFAULT NULL,
`stvsbgi_admr_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_edi_capable` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_fice` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_vr_msg_no` int(6) DEFAULT NULL,
`stvsbgi_disp_web_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_sbgi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_street_line1` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_street_line2` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_street_line3` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_city` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_stat_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_cnty_code` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_zip` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_natn_code` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_activity_date` date DEFAULT NULL,
KEY `sobsbgi_stat_code` (`sobsbgi_stat_code`),
KEY `stvsbgi_code` (`stvsbgi_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swvcurrcrst` (
`swvcurrcrst_code` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swvcurrcrst_desc` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swvcurrcrst_sort_ord` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `swvcurrcrst_code` (`swvcurrcrst_code`),
KEY `swvcurrcrst_sort_ord` (`swvcurrcrst_sort_ord`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swvcurrdegr` (
`swvcurrdegr_dlev_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swvcurrdegr_long_desc` varchar(60) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swvcurrdegr_activity_date` date DEFAULT NULL,
`swvcurrdegr_enter_user` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swvcurrdegr_modify_user` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `swvcurrdegr_dlev_code` (`swvcurrdegr_dlev_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swvcurrmajr` (
`swvcurrmajr_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swvcurrmajr_long_desc` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swvcurrmajr_activity_date` date DEFAULT NULL,
`swvcurrmajr_enter_user` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swvcurrmajr_modify_user` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `swvcurrmajr_code` (`swvcurrmajr_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swvcurrschl` (
`swvcurrschl_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swvcurrschl_desc` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swvcurrschl_activity_date` date DEFAULT NULL,
`swvcurrschl_enter_user` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swvcurrschl_modify_user` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swvcurrschl_narrative` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swvcurrschl_ispathway` int(1) DEFAULT NULL,
KEY `swvcurrschl_code` (`swvcurrschl_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swvcurrsubs` (
`swvcurrsubs_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swvcurrsubs_desc` varchar(200) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swvcurrsubs_activity_date` date DEFAULT NULL,
`swvcurrsubs_enter_user` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swvcurrsubs_modify_user` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`swvcurrsubs_narrative` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `swvcurrsubs_code` (`swvcurrsubs_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swvmicollege` (
`stvsbgi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_type_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_srce_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_desc` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_activity_date` date DEFAULT NULL,
`stvsbgi_admr_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_edi_capable` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_fice` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_vr_msg_no` int(6) DEFAULT NULL,
`stvsbgi_disp_web_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_sbgi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_street_line1` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_street_line2` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_street_line3` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_city` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_stat_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_cnty_code` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_zip` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_natn_code` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_activity_date` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swvmihs` (
`stvsbgi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_type_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_srce_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_desc` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_activity_date` date DEFAULT NULL,
`stvsbgi_admr_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_edi_capable` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_fice` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`stvsbgi_vr_msg_no` int(6) DEFAULT NULL,
`stvsbgi_disp_web_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_sbgi_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_street_line1` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_street_line2` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_street_line3` varchar(75) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_city` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_stat_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_cnty_code` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_zip` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_natn_code` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`sobsbgi_activity_date` date DEFAULT NULL,
KEY `stvsbgi_code` (`stvsbgi_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `swvpers` (
`spbpers_pidm` int(8) DEFAULT NULL,
`spbpers_pref_first_name` varchar(60) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `spbpers_pidm` (`spbpers_pidm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `tbbdetc` (
`tbbdetc_detail_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`tbbdetc_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `tbbdetc_detail_code` (`tbbdetc_detail_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `wsrcrse` (
`wsrcrse_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_crn` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_ptrm_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_first_name` varchar(60) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_last_name` varchar(60) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_begin_time` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_end_time` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_start_date` date DEFAULT NULL,
`wsrcrse_bldg_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_room_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_max_enrl` int(4) DEFAULT NULL,
`wsrcrse_seats_avail` int(4) DEFAULT NULL,
`wsrcrse_enrl` int(4) DEFAULT NULL,
`wsrcrse_seq_numb` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_days` varchar(7) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_end_date` date DEFAULT NULL,
`wsrcrse_levl_code` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_divs_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_dept_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_asgn_over_ride` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_meet_over_ride` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_changes` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_title` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_site_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_site_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_credits` varchar(84) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_dept_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_divs_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_xlst_max_enrl` int(4) DEFAULT NULL,
`wsrcrse_xlst_enrl` int(4) DEFAULT NULL,
`wsrcrse_xlst_seats_avail` int(4) DEFAULT NULL,
`wsrcrse_xlst_group` varchar(15) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_ssts_code` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_pidm` int(8) DEFAULT NULL,
`wsrcrse_gradable_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_csta_code` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_wait_count` int(4) DEFAULT NULL,
`wsrcrse_wait_avail` int(4) DEFAULT NULL,
`wsrcrse_ptrm_start_date` date DEFAULT NULL,
`wsrcrse_ptrm_end_date` date DEFAULT NULL,
`wsrcrse_enrl_cut_off_date` date DEFAULT NULL,
`wsrcrse_census_2_enrl` int(4) DEFAULT NULL,
`wsrcrse_capp_prereq_test_ind` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_instructor_id` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsrcrse_emrt_enrl` int(4) DEFAULT NULL,
`wsrcrse_wtmc_enrl` int(4) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `wsvcatl` (
`wsvcatl_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvcatl_crn` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvcatl_sub_crse` varchar(37) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvcatl_seq_num` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvcatl_title` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvcatl_credits` varchar(84) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvcatl_days` varchar(7) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvcatl_time` varchar(11) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvcatl_room` varchar(16) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvcatl_location` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvcatl_instructor` varchar(249) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvcatl_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvcatl_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvcatl_dept_desc` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvcatl_status` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvcatl_ptrm_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `wsvcatl_crn` (`wsvcatl_crn`),
KEY `wsvcatl_subj_code` (`wsvcatl_subj_code`),
KEY `wsvcatl_term_code` (`wsvcatl_term_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `wsvnocr` (
`wsvnocr_crn` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvnocr_term_code` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvnocr_subj_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvnocr_crse_numb` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvnocr_seq_num` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvnocr_title` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvnocr_dept` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvnocr_ceu` varchar(40) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvnocr_detl_code` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvnocr_fee_amount` decimal(12,2) DEFAULT NULL,
`wsvnocr_start_date` date DEFAULT NULL,
`wsvnocr_end_date` date DEFAULT NULL,
`wsvnocr_date` varchar(11) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvnocr_time` varchar(11) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvnocr_bldg_room` varchar(17) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvnocr_name` varchar(121) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`wsvnocr_change` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
KEY `wsvnocr_crn` (`wsvnocr_crn`),
KEY `wsvnocr_subj_code` (`wsvnocr_subj_code`),
KEY `wsvnocr_term_code` (`wsvnocr_term_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `WUBPAPP` (
`wubpapp_local_union_number` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE TABLE `wubpapp` (
`wubpapp_local_union_number` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
CREATE ALGORITHM=UNDEFINED DEFINER=`lustark`@`%.wccnet.%` SQL SECURITY DEFINER VIEW `schedule` AS select concat(`s`.`ssbsect_term_code`,`s`.`ssbsect_crn`) AS `UID`,`s`.`ssbsect_crn` AS `section_crn`,`d`.`stvsubj_desc` AS `subject_description`,concat(`s`.`ssbsect_subj_code`,`s`.`ssbsect_crse_numb`) AS `course_uid`,concat(`s`.`ssbsect_subj_code`,`s`.`ssbsect_crse_numb`,`s`.`ssbsect_seq_numb`) AS `section_uid`,`t2`.`scrsyln_long_course_title` AS `course_title_long`,`t1`.`scbcrse_title` AS `course_title`,`d`.`stvsubj_desc` AS `subject_title`,group_concat(concat(`i2`.`spriden_first_name`,' ',`i2`.`spriden_last_name`) separator ', ') AS `instructor_names`,`s`.`ssbsect_term_code` AS `term_code`,`s`.`ssbsect_crn` AS `crn`,`s`.`ssbsect_subj_code` AS `subject`,`s`.`ssbsect_subj_code` AS `subject_text`,`s`.`ssbsect_crse_numb` AS `number`,`s`.`ssbsect_crse_numb` AS `number_text`,`s`.`ssbsect_seq_numb` AS `section`,if(`s`.`ssbsect_schd_code` = 'VL' or `s`.`ssbsect_schd_code` = 'VB' or `s`.`ssbsect_schd_code` = 'MV','vclass',if(`s`.`ssbsect_schd_code` = 'D','online',if(`s`.`ssbsect_schd_code` = 'Y' or `s`.`ssbsect_schd_code` = 'MO' or `s`.`ssbsect_schd_code` = 'MR' or `s`.`ssbsect_schd_code` = 'MB','blended','regular'))) AS `section_type`,`s`.`ssbsect_ssts_code` AS `status_code`,if(`t1`.`scbcrse_credit_hr_low` is null,`t1`.`scbcrse_credit_hr_high`,`t1`.`scbcrse_credit_hr_low`) AS `credits_low`,if(`t1`.`scbcrse_credit_hr_high` is null,`t1`.`scbcrse_credit_hr_low`,`t1`.`scbcrse_credit_hr_high`) AS `credits_high`,if(`m`.`ssrmeet_bldg_code` = 'ONLINE',1,0) AS `online`,unix_timestamp(min(concat(`m`.`ssrmeet_start_date`,' 00:00'))) AS `start_date`,unix_timestamp(max(concat(`m`.`ssrmeet_end_date`,' 23:59'))) AS `end_date`,min(`m`.`ssrmeet_begin_time`) AS `start_time`,unix_timestamp(if(`r`.`sfrrsts_end_date` is not null,`r`.`sfrrsts_end_date`,`s`.`ssbsect_ptrm_end_date`)) AS `end_reg_date`,if(`xb`.`ssbxlst_max_enrl` is not null,`xb`.`ssbxlst_max_enrl`,`s`.`ssbsect_max_enrl`) AS `max_enroll`,greatest(if(`xb`.`ssbxlst_enrl` is not null,`xb`.`ssbxlst_seats_avail`,`s`.`ssbsect_seats_avail`),0) AS `seats_avail`,`s`.`ssbsect_wait_count` AS `wait_count`,`s`.`ssbsect_wait_avail` AS `wait_avail`,`d`.`stvsubj_desc` AS `order_subject`,`s`.`ssbsect_seq_numb` AS `order_section`,concat(`d`.`stvsubj_desc`,`s`.`ssbsect_subj_code`,`s`.`ssbsect_crse_numb`) AS `order_class`,if(`s`.`ssbsect_seq_numb` like 'M%',1,if(`s`.`ssbsect_seq_numb` like 'D%',2,3)) AS `order_type` from ((((((((((`ssbsect` `s` join `scbcrse` `t1` on(`t1`.`scbcrse_subj_code` = `s`.`ssbsect_subj_code` and `t1`.`scbcrse_crse_numb` = `s`.`ssbsect_crse_numb` and `t1`.`scbcrse_eff_term` = (select max(`scbcrse`.`scbcrse_eff_term`) from `scbcrse` where `scbcrse`.`scbcrse_subj_code` = `s`.`ssbsect_subj_code` and `scbcrse`.`scbcrse_crse_numb` = `s`.`ssbsect_crse_numb` and `scbcrse`.`scbcrse_eff_term` <= `s`.`ssbsect_term_code`))) join `scrlevl` `l` on(`l`.`scrlevl_subj_code` = `s`.`ssbsect_subj_code` and `l`.`scrlevl_crse_numb` = `s`.`ssbsect_crse_numb` and `l`.`scrlevl_levl_code` = 'CR' and `l`.`scrlevl_eff_term` = (select max(`scrlevl`.`scrlevl_eff_term`) from `scrlevl` where `scrlevl`.`scrlevl_subj_code` = `s`.`ssbsect_subj_code` and `scrlevl`.`scrlevl_crse_numb` = `s`.`ssbsect_crse_numb` and `scrlevl`.`scrlevl_eff_term` <= `s`.`ssbsect_term_code`))) join `stvsubj` `d` on(`d`.`stvsubj_code` = `s`.`ssbsect_subj_code`)) left join `scrsyln` `t2` on(`t2`.`scrsyln_subj_code` = `s`.`ssbsect_subj_code` and `t2`.`scrsyln_crse_numb` = `s`.`ssbsect_crse_numb` and `t2`.`scrsyln_term_code_eff` = (select max(`scrsyln`.`scrsyln_term_code_eff`) from `scrsyln` where `scrsyln`.`scrsyln_subj_code` = `s`.`ssbsect_subj_code` and `scrsyln`.`scrsyln_crse_numb` = `s`.`ssbsect_crse_numb` and `scrsyln`.`scrsyln_term_code_eff` <= `s`.`ssbsect_term_code`))) join `ssrmeet` `m` on(`m`.`ssrmeet_term_code` = `s`.`ssbsect_term_code` and `m`.`ssrmeet_crn` = `s`.`ssbsect_crn`)) left join `ssrxlst` `xr` on(`xr`.`ssrxlst_term_code` = `s`.`ssbsect_term_code` and `xr`.`ssrxlst_crn` = `s`.`ssbsect_crn`)) left join `ssbxlst` `xb` on(`xb`.`ssbxlst_term_code` = `xr`.`ssrxlst_term_code` and `xb`.`ssbxlst_xlst_group` = `xr`.`ssrxlst_xlst_group`)) left join `sirasgn` `i` on(`i`.`sirasgn_term_code` = `s`.`ssbsect_term_code` and `i`.`sirasgn_crn` = `s`.`ssbsect_crn`)) left join `spriden` `i2` on(`i2`.`spriden_pidm` = `i`.`sirasgn_pidm`)) left join `sfrrsts` `r` on(`r`.`sfrrsts_term_code` = `s`.`ssbsect_term_code` and `r`.`sfrrsts_ptrm_code` = `s`.`ssbsect_ptrm_code` and `r`.`sfrrsts_rsts_code` = 'RX')) where `s`.`ssbsect_ssts_code` in ('A','X','C') and `s`.`ssbsect_prnt_ind` = 'Y' and `s`.`ssbsect_subj_code` not in ('APP','UAF','UAP','UAR','UAS','UAT','IWA') and `s`.`ssbsect_term_code` between 202209 and 202301 group by `s`.`ssbsect_term_code`,`s`.`ssbsect_crn`;
SET @ORIG_TIME_ZONE = @@TIME_ZONE;
SET TIME_ZONE = @ORIG_TIME_ZONE;
SET SQL_MODE = @ORIG_SQL_MODE;
# Export Finished: May 3, 2023 at 11:04:51 AM EDT
Raw
schedule.sql
CREATE ALGORITHM=UNDEFINED DEFINER=`webview`@`%.wccnet.%` SQL SECURITY DEFINER VIEW `cache`.`schedule` AS select concat(`s`.`ssbsect_term_code`,`s`.`ssbsect_crn`) AS `UID`,`s`.`ssbsect_crn` AS `section_crn`,`d`.`stvsubj_desc` AS `subject_description`,concat(`s`.`ssbsect_subj_code`,`s`.`ssbsect_crse_numb`) AS `course_uid`,concat(`s`.`ssbsect_subj_code`,`s`.`ssbsect_crse_numb`,`s`.`ssbsect_seq_numb`) AS `section_uid`,`t2`.`scrsyln_long_course_title` AS `course_title_long`,`t1`.`scbcrse_title` AS `course_title`,`d`.`stvsubj_desc` AS `subject_title`,group_concat(concat(`i2`.`spriden_first_name`,' ',`i2`.`spriden_last_name`) separator ', ') AS `instructor_names`,`s`.`ssbsect_term_code` AS `term_code`,`s`.`ssbsect_crn` AS `crn`,`s`.`ssbsect_subj_code` AS `subject`,`s`.`ssbsect_subj_code` AS `subject_text`,`s`.`ssbsect_crse_numb` AS `number`,`s`.`ssbsect_crse_numb` AS `number_text`,`s`.`ssbsect_seq_numb` AS `section`,if(`s`.`ssbsect_schd_code` = 'VL' or `s`.`ssbsect_schd_code` = 'VB' or `s`.`ssbsect_schd_code` = 'MV','vclass',if(`s`.`ssbsect_schd_code` = 'D','online',if(`s`.`ssbsect_schd_code` = 'Y' or `s`.`ssbsect_schd_code` = 'MO' or `s`.`ssbsect_schd_code` = 'MR' or `s`.`ssbsect_schd_code` = 'MB','blended','regular'))) AS `section_type`,`s`.`ssbsect_ssts_code` AS `status_code`,if(`t1`.`scbcrse_credit_hr_low` is null,`t1`.`scbcrse_credit_hr_high`,`t1`.`scbcrse_credit_hr_low`) AS `credits_low`,if(`t1`.`scbcrse_credit_hr_high` is null,`t1`.`scbcrse_credit_hr_low`,`t1`.`scbcrse_credit_hr_high`) AS `credits_high`,if(`m`.`ssrmeet_bldg_code` = 'ONLINE',1,0) AS `online`,unix_timestamp(min(concat(`m`.`ssrmeet_start_date`,' 00:00'))) AS `start_date`,unix_timestamp(max(concat(`m`.`ssrmeet_end_date`,' 23:59'))) AS `end_date`,min(`m`.`ssrmeet_begin_time`) AS `start_time`,unix_timestamp(if(`r`.`sfrrsts_end_date` is not null,`r`.`sfrrsts_end_date`,`s`.`ssbsect_ptrm_end_date`)) AS `end_reg_date`,if(`xb`.`ssbxlst_max_enrl` is not null,`xb`.`ssbxlst_max_enrl`,`s`.`ssbsect_max_enrl`) AS `max_enroll`,greatest(if(`xb`.`ssbxlst_enrl` is not null,`xb`.`ssbxlst_seats_avail`,`s`.`ssbsect_seats_avail`),0) AS `seats_avail`,`s`.`ssbsect_wait_count` AS `wait_count`,`s`.`ssbsect_wait_avail` AS `wait_avail`,`d`.`stvsubj_desc` AS `order_subject`,`s`.`ssbsect_seq_numb` AS `order_section`,concat(`d`.`stvsubj_desc`,`s`.`ssbsect_subj_code`,`s`.`ssbsect_crse_numb`) AS `order_class`,if(`s`.`ssbsect_seq_numb` like 'M%',1,if(`s`.`ssbsect_seq_numb` like 'D%',2,3)) AS `order_type` from ((((((((((`cache`.`ssbsect` `s` join `cache`.`scbcrse` `t1` on(`t1`.`scbcrse_subj_code` = `s`.`ssbsect_subj_code` and `t1`.`scbcrse_crse_numb` = `s`.`ssbsect_crse_numb` and `t1`.`scbcrse_eff_term` = (select max(`cache`.`scbcrse`.`scbcrse_eff_term`) from `cache`.`scbcrse` where `cache`.`scbcrse`.`scbcrse_subj_code` = `s`.`ssbsect_subj_code` and `cache`.`scbcrse`.`scbcrse_crse_numb` = `s`.`ssbsect_crse_numb` and `cache`.`scbcrse`.`scbcrse_eff_term` <= `s`.`ssbsect_term_code`))) join `cache`.`scrlevl` `l` on(`l`.`scrlevl_subj_code` = `s`.`ssbsect_subj_code` and `l`.`scrlevl_crse_numb` = `s`.`ssbsect_crse_numb` and `l`.`scrlevl_levl_code` = 'CR' and `l`.`scrlevl_eff_term` = (select max(`cache`.`scrlevl`.`scrlevl_eff_term`) from `cache`.`scrlevl` where `cache`.`scrlevl`.`scrlevl_subj_code` = `s`.`ssbsect_subj_code` and `cache`.`scrlevl`.`scrlevl_crse_numb` = `s`.`ssbsect_crse_numb` and `cache`.`scrlevl`.`scrlevl_eff_term` <= `s`.`ssbsect_term_code`))) join `cache`.`stvsubj` `d` on(`d`.`stvsubj_code` = `s`.`ssbsect_subj_code`)) left join `cache`.`scrsyln` `t2` on(`t2`.`scrsyln_subj_code` = `s`.`ssbsect_subj_code` and `t2`.`scrsyln_crse_numb` = `s`.`ssbsect_crse_numb` and `t2`.`scrsyln_term_code_eff` = (select max(`cache`.`scrsyln`.`scrsyln_term_code_eff`) from `cache`.`scrsyln` where `cache`.`scrsyln`.`scrsyln_subj_code` = `s`.`ssbsect_subj_code` and `cache`.`scrsyln`.`scrsyln_crse_numb` = `s`.`ssbsect_crse_numb` and `cache`.`scrsyln`.`scrsyln_term_code_eff` <= `s`.`ssbsect_term_code`))) join `cache`.`ssrmeet` `m` on(`m`.`ssrmeet_term_code` = `s`.`ssbsect_term_code` and `m`.`ssrmeet_crn` = `s`.`ssbsect_crn`)) left join `cache`.`ssrxlst` `xr` on(`xr`.`ssrxlst_term_code` = `s`.`ssbsect_term_code` and `xr`.`ssrxlst_crn` = `s`.`ssbsect_crn`)) left join `cache`.`ssbxlst` `xb` on(`xb`.`ssbxlst_term_code` = `xr`.`ssrxlst_term_code` and `xb`.`ssbxlst_xlst_group` = `xr`.`ssrxlst_xlst_group`)) left join `cache`.`sirasgn` `i` on(`i`.`sirasgn_term_code` = `s`.`ssbsect_term_code` and `i`.`sirasgn_crn` = `s`.`ssbsect_crn`)) left join `cache`.`spriden` `i2` on(`i2`.`spriden_pidm` = `i`.`sirasgn_pidm`)) left join `cache`.`sfrrsts` `r` on(`r`.`sfrrsts_term_code` = `s`.`ssbsect_term_code` and `r`.`sfrrsts_ptrm_code` = `s`.`ssbsect_ptrm_code` and `r`.`sfrrsts_rsts_code` = 'RX')) where `s`.`ssbsect_ssts_code` in ('A','X','C') and `s`.`ssbsect_prnt_ind` = 'Y' and `s`.`ssbsect_subj_code` not in ('APP','UAF','UAP','UAR','UAS','UAT','IWA') and `s`.`ssbsect_term_code` between 202209 and 202301 group by `s`.`ssbsect_term_code`,`s`.`ssbsect_crn`;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment