MCIR Data Dictionary
Michigan Department of Information Technology
Production

Schema Index

 

Tables in MCIR@MCIRQRY.WORLD

<--More Tables
Table Name # of Cols # of Indexes Size Tablespace
SCHOOL_DISTRICT 5 3   MCIR_DATA
SCHOOL_SITE 16 5   MCIR_DATA
SCHOOL_SITE_REPORT_GRADE 3 3   MCIR_DATA
SCHOOL_SITE_ROSTER 6 3   MCIR_DATA
SCHOOL_TYPE 3 1   MCIR_MISC
SCHOOL_TYPE_FUND 4 3   MCIR_MISC
SCHOOL_TYPE_ROLE 3 3   MCIR_DATA_IDX
SEASON 2 1   MCIR_DATA
SECURITY_AUDIT 9 2   MCIR_MISC
SERIES 9 2   MCIR_DATA
SERIES_ANTIGEN 3 3   MCIR_MISC
SERIES_EVAL 15 7   MCIR_DATA
SERIES_MESSAGE 4 1   MCIR_DATA
SERIES_TITER 6 1   MCIR_DATA
SERIES_USAGE 9 3   MCIR_MISC
SERIES_VACCINE 7 2   MCIR_DATA
SHOT 24 8   MCIR_DATA
SIRS_SERIES_VACCINE 3 3   MCIR_MISC
SITE 16 5   MCIR_DATA
SITE_ADDRESS 7 3   MCIR_DATA
SITE_CLASS 2 1   MCIR_MISC
SITE_CLASS_MAP 3 3   MCIR_DATA
SITE_CLASS_PRIV 3 3   MCIR_MISC
SITE_CLASS_PROTOCOL 3 3   MCIR_MISC
SITE_CLASS_REC_STATUS 3 3   MCIR_MISC
SITE_CLASS_WAIVER_TYPE 3 3   MCIR_MISC
SITE_EMAIL 8 3   MCIR_DATA
SITE_PERSON 9 3   USERS
SITE_PERSON_MAP 12 3   MCIR_DATA
SITE_PHONE 8 3   MCIR_DATA
SITE_PREF 4 2   MCIR_DATA_IDX
SITE_ROSTER 7 3   MCIR_DATA
TRANSFER_JOB 15 5   MCIR_DATA
TRANSFER_JOB_STATISTICS 8 4   MCIR_DATA_IDX
TRANSFER_LOG 8 1   MCIR_MISC
USER_PREF 4 2   MCIR_DATA
USER_REPORT_PREF 5 3   MCIR_DATA
USER_VACCINE_PREF 9 1   MCIR_DATA
VACCINE 10 4   MCIR_MISC
VACCINE_AGE_MAP 2 1   MCIR_DATA
VACCINE_ANTIGEN 3 4   MCIR_MISC
VACCINE_LOT 10 2   MCIR_DATA
VACCINE_LOT_TRANS 13 3   MCIR_DATA
VACCINE_MFR 12 1   MCIR_DATA
VACCINE_SCHEDULE 14 4   MCIR_MISC
VIM_COUNTY 5 3   MCIR_DATA
VIM_VACCINE 4 1   MCIR_DATA
VIS 5 2   MCIR_MISC
VXQ_PHP 29 0   USERS
WAIVER_TYPE 6 1   MCIR_MISC
ZIP5_CODE 16 3   MCIR_MISC_IDX
ZIP5_CODE_LOCATION 3 3   MCIR_MISC_IDX

By Joseph S. Davis