-- Schema: aihub_education
CREATE SCHEMA IF NOT EXISTS "aihub_education";

-- Table: publicdata_education_10207__DGE_DAEGU_LIBRARY_POPULARITY_BOOK_L
CREATE TABLE "aihub_education"."publicdata_education_10207__DGE_DAEGU_LIBRARY_POPULARITY_BOOK_L" (
    "RANKING" NUMERIC,
    "REGISTRATION_NUMBER" TEXT,
    "BILLING_SYMBOL" TEXT,
    "SIGNATURE" TEXT,
    "AUTHOR" TEXT,
    "ISSUER" TEXT,
    "ARCHIVES_OFFICE" TEXT,
    "NUMBER_LOANS" NUMERIC
);

-- Table: publicdata_education_10207__LIST_POPULAR_BOOKS_DGE_DAEGU_DALSEO
CREATE TABLE "aihub_education"."publicdata_education_10207__LIST_POPULAR_BOOKS_DGE_DAEGU_DALSEO" (
    "RANKING" NUMERIC,
    "REGISTRATION_NUMBER" TEXT,
    "SIGNATURE" TEXT,
    "AUTHOR" TEXT,
    "ISSUER" TEXT,
    "BILLING_SYMBOL" TEXT,
    "ARCHIVES_OFFICE" TEXT,
    "NUMBER_LOANS" NUMERIC
);

-- Table: publicdata_education_11208__DGE_DAEGU_LIBRARY_POPULARITY_BOOK_L
CREATE TABLE "aihub_education"."publicdata_education_11208__DGE_DAEGU_LIBRARY_POPULARITY_BOOK_L" (
    "RANKING" NUMERIC,
    "REGISTRATION_NUMBER" TEXT,
    "BILLING_SYMBOL" TEXT,
    "SIGNATURE" TEXT,
    "AUTHOR" TEXT,
    "ISSUER" TEXT,
    "ARCHIVES_OFFICE" TEXT,
    "NUMBER_LOANS" NUMERIC
);

-- Table: publicdata_education_11208__LIST_POPULAR_BOOKS_DGE_DAEGU
CREATE TABLE "aihub_education"."publicdata_education_11208__LIST_POPULAR_BOOKS_DGE_DAEGU" (
    "RANKING" NUMERIC,
    "REGISTRATION_NUMBER" TEXT,
    "SIGNATURE" TEXT,
    "AUTHOR" TEXT,
    "ISSUER" TEXT,
    "BILLING_SYMBOL" TEXT,
    "NUMBER_LOANS" NUMERIC
);

-- Table: publicdata_education_1163__CURRENT_STS_RENTAL_STUDY_SPACE_SUSEO
CREATE TABLE "aihub_education"."publicdata_education_1163__CURRENT_STS_RENTAL_STUDY_SPACE_SUSEO" (
    "DATE_COMMENCEMENT_RENTAL" TEXT,
    "DATE_COMPLETION_RENTAL" TEXT,
    "CHIEF_GOVERNMENT" TEXT,
    "CLASSIFICATION" TEXT,
    "RENTAL_TIME" TEXT
);

-- Table: publicdata_education_11822__HRDK_N_QUALIFICATION_LIST_INFO
CREATE TABLE "aihub_education"."publicdata_education_11822__HRDK_N_QUALIFICATION_LIST_INFO" (
    "QUALIFICATION_CODE" TEXT,
    "CLEAR_QUALIFICATION" TEXT,
    "AFFILIATED_NAME" TEXT,
    "STOCK_NAME" TEXT
);

-- Table: publicdata_education_11822__HRDK_N_TECHNICAL_QUALIFICATION_TEST
CREATE TABLE "aihub_education"."publicdata_education_11822__HRDK_N_TECHNICAL_QUALIFICATION_TEST" (
    "STOCK_NAME" TEXT,
    "ITEM" TEXT,
    "CONTENTS" TEXT,
    "DIV" TEXT
);

-- Table: publicdata_education_12498__KRIVET_PRIVATE_Q_ACQUISITION_STS
CREATE TABLE "aihub_education"."publicdata_education_12498__KRIVET_PRIVATE_Q_ACQUISITION_STS" (
    "RE_NUMZ" TEXT,
    "QUALIFICATION_NMA" TEXT,
    "Q_I_I_BB" TEXT,
    "COMPETENT_MINISTRYC" TEXT,
    "TEST_METHODD" TEXT,
    "VALIDATION_YEARE" NUMERIC,
    "RATINGF" TEXT,
    "TOTAL_NUM_TESTSG" NUMERIC,
    "TOTAL_NUM_APPLICANTSH" NUMERIC,
    "TOTAL_NUM_APPLICANTSI" NUMERIC,
    "TOTAL_ACQUIRERSJ" NUMERIC,
    "ACCEPTANCE_RATEK" NUMERIC
);

-- Table: publicdata_education_12498__KRIVET_PRIVATE_Q_REG_INFO
CREATE TABLE "aihub_education"."publicdata_education_12498__KRIVET_PRIVATE_Q_REG_INFO" (
    "RE_DTU" TEXT,
    "CR_STAV" TEXT,
    "D_N_C_D_C_F_D_N" TEXT,
    "R_N_R_I_Y_R_I_N_O" TEXT,
    "QUALIFICATION_NMY" TEXT,
    "RATING_NMZ" TEXT,
    "APPLICANT_ORGANIZATIONA" TEXT,
    "QUALIFICATIONS_OVERVIEWB" TEXT,
    "JOB_DETAILS_GRADEC" TEXT,
    "AUTHORIZED_CDD" TEXT,
    "GRADING_STAE" TEXT,
    "J_O_I_N_W" TEXT
);

-- Table: publicdata_education_12527__KRIVET_AUTHORIZED_PRIVATE_Q_REG_STS
CREATE TABLE "aihub_education"."publicdata_education_12527__KRIVET_AUTHORIZED_PRIVATE_Q_REG_STS" (
    "COMPETENT_MINISTRIESE" TEXT,
    "QUALIFICATION_ITEMSF" TEXT,
    "RATINGG" TEXT,
    "QUALIFICATION_MANAGERH" TEXT,
    "A_V_P_B_J" TEXT,
    "E_A_V_P_K" TEXT,
    "START_STOMATAL_PERIODK" TEXT,
    "E_O_S_P_M" TEXT
);

-- Table: publicdata_education_12527__KRIVET_PRIVATE_Q_REG_INFO
CREATE TABLE "aihub_education"."publicdata_education_12527__KRIVET_PRIVATE_Q_REG_INFO" (
    "RE_DTU" TEXT,
    "CR_STAV" TEXT,
    "D_N_C_D_C_F_D_N" TEXT,
    "R_N_R_I_Y_R_I_N_O" TEXT,
    "QUALIFICATION_NMY" TEXT,
    "RATING_NMZ" TEXT,
    "APPLICANT_ORGANIZATIONA" TEXT,
    "QUALIFICATIONS_OVERVIEWB" TEXT,
    "JOB_DETAILS_GRADEC" TEXT,
    "AUTHORIZED_CDD" TEXT,
    "GRADING_STAE" TEXT,
    "J_O_I_N_W" TEXT
);

-- Table: publicdata_education_1312__LIFE_INFO_EDUAL_INST_ANYANG_GYEONGGI
CREATE TABLE "aihub_education"."publicdata_education_1312__LIFE_INFO_EDUAL_INST_ANYANG_GYEONGGI" (
    "CATEGORY" TEXT,
    "MUTUAL_NAME" TEXT,
    "STREET_NAME_ADDRESS" TEXT,
    "PHONE_NUMBER" TEXT,
    "ONE_LINE_EXPLANATION" TEXT,
    "INTRODUCE" TEXT
);

-- Table: publicdata_education_13524__GGGJ_BOOK_LOAN_INFO_STS
CREATE TABLE "aihub_education"."publicdata_education_13524__GGGJ_BOOK_LOAN_INFO_STS" (
    "CITY_COUNTY_NMM" TEXT,
    "LIBRARY_NMN" TEXT,
    "BOOK_NMO" TEXT,
    "I_S_B_N_Q" TEXT,
    "C_S_K_D_C_M_RC" NUMERIC,
    "DT_TIME_LOANR" TEXT,
    "DATA_BASE_DTS" TEXT
);

-- Table: publicdata_education_13524__LIST_GGIC_POPULAR_BOOKS
CREATE TABLE "aihub_education"."publicdata_education_13524__LIST_GGIC_POPULAR_BOOKS" (
    "NUMQ" NUMERIC,
    "BOOK_NMR" TEXT,
    "AUTHORS" TEXT,
    "PUBLISHING_HOUSET" TEXT,
    "YEAR_ISSUE_YEARU" NUMERIC,
    "NUM_LOANSV" NUMERIC,
    "BASE_QUARTERW" TEXT
);

-- Table: publicdata_education_1538__CURRENT_STS_STUDENTS_NAM_GU_ULSAN
CREATE TABLE "aihub_education"."publicdata_education_1538__CURRENT_STS_STUDENTS_NAM_GU_ULSAN" (
    "LECTURE" TEXT,
    "REGISTRATION_DATE" TEXT,
    "GENDER" TEXT,
    "TUITION" TEXT
);

-- Table: publicdata_education_1557__NUM_NEW_SUBSCRIBERS_KOJOB_WEBSITE
CREATE TABLE "aihub_education"."publicdata_education_1557__NUM_NEW_SUBSCRIBERS_KOJOB_WEBSITE" (
    "STANDARD_DAY" TEXT,
    "NEW_PRICE" NUMERIC,
    "NEW_SUBSCRIPTION_SYSTEM" NUMERIC
);

-- Table: publicdata_education_1593__CURRENT_STS_CHILDREN_PLAY_FAC_SEOUL_
CREATE TABLE "aihub_education"."publicdata_education_1593__CURRENT_STS_CHILDREN_PLAY_FAC_SEOUL_" (
    "ANNUAL" NUMERIC,
    "FACILITY_NUMBER" NUMERIC,
    "PLACEMENT" TEXT,
    "NAMES_OF_PLAY_FACILITIES" TEXT,
    "REGIONAL_CLASSIFICATION" TEXT,
    "INDOOR" TEXT
);

-- Table: publicdata_education_1646__BASIC_UNIVERSITIES_S_KSAF_YOUTH_EDU_
CREATE TABLE "aihub_education"."publicdata_education_1646__BASIC_UNIVERSITIES_S_KSAF_YOUTH_EDU_" (
    "PRODUCT_NAME" TEXT,
    "ALLOCATION" NUMERIC,
    "DIVISION_OF_ASSIGNMENT" TEXT,
    "ASSIGNED_SERIAL_NUMBER" NUMERIC,
    "UNIVERSITY_NAME" TEXT
);

-- Table: publicdata_education_1654__DETAILS_BUSAN_HUMAN_RESOURCES_DEV_IN
CREATE TABLE "aihub_education"."publicdata_education_1654__DETAILS_BUSAN_HUMAN_RESOURCES_DEV_IN" (
    "COURSE_NUMBER" NUMERIC,
    "EVALUATION_ITEM_ID" NUMERIC,
    "COURSE_ORDER_ID" TEXT,
    "EVALUATION_ITEM_CODE" NUMERIC,
    "EVALUATION_PORT" TEXT,
    "EVALUATION_ITEM" NUMERIC,
    "TOTAL_SCORE" NUMERIC,
    "AUTHOR_NUMBER" NUMERIC,
    "DATE_OF_ISSUE" TEXT,
    "EVALUATION" NUMERIC
);

-- Table: publicdata_education_1822__HRDK_N_TECHNICAL_QUALIFICATION_TEST_
CREATE TABLE "aihub_education"."publicdata_education_1822__HRDK_N_TECHNICAL_QUALIFICATION_TEST_" (
    "STOCK_NAME" TEXT,
    "ITEM" TEXT,
    "CONTENTS" TEXT,
    "DIV" TEXT
);

-- Table: publicdata_education_1851__DETAILS_ATTACHMENT_REPORT_RESULTS_O_
CREATE TABLE "aihub_education"."publicdata_education_1851__DETAILS_ATTACHMENT_REPORT_RESULTS_O_" (
    "PRODUCT_NAME" TEXT,
    "YEAR" NUMERIC,
    "SEMESTER" NUMERIC,
    "UNIVERSITY_NAME" TEXT,
    "ATTACHMENT_SERIAL_NUMBER" NUMERIC,
    "FILE_CLASSIFICATION" TEXT,
    "UPLOAD_FILE_NAME" TEXT,
    "UPLOAD_FILE_ONE_REAL_NAME" TEXT
);

-- Table: publicdata_education_1863__NILE_CREDIT_BANK_INFO_SYS_CERTIFIED_
CREATE TABLE "aihub_education"."publicdata_education_1863__NILE_CREDIT_BANK_INFO_SYS_CERTIFIED_" (
    "DIVISION" TEXT,
    "SUBJECT_NAME" TEXT,
    "NOTE" TEXT
);

-- Table: publicdata_education_2015__EDU_PROGRAM_SOUTHERN_WOMEN_FAMILY_CN
CREATE TABLE "aihub_education"."publicdata_education_2015__EDU_PROGRAM_SOUTHERN_WOMEN_FAMILY_CN" (
    "COURSE_CLASSIFICATION" TEXT,
    "LECTURE" TEXT,
    "MONTH" NUMERIC,
    "DAY_WEEK" TEXT,
    "TIME" TEXT
);

-- Table: publicdata_education_2091__NILE_CBINFO_AGENCY_DEV_PLAN_SPECIALI
CREATE TABLE "aihub_education"."publicdata_education_2091__NILE_CBINFO_AGENCY_DEV_PLAN_SPECIALI" (
    "DISCLOSURE_YEAR" NUMERIC,
    "DISCLOSURE" NUMERIC,
    "PUBLICATION" TEXT,
    "CORRECTION" NUMERIC,
    "INPUT_ORDER" NUMERIC,
    "FILE_ACCESS_ADDRESS" TEXT,
    "YEAR_ROUND_YEAR" NUMERIC,
    "CREATION_DATE" TEXT,
    "MODIFIED_DATE_AND_TIME" TEXT
);

-- Table: publicdata_education_2111__YEONGDO_GU_BUSAN_LIFELONG_LEARNING_R
CREATE TABLE "aihub_education"."publicdata_education_2111__YEONGDO_GU_BUSAN_LIFELONG_LEARNING_R" (
    "DIVISION" TEXT,
    "SITE_NAME" TEXT,
    "SITE_GUIDE" TEXT,
    "HOME_PAGE" TEXT
);

-- Table: publicdata_education_2150__STS_INTEREST_EXEMPTION_AGE_KOSAF_MIL
CREATE TABLE "aihub_education"."publicdata_education_2150__STS_INTEREST_EXEMPTION_AGE_KOSAF_MIL" (
    "REFERENCE" TEXT,
    "LENDING" NUMERIC,
    "LENDING_SEMESTER" NUMERIC,
    "PRODUCT_CODE" TEXT,
    "PRODUCT_CODE_NAME" TEXT,
    "AGE" NUMERIC,
    "LOAN_AMOUNT" NUMERIC,
    "INTEREST" NUMERIC,
    "LOAN_BALANCE" NUMERIC
);

-- Table: publicdata_education_2202__C_STS_GWE_SCHOOL_AMUSEMENT_FAC
CREATE TABLE "aihub_education"."publicdata_education_2202__C_STS_GWE_SCHOOL_AMUSEMENT_FAC" (
    "SERIAL_NUMR" NUMERIC,
    "FACILITY_NUMS" NUMERIC,
    "PLACE_INST" TEXT,
    "NM_AMUSEMENT_FACILITYU" TEXT,
    "SAFETY_INSPECTION_STAV" TEXT,
    "COMPLETION_SAFETY_EDUW" TEXT,
    "I_S_S_X" TEXT,
    "NOTEY" TEXT
);

-- Table: publicdata_education_2222__GG_YJ_P_LIBRARY_USER_BOOK_LOAN_INFO
CREATE TABLE "aihub_education"."publicdata_education_2222__GG_YJ_P_LIBRARY_USER_BOOK_LOAN_INFO" (
    "CITY_COUNTY_NMA" TEXT,
    "LIBRARY_NMB" TEXT,
    "SIGNATUREC" TEXT,
    "RE_NUMD" TEXT,
    "ISBNE" NUMERIC,
    "CLAS_SYMBOLF" NUMERIC,
    "DT_TIME_LOANG" TEXT,
    "NM_MANAGEMENT_AGENCYH" TEXT,
    "DATA_BASE_DTI" TEXT
);

-- Table: publicdata_education_2269__GWE_CHUNCHEON_CITY_MIDDLE_SCHOOL_DIS
CREATE TABLE "aihub_education"."publicdata_education_2269__GWE_CHUNCHEON_CITY_MIDDLE_SCHOOL_DIS" (
    "S_G_M_S_L_N_Q" TEXT,
    "E_SCHOOL_NMK" TEXT,
    "AREA_CONCERNEDL" TEXT,
    "M_SCHOOL_NMM" TEXT,
    "NOTEN" TEXT
);

-- Table: publicdata_education_2284__GGGY_LIFELONG_LEARNING_INFO
CREATE TABLE "aihub_education"."publicdata_education_2284__GGGY_LIFELONG_LEARNING_INFO" (
    "CLAS_EDUAL_INSTITUTIONSG" TEXT,
    "EDUAL_INSTITUTIONH" TEXT,
    "A_E_I_A" TEXT,
    "P_N_E_I_BB" TEXT,
    "CLUBK" TEXT,
    "CLUB_ACTIVITY_AREAL" TEXT,
    "FOUNDING_DAY_CLUBM" TEXT,
    "FIELD_CLUB_ACTIVITIESN" TEXT,
    "NUM_CLUB_MEMBERSO" NUMERIC,
    "CAFEP" TEXT,
    "CAFE_ADDRESSQ" TEXT
);

-- Table: publicdata_education_2409__GG_YP_INNOVATION_EDU_DISTRICT_PRO_O_
CREATE TABLE "aihub_education"."publicdata_education_2409__GG_YP_INNOVATION_EDU_DISTRICT_PRO_O_" (
    "BASE_YEARV" TEXT,
    "SORTATIONW" TEXT,
    "SCHOOL_NMX" TEXT,
    "BUSINESS_CLASY" TEXT,
    "BUSINESS_CLASZ" TEXT,
    "AMT_GRANTA" NUMERIC
);

-- Table: publicdata_education_2498__KRIVET_PRIVATE_Q_ACQUISITION_STS
CREATE TABLE "aihub_education"."publicdata_education_2498__KRIVET_PRIVATE_Q_ACQUISITION_STS" (
    "RE_NUMZ" TEXT,
    "QUALIFICATION_NMA" TEXT,
    "Q_I_I_BB" TEXT,
    "COMPETENT_MINISTRYC" TEXT,
    "TEST_METHODD" TEXT,
    "VALIDATION_YEARE" NUMERIC,
    "RATINGF" TEXT,
    "TOTAL_NUM_TESTSG" NUMERIC,
    "TOTAL_NUM_APPLICANTSH" NUMERIC,
    "TOTAL_NUM_APPLICANTSI" NUMERIC,
    "TOTAL_ACQUIRERSJ" NUMERIC,
    "ACCEPTANCE_RATEK" NUMERIC
);

-- Table: publicdata_education_2527__KRIVET_AUTHORIZED_PRIVATE_Q_REG_STS
CREATE TABLE "aihub_education"."publicdata_education_2527__KRIVET_AUTHORIZED_PRIVATE_Q_REG_STS" (
    "COMPETENT_MINISTRIESE" TEXT,
    "QUALIFICATION_ITEMSF" TEXT,
    "RATINGG" TEXT,
    "QUALIFICATION_MANAGERH" TEXT,
    "A_V_P_B_J" TEXT,
    "E_A_V_P_K" TEXT,
    "START_STOMATAL_PERIODK" TEXT,
    "E_O_S_P_M" TEXT
);

-- Table: publicdata_education_2548__C_STS_GNGH_LIFELONG_EDU_INST
CREATE TABLE "aihub_education"."publicdata_education_2548__C_STS_GNGH_LIFELONG_EDU_INST" (
    "NUMM" NUMERIC,
    "A_D_XZ" TEXT,
    "NM_ORGANIZATIONO" TEXT,
    "LAND_NUM_ADDRESSP" TEXT,
    "ROAD_NM_ADDRESSQ" TEXT,
    "PHONE_NUMR" TEXT,
    "FAX_NUMS" TEXT,
    "LATITUDET" NUMERIC,
    "HARDNESSU" NUMERIC
);

-- Table: publicdata_education_2648__GGGY_LIBRARY_CNT_REVIEW_SCORE_INFO
CREATE TABLE "aihub_education"."publicdata_education_2648__GGGY_LIBRARY_CNT_REVIEW_SCORE_INFO" (
    "BARCDW" TEXT,
    "CONTENT_HANGUL_NMX" TEXT,
    "REVIEW_CONTENTSY" TEXT,
    "SCOREZ" NUMERIC
);

-- Table: publicdata_education_2711__GNYS_LIFELONG_LEARNING_CNT_DELIVERY_
CREATE TABLE "aihub_education"."publicdata_education_2711__GNYS_LIFELONG_LEARNING_CNT_DELIVERY_" (
    "SERIAL_NUMK" NUMERIC,
    "KINDL" TEXT,
    "NM_LECTUREM" TEXT,
    "AREA_WHERE_YOU_CAN_TAKEN" TEXT,
    "AVAILABLE_TIME_LECTUREO" TEXT,
    "PHONE_NUMP" TEXT,
    "DATA_BASE_DTQ" TEXT
);

-- Table: publicdata_education_2921__GGIC_LIFELONG_LEARNING_CLUB_STS
CREATE TABLE "aihub_education"."publicdata_education_2921__GGIC_LIFELONG_LEARNING_CLUB_STS" (
    "NM_CLUBG" TEXT,
    "NUM_CLUB_MEMBERSH" NUMERIC,
    "CLUB_ROOMI" TEXT,
    "MEETING_CYCLEJ" TEXT,
    "RE_DTK" TEXT,
    "CLUB_INFL" TEXT
);

-- Table: publicdata_education_2945__GGGY_ACTUAL_R_DETAILS
CREATE TABLE "aihub_education"."publicdata_education_2945__GGGY_ACTUAL_R_DETAILS" (
    "BARCDO" TEXT,
    "SIGNATUREP" TEXT,
    "ACTUAL_NUM_RESERVATIONSQ" NUMERIC
);

-- Table: publicdata_education_2966__GGGY_ACTUAL_LOAN_DETAILS
CREATE TABLE "aihub_education"."publicdata_education_2966__GGGY_ACTUAL_LOAN_DETAILS" (
    "BARCDO" TEXT,
    "SIGNATUREP" TEXT,
    "ACTUAL_LOAN_COUNTQ" NUMERIC
);

-- Table: publicdata_education_2993__GNYS_LIBRARY_READING_CULTURE_PROGRAM
CREATE TABLE "aihub_education"."publicdata_education_2993__GNYS_LIBRARY_READING_CULTURE_PROGRAM" (
    "SERIAL_NUMS" NUMERIC,
    "LIBRARY_NMT" TEXT,
    "SORTATIONU" TEXT,
    "CONTENTV" TEXT,
    "START_DTW" TEXT,
    "END_DTX" TEXT,
    "TARGETY" TEXT,
    "PERSONNELZ" NUMERIC,
    "BASE_DTA" TEXT
);

-- Table: publicdata_education_3019__STS_GGHN_S_LIBRARY
CREATE TABLE "aihub_education"."publicdata_education_3019__STS_GGHN_S_LIBRARY" (
    "SERIAL_NUMI" NUMERIC,
    "LIBRARY_NMJ" TEXT,
    "LIBRARY_BOOKK" NUMERIC,
    "OPERATING_DAYL" TEXT,
    "OPERATING_HOURSM" TEXT,
    "ROAD_NM_ADDRESSN" TEXT,
    "PHONE_NUMO" TEXT,
    "DATA_BASE_DTP" TEXT
);

-- Table: publicdata_education_3194__GNE_GENE_SCIENCE_EDU_CNT_SCIENCE_EXP
CREATE TABLE "aihub_education"."publicdata_education_3194__GNE_GENE_SCIENCE_EDU_CNT_SCIENCE_EXP" (
    "SERIAL_NUMH" NUMERIC,
    "NM_EXPERIENCEI" TEXT,
    "HOW_EXPERIENCE_ITJ" TEXT,
    "I_Q_D_E_I" TEXT,
    "PRECAUTIONS_EXPERIENCEL" TEXT,
    "S_C_A_K" TEXT,
    "S_C_T_L" TEXT,
    "S_C_A_S_M" TEXT
);

-- Table: publicdata_education_3339__KRIVET_PRIVATE_Q_REG_INFO
CREATE TABLE "aihub_education"."publicdata_education_3339__KRIVET_PRIVATE_Q_REG_INFO" (
    "RE_DTU" TEXT,
    "CR_STAV" TEXT,
    "D_N_C_D_C_F_D_N" TEXT,
    "R_N_R_I_Y_R_I_N_O" TEXT,
    "QUALIFICATION_NMY" TEXT,
    "RATING_NMZ" TEXT,
    "APPLICANT_ORGANIZATIONA" TEXT,
    "QUALIFICATIONS_OVERVIEWB" TEXT,
    "JOB_DETAILS_GRADEC" TEXT,
    "AUTHORIZED_CDD" TEXT,
    "GRADING_STAE" TEXT,
    "J_O_I_N_W" TEXT
);

-- Table: publicdata_education_3360__GGIC_P_LIBRARY_ANNUAL_W_INFO
CREATE TABLE "aihub_education"."publicdata_education_3360__GGIC_P_LIBRARY_ANNUAL_W_INFO" (
    "ANL_WATER_CONTROL_NUMY" NUMERIC,
    "CONTROL_NUMZ" NUMERIC,
    "SIGNATUREA" TEXT,
    "PUBLISHING_HOUSEB" TEXT,
    "INTERLUDEC" TEXT,
    "BINDING_STAD" NUMERIC,
    "MEDIA_FORME" NUMERIC,
    "LANGUAGEF" TEXT,
    "ISSUING_COUNTRYG" TEXT,
    "DIVING_CLASH" NUMERIC,
    "SORTING_SIGNATURESI" TEXT,
    "ISSUER_SORTINGJ" TEXT,
    "ISSNK" TEXT,
    "SORT_ISSNL" NUMERIC,
    "PLACE_COLLECTIONM" TEXT,
    "DATA_ROOMN" TEXT,
    "SUSEO_NUMO" NUMERIC,
    "DISTRIBUTION_STAP" NUMERIC,
    "NUM_SUBSCRIPTIONSQ" NUMERIC,
    "NUM_BINDINGSR" TEXT,
    "BINDING_START_DTS" TEXT,
    "END_BOOKBINDINGT" TEXT,
    "NUM_HANDSU" TEXT,
    "I_T_R_S_S" NUMERIC,
    "YEAR_ISSUEW" TEXT,
    "SUBSCRIPTION_STAX" NUMERIC,
    "BINDING_SIGNATUREY" TEXT,
    "BLIND_CHECKZ" TEXT,
    "LOAN_INSPECTION_STAA" NUMERIC,
    "BILLING_SYMBOLB" TEXT,
    "RE_STAC" NUMERIC,
    "EXHIBITION_TARGET_STAD" NUMERIC,
    "DISPOSAL_STAE" TEXT,
    "ARTICLE_STAF" TEXT,
    "ANL_WATER_ORDER_NUMG" NUMERIC
);

-- Table: publicdata_education_3377__GGPT_LIBRARY_LOAN_STS
CREATE TABLE "aihub_education"."publicdata_education_3377__GGPT_LIBRARY_LOAN_STS" (
    "CITY_COUNTY_NMZ" TEXT,
    "LIBRARY_NMA" TEXT,
    "BOOK_NMB" TEXT,
    "C_S_K_D_C_M_K" NUMERIC,
    "LOAN_DTD" TEXT,
    "LOAN_TIMEE" TEXT
);

-- Table: publicdata_education_3435__LIST_GN_CONTINUOUS_PATIONS
CREATE TABLE "aihub_education"."publicdata_education_3435__LIST_GN_CONTINUOUS_PATIONS" (
    "SERIAL_NUMY" NUMERIC,
    "SORTATIONZ" TEXT,
    "PUBLICATION_NMA" TEXT,
    "ISSUING_COMPANYB" TEXT,
    "INTERLUDEC" TEXT
);

-- Table: publicdata_education_3524__GGGJ_BOOK_LOAN_INFO_STS
CREATE TABLE "aihub_education"."publicdata_education_3524__GGGJ_BOOK_LOAN_INFO_STS" (
    "CITY_COUNTY_NMM" TEXT,
    "LIBRARY_NMN" TEXT,
    "BOOK_NMO" TEXT,
    "I_S_B_N_Q" TEXT,
    "C_S_K_D_C_M_RC" NUMERIC,
    "DT_TIME_LOANR" TEXT,
    "DATA_BASE_DTS" TEXT
);

-- Table: publicdata_education_3545__GNYS_S_CLASS_STS
CREATE TABLE "aihub_education"."publicdata_education_3545__GNYS_S_CLASS_STS" (
    "FACILITY_NMN" TEXT,
    "ESTABLISHMENTO" TEXT,
    "SORTATIONP" TEXT,
    "TOTAL_NUM_LEARNINGSQ" NUMERIC,
    "SPECIAL_CLASSR" NUMERIC,
    "ADDRESSS" TEXT,
    "PHONE_NUMT" TEXT
);

-- Table: publicdata_education_3546__GGGJ_SCHOOL_STS
CREATE TABLE "aihub_education"."publicdata_education_3546__GGGJ_SCHOOL_STS" (
    "SCHOOL_NMU" TEXT,
    "ADDRESSV" TEXT,
    "POSTAL_CDW" NUMERIC,
    "GENERAL_CLASS_SPECIALX" TEXT,
    "NUM_STUDENTSY" NUMERIC,
    "HEADMASTERZ" TEXT,
    "COMMUNIONA" TEXT,
    "C_A_O_S" TEXT,
    "T_O_P_N_T" TEXT,
    "A_O_P_N_U" TEXT,
    "FAX_PHONE_NUME" TEXT,
    "ESTABLISHMENT_CLASF" TEXT,
    "DATA_BASE_DTG" TEXT
);

-- Table: publicdata_education_3865__GGGY_LIBRARY_CNT_CONTENT_USAGE_INFO
CREATE TABLE "aihub_education"."publicdata_education_3865__GGGY_LIBRARY_CNT_CONTENT_USAGE_INFO" (
    "PRODUCT_CDZ" NUMERIC,
    "CONTENT_HANGUL_NMA" TEXT,
    "NUM_LOANSB" NUMERIC
);

-- Table: publicdata_education_390__APP_LIBRARY_CLUBS_BORYEONG_CHUNGNAM
CREATE TABLE "aihub_education"."publicdata_education_390__APP_LIBRARY_CLUBS_BORYEONG_CHUNGNAM" (
    "APPLICATION_DATE" TEXT,
    "APPLICATION_TIME" TEXT,
    "MEETING_NAME" TEXT,
    "PURPOSE_OF_USE" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_education_3947__GBGJ_MUNICIPAL_LIBRARY_LOCAL_ARCHIVE
CREATE TABLE "aihub_education"."publicdata_education_3947__GBGJ_MUNICIPAL_LIBRARY_LOCAL_ARCHIVE" (
    "REAL_NM_DATAO" TEXT,
    "BOOK_NMP" TEXT,
    "PUBLISHER_NMQ" TEXT,
    "AUTHOR_NMR" TEXT,
    "DATA_BASE_DTS" TEXT
);

-- Table: publicdata_education_3978__C_STS_GN_P_LIBRARY
CREATE TABLE "aihub_education"."publicdata_education_3978__C_STS_GN_P_LIBRARY" (
    "SERIAL_NUMK" NUMERIC,
    "METROPOLITAN_CITYL" TEXT,
    "CITY_COUNTY_NMM" TEXT,
    "LIBRARY_NMN" TEXT,
    "POSTAL_CDO" NUMERIC,
    "ADDRESSP" TEXT,
    "HOMEPAGEQ" TEXT,
    "PHONE_NUMR" TEXT,
    "CLOSED_DAYS" TEXT,
    "OPEN_YEART" NUMERIC,
    "LIBRARY_CLASU" TEXT,
    "ESTABLISHMENT_SJV" TEXT,
    "FAX_NUMW" TEXT
);

-- Table: publicdata_education_4471__KOSAF_STUDENT_FINANCIAL_SU_INFO
CREATE TABLE "aihub_education"."publicdata_education_4471__KOSAF_STUDENT_FINANCIAL_SU_INFO" (
    "NUMD" NUMERIC,
    "N_O_I_U" TEXT,
    "PRODUCT_NMF" TEXT,
    "O_I_C_W" TEXT,
    "PRODUCT_CLASH" TEXT,
    "STUDENT_TYPE_CLASI" TEXT,
    "UNIVERSITY_CLASJ" TEXT,
    "GRADE_CLASK" TEXT,
    "DEPARTMENT_CLASL" TEXT,
    "P_C_D_CV" TEXT,
    "INCOME_STANDARD_DETAILSN" TEXT,
    "SUPPORT_DETAILS_DETAILSO" TEXT,
    "S_Q_D_A" TEXT,
    "R_R_S_D_BB" TEXT,
    "D_A_R_D_E_C" TEXT,
    "S_M_D_DE" TEXT,
    "D_N_P_S_EA" TEXT,
    "Q_R_D_F" TEXT,
    "R_M_D_G" TEXT,
    "S_D_D_H" TEXT
);

-- Table: publicdata_education_4501__M_USAGE_STS_KOJOB
CREATE TABLE "aihub_education"."publicdata_education_4501__M_USAGE_STS_KOJOB" (
    "BASE_DTX" TEXT,
    "YOUTH_EXPERIENCE_CENTERY" NUMERIC,
    "C_E_C_VA" NUMERIC,
    "EXHIBITION_HALLA" NUMERIC,
    "SUMB" NUMERIC
);

-- Table: publicdata_education_4502__NUM_KOJOB_GROUP_PASSENGERS
CREATE TABLE "aihub_education"."publicdata_education_4502__NUM_KOJOB_GROUP_PASSENGERS" (
    "BASE_DTC" TEXT,
    "YOUTH_EXPERIENCE_CENTERD" NUMERIC,
    "C_E_C_BB" NUMERIC,
    "EXHIBITION_HALLF" NUMERIC,
    "SUMG" NUMERIC
);

-- Table: publicdata_education_4542__NRF_KCI_CITATION_IDX_INFO
CREATE TABLE "aihub_education"."publicdata_education_4542__NRF_KCI_CITATION_IDX_INFO" (
    "I_S_C_P_N_BB" TEXT,
    "N_S_P_K_L_C" TEXT,
    "F_L_N_A_S_DE" TEXT,
    "ISSUING_INSTITUTIONN" TEXT,
    "I_A_E_F" TEXT,
    "MAJOR_CLASP" TEXT,
    "M_CLASQ" TEXT,
    "REGISTERED_INFR" TEXT,
    "W_S_I_I_I_K_J_L_2_Y_J" TEXT,
    "I_I_K_J_L_2_Y_K" NUMERIC,
    "E_S_Q_I_2_Y_L" NUMERIC,
    "CENTRALITY_IDX_3_YEARSV" NUMERIC,
    "IMMEDIACY_IDXW" NUMERIC,
    "SELF_QUOTE_RATE_2_YEARSX" NUMERIC,
    "TWO_YEARS_PAPERSY" NUMERIC,
    "NUM_CITATIONS_2_YEARSZ" NUMERIC,
    "W_S_C_2_Y_RC" NUMERIC
);

-- Table: publicdata_education_4544__C_STS_MENTORING_MENTORS_COLLEGE_STUD
CREATE TABLE "aihub_education"."publicdata_education_4544__C_STS_MENTORING_MENTORS_COLLEGE_STUD" (
    "NUML" NUMERIC,
    "YEARM" NUMERIC,
    "GENDERN" TEXT,
    "SPECIALIZED_DEPARTMENTO" TEXT,
    "PARTICIPANT_CLASP" TEXT
);

-- Table: publicdata_education_4588__NRF_KCI_JOURNAL_INFO
CREATE TABLE "aihub_education"."publicdata_education_4588__NRF_KCI_JOURNAL_INFO" (
    "I_S_C_P_N_E_F" TEXT,
    "I_S_C_P_N_P_F_G" TEXT,
    "N_S_P_K_L_H" TEXT,
    "F_L_N_A_S_I" TEXT,
    "LISTING_CLASF" TEXT,
    "F_A_J_R_K" TEXT,
    "YEAR_ITS_FOUNDATIONH" NUMERIC,
    "PUBLICATION_PERIODI" TEXT,
    "LANGUAGE_USEDJ" TEXT,
    "I_I_N_K_O" TEXT,
    "I_A_N_E_P" TEXT,
    "U_A_R_I_Q" TEXT,
    "ORGANIZATION_CLASN" TEXT
);

-- Table: publicdata_education_4602__KOSAF_YOUTH_EDU_MNG_I_INCOME_M_CLOSI
CREATE TABLE "aihub_education"."publicdata_education_4602__KOSAF_YOUTH_EDU_MNG_I_INCOME_M_CLOSI" (
    "PRODUCT_NMU" TEXT,
    "NM_UNIVERSITYV" TEXT,
    "CLOSING_DTW" TEXT,
    "CLOSING_SERIAL_NUMX" NUMERIC,
    "NUM_PAYERSY" NUMERIC,
    "N_T_P_A_J" NUMERIC,
    "RETURN_AMTA" NUMERIC,
    "T_I_I_A_L" NUMERIC,
    "BALANCE_TREASURYC" NUMERIC,
    "C_I_A_N" NUMERIC,
    "C_I_B_O" NUMERIC,
    "EXECUTION_GRANT_AMTF" NUMERIC,
    "INTEREST_EXECUTION_AMTG" NUMERIC,
    "R_I_E_A_1_RC" NUMERIC,
    "R_I_E_A_2_S" NUMERIC
);

-- Table: publicdata_education_4603__KOSAF_YOUTH_EDU_MNG_ASSIGNMENT_AMT_D
CREATE TABLE "aihub_education"."publicdata_education_4603__KOSAF_YOUTH_EDU_MNG_ASSIGNMENT_AMT_D" (
    "PRODUCT_NMJ" TEXT,
    "ALLOC_YEARK" NUMERIC,
    "ASSIGNMENT_CLASL" TEXT,
    "ASSIGNMENT_SERIAL_NUMM" NUMERIC,
    "NM_UNIVERSITYN" TEXT,
    "TOTAL_ALLOC_AMTO" NUMERIC,
    "A_A_1_S_Z" NUMERIC,
    "A_A_2_S_ZZ" NUMERIC,
    "ALLOC_DTR" TEXT
);

-- Table: publicdata_education_4604__DETAILS_ATTACHED_FILE_KOSAF_YOUTH_ED
CREATE TABLE "aihub_education"."publicdata_education_4604__DETAILS_ATTACHED_FILE_KOSAF_YOUTH_ED" (
    "PRODUCT_NMS" TEXT,
    "YEART" NUMERIC,
    "SEMESTERU" NUMERIC,
    "NM_UNIVERSITYV" TEXT,
    "ATTACHMENT_SERIAL_NUMW" NUMERIC,
    "FILE_CLASX" TEXT,
    "UPLOAD_FILE_NMY" TEXT,
    "UPLOAD_FILE_ORIGINAL_NMZ" TEXT
);

-- Table: publicdata_education_4608__KOSAF_YOUTH_EDU_MNG_FUNDAMENTALS_TRE
CREATE TABLE "aihub_education"."publicdata_education_4608__KOSAF_YOUTH_EDU_MNG_FUNDAMENTALS_TRE" (
    "PRODUCT_NMW" TEXT,
    "YEARX" NUMERIC,
    "SEMESTERY" NUMERIC,
    "NM_UNIVERSITYZ" TEXT,
    "INTEREST_ACCRUAL_DTA" TEXT,
    "INTEREST_INCOME_AMTB" NUMERIC
);

-- Table: publicdata_education_4611__KOSAF_YOUTH_EDU_MNG_APP_PERIOD_UNIV_
CREATE TABLE "aihub_education"."publicdata_education_4611__KOSAF_YOUTH_EDU_MNG_APP_PERIOD_UNIV_" (
    "NM_UNIVERSITYS" TEXT,
    "PRODUCT_NMT" TEXT,
    "S_P_T_U" TEXT,
    "SCHOLARSHIP_SCHOOLV" NUMERIC,
    "SCHOLARSHIP_SEMESTERW" NUMERIC,
    "SCHOLARSHIP_MEETINGX" NUMERIC,
    "S_B_P_C_Y" TEXT,
    "USAGE_STAZ" TEXT,
    "I_R_T_C_1_ZZ" TEXT,
    "I_R_T_C_2_VA" TEXT
);

-- Table: publicdata_education_4614__BASICS_UNIVERSITIES_ASSIGNED_KOSAF_Y
CREATE TABLE "aihub_education"."publicdata_education_4614__BASICS_UNIVERSITIES_ASSIGNED_KOSAF_Y" (
    "PRODUCT_NMV" TEXT,
    "ALLOC_YEARW" NUMERIC,
    "ASSIGNMENT_CLASX" TEXT,
    "ASSIGNMENT_SERIAL_NUMY" NUMERIC,
    "NM_UNIVERSITYZ" TEXT
);

-- Table: publicdata_education_4615__DETAILS_RETURN_KOSAF_YOUTH_EDU_MNG_G
CREATE TABLE "aihub_education"."publicdata_education_4615__DETAILS_RETURN_KOSAF_YOUTH_EDU_MNG_G" (
    "PRODUCT_NMA" TEXT,
    "ALLOC_YEARB" NUMERIC,
    "ASSIGNMENT_CLASC" TEXT,
    "ASSIGNMENT_SERIAL_NUMD" NUMERIC,
    "ALLOC_SEMESTERE" NUMERIC,
    "NM_UNIVERSITYF" TEXT,
    "APPLICATION_SERIAL_NUMG" NUMERIC,
    "RETURN_SERIAL_NUMH" NUMERIC,
    "RETURN_AMTI" NUMERIC,
    "DT_TIME_RETURNJ" TEXT,
    "RETURN_ITEM_NUMK" NUMERIC,
    "REASON_RETURNL" TEXT,
    "SCHOLARSHIP_RETURN_NUMM" TEXT,
    "RETURN_INTEREST_AMTN" NUMERIC,
    "RETURN_AMT_TREASURYO" NUMERIC,
    "RETURN_CANCELLATION_DTP" TEXT,
    "RETURN_CANCELLATION_AMTQ" NUMERIC,
    "R_C_P_S_C_H" TEXT,
    "R_C_A_P_N_I" NUMERIC,
    "S_R_S_C_J" TEXT,
    "RETURN_APPROVAL_DT_TIMEU" TEXT,
    "S_A_S_N_L" NUMERIC,
    "U_S_D_R_S_M" TEXT
);

-- Table: publicdata_education_4621__NUM_NEW_SUBSCRIBERS_KOJOB_HOMEPAGE
CREATE TABLE "aihub_education"."publicdata_education_4621__NUM_NEW_SUBSCRIBERS_KOJOB_HOMEPAGE" (
    "BASE_DTD" TEXT,
    "NUM_NEW_SUBSCRIPTIONSE" NUMERIC,
    "C_N_S_Q" NUMERIC
);

-- Table: publicdata_education_4630__C_STS_LOAN_BALANCE_OVERDUE_BALANCE_K
CREATE TABLE "aihub_education"."publicdata_education_4630__C_STS_LOAN_BALANCE_OVERDUE_BALANCE_K" (
    "BASE_YEAR_MONTHC" TEXT,
    "PRODUCT_CDD" TEXT,
    "ADDRESSE" TEXT,
    "LOAN_YEARF" NUMERIC,
    "LOAN_SEMESTERG" NUMERIC,
    "LOAN_AMTH" NUMERIC,
    "LOAN_BALANCEI" NUMERIC,
    "T_B_O_B_A" NUMERIC,
    "L_C_B_O_B_BB" NUMERIC,
    "LOAN_INTEREST_RATEL" NUMERIC,
    "PRODUCT_CLAS_CDM" TEXT
);

-- Table: publicdata_education_4647__BASIS_CALCULATING_KOSAF_D_LINKED_TUI
CREATE TABLE "aihub_education"."publicdata_education_4647__BASIS_CALCULATING_KOSAF_D_LINKED_TUI" (
    "SURVEY_YEARC" NUMERIC,
    "ORDERD" NUMERIC,
    "SCHOOL_NME" TEXT,
    "MAIN_BRANCH_CLASF" TEXT,
    "FILE_ORDERG" NUMERIC,
    "TITLEH" TEXT,
    "APPLIED_YEARI" NUMERIC,
    "FILE_NMJ" TEXT
);

-- Table: publicdata_education_4648__KOSAF_P_NOTICE_LINKED_TUITION_PAYMEN
CREATE TABLE "aihub_education"."publicdata_education_4648__KOSAF_P_NOTICE_LINKED_TUITION_PAYMEN" (
    "SURVEY_YEARK" NUMERIC,
    "ORDERL" NUMERIC,
    "SCHOOL_NMM" TEXT,
    "MAIN_BRANCH_CLASN" TEXT,
    "PAY_CLASO" TEXT,
    "PAY_METHOD_NMP" TEXT,
    "APPLIED_YEARQ" NUMERIC,
    "IMPLEMENTATION_STAR" TEXT,
    "F_I_Y_U" NUMERIC,
    "NUM_STUDENTS_USING_ITT" NUMERIC,
    "AMT_USEDU" NUMERIC,
    "NUM_INSTALLMENT_PAYSV" NUMERIC,
    "NUM_MONTHS_INSTALLMENTSW" NUMERIC,
    "S_C_C_C_R_Z" NUMERIC,
    "ADDITION_STAY" TEXT,
    "THIS_YEAR_PLANZ" TEXT
);

-- Table: publicdata_education_4649__KOSAF_LOAN_HOLDING_PERIOD_MNG_S
CREATE TABLE "aihub_education"."publicdata_education_4649__KOSAF_LOAN_HOLDING_PERIOD_MNG_S" (
    "PRODUCT_NMA" TEXT,
    "NM_UNIVERSITYB" TEXT,
    "NM_DEPARTMENTC" TEXT,
    "M_N_M_H_P_A" NUMERIC
);

-- Table: publicdata_education_4651__INFO_STS_STUDENT_LOANS_DISCLOSED_KOS
CREATE TABLE "aihub_education"."publicdata_education_4651__INFO_STS_STUDENT_LOANS_DISCLOSED_KOS" (
    "SURVEY_YEARJ" NUMERIC,
    "ORDERK" NUMERIC,
    "SCHOOL_NML" TEXT,
    "MAIN_BRANCH_CLASM" TEXT,
    "APPLIED_YEARN" NUMERIC,
    "SCHOOL_CLASO" TEXT,
    "SCHOOL_CLASP" TEXT,
    "NUM_ENROLLED_STUDENTSQ" NUMERIC,
    "T_N_S_G_S_L_O" NUMERIC,
    "T_A_G_S_L_P" NUMERIC,
    "N_S_G_S_L_T_Q" NUMERIC,
    "T_A_G_S_L_RC" NUMERIC,
    "T_N_S_E_L_S" NUMERIC,
    "T_A_E_S_L_T" NUMERIC,
    "N_S_E_S_L_T_U" NUMERIC,
    "E_S_L_T_A_V" NUMERIC
);

-- Table: publicdata_education_4652__KOSAF_STS_SURVEY_SYS_MENU_HELP
CREATE TABLE "aihub_education"."publicdata_education_4652__KOSAF_STS_SURVEY_SYS_MENU_HELP" (
    "YEARZ" NUMERIC,
    "BUSINESS_CLASA" TEXT,
    "MENU_NMB" TEXT,
    "DETAILED_HELPC" TEXT,
    "SUMMARY_HELPD" TEXT
);

-- Table: publicdata_education_4653__HISTORY_RETURN_KOSAF_YOUTH_EDU_MNG_G
CREATE TABLE "aihub_education"."publicdata_education_4653__HISTORY_RETURN_KOSAF_YOUTH_EDU_MNG_G" (
    "PRODUCT_CDE" TEXT,
    "ALLOC_YEARF" NUMERIC,
    "ASSIGNMENT_CLAS_CDG" TEXT,
    "ASSIGNMENT_SERIAL_NUMH" NUMERIC,
    "ALLOC_SEMESTERI" NUMERIC,
    "UNIVERSITY_CDJ" TEXT,
    "APPLICATION_SERIAL_NUMK" NUMERIC,
    "RETURN_SERIAL_NUML" NUMERIC,
    "DETAILED_DT_TIME_CHANGEM" TEXT,
    "RETURN_AMTN" NUMERIC,
    "DT_TIME_RETURNO" TEXT,
    "RETURN_ITEM_NUMP" NUMERIC,
    "REASON_RETURNQ" TEXT,
    "SCHOLARSHIP_RETURN_NUMR" TEXT,
    "RETURN_INTEREST_AMTS" NUMERIC,
    "RETURN_AMT_TREASURYT" NUMERIC,
    "R_C_P_S_C_M" TEXT,
    "R_C_A_P_N_N" NUMERIC,
    "S_R_S_C_O" TEXT,
    "RETURN_APPROVAL_DT_TIMEX" TEXT,
    "S_A_S_N_Q" NUMERIC,
    "U_S_D_R_S_RC" TEXT,
    "DT_TIME_INITIAL_REA" TEXT,
    "LAST_CHANGE_DT_TIMEB" TEXT
);

-- Table: publicdata_education_4656__INFO_STS_STUDENT_LOANS_LINKED_D_KOSA
CREATE TABLE "aihub_education"."publicdata_education_4656__INFO_STS_STUDENT_LOANS_LINKED_D_KOSA" (
    "SURVEY_YEART" NUMERIC,
    "ORDERU" NUMERIC,
    "SCHOOL_NMV" TEXT,
    "MAIN_BRANCH_CLASW" TEXT,
    "NM_DEPARTMENTX" TEXT,
    "COLLEGE_SCIENCEY" TEXT,
    "APPLIED_YEARZ" NUMERIC,
    "SCHOOL_CLASA" TEXT,
    "DAY_NIGHT_SEASON_CLASB" TEXT,
    "CHARACTERISTICS_SJC" TEXT,
    "T_N_S_G_S_L_Q" NUMERIC,
    "T_A_G_S_L_RC" NUMERIC,
    "N_S_G_S_L_T_S" NUMERIC,
    "T_A_G_S_L_T" NUMERIC,
    "T_N_S_E_L_U" NUMERIC,
    "T_A_E_S_L_V" NUMERIC,
    "N_S_E_S_L_T_W" NUMERIC,
    "E_S_L_T_A_X" NUMERIC
);

-- Table: publicdata_education_4657__INFO_ADVANCED_STS_KOSAF_STUDENT_LOAN
CREATE TABLE "aihub_education"."publicdata_education_4657__INFO_ADVANCED_STS_KOSAF_STUDENT_LOAN" (
    "SUBMISSION_YEARL" NUMERIC,
    "ORDERM" NUMERIC,
    "BASE_YEARN" NUMERIC,
    "SCHOOL_CLASO" TEXT,
    "UNDERGRADUATE_CLASP" TEXT,
    "NM_SERIESQ" TEXT,
    "NM_DEPARTMENTR" TEXT,
    "DEPARTMENT_TYPE_NMS" TEXT,
    "MAIN_BASEBALL_TEAM_NMT" TEXT,
    "SCHOOL_NMU" TEXT,
    "MAIN_BRANCH_CLAS_NMV" TEXT,
    "COLLEGE_NMW" TEXT,
    "T_N_S_G_S_L_F" NUMERIC,
    "T_A_G_S_L_G" NUMERIC,
    "N_S_G_S_L_T_H" NUMERIC,
    "T_A_G_S_L_I" NUMERIC,
    "T_N_S_E_L_J" NUMERIC,
    "T_A_E_S_L_K" NUMERIC,
    "N_S_E_S_L_T_L" NUMERIC,
    "E_S_L_T_A_M" NUMERIC,
    "IDXF" NUMERIC,
    "DT_ENTRYG" TEXT
);

-- Table: publicdata_education_4658__BASIC_HISTORY_M_CLOSING_I_EARNINGS_K
CREATE TABLE "aihub_education"."publicdata_education_4658__BASIC_HISTORY_M_CLOSING_I_EARNINGS_K" (
    "PRODUCT_CDH" TEXT,
    "UNIVERSITY_CDI" TEXT,
    "CLOSING_DTJ" TEXT,
    "CLOSING_SERIAL_NUMK" NUMERIC,
    "DETAILED_DT_TIME_CHANGEL" TEXT,
    "NUM_PAYERSM" NUMERIC,
    "N_T_P_A_V" NUMERIC,
    "RETURN_AMTO" NUMERIC,
    "T_I_I_A_X" NUMERIC,
    "BALANCE_TREASURYQ" NUMERIC,
    "C_I_A_Z" NUMERIC,
    "C_I_B_ZZ" NUMERIC,
    "EXECUTION_GRANT_AMTT" NUMERIC,
    "INTEREST_EXECUTION_AMTU" NUMERIC,
    "R_I_E_A_1_DE" NUMERIC,
    "R_I_E_A_2_XZ" NUMERIC,
    "DT_TIME_INITIAL_REX" TEXT,
    "LAST_CHANGE_DT_TIMEY" TEXT
);

-- Table: publicdata_education_4659__KOSAF_YOUTH_EDU_MNG_ENFORCEMENT_DETA
CREATE TABLE "aihub_education"."publicdata_education_4659__KOSAF_YOUTH_EDU_MNG_ENFORCEMENT_DETA" (
    "PRODUCT_CDZ" TEXT,
    "YEARA" NUMERIC,
    "SEMESTERB" NUMERIC,
    "UNIVERSITY_CDC" TEXT,
    "L_D_L_C_C_G" TEXT,
    "LABOR_DETAILS_CLAS_CDE" TEXT,
    "DETAILED_DT_TIME_CHANGEF" TEXT,
    "NUM_WORK_DEPARTMENTSG" NUMERIC,
    "TARGET_NUM_PEOPLEH" NUMERIC,
    "EXECUTION_AMTI" NUMERIC,
    "DT_TIME_INITIAL_REJ" TEXT,
    "LAST_CHANGE_DT_TIMEK" TEXT
);

-- Table: publicdata_education_4660__BASIC_HISTORY_UNIVERSITIES_ASSIGNED_
CREATE TABLE "aihub_education"."publicdata_education_4660__BASIC_HISTORY_UNIVERSITIES_ASSIGNED_" (
    "PRODUCT_CDL" TEXT,
    "ALLOC_YEARM" NUMERIC,
    "ASSIGNMENT_CLAS_CDN" TEXT,
    "ASSIGNMENT_SERIAL_NUMO" NUMERIC,
    "UNIVERSITY_CDP" TEXT,
    "DETAILED_DT_TIME_CHANGEQ" TEXT,
    "NOTER" TEXT,
    "DT_TIME_INITIAL_RES" TEXT,
    "LAST_CHANGE_DT_TIMET" TEXT
);

-- Table: publicdata_education_4661__O_RESULTS_KOSAF_YOUTH_EDU_SU_ATTACHM
CREATE TABLE "aihub_education"."publicdata_education_4661__O_RESULTS_KOSAF_YOUTH_EDU_SU_ATTACHM" (
    "PRODUCT_CDU" TEXT,
    "YEARV" NUMERIC,
    "SEMESTERW" NUMERIC,
    "UNIVERSITY_CDX" TEXT,
    "ATTACHMENT_SERIAL_NUMY" NUMERIC,
    "DETAILED_DT_TIME_CHANGEZ" TEXT,
    "FILE_CLAS_CDA" TEXT,
    "FILE_STORAGE_PATH_NMB" TEXT,
    "UPLOAD_FILE_NMC" TEXT,
    "UPLOAD_FILE_ORIGINAL_NMD" TEXT,
    "DT_TIME_INITIAL_REE" TEXT,
    "LAST_CHANGE_DT_TIMEF" TEXT
);

-- Table: publicdata_education_4664__REDUCTION_EXEMPTION_TUITION_FEES_LIN
CREATE TABLE "aihub_education"."publicdata_education_4664__REDUCTION_EXEMPTION_TUITION_FEES_LIN" (
    "ORDERY" NUMERIC,
    "SCHOOL_NMZ" TEXT,
    "MAIN_BRANCH_CLASA" TEXT,
    "E_3_C_R_U" NUMERIC,
    "E_30_AMT_COMPLIANCEC" NUMERIC,
    "TOTAL_TUITION_INCOMED" NUMERIC,
    "E_1_C_S_U_P_X" NUMERIC,
    "E_1_C_S_U_A_Y" NUMERIC,
    "E_1_C_G_S_P_Z" NUMERIC,
    "E_1_C_G_S_A_ZZ" NUMERIC,
    "E_3_C_S_U_P_VA" NUMERIC,
    "E_3_C_S_U_A_CV" NUMERIC,
    "E_3_P_C_C_G_S_S_DE" NUMERIC,
    "E_3_C_G_S_A_XZ" NUMERIC,
    "T_A_U_T_I_A" NUMERIC,
    "T_I_G_S_T_BB" NUMERIC
);

-- Table: publicdata_education_4666__KOSAF_LOAN_LIMIT_MNG_S
CREATE TABLE "aihub_education"."publicdata_education_4666__KOSAF_LOAN_LIMIT_MNG_S" (
    "PRODUCT_NMX" TEXT,
    "NM_UNIVERSITYY" TEXT,
    "NM_DEPARTMENTZ" TEXT,
    "LIMIT_AMTA" NUMERIC
);

-- Table: publicdata_education_4667__KOSAF_TUITION_PAYMENT_SYS
CREATE TABLE "aihub_education"."publicdata_education_4667__KOSAF_TUITION_PAYMENT_SYS" (
    "SURVEY_YEARB" NUMERIC,
    "ORDERC" NUMERIC,
    "SCHOOL_NMD" TEXT,
    "MAIN_BRANCH_CLASE" TEXT,
    "PAY_CLASF" TEXT,
    "PAY_METHOD_NMG" TEXT,
    "APPLIED_YEARH" NUMERIC,
    "IMPLEMENTATION_STAI" TEXT,
    "F_I_Y_X" NUMERIC,
    "NUM_STUDENTS_USING_ITK" NUMERIC,
    "AMT_USEDL" NUMERIC,
    "NUM_INSTALLMENT_PAYSM" NUMERIC,
    "NUM_MONTHS_INSTALLMENTSN" NUMERIC,
    "S_C_C_C_R_CV" NUMERIC,
    "ADDITION_STAP" TEXT,
    "THIS_YEAR_PLANQ" TEXT,
    "S_N_A_N_A" NUMERIC,
    "RECIPIENT_SCHOLARSHIPS" TEXT,
    "R_I_A_C_C" TEXT,
    "O_A_A_M_DE" TEXT,
    "R_P_A_S_EA" TEXT
);

-- Table: publicdata_education_4668__KOSAF_STUDENT_LOAN_STS_UNIV_INFO_D
CREATE TABLE "aihub_education"."publicdata_education_4668__KOSAF_STUDENT_LOAN_STS_UNIV_INFO_D" (
    "SURVEY_YEARW" NUMERIC,
    "ORDERX" NUMERIC,
    "SCHOOL_CLASY" TEXT,
    "UNIVERSITY_CLAS_NMZ" TEXT,
    "SCHOOL_NMA" TEXT,
    "MAIN_BRANCH_CLASB" TEXT,
    "APPLIED_YEARC" NUMERIC,
    "NUM_ENROLLED_STUDENTSD" NUMERIC,
    "T_N_S_G_S_L_N" NUMERIC,
    "T_A_G_S_L_O" NUMERIC,
    "N_S_G_S_L_T_P" NUMERIC,
    "T_A_G_S_L_Q" NUMERIC,
    "T_N_S_E_L_RC" NUMERIC,
    "T_A_E_S_L_S" NUMERIC,
    "N_S_E_S_L_T_T" NUMERIC,
    "E_S_L_T_A_U" NUMERIC
);

-- Table: publicdata_education_4669__KOSAF_D_LOAN_DIVISION_EXECUTION_STS
CREATE TABLE "aihub_education"."publicdata_education_4669__KOSAF_D_LOAN_DIVISION_EXECUTION_STS" (
    "BASE_DTM" TEXT,
    "PRODUCT_NMN" TEXT,
    "EXECUTION_CYCLEO" NUMERIC,
    "N_N_E_S_D_Y" NUMERIC,
    "N_E_A_S_D_K_1_M_Z" NUMERIC
);

-- Table: publicdata_education_4671__KOSAF_D_LOAN_EXECUTION_STS
CREATE TABLE "aihub_education"."publicdata_education_4671__KOSAF_D_LOAN_EXECUTION_STS" (
    "BASE_DTU" TEXT,
    "PRODUCT_NMV" TEXT,
    "N_N_E_S_D_A" NUMERIC,
    "N_E_A_S_D_K_1_M_BB" NUMERIC
);

-- Table: publicdata_education_4672__KOSAF_LOANABLE_PROD_S
CREATE TABLE "aihub_education"."publicdata_education_4672__KOSAF_LOANABLE_PROD_S" (
    "PRODUCT_NMY" TEXT,
    "NM_UNIVERSITYZ" TEXT,
    "S_L_A_EA" TEXT
);

-- Table: publicdata_education_4674__STS_I_EXEMPTION_MILITARY_SERVICE_KOS
CREATE TABLE "aihub_education"."publicdata_education_4674__STS_I_EXEMPTION_MILITARY_SERVICE_KOS" (
    "BASE_YEAR_MONTHE" TEXT,
    "LOAN_YEARF" NUMERIC,
    "LOAN_SEMESTERG" NUMERIC,
    "PRODUCT_CDH" TEXT,
    "PRODUCT_CD_NMI" TEXT,
    "AGEJ" NUMERIC,
    "LOAN_AMTK" NUMERIC,
    "INTEREST_EXEMPTION_AMTL" NUMERIC,
    "LOAN_BALANCEM" NUMERIC
);

-- Table: publicdata_education_4675__BASIC_HISTORY_N_TREASURY_I_PROFIT_KO
CREATE TABLE "aihub_education"."publicdata_education_4675__BASIC_HISTORY_N_TREASURY_I_PROFIT_KO" (
    "PRODUCT_CDN" TEXT,
    "YEARO" NUMERIC,
    "SEMESTERP" NUMERIC,
    "UNIVERSITY_CDQ" TEXT,
    "INTEREST_ACCRUAL_DTR" TEXT,
    "DETAILED_DT_TIME_CHANGES" TEXT,
    "INTEREST_INCOME_AMTT" NUMERIC,
    "DT_TIME_INITIAL_REU" TEXT,
    "LAST_CHANGE_DT_TIMEV" TEXT
);

-- Table: publicdata_education_4676__CONSIDERATION_FACTORS_ESTABLISHING_T
CREATE TABLE "aihub_education"."publicdata_education_4676__CONSIDERATION_FACTORS_ESTABLISHING_T" (
    "TOTAL_NUMW" NUMERIC,
    "SURVEY_YEARX" NUMERIC,
    "ORDERY" NUMERIC,
    "SCHOOL_NMZ" TEXT,
    "MAIN_BRANCH_CLASA" TEXT,
    "APPLIED_YEARB" NUMERIC,
    "CONSIDERING_ELEMENT_NMC" TEXT,
    "CONSIDERATION_STAD" TEXT,
    "CONTENTE" TEXT,
    "INITIAL_RE_DTF" TEXT,
    "RESULT_VALUEG" TEXT
);

-- Table: publicdata_education_4677__STS_SCHOLARSHIP_RECIPIENTS_KOSAF_UNI
CREATE TABLE "aihub_education"."publicdata_education_4677__STS_SCHOLARSHIP_RECIPIENTS_KOSAF_UNI" (
    "NM_UNIVERSITYH" TEXT,
    "SCHOOL_SYSI" TEXT,
    "ESTABLISHMENTJ" TEXT,
    "REGIONK" TEXT,
    "S_S_S_K" NUMERIC,
    "C_S_S_L" NUMERIC,
    "S_S_L_G_M" NUMERIC,
    "S_S_E_O_N" NUMERIC,
    "SUBTOTAL_SCHOOL_TUITIONP" NUMERIC,
    "S_S_E_S_P" NUMERIC,
    "S_L_I_F_Q" NUMERIC,
    "S_S_W_S_RC" NUMERIC,
    "S_S_D_S_S" NUMERIC,
    "S_S_S_E_T" NUMERIC,
    "SCHOOL_TUITION_OTHERSV" NUMERIC,
    "SUM_TOTALW" NUMERIC
);

-- Table: publicdata_education_4681__STS_AMT_SU_T_1_KOSAF_N_SCHOLARSHIP
CREATE TABLE "aihub_education"."publicdata_education_4681__STS_AMT_SU_T_1_KOSAF_N_SCHOLARSHIP" (
    "YEARI" NUMERIC,
    "SEMESTERJ" TEXT,
    "SCHOLARSHIP_PRODUCTK" TEXT,
    "SCHOOL_SYS_CLASL" TEXT,
    "ESTABLISHMENT_CLASM" TEXT,
    "CLAS_UNIVERSITY_LOCN" TEXT,
    "SUPPORT_AMTO" NUMERIC
);

-- Table: publicdata_education_4683__KOSAF_STATEMENT_FINANCIAL_POSITION
CREATE TABLE "aihub_education"."publicdata_education_4683__KOSAF_STATEMENT_FINANCIAL_POSITION" (
    "SJD" TEXT,
    "E_13TH_PARTY_ORIGIN_1E" NUMERIC,
    "E_13TH_PARTY_ORIGIN_2F" NUMERIC,
    "E_1_E_O_1_ZZ" NUMERIC,
    "E_1_E_O_2_VA" NUMERIC
);

-- Table: publicdata_education_4685__KOSAF_MENTORING_MNG_ACADEMIC_TIMBLE_
CREATE TABLE "aihub_education"."publicdata_education_4685__KOSAF_MENTORING_MNG_ACADEMIC_TIMBLE_" (
    "CLASS_CLAS_CDQ" TEXT,
    "DAY_WEEK_CLAS_CDR" TEXT,
    "STUDY_START_TIMES" TEXT,
    "END_STUDY_TIMET" TEXT
);

-- Table: publicdata_education_4699__KOSAF_GRADUATE_SCHOOL_TUITION_INFO_R
CREATE TABLE "aihub_education"."publicdata_education_4699__KOSAF_GRADUATE_SCHOOL_TUITION_INFO_R" (
    "SURVEY_YEARF" NUMERIC,
    "ORDERG" NUMERIC,
    "SCHOOL_NMH" TEXT,
    "MAIN_BRANCH_CLASI" TEXT,
    "NM_DEPARTMENTJ" TEXT,
    "COLLEGE_SCIENCEK" TEXT,
    "MASTER_PHD_PROGRAMSL" TEXT,
    "G_S_A_O_H" TEXT,
    "APPLIED_YEARN" NUMERIC,
    "DAY_NIGHT_SEASON_CLASO" TEXT,
    "CHARACTERISTICS_SJP" TEXT,
    "ADMISSION_AMTQ" NUMERIC,
    "TUITION_FEER" NUMERIC,
    "E_M_F_N" NUMERIC,
    "ADMISSION_QUOTAT" NUMERIC,
    "E_A_P_S_Y_P" NUMERIC,
    "A_Q_P_Y_Q" NUMERIC,
    "INITIAL_RE_DTW" TEXT,
    "S_N_A_N_S" NUMERIC
);

-- Table: publicdata_education_4730__DEPARTMENT_TUITION_INFO_LINKED_D_KOS
CREATE TABLE "aihub_education"."publicdata_education_4730__DEPARTMENT_TUITION_INFO_LINKED_D_KOS" (
    "TOTAL_NUMA" NUMERIC,
    "SURVEY_YEARB" NUMERIC,
    "ORDERC" NUMERIC,
    "SCHOOL_NMD" TEXT,
    "MAIN_BRANCH_CLASE" TEXT,
    "GRADE_CLASF" TEXT,
    "NM_DEPARTMENTG" TEXT,
    "COLLEGE_SCIENCEH" TEXT,
    "APPLIED_YEARI" NUMERIC,
    "DAY_NIGHT_SEASON_CLASJ" TEXT,
    "CHARACTERISTICS_SJK" TEXT,
    "ADMISSION_AMTL" NUMERIC,
    "TUITION_FEEM" NUMERIC,
    "E_M_F_A" NUMERIC,
    "ADMISSION_QUOTAO" NUMERIC,
    "E_A_P_S_Y_C" NUMERIC,
    "A_Q_P_Y_DE" NUMERIC,
    "INITIAL_RE_DTR" TEXT,
    "S_N_A_N_F" NUMERIC
);

-- Table: publicdata_education_4741__KDN_CHILDREN_LIBRARY_BOOK_LIST_INFO
CREATE TABLE "aihub_education"."publicdata_education_4741__KDN_CHILDREN_LIBRARY_BOOK_LIST_INFO" (
    "NUMR" NUMERIC,
    "SORTATIONS" TEXT,
    "MAJOR_CLAST" NUMERIC,
    "BOOK_NMU" TEXT,
    "SUBHEADV" TEXT,
    "PUBLISHING_HOUSEW" TEXT,
    "UNITX" TEXT,
    "QUANTITYY" NUMERIC
);

-- Table: publicdata_education_4747__INTERVIEW_DEPARTMENT_KRIVET_CAREERNE
CREATE TABLE "aihub_education"."publicdata_education_4747__INTERVIEW_DEPARTMENT_KRIVET_CAREERNE" (
    "SERIAL_NUMQ" NUMERIC,
    "INTERVIEW_TITLER" TEXT,
    "I_P_P_BB" TEXT,
    "QUESTION_1T" TEXT,
    "ANSWER_1U" TEXT,
    "QUESTION_2V" TEXT,
    "ANSWER_2W" TEXT,
    "QUESTION_3X" TEXT,
    "ANSWER_3Y" TEXT,
    "QUESTION_4Z" TEXT,
    "ANSWER_4A" TEXT,
    "QUESTION_5B" TEXT,
    "ANSWER_5C" TEXT,
    "QUESTION_6D" TEXT,
    "ANSWER_6E" TEXT,
    "QUESTION_7F" TEXT,
    "ANSWER_7G" TEXT,
    "QUESTION_8H" TEXT,
    "ANSWER_8I" TEXT,
    "QUESTION_9J" TEXT,
    "ANSWER_9K" TEXT,
    "QUESTION_10L" TEXT,
    "ANSWER_10M" TEXT,
    "QUESTION_11N" TEXT,
    "ANSWER_11O" TEXT,
    "QUESTION_12P" TEXT,
    "ANSWER_12Q" TEXT,
    "QUESTION_13R" TEXT,
    "ANSWER_13S" TEXT,
    "Q14T" TEXT,
    "ANSWER_14U" TEXT,
    "Q15V" TEXT,
    "ANSWER_15W" TEXT,
    "Q16X" TEXT,
    "ANSWER_16Y" TEXT,
    "QUESTION_17Z" TEXT,
    "ANSWER_17A" TEXT,
    "Q18B" TEXT,
    "ANSWER_18C" TEXT,
    "Q19D" TEXT
);

-- Table: publicdata_education_4756__KOSAF_EMPLOYEE_TRAINING_STS
CREATE TABLE "aihub_education"."publicdata_education_4756__KOSAF_EMPLOYEE_TRAINING_STS" (
    "COURSE_YEARR" NUMERIC,
    "EDU_CLASS" TEXT,
    "CURRICULUM_NMT" TEXT,
    "TRAINING_START_DTU" TEXT,
    "TRAINING_END_DTV" TEXT,
    "N_P_W_H_C_T_Q" NUMERIC,
    "T_H_C_H_RC" NUMERIC
);

-- Table: publicdata_education_4781__STS_PARENTAL_LEAVE_KOSAF
CREATE TABLE "aihub_education"."publicdata_education_4781__STS_PARENTAL_LEAVE_KOSAF" (
    "NUMC" NUMERIC,
    "POSITIOND" TEXT,
    "POSITIONE" TEXT,
    "REASON_LEAVE_ABSENCEF" TEXT,
    "START_DT_LEAVE_ABSENCEG" TEXT,
    "END_LEAVE_ABSENCEH" TEXT,
    "SC_DT_REINSTATEMENTI" TEXT
);

-- Table: publicdata_education_4908__KSSN_SOCIAL_WORKER_TRAINING_INFO
CREATE TABLE "aihub_education"."publicdata_education_4908__KSSN_SOCIAL_WORKER_TRAINING_INFO" (
    "EDU_NMS" TEXT,
    "TRAINING_START_DTT" TEXT,
    "TRAINING_END_DTU" TEXT,
    "INSTRUCTOR_AFFILIATEDV" TEXT
);

-- Table: publicdata_education_4928__KASFO_LOAN_ONE_STOP_SYS_MNG_CD
CREATE TABLE "aihub_education"."publicdata_education_4928__KASFO_LOAN_ONE_STOP_SYS_MNG_CD" (
    "ALLOC_YEARZ" NUMERIC,
    "RECEPTION_CLAS_CD_NMA" TEXT,
    "SCHOOL_LEVEL_CD_NMB" TEXT,
    "BUSINESS_CLAS_CD_NMC" TEXT,
    "EVALUATION_GROUP_CD_NMD" TEXT,
    "LARGE_CLAS_CD_NME" TEXT,
    "SCOREF" NUMERIC,
    "USAGE_STAG" TEXT,
    "RE_DTH" TEXT
);

-- Table: publicdata_education_4962__KASFO_FINANCING_ONE_STOP_SYS_USER_ME
CREATE TABLE "aihub_education"."publicdata_education_4962__KASFO_FINANCING_ONE_STOP_SYS_USER_ME" (
    "SCREEN_IDH" TEXT,
    "COLUMN_IDI" TEXT,
    "COLUMN_NMJ" TEXT,
    "SORT_ORDERK" NUMERIC,
    "REGISTRAR_IDL" TEXT,
    "RE_DTM" TEXT
);

-- Table: publicdata_education_4963__KASFO_WEBSITE_MNG_RECOMMENDATION_SIT
CREATE TABLE "aihub_education"."publicdata_education_4963__KASFO_WEBSITE_MNG_RECOMMENDATION_SIT" (
    "SORTATIONN" TEXT,
    "SITE_NMO" TEXT,
    "ACCESS_ADDRESSP" TEXT
);

-- Table: publicdata_education_5043__HRDK_TRAINING_CUR_ZIP_DATA_LIST
CREATE TABLE "aihub_education"."publicdata_education_5043__HRDK_TRAINING_CUR_ZIP_DATA_LIST" (
    "SERIAL_NUMF" NUMERIC,
    "TRAINING_COURSE_NMG" TEXT,
    "BUSINESS_CLASH" TEXT,
    "TRAINING_INSTITUTION_NMI" TEXT,
    "N_C_S_N_C_ZZ" NUMERIC,
    "N_C_S_N_C_1_VA" NUMERIC,
    "N_C_S_N_C_2_CV" NUMERIC,
    "N_C_S_N_C_3_DE" NUMERIC,
    "N_C_S_N_C_N_1_XZ" TEXT,
    "N_C_S_N_C_N_2_A" TEXT,
    "N_C_S_N_C_N_3_BB" TEXT,
    "TRAINING_METHODQ" TEXT,
    "TRAINING_TIMER" NUMERIC
);

-- Table: publicdata_education_505__KASFO_HOMEPAGE_MNG_NEWSLETTER_MNG_MEN
CREATE TABLE "aihub_education"."publicdata_education_505__KASFO_HOMEPAGE_MNG_NEWSLETTER_MNG_MEN" (
    "ARTICLE_NO" NUMERIC,
    "ARTICLE_NM" TEXT,
    "ARTICLE_SUMMARY" TEXT,
    "TREE" TEXT,
    "FILE_NAME" TEXT,
    "IMAGE_WAVE_AKA" TEXT,
    "SHARED_TYPE_CODE_GROUP" TEXT,
    "REGISTERED_ID" TEXT,
    "REGISTRATION_DATE" TEXT,
    "MODIFIER" TEXT,
    "MODIFICATION_DATE" TEXT,
    "NUMBER_OF_CLICKS" NUMERIC,
    "NUMBER_OF_EMAIL_READING" NUMERIC
);

-- Table: publicdata_education_5072__GBE_GBYOE_HAGWON_CLASS_REG_STS
CREATE TABLE "aihub_education"."publicdata_education_5072__GBE_GBYOE_HAGWON_CLASS_REG_STS" (
    "NMW" TEXT,
    "FOUNDER_OPERATORX" TEXT,
    "LOCY" TEXT,
    "NUM_INSTRUCTORSZ" NUMERIC,
    "FIELD_CLASA" TEXT,
    "TEACHING_SERIESB" TEXT,
    "TEACHING_COURSEC" TEXT,
    "TEACHING_CLASSD" TEXT,
    "PERIOD_INSTRUCTIONE" TEXT,
    "TOTAL_TRAINING_HOURSF" NUMERIC,
    "TEACHING_FEEG" NUMERIC,
    "O_E_S_T_E_G" NUMERIC,
    "TOTAL_COST_TEACHINGI" NUMERIC
);

-- Table: publicdata_education_5088__HRDK_HRD4U_CONTENT_STS
CREATE TABLE "aihub_education"."publicdata_education_5088__HRDK_HRD4U_CONTENT_STS" (
    "CONTENT_TYPEW" TEXT,
    "CONTENT_FIELDX" TEXT,
    "CONTENT_NMY" TEXT,
    "NEXT_NMZ" TEXT,
    "PRODUCTION_DTA" TEXT,
    "SOURCESB" TEXT
);

-- Table: publicdata_education_508__KASFO_SURVEY_BASIC_INFO
CREATE TABLE "aihub_education"."publicdata_education_508__KASFO_SURVEY_BASIC_INFO" (
    "QUESTIONNAIRE_NUMBER" NUMERIC,
    "QUESTION_NUMBER" NUMERIC,
    "MATRIX_NUMBER" NUMERIC,
    "TYPE_CODE" TEXT,
    "SEE_THE_NUMBER_OF_LINES" NUMERIC,
    "QUESTIONNAIRE_CONTENT" TEXT,
    "REQUIRED_RESPONSE" TEXT,
    "MATRIX_TYPE" TEXT,
    "QUESTION" TEXT,
    "VIEW_MIX" TEXT,
    "MAXIMUM" NUMERIC,
    "PAGE_NUMBER" NUMERIC,
    "QUESTIONNAIRE_ORDER" NUMERIC,
    "MATRIX_ORDER" NUMERIC,
    "REGISTRATION_DATE" TEXT,
    "MODIFICATION_DATE" TEXT,
    "INDENTATION_DEPTH" NUMERIC
);

-- Table: publicdata_education_5093__GBE_GB_YECHEON_O_EDU_C_STS_HAGWON
CREATE TABLE "aihub_education"."publicdata_education_5093__GBE_GB_YECHEON_O_EDU_C_STS_HAGWON" (
    "SORTATIONE" TEXT,
    "NUMF" NUMERIC,
    "NM_ACADEMYG" TEXT,
    "ADDRESSH" TEXT,
    "PHONE_NUMI" TEXT
);

-- Table: publicdata_education_5158__HRDK_COUNTRY_Q_CBT_SS
CREATE TABLE "aihub_education"."publicdata_education_5158__HRDK_COUNTRY_Q_CBT_SS" (
    "SERIAL_NUMW" NUMERIC,
    "SJ_NMX" TEXT,
    "RE_DTY" TEXT
);

-- Table: publicdata_education_5159__HRDK_N_Q_CBT_TEACHING_S_INFO
CREATE TABLE "aihub_education"."publicdata_education_5159__HRDK_N_Q_CBT_TEACHING_S_INFO" (
    "NM_EVENTZ" TEXT,
    "SJ_NMA" TEXT,
    "ORDER_STUDYB" NUMERIC,
    "TEACHING_NUMC" NUMERIC,
    "NUM_ITEMSD" NUMERIC,
    "EXAMINATION_TIMEE" NUMERIC,
    "RE_DTF" TEXT
);

-- Table: publicdata_education_5161__HRDK_N_Q_CBT_EVENTS_RATINGS
CREATE TABLE "aihub_education"."publicdata_education_5161__HRDK_N_Q_CBT_EVENTS_RATINGS" (
    "NM_EVENTL" TEXT,
    "EVENT_ENGLISH_NMM" TEXT,
    "CORRESPONDING_GRADEN" TEXT,
    "USAGE_STAO" TEXT,
    "DT_RE_RELEVANT_GRADEP" TEXT,
    "ITEM_RE_DTQ" TEXT,
    "RECEIVING_TARGET_STAR" TEXT,
    "IMPLEMENTATION_STAS" TEXT
);

-- Table: publicdata_education_524__MANAGE_KASFO_HOMEPAGE_MNG_PAGE
CREATE TABLE "aihub_education"."publicdata_education_524__MANAGE_KASFO_HOMEPAGE_MNG_PAGE" (
    "PAGE_URL" TEXT,
    "DIVISION" TEXT,
    "DEPARTMENT" TEXT,
    "PHONE_NUMBER" TEXT,
    "E_MAIL" TEXT,
    "WRITING_ID" TEXT,
    "WRITTEN_NAME" TEXT,
    "IP" TEXT,
    "REGISTRATION_DATE" TEXT,
    "MODIFICATION_DATE" TEXT,
    "PAGE_ALIGNMENT" TEXT
);

-- Table: publicdata_education_526__KASFO_HOMEPAGE_MNG_TRANSMISSION
CREATE TABLE "aihub_education"."publicdata_education_526__KASFO_HOMEPAGE_MNG_TRANSMISSION" (
    "GROUP_NUMBER" NUMERIC,
    "GROUP_NAME" TEXT,
    "TOOL_TYPE_CODE" TEXT,
    "TARGET_EXTRACTION_QUERY" TEXT,
    "TARGET" TEXT,
    "GROUP_EXPLANATION" TEXT,
    "DB_ACCESS_ID" NUMERIC,
    "SHARED_TYPE_CODE_GROUP" TEXT,
    "CREATION_DATE" TEXT,
    "MODIFICATION_DATE" TEXT
);

-- Table: publicdata_education_5328__KASFO_TRAINING_PRO_OTHER_MNG_CUSTOME
CREATE TABLE "aihub_education"."publicdata_education_5328__KASFO_TRAINING_PRO_OTHER_MNG_CUSTOME" (
    "NUMC" NUMERIC,
    "T_A_N_Q" TEXT,
    "SCHOOL_NME" TEXT,
    "SCHOOL_ADDRESSF" TEXT,
    "NUM_APPLICATIONSG" NUMERIC,
    "RE_DTH" TEXT,
    "WAGE_STAI" TEXT
);

-- Table: publicdata_education_5329__KASFO_TRAINING_PRO_TRAINING_MNG_TRAI
CREATE TABLE "aihub_education"."publicdata_education_5329__KASFO_TRAINING_PRO_TRAINING_MNG_TRAI" (
    "TRAINING_NUMJ" TEXT,
    "HOTEL_ORDERK" NUMERIC,
    "HOTEL_UNIQUE_NUML" NUMERIC,
    "ROOM_NUMM" NUMERIC,
    "DISCLOSURE_STAN" TEXT,
    "TYPEO" NUMERIC,
    "CPP" NUMERIC,
    "NUM_APPLICANTSQ" NUMERIC,
    "GENDER_DISTINCTIONR" TEXT,
    "PRIVATE_ROOM_STAS" TEXT,
    "DT_ENTRYT" TEXT,
    "INPUT_PERSONU" TEXT,
    "REVISION_DTV" TEXT
);

-- Table: publicdata_education_5370__KASFO_HOMEPAGE_MNG_MESSAGE
CREATE TABLE "aihub_education"."publicdata_education_5370__KASFO_HOMEPAGE_MNG_MESSAGE" (
    "MESSAGE_IDI" NUMERIC,
    "MESSAGE_INF_STAJ" TEXT,
    "MAIL_TYPE_CDK" TEXT,
    "MAIL_TYPE_CDL" TEXT,
    "MESSAGE_NMM" TEXT,
    "MAIL_TITLEN" TEXT,
    "MESSAGE_DESCRIPTIONO" TEXT,
    "SHIPMENT_TARGET_NMP" TEXT,
    "DISPATCH_TARGET_NUMQ" NUMERIC,
    "MAIL_CONTENT_FILE_NMR" TEXT,
    "ATTACHMENT_NMS" TEXT,
    "QUESTIONNAIRE_NUMT" NUMERIC,
    "NEWSLETTER_ISSUE_NUMU" TEXT,
    "DT_RESPONSE_DTV" NUMERIC,
    "CHARACTER_SETW" TEXT,
    "HADER_ENCODINGX" TEXT,
    "BODY_ENCODINGY" TEXT,
    "S_D_S_U" TEXT,
    "ENCRYPTION_STAA" TEXT,
    "A_S_V_S_W" TEXT,
    "REGISTRARC" TEXT,
    "RE_DTD" TEXT,
    "MODIFIERE" TEXT,
    "REVISION_DTF" TEXT,
    "DISCLOSURE_STAG" TEXT
);

-- Table: publicdata_education_5382__C_STS_GBE_GB_UJES_ACADEMIES_TEACHING
CREATE TABLE "aihub_education"."publicdata_education_5382__C_STS_GBE_GB_UJES_ACADEMIES_TEACHING" (
    "NM_ACADEMYA" TEXT,
    "TYPE_ACADEMYB" TEXT,
    "FIELD_CLASC" TEXT,
    "ACADEMY_ADDRESSD" TEXT,
    "POSTAL_CDE" NUMERIC,
    "RE_DTF" TEXT,
    "RE_STAG" TEXT,
    "FOUNDER_NMH" TEXT,
    "PHONE_NUMI" TEXT,
    "TEACHING_SERIESJ" TEXT,
    "TEACHING_COURSEK" TEXT,
    "NUM_INSTRUCTORSL" NUMERIC
);

-- Table: publicdata_education_5404__GBE_GB_ADES_ACADEMY_STS
CREATE TABLE "aihub_education"."publicdata_education_5404__GBE_GB_ADES_ACADEMY_STS" (
    "ORDERZ" NUMERIC,
    "NM_ACADEMYA" TEXT,
    "TYPE_ACADEMYB" TEXT,
    "FIELD_CLASC" TEXT,
    "ACADEMY_ADDRESSD" TEXT,
    "FOUNDER_NME" TEXT,
    "TEACHING_COURSEF" TEXT
);

-- Table: publicdata_education_5408__C_STS_GBE_GB_GSES_ACADEMIES_TEACHING
CREATE TABLE "aihub_education"."publicdata_education_5408__C_STS_GBE_GB_GSES_ACADEMIES_TEACHING" (
    "NUMM" NUMERIC,
    "NM_ACADEMYN" TEXT,
    "KINDO" TEXT,
    "ACADEMY_ADDRESSP" TEXT,
    "RE_STAQ" TEXT,
    "PHONE_NUMR" TEXT
);

-- Table: publicdata_education_5427__C_STS_GBE_GB_KCES_HAGWON_TEACHING_CN
CREATE TABLE "aihub_education"."publicdata_education_5427__C_STS_GBE_GB_KCES_HAGWON_TEACHING_CN" (
    "ORDERB" NUMERIC,
    "NM_ACADEMYC" TEXT,
    "TYPE_ACADEMYD" TEXT,
    "ACADEMY_ADDRESSE" TEXT,
    "PHONE_NUMF" TEXT
);

-- Table: publicdata_education_5473__STS_SU_KASFO_HAPPY_DORMITORY_PRO
CREATE TABLE "aihub_education"."publicdata_education_5473__STS_SU_KASFO_HAPPY_DORMITORY_PRO" (
    "YEARG" NUMERIC,
    "SCHOOL_NM_BUSINESS_NMH" TEXT,
    "CPI" NUMERIC,
    "T_P_C_1_M_W_Q" NUMERIC,
    "METER_SQUARE_FLOOR_AREAK" NUMERIC,
    "P_F_F_R_S" NUMERIC,
    "FINANCIAL_HOUSING_FUNDM" NUMERIC,
    "F_R_T_U" NUMERIC,
    "GOVERNMENT_SUBSIDYO" TEXT,
    "PROGRESS_STAP" TEXT
);

-- Table: publicdata_education_5492__K_H_E_F_S_I_S_M_N_M_F_M_C_V
CREATE TABLE "aihub_education"."publicdata_education_5492__K_H_E_F_S_I_S_M_N_M_F_M_C_V" (
    "STATISTICAL_CLASV" TEXT,
    "COLUMN_NMW" TEXT,
    "COLUMN_VALUEX" TEXT,
    "RE_DT_TIMEY" TEXT,
    "REGISTRAR_IDZ" TEXT
);

-- Table: publicdata_education_5502__I_T_P_K_S_P_P_K_S_C_R_I_YZ
CREATE TABLE "aihub_education"."publicdata_education_5502__I_T_P_K_S_P_P_K_S_C_R_I_YZ" (
    "BUSINESS_NMN" TEXT,
    "FIELD_APPLICATIONO" TEXT,
    "SELECTED_YEARP" NUMERIC,
    "TASK_NUMQ" TEXT,
    "ASSIGNMENT_NMR" TEXT,
    "RESEARCH_MANAGER_NMS" TEXT,
    "N_R_I_C_RC" TEXT,
    "NM_COUNTRY_CONCERNEDU" TEXT,
    "RESEARCH_PERIOD_NMV" TEXT,
    "ANL_RESEARCH_FUNDW" NUMERIC,
    "NUMX" NUMERIC,
    "REGISTRARY" TEXT,
    "RE_DTZ" TEXT,
    "MODIFIERA" TEXT,
    "MODIFIED_DTB" TEXT
);

-- Table: publicdata_education_5525__CONTENTS_ANNUAL_PRO_SU_KRN_STUDIES_C
CREATE TABLE "aihub_education"."publicdata_education_5525__CONTENTS_ANNUAL_PRO_SU_KRN_STUDIES_C" (
    "SERIAL_NUMB" NUMERIC,
    "APPLICATION_YEARC" NUMERIC,
    "BUSINESS_NMD" TEXT,
    "FIELD_APPLICATIONE" TEXT,
    "PROJECT_SUPPORT_DETAILSF" TEXT,
    "D_I_C_Q" TEXT,
    "PROJECT_SUPPORT_AMTH" NUMERIC,
    "S_D_N_A_A_S" TEXT,
    "N_A_A_E_D_T" TEXT,
    "NEW_PROJECT_SUPPORT_AMTK" NUMERIC,
    "BUSINESS_MONTHN" NUMERIC,
    "BUSINESS_CLAS_CDO" TEXT,
    "REGISTRARP" TEXT,
    "RE_DTQ" TEXT,
    "MODIFIERR" TEXT,
    "MODIFIED_DTS" TEXT
);

-- Table: publicdata_education_5526__A_KRN_STUDIES_PROMOTION_PRO_KRN_STUD
CREATE TABLE "aihub_education"."publicdata_education_5526__A_KRN_STUDIES_PROMOTION_PRO_KRN_STUD" (
    "ANNOUNCEMENT_NUMT" NUMERIC,
    "ANNOUNCEMENT_TITLEU" TEXT,
    "CONTENTS_ANNOUNCEMENTV" TEXT,
    "D_F_C_C_BB" TEXT,
    "ORIGINAL_FILE_NMX" TEXT,
    "ACTUAL_LOCY" TEXT,
    "REGISTRARZ" TEXT,
    "RE_DT_TIMEA" TEXT,
    "MODIFIERB" TEXT,
    "MODIFIED_DT_TIMEC" TEXT
);

-- Table: publicdata_education_5527__KASFO_WEBSITE_MNG_NOTICE
CREATE TABLE "aihub_education"."publicdata_education_5527__KASFO_WEBSITE_MNG_NOTICE" (
    "NUMD" NUMERIC,
    "RE_DTE" TEXT,
    "END_DTF" TEXT,
    "TARGETG" TEXT,
    "EXPOSED_STAH" TEXT,
    "TITLEI" TEXT,
    "CONTENTJ" TEXT,
    "SIZEK" TEXT,
    "BACKGROUNDL" TEXT,
    "SORT_BYM" NUMERIC,
    "ADMINISTRATOR_IDN" TEXT
);

-- Table: publicdata_education_5528__KRN_STUDIES_CENTRAL_RESEARCH_I_ROAD_
CREATE TABLE "aihub_education"."publicdata_education_5528__KRN_STUDIES_CENTRAL_RESEARCH_I_ROAD_" (
    "NEW_POSTCD_5_DIGITSO" NUMERIC,
    "R_C_P_U" TEXT,
    "DISTRICTSQ" TEXT,
    "LOCAL_ROAD_NM_ADDRESSR" TEXT,
    "BUILDING_NMS" TEXT,
    "T_L_N_R_N_Y" TEXT,
    "T_R_N_L_D_Z" TEXT,
    "P_P_6_D_ZZ" NUMERIC
);

-- Table: publicdata_education_5633__L_M_C_K_I_I_S_A_U_M_A_BB
CREATE TABLE "aihub_education"."publicdata_education_5633__L_M_C_K_I_I_S_A_U_M_A_BB" (
    "NUMS" NUMERIC,
    "SIGNATURET" TEXT,
    "AUTHORU" TEXT,
    "PUBLISHING_HOUSEV" TEXT,
    "YEAR_PUBLICATIONW" NUMERIC,
    "BILLING_SYMBOLX" TEXT,
    "RE_NUMY" NUMERIC
);

-- Table: publicdata_education_5634__CONTENTS_INFO_EINSE_PORTAL_KR_I_INFO
CREATE TABLE "aihub_education"."publicdata_education_5634__CONTENTS_INFO_EINSE_PORTAL_KR_I_INFO" (
    "NUMZ" NUMERIC,
    "TRAINING_DATA_NMA" TEXT,
    "TARGETB" TEXT,
    "PRODUCTION_YEARC" NUMERIC,
    "PORTIOND" TEXT,
    "CONTENTE" TEXT,
    "ADDRESS_URLF" TEXT,
    "RE_DTG" TEXT
);

-- Table: publicdata_education_5657__INFO_HUMAN_R_CAMPUS_KR_CREATIVE_CONT
CREATE TABLE "aihub_education"."publicdata_education_5657__INFO_HUMAN_R_CAMPUS_KR_CREATIVE_CONT" (
    "IDV" NUMERIC,
    "TITLEW" TEXT,
    "STATEX" TEXT,
    "RE_DTY" TEXT,
    "REVISION_DTZ" TEXT,
    "THEME_IMAGEA" TEXT,
    "DESCRIPTIONB" TEXT,
    "POSTER_IMAGEC" TEXT,
    "THEME_IDD" NUMERIC,
    "TYPEE" TEXT,
    "COURSE_SEQF" NUMERIC,
    "SORT_ORDERG" NUMERIC
);

-- Table: publicdata_education_5769__LECTURE_INFO_KR_CREATIVE_CONTENT_AGE
CREATE TABLE "aihub_education"."publicdata_education_5769__LECTURE_INFO_KR_CREATIVE_CONTENT_AGE" (
    "SORTATIONL" TEXT,
    "SERIAL_NUMM" NUMERIC,
    "VIEW_DTN" TEXT,
    "NUM_TIMESO" NUMERIC
);

-- Table: publicdata_education_5772__KR_CREATIVE_CONTENT_AGENCY_CONTENT_T
CREATE TABLE "aihub_education"."publicdata_education_5772__KR_CREATIVE_CONTENT_AGENCY_CONTENT_T" (
    "SERIAL_NUMM" NUMERIC,
    "VOD_IMAGEN" TEXT,
    "VODURLO" TEXT,
    "COURSE_NMP" TEXT,
    "LECTURE_TIMEQ" TEXT,
    "GENRER" TEXT,
    "PRODUCTIONS" TEXT,
    "INITIAL_RE_DTT" TEXT,
    "NUM_VIEWSU" NUMERIC,
    "VERTICAL_SIZEV" NUMERIC,
    "HORIZONTAL_SIZEW" NUMERIC,
    "COURSE_STA_THIS_MONTHX" TEXT,
    "DT_CREATEDY" TEXT,
    "USAGE_STAZ" TEXT,
    "CUMULATIVE_INQUIRYA" NUMERIC,
    "BANNER_IMAGE_MAINB" TEXT,
    "PRODUCTION_YEARC" NUMERIC,
    "SJ_PROCESSD" TEXT,
    "CONTENT_TYPEE" TEXT,
    "OPEN_CLASF" TEXT,
    "NEW_STAG" TEXT,
    "OPEN_COURSE_THEME_CLASH" TEXT,
    "U_W_S_T_R_C_Y" TEXT,
    "RECOMMENDATION_STAJ" TEXT,
    "POPULARITY_STAK" TEXT,
    "SERIAL_NUM_1L" TEXT,
    "NUMM" TEXT,
    "SCOREN" TEXT
);

-- Table: publicdata_education_5851__INFO_SURVEY_KR_INTERNET_SECURITY_AGE
CREATE TABLE "aihub_education"."publicdata_education_5851__INFO_SURVEY_KR_INTERNET_SECURITY_AGE" (
    "NUMR" NUMERIC,
    "DETAILED_NUMS" NUMERIC,
    "ENABLED_NOTT" TEXT,
    "CONTENTS_QUESTIONU" TEXT,
    "ANSWERV" TEXT
);

-- Table: publicdata_education_5992__BASIC_INFO_MNG_KOSAF_SCHOLARSHIP_BAS
CREATE TABLE "aihub_education"."publicdata_education_5992__BASIC_INFO_MNG_KOSAF_SCHOLARSHIP_BAS" (
    "PRODUCT_CDF" TEXT,
    "PRODUCT_CD_DESCRIPTIONG" TEXT,
    "S_P_T_C_A" NUMERIC,
    "S_P_T_C_D_BB" TEXT,
    "SCHOLARSHIP_SCHOOLJ" NUMERIC,
    "SCHOLARSHIP_SEMESTERK" NUMERIC,
    "UNIVERSITY_CDL" TEXT,
    "U_C_D_F" TEXT,
    "UNIVERSITY_AVAILABILITYN" TEXT
);

-- Table: publicdata_education_5993__KOSAF_SCHOLARSHIP_BASIC_INFO_MNG_SCH
CREATE TABLE "aihub_education"."publicdata_education_5993__KOSAF_SCHOLARSHIP_BASIC_INFO_MNG_SCH" (
    "PRODUCT_CDO" TEXT,
    "PRODUCT_CD_DESCRIPTIONP" TEXT,
    "S_P_T_C_J" NUMERIC,
    "S_P_T_C_D_K" TEXT,
    "SCHOLARSHIP_SCHOOLS" NUMERIC,
    "SCHOLARSHIP_SEMESTERT" NUMERIC,
    "SCHOLARSHIP_MEETINGU" NUMERIC,
    "BUSINESS_START_DTV" TEXT,
    "BUSINESS_TERMINATION_DTW" TEXT
);

-- Table: publicdata_education_5994__KOSAF_SCHOLARSHIP_BASIC_INFO_MNG_SCH
CREATE TABLE "aihub_education"."publicdata_education_5994__KOSAF_SCHOLARSHIP_BASIC_INFO_MNG_SCH" (
    "PRODUCT_CDX" TEXT,
    "PRODUCT_CD_DESCRIPTIONY" TEXT,
    "SCHOLARSHIP_SCHOOLZ" NUMERIC,
    "SCHOLARSHIP_SEMESTERA" NUMERIC,
    "SCHOLARSHIP_MEETINGB" NUMERIC,
    "BUSINESS_START_DTC" TEXT,
    "BUSINESS_TERMINATION_DTD" TEXT
);

-- Table: publicdata_education_5995__K_S_B_I_M_B_N_S_B_P_O
CREATE TABLE "aihub_education"."publicdata_education_5995__K_S_B_I_M_B_N_S_B_P_O" (
    "PRODUCT_CDE" TEXT,
    "PRODUCT_CD_DESCRIPTIONF" TEXT,
    "CLAS_CD_ACADEMIC_SYSG" NUMERIC,
    "E_C_C_A_S_ZZ" TEXT,
    "MAX_NUM_BENEFITSI" NUMERIC
);

-- Table: publicdata_education_5996__KOSAF_UNIV_OS_MNG_BASIC
CREATE TABLE "aihub_education"."publicdata_education_5996__KOSAF_UNIV_OS_MNG_BASIC" (
    "SCHOOL_NMJ" TEXT,
    "HOME_PAGE_ADDRESSK" TEXT
);

-- Table: publicdata_education_6047__MOIS_LOCAL_HUMAN_R_DEV_I_CURRICULUM_
CREATE TABLE "aihub_education"."publicdata_education_6047__MOIS_LOCAL_HUMAN_R_DEV_I_CURRICULUM_" (
    "COURSE_YEARS" NUMERIC,
    "PROCESS_ORDERT" NUMERIC,
    "COURSE_NMU" TEXT,
    "TRAINING_START_DTV" TEXT,
    "TRAINING_END_DTW" TEXT,
    "NUM_STUDENTSX" NUMERIC,
    "EDUAL_TARGETY" TEXT,
    "N_P_W_C_E_L" NUMERIC
);

-- Table: publicdata_education_6435__C_STS_DEPARTMENT_INFO_KR_PROFESSIONA
CREATE TABLE "aihub_education"."publicdata_education_6435__C_STS_DEPARTMENT_INFO_KR_PROFESSIONA" (
    "AREAV" TEXT,
    "ESTABLISHMENTW" TEXT,
    "NM_UNIVERSITYX" TEXT,
    "MAJOR_CLASY" TEXT,
    "M_CLASZ" TEXT,
    "SUBCATEGORYA" TEXT,
    "RECRUITMENT_UNITB" TEXT,
    "INTERDISCIPLINARYC" NUMERIC,
    "ADMISSION_CP_STATED" NUMERIC,
    "IT_ENTRANCE_QUOTAE" TEXT,
    "ADMISSION_CPF" NUMERIC,
    "ADMISSION_FEEG" TEXT
);

-- Table: publicdata_education_6564__GWE_WONJU_MIDDLE_SCHOOL
CREATE TABLE "aihub_education"."publicdata_education_6564__GWE_WONJU_MIDDLE_SCHOOL" (
    "S_G_M_S_L_N_CV" TEXT,
    "E_SCHOOL_NMX" TEXT,
    "AREA_CONCERNEDY" TEXT,
    "M_SCHOOL_NMZ" TEXT
);

-- Table: publicdata_education_6567__GWE_STS
CREATE TABLE "aihub_education"."publicdata_education_6567__GWE_STS" (
    "EDU_SUPPORT_AGENCYK" TEXT,
    "SCHOOL_LEVELL" TEXT,
    "ESTABLISHMENTM" TEXT,
    "SCHOOL_NMN" TEXT,
    "AUTONOMOUS_DISTRICTO" TEXT,
    "HIGH_SCHOOL_TYPEP" TEXT,
    "NUM_CLASSESQ" NUMERIC,
    "NUM_STUDENTSR" NUMERIC,
    "STUDENT_GRANTS" NUMERIC,
    "ADMISSIONS_MANT" NUMERIC,
    "NEW_STUDENTU" NUMERIC,
    "GRADUATE_MANV" NUMERIC,
    "GRADUATE_SCHOOLW" NUMERIC,
    "ADVANCED_SCHOLARX" NUMERIC,
    "TRUE_SCHOLARY" NUMERIC,
    "EMPLOYED_MANZ" NUMERIC,
    "EMPLOYED_WOMANA" NUMERIC,
    "NUM_TEACHERSB" NUMERIC,
    "TEACHER_GRANTC" NUMERIC,
    "PART_TIME_INSTRUCTORD" NUMERIC,
    "IM_PART_LAWE" NUMERIC,
    "TEACHER_LEAVEF" NUMERIC,
    "TEACHER_LEAVEG" NUMERIC,
    "NUM_EMPLOYEESH" NUMERIC,
    "EMPLOYEE_CONCESSIONI" NUMERIC,
    "NUM_REGULAR_CLASSESJ" NUMERIC,
    "S_N_C_G" NUMERIC,
    "NUM_CLASSROOMS_LEVELL" NUMERIC,
    "NUM_REGULAR_CLASSROOMSM" NUMERIC,
    "NUM_CLASSROOMSN" NUMERIC,
    "SPECIAL_CLASSMATEO" NUMERIC
);

-- Table: publicdata_education_6568__F_C_M_K_L_A_C_I_K_S_ZC
CREATE TABLE "aihub_education"."publicdata_education_6568__F_C_M_K_L_A_C_I_K_S_ZC" (
    "NUMP" NUMERIC,
    "FOOTNOTE_NUMQ" NUMERIC,
    "CAPTION_NUMR" TEXT,
    "FOOTNOTE_NMS" TEXT,
    "FOOTNOTE_CONTENTST" TEXT
);

-- Table: publicdata_education_6569__L_P_K_S_O_K_S_I_K_S_C_R_I_ZZ
CREATE TABLE "aihub_education"."publicdata_education_6569__L_P_K_S_O_K_S_I_K_S_C_R_I_ZZ" (
    "INSTITUTION_FACULTY_IDU" NUMERIC,
    "INSTITUTION_NUMV" NUMERIC,
    "PROFILE_IDW" NUMERIC,
    "MEMBER_NUMX" TEXT,
    "MEMBER_IDY" TEXT,
    "CD_ORDERZ" NUMERIC,
    "EMAIL_OPENA" TEXT,
    "REGISTER_DTB" TEXT,
    "MODIFY_DTC" TEXT,
    "MODIFIERD" TEXT,
    "ERASE_YNE" TEXT,
    "ERASE_DTF" TEXT,
    "ERASERG" TEXT
);

-- Table: publicdata_education_6571__D_I_R_R_O_K_S_S_P_K_S_C_R_I_CV
CREATE TABLE "aihub_education"."publicdata_education_6571__D_I_R_R_O_K_S_S_P_K_S_C_R_I_CV" (
    "CATALOG_IDM" TEXT,
    "PARENT_CATALOG_IDN" NUMERIC,
    "TITLE_ENGO" TEXT,
    "TITLE_KORP" TEXT,
    "TITLE_ORIQ" TEXT,
    "SUBTITLE_ENGR" TEXT,
    "SUBTITLE_KORS" TEXT,
    "SUBTITLE_ORIT" TEXT,
    "AUTHOR_ORIU" TEXT,
    "AUTHOR_KORV" TEXT,
    "AUTHOR_ENGW" TEXT,
    "AUTHOR_ETCX" TEXT,
    "ORGANIZATION_ORIY" TEXT,
    "ORGANIZATION_ENGA" TEXT,
    "ORGANIZATION_ETCB" TEXT,
    "NATIONC" TEXT,
    "SUPPORTD" TEXT,
    "CATEGORYE" TEXT,
    "LANGUAGEF" TEXT,
    "PAPER_PAGE_STARTG" NUMERIC,
    "PAPER_PAGE_ENDH" NUMERIC,
    "PDF_PAGE_STARTI" NUMERIC,
    "PDF_PAGE_ENDJ" NUMERIC,
    "PAGESK" NUMERIC,
    "PROJECTYEAR_BEGINM" NUMERIC,
    "PROJECTYEAR_ENDN" TEXT,
    "PUBLISH_DTO" TEXT,
    "SERIAL_NUMQ" TEXT,
    "VOLUMER" TEXT,
    "NUMS" TEXT,
    "ISSNU" TEXT,
    "SORT_TITLE_ENGV" TEXT,
    "SORT_TITLE_KORW" TEXT,
    "SORT_TITLE_ORIX" TEXT,
    "GANADA_TITLE_ENGY" TEXT,
    "GANADA_TITLE_KORZ" TEXT,
    "GANADA_TITLE_ORIA" TEXT,
    "SEARCH_YNB" TEXT,
    "IS_OPENC" TEXT,
    "ERASE_YND" TEXT,
    "FILE_NME" TEXT,
    "ROOT_DIRF" TEXT,
    "SUB_DIRG" TEXT,
    "REGISTERI" TEXT,
    "MODIFIED_DTJ" TEXT,
    "MODIFIERK" TEXT,
    "ERASE_DTL" TEXT,
    "ERASERM" TEXT
);

-- Table: publicdata_education_6572__D_I_S_D_K_L_A_K_C_R_I_DE
CREATE TABLE "aihub_education"."publicdata_education_6572__D_I_S_D_K_L_A_K_C_R_I_DE" (
    "NUMN" NUMERIC,
    "NUM_INTERVIEWSO" NUMERIC,
    "INTERVIEW_RE_DTP" TEXT,
    "INTERVIEW_TIMEQ" TEXT,
    "INTERVIEW_LOCR" TEXT,
    "DATA_COLLECTION_AREAS" TEXT,
    "COLLECTION_DATAT" TEXT,
    "MAJOR_IDX_WORDU" TEXT
);

-- Table: publicdata_education_6573__K_S_M_K_L_A_K_S_C_I_XZ
CREATE TABLE "aihub_education"."publicdata_education_6573__K_S_M_K_L_A_K_S_C_I_XZ" (
    "NUMV" NUMERIC,
    "TITLEW" TEXT,
    "NUM_POPULAR_SEARCHESX" NUMERIC,
    "RE_DTY" TEXT,
    "REVISION_DTZ" TEXT
);

-- Table: publicdata_education_6574__MDATA_LIST_BOOKS_PUBLISHED_KR_RESEAR
CREATE TABLE "aihub_education"."publicdata_education_6574__MDATA_LIST_BOOKS_PUBLISHED_KR_RESEAR" (
    "BOOK_NMA" TEXT,
    "BOOK_NM_HANGULB" TEXT,
    "AUTHORC" TEXT,
    "YEAR_PUBLICATIOND" NUMERIC,
    "PLATE_SHAPEE" TEXT,
    "NUM_PAGESF" NUMERIC,
    "I_S_B_N_N" NUMERIC,
    "TABLE_CONTENTSH" TEXT,
    "INTRODUCTION_AUTHORI" TEXT
);

-- Table: publicdata_education_6575__D_P_I_L_K_L_A_K_C_I_K_L_I_AM
CREATE TABLE "aihub_education"."publicdata_education_6575__D_P_I_L_K_L_A_K_C_I_K_L_I_AM" (
    "NUMJ" NUMERIC,
    "RE_DTK" TEXT,
    "PRODUCER_CDL" TEXT,
    "ORAL_INF_CONNECTION_NUMM" TEXT
);

-- Table: publicdata_education_6578__SUB_DATA_KRN_LITERATURE_ARCHIVE_KRN_
CREATE TABLE "aihub_education"."publicdata_education_6578__SUB_DATA_KRN_LITERATURE_ARCHIVE_KRN_" (
    "NUMV" NUMERIC,
    "DATA_NUMW" NUMERIC,
    "DATA_CREATION_DTX" NUMERIC,
    "ORAL_BUSINESS_OVERVIEWY" TEXT,
    "MAJOR_IDX_WORDZ" TEXT,
    "RE_DTA" TEXT,
    "NUM_VIEWSB" NUMERIC,
    "IMAGE_NMC" TEXT,
    "NUM_VIEWSD" NUMERIC,
    "IMAGE_NME" NUMERIC,
    "DATA_GENERATION_DT_ENDF" TEXT,
    "TRANSMISSION_DTG" TEXT,
    "MODIFICATION_STAH" TEXT,
    "DONATION_DTI" TEXT
);

-- Table: publicdata_education_6579__SUB_DATA_COUNTRY_KRN_LITERATURE_ARCH
CREATE TABLE "aihub_education"."publicdata_education_6579__SUB_DATA_COUNTRY_KRN_LITERATURE_ARCH" (
    "NUMJ" NUMERIC,
    "COUNTRY_NMK" TEXT,
    "COUNTRY_CDL" TEXT
);

-- Table: publicdata_education_6581__L_D_S_P_K_S_E_L_K_S_C_R_I_DE
CREATE TABLE "aihub_education"."publicdata_education_6581__L_D_S_P_K_S_E_L_K_S_C_R_I_DE" (
    "SERIAL_NUMD" NUMERIC,
    "SIGNATUREE" TEXT,
    "AUTHORF" TEXT
);

-- Table: publicdata_education_6583__L_D_A_B_K_S_E_L_K_S_C_R_I_F
CREATE TABLE "aihub_education"."publicdata_education_6583__L_D_A_B_K_S_E_L_K_S_C_R_I_F" (
    "BIBLIOGRAPHIC_NUMJ" NUMERIC,
    "BILLING_SYMBOLK" TEXT,
    "SIGNATUREL" TEXT,
    "AUTHORM" TEXT,
    "PUBLISHING_HOUSEN" TEXT,
    "YEAR_PUBLICATIONO" NUMERIC,
    "CONTENT_NMP" TEXT,
    "COLLECTION_BOOKSQ" TEXT
);

-- Table: publicdata_education_6689__GBE_GB_SJES_ACADEMY_STS
CREATE TABLE "aihub_education"."publicdata_education_6689__GBE_GB_SJES_ACADEMY_STS" (
    "SERIAL_NUMZ" NUMERIC,
    "NM_ACADEMYA" TEXT,
    "FOUNDERB" TEXT,
    "PHONE_NUMC" TEXT,
    "ADDRESSD" TEXT
);

-- Table: publicdata_education_6700__C_STS_GBE_GB_GJES_TRAINING_CNT
CREATE TABLE "aihub_education"."publicdata_education_6700__C_STS_GBE_GB_GJES_TRAINING_CNT" (
    "NM_TEACHING_CALLO" TEXT,
    "NM_INSTRUCTORP" TEXT,
    "PHONE_NUMQ" TEXT,
    "TEACHING_ADDRESSR" TEXT,
    "TEACHING_COURSES" TEXT
);

-- Table: publicdata_education_6709__GWE_TEACHING_CNT_STS
CREATE TABLE "aihub_education"."publicdata_education_6709__GWE_TEACHING_CNT_STS" (
    "NM_TEACHING_CALLA" TEXT,
    "NM_INSTRUCTORB" TEXT,
    "RE_STAC" TEXT,
    "PHONE_NUMD" TEXT,
    "TEACHING_ADDRESSE" TEXT,
    "NUM_PEOPLE_TEMPORARY_CPF" NUMERIC,
    "TOTAL_QUOTAG" NUMERIC,
    "FIELD_CLASH" TEXT,
    "TEACHING_SERIESI" TEXT,
    "TEACHING_COURSEJ" TEXT,
    "TEACHING_CLASSK" TEXT,
    "PERIOD_INSTRUCTIONL" TEXT,
    "TOTAL_TRAINING_HOURSM" NUMERIC,
    "TEACHING_FEEN" TEXT,
    "TEACHING_FEE_PER_HOURO" TEXT,
    "TEXTBOOK_EXPENSESP" NUMERIC,
    "MOCK_TEST_FEEQ" NUMERIC,
    "MATERIAL_COSTR" NUMERIC,
    "SCHOOL_MEAL_EXPENSESS" NUMERIC,
    "COST_SNACKST" NUMERIC,
    "DORMITORY_FEEU" NUMERIC,
    "COST_VEHICLEV" NUMERIC,
    "OTHER_EXPENSESW" NUMERIC,
    "CLOTHING_COSTX" NUMERIC,
    "TOTAL_OTHER_EXPENSESY" NUMERIC,
    "TOTAL_COST_TEACHINGZ" TEXT,
    "T_T_F_P_H_J" TEXT
);

-- Table: publicdata_education_6710__C_STS_GBE_GB_GJES_ACADEMY
CREATE TABLE "aihub_education"."publicdata_education_6710__C_STS_GBE_GB_GJES_ACADEMY" (
    "NM_ACADEMYB" TEXT,
    "ACADEMY_ADDRESSC" TEXT,
    "FOUNDER_NMD" TEXT,
    "PHONE_NUME" TEXT,
    "TEACHING_COURSEF" TEXT
);

-- Table: publicdata_education_6711__GWE_SCHOOL_STS
CREATE TABLE "aihub_education"."publicdata_education_6711__GWE_SCHOOL_STS" (
    "JURISDICTIONG" TEXT,
    "NM_SCHOOLH" TEXT,
    "ADDRESSI" TEXT,
    "PHONE_NUMJ" NUMERIC,
    "HOMEPAGEK" TEXT
);

-- Table: publicdata_education_6712__GWE_ACADEMY_STS
CREATE TABLE "aihub_education"."publicdata_education_6712__GWE_ACADEMY_STS" (
    "NM_ACADEMYL" TEXT,
    "TYPE_ACADEMYM" TEXT,
    "FIELD_CLASN" TEXT,
    "ACADEMY_ADDRESSO" TEXT,
    "RE_STAP" TEXT,
    "FOUNDER_NMQ" TEXT,
    "PHONE_NUMR" TEXT,
    "NUM_PEOPLE_TEMPORARY_CPS" NUMERIC,
    "TOTAL_QUOTAT" NUMERIC,
    "TEACHING_SERIESU" TEXT,
    "TEACHING_COURSEV" TEXT,
    "TEACHING_CLASSW" TEXT,
    "GARDENX" NUMERIC,
    "PERIOD_INSTRUCTIONY" TEXT,
    "TOTAL_TRAINING_HOURSZ" TEXT,
    "TEACHING_FEEA" TEXT,
    "TEACHING_FEE_PER_HOURB" TEXT,
    "MOCK_TEST_FEEC" NUMERIC,
    "MATERIAL_COSTD" NUMERIC,
    "SCHOOL_MEAL_EXPENSESE" NUMERIC,
    "DORMITORY_FEEF" NUMERIC,
    "COST_VEHICLEG" NUMERIC,
    "CLOTHING_COSTH" TEXT,
    "TOTAL_OTHER_EXPENSESI" NUMERIC,
    "TOTAL_COST_TEACHINGJ" TEXT,
    "T_T_F_P_H_O" TEXT,
    "NUM_INSTRUCTORSL" NUMERIC
);

-- Table: seouldata_education_1260__NEIS_ACADEMY_INFO_GJ
CREATE TABLE "aihub_education"."seouldata_education_1260__NEIS_ACADEMY_INFO_GJ" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_ASNUM" NUMERIC,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "REG_YMD" TEXT,
    "REG_STTUS_NM" TEXT,
    "CAA_BEGIN_YMD" TEXT,
    "CAA_END_YMD" TEXT,
    "TOFOR_SMTOT" TEXT,
    "DTM_RCPTN_ABLTY_NMPR_SMTOT" TEXT,
    "REALM_SC_NM" TEXT,
    "LE_ORD_NM" TEXT,
    "LE_CRSE_LIST_NM" TEXT,
    "LE_CRSE_NM" TEXT,
    "PSNBY_THCC_CNTNT" TEXT,
    "THCC_OTHBC_YN" TEXT,
    "FA_RDNZC" NUMERIC,
    "FA_RDNMA" TEXT,
    "FA_RDNDA" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_1261__NEIS_ACADEMY_INFO_YS
CREATE TABLE "aihub_education"."seouldata_education_1261__NEIS_ACADEMY_INFO_YS" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_ASNUM" NUMERIC,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "REG_YMD" TEXT,
    "REG_STTUS_NM" TEXT,
    "CAA_BEGIN_YMD" TEXT,
    "CAA_END_YMD" TEXT,
    "TOFOR_SMTOT" TEXT,
    "DTM_RCPTN_ABLTY_NMPR_SMTOT" TEXT,
    "REALM_SC_NM" TEXT,
    "LE_ORD_NM" TEXT,
    "PSNBY_THCC_CNTNT" TEXT,
    "THCC_OTHBC_YN" TEXT,
    "FA_RDNMA" TEXT,
    "FA_RDNDA" TEXT
);

-- Table: seouldata_education_1263__NEIS_ACADEMY_INFO_GR
CREATE TABLE "aihub_education"."seouldata_education_1263__NEIS_ACADEMY_INFO_GR" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_ASNUM" NUMERIC,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "REG_STTUS_NM" TEXT,
    "CAA_END_YMD" TEXT,
    "TOFOR_SMTOT" TEXT,
    "DTM_RCPTN_ABLTY_NMPR_SMTOT" TEXT,
    "LE_ORD_NM" TEXT,
    "LE_CRSE_LIST_NM" TEXT,
    "LE_CRSE_NM" TEXT,
    "THCC_OTHBC_YN" TEXT,
    "FA_RDNZC" NUMERIC,
    "FA_RDNDA" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_1264__NEIS_ACADEMY_INFO_YD
CREATE TABLE "aihub_education"."seouldata_education_1264__NEIS_ACADEMY_INFO_YD" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_ASNUM" NUMERIC,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "REG_YMD" NUMERIC,
    "REG_STTUS_NM" TEXT,
    "CAA_BEGIN_YMD" TEXT,
    "CAA_END_YMD" TEXT,
    "TOFOR_SMTOT" TEXT,
    "DTM_RCPTN_ABLTY_NMPR_SMTOT" TEXT,
    "REALM_SC_NM" TEXT,
    "LE_ORD_NM" TEXT,
    "LE_CRSE_NM" TEXT,
    "THCC_OTHBC_YN" TEXT,
    "BRHS_ACA_YN" TEXT,
    "FA_RDNZC" NUMERIC,
    "FA_RDNMA" TEXT,
    "FA_RDNDA" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_1269__NEIS_ACADEMY_INFO_GS
CREATE TABLE "aihub_education"."seouldata_education_1269__NEIS_ACADEMY_INFO_GS" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "REG_YMD" TEXT,
    "TOFOR_SMTOT" TEXT,
    "DTM_RCPTN_ABLTY_NMPR_SMTOT" TEXT,
    "REALM_SC_NM" TEXT,
    "LE_ORD_NM" TEXT,
    "LE_CRSE_NM" TEXT,
    "PSNBY_THCC_CNTNT" TEXT,
    "THCC_OTHBC_YN" TEXT,
    "BRHS_ACA_YN" TEXT,
    "FA_RDNZC" NUMERIC,
    "FA_RDNMA" TEXT,
    "FA_RDNDA" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_1270__NEIS_ACADEMY_INFO_JG
CREATE TABLE "aihub_education"."seouldata_education_1270__NEIS_ACADEMY_INFO_JG" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "REG_YMD" TEXT,
    "CAA_BEGIN_YMD" TEXT,
    "CAA_END_YMD" TEXT,
    "TOFOR_SMTOT" TEXT,
    "DTM_RCPTN_ABLTY_NMPR_SMTOT" TEXT,
    "REALM_SC_NM" TEXT,
    "LE_CRSE_NM" TEXT,
    "PSNBY_THCC_CNTNT" TEXT,
    "THCC_OTHBC_YN" TEXT,
    "BRHS_ACA_YN" TEXT,
    "FA_RDNZC" NUMERIC,
    "FA_RDNMA" TEXT,
    "FA_RDNDA" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_1273__NEIS_ACADEMY_INFO_SD
CREATE TABLE "aihub_education"."seouldata_education_1273__NEIS_ACADEMY_INFO_SD" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_ASNUM" NUMERIC,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "REG_YMD" TEXT,
    "REG_STTUS_NM" TEXT,
    "CAA_END_YMD" TEXT,
    "TOFOR_SMTOT" TEXT,
    "DTM_RCPTN_ABLTY_NMPR_SMTOT" TEXT,
    "REALM_SC_NM" TEXT,
    "LE_ORD_NM" TEXT,
    "PSNBY_THCC_CNTNT" TEXT,
    "THCC_OTHBC_YN" TEXT,
    "BRHS_ACA_YN" TEXT,
    "FA_RDNZC" NUMERIC,
    "FA_RDNMA" TEXT,
    "FA_RDNDA" TEXT
);

-- Table: seouldata_education_1275__NEIS_ACADEMY_INFO_GA
CREATE TABLE "aihub_education"."seouldata_education_1275__NEIS_ACADEMY_INFO_GA" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_ASNUM" NUMERIC,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "REG_YMD" TEXT,
    "REG_STTUS_NM" TEXT,
    "CAA_BEGIN_YMD" TEXT,
    "CAA_END_YMD" TEXT,
    "TOFOR_SMTOT" TEXT,
    "DTM_RCPTN_ABLTY_NMPR_SMTOT" TEXT,
    "REALM_SC_NM" TEXT,
    "LE_ORD_NM" TEXT,
    "LE_CRSE_NM" TEXT,
    "PSNBY_THCC_CNTNT" TEXT,
    "THCC_OTHBC_YN" TEXT,
    "BRHS_ACA_YN" TEXT,
    "FA_RDNZC" NUMERIC,
    "FA_RDNMA" TEXT,
    "FA_RDNDA" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_1278__NEIS_ACADEMY_INFO_SM
CREATE TABLE "aihub_education"."seouldata_education_1278__NEIS_ACADEMY_INFO_SM" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_ASNUM" NUMERIC,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "REG_YMD" TEXT,
    "CAA_BEGIN_YMD" TEXT,
    "TOFOR_SMTOT" TEXT,
    "DTM_RCPTN_ABLTY_NMPR_SMTOT" TEXT,
    "REALM_SC_NM" TEXT,
    "LE_ORD_NM" TEXT,
    "LE_CRSE_NM" TEXT,
    "PSNBY_THCC_CNTNT" TEXT,
    "THCC_OTHBC_YN" TEXT,
    "BRHS_ACA_YN" TEXT,
    "FA_RDNMA" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_1280__NEIS_ACADEMY_INFO_DJ
CREATE TABLE "aihub_education"."seouldata_education_1280__NEIS_ACADEMY_INFO_DJ" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_ASNUM" NUMERIC,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "REG_YMD" TEXT,
    "REG_STTUS_NM" TEXT,
    "CAA_BEGIN_YMD" TEXT,
    "CAA_END_YMD" TEXT,
    "TOFOR_SMTOT" TEXT,
    "DTM_RCPTN_ABLTY_NMPR_SMTOT" TEXT,
    "REALM_SC_NM" TEXT,
    "LE_CRSE_LIST_NM" TEXT,
    "LE_CRSE_NM" TEXT,
    "THCC_OTHBC_YN" TEXT,
    "BRHS_ACA_YN" TEXT,
    "FA_RDNMA" TEXT,
    "FA_RDNDA" TEXT
);

-- Table: seouldata_education_1281__NEIS_ACADEMY_INFO_NW
CREATE TABLE "aihub_education"."seouldata_education_1281__NEIS_ACADEMY_INFO_NW" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_ASNUM" NUMERIC,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "REG_YMD" TEXT,
    "REG_STTUS_NM" TEXT,
    "CAA_BEGIN_YMD" TEXT,
    "CAA_END_YMD" TEXT,
    "TOFOR_SMTOT" TEXT,
    "DTM_RCPTN_ABLTY_NMPR_SMTOT" TEXT,
    "REALM_SC_NM" TEXT,
    "LE_CRSE_LIST_NM" TEXT,
    "LE_CRSE_NM" TEXT,
    "THCC_OTHBC_YN" TEXT,
    "BRHS_ACA_YN" TEXT,
    "FA_RDNZC" NUMERIC,
    "FA_RDNMA" TEXT,
    "FA_RDNDA" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_1282__NEIS_ACADEMY_INFO_SB
CREATE TABLE "aihub_education"."seouldata_education_1282__NEIS_ACADEMY_INFO_SB" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_ASNUM" NUMERIC,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "CAA_BEGIN_YMD" TEXT,
    "CAA_END_YMD" TEXT,
    "TOFOR_SMTOT" TEXT,
    "DTM_RCPTN_ABLTY_NMPR_SMTOT" TEXT,
    "REALM_SC_NM" TEXT,
    "LE_ORD_NM" TEXT,
    "LE_CRSE_LIST_NM" TEXT,
    "LE_CRSE_NM" TEXT,
    "THCC_OTHBC_YN" TEXT,
    "FA_RDNZC" NUMERIC,
    "FA_RDNDA" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_1289__NEIS_ACADEMY_INFO_YC
CREATE TABLE "aihub_education"."seouldata_education_1289__NEIS_ACADEMY_INFO_YC" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_ASNUM" NUMERIC,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "REG_YMD" TEXT,
    "REG_STTUS_NM" TEXT,
    "CAA_END_YMD" NUMERIC,
    "TOFOR_SMTOT" TEXT,
    "DTM_RCPTN_ABLTY_NMPR_SMTOT" TEXT,
    "REALM_SC_NM" TEXT,
    "LE_ORD_NM" TEXT,
    "LE_CRSE_LIST_NM" TEXT,
    "LE_CRSE_NM" TEXT,
    "PSNBY_THCC_CNTNT" TEXT,
    "THCC_OTHBC_YN" TEXT,
    "BRHS_ACA_YN" TEXT,
    "FA_RDNMA" TEXT,
    "FA_RDNDA" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_1298__NEIS_ACADEMY_INFO_JN
CREATE TABLE "aihub_education"."seouldata_education_1298__NEIS_ACADEMY_INFO_JN" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_ASNUM" NUMERIC,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "REG_YMD" TEXT,
    "REG_STTUS_NM" TEXT,
    "CAA_BEGIN_YMD" TEXT,
    "TOFOR_SMTOT" TEXT,
    "DTM_RCPTN_ABLTY_NMPR_SMTOT" TEXT,
    "REALM_SC_NM" TEXT,
    "LE_CRSE_LIST_NM" TEXT,
    "PSNBY_THCC_CNTNT" TEXT,
    "THCC_OTHBC_YN" TEXT,
    "FA_RDNMA" TEXT,
    "FA_RDNDA" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_1300__NEIS_ACADEMY_INFO_DB
CREATE TABLE "aihub_education"."seouldata_education_1300__NEIS_ACADEMY_INFO_DB" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_ASNUM" NUMERIC,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "REG_YMD" TEXT,
    "REG_STTUS_NM" TEXT,
    "CAA_BEGIN_YMD" TEXT,
    "CAA_END_YMD" TEXT,
    "TOFOR_SMTOT" TEXT,
    "DTM_RCPTN_ABLTY_NMPR_SMTOT" TEXT,
    "REALM_SC_NM" TEXT,
    "LE_ORD_NM" TEXT,
    "LE_CRSE_LIST_NM" TEXT,
    "BRHS_ACA_YN" TEXT,
    "FA_RDNDA" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_1301__NEIS_ACADEMY_INFO_SC
CREATE TABLE "aihub_education"."seouldata_education_1301__NEIS_ACADEMY_INFO_SC" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_ASNUM" NUMERIC,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "REG_YMD" TEXT,
    "REG_STTUS_NM" TEXT,
    "TOFOR_SMTOT" TEXT,
    "DTM_RCPTN_ABLTY_NMPR_SMTOT" TEXT,
    "REALM_SC_NM" TEXT,
    "LE_ORD_NM" TEXT,
    "LE_CRSE_LIST_NM" TEXT,
    "LE_CRSE_NM" TEXT,
    "PSNBY_THCC_CNTNT" TEXT,
    "THCC_OTHBC_YN" TEXT,
    "BRHS_ACA_YN" TEXT,
    "FA_RDNZC" TEXT,
    "FA_RDNMA" TEXT,
    "FA_RDNDA" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_1302__NEIS_ACADEMY_INFO_GC
CREATE TABLE "aihub_education"."seouldata_education_1302__NEIS_ACADEMY_INFO_GC" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_ASNUM" NUMERIC,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "REG_YMD" TEXT,
    "CAA_END_YMD" TEXT,
    "TOFOR_SMTOT" TEXT,
    "DTM_RCPTN_ABLTY_NMPR_SMTOT" TEXT,
    "REALM_SC_NM" TEXT,
    "LE_ORD_NM" TEXT,
    "LE_CRSE_LIST_NM" TEXT,
    "LE_CRSE_NM" TEXT,
    "PSNBY_THCC_CNTNT" TEXT,
    "THCC_OTHBC_YN" TEXT,
    "BRHS_ACA_YN" TEXT,
    "FA_RDNZC" NUMERIC,
    "FA_RDNDA" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_1304__NEIS_ACADEMY_INFO_JR
CREATE TABLE "aihub_education"."seouldata_education_1304__NEIS_ACADEMY_INFO_JR" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_ASNUM" NUMERIC,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "REG_STTUS_NM" TEXT,
    "CAA_BEGIN_YMD" TEXT,
    "LE_ORD_NM" TEXT,
    "LE_CRSE_LIST_NM" TEXT,
    "LE_CRSE_NM" TEXT,
    "PSNBY_THCC_CNTNT" TEXT,
    "THCC_OTHBC_YN" TEXT,
    "FA_RDNZC" NUMERIC,
    "FA_RDNMA" TEXT,
    "FA_RDNDA" TEXT
);

-- Table: seouldata_education_1306__NEIS_ACADEMY_INFO_EP
CREATE TABLE "aihub_education"."seouldata_education_1306__NEIS_ACADEMY_INFO_EP" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_ASNUM" NUMERIC,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "REG_YMD" TEXT,
    "TOFOR_SMTOT" TEXT,
    "DTM_RCPTN_ABLTY_NMPR_SMTOT" TEXT,
    "REALM_SC_NM" TEXT,
    "LE_ORD_NM" TEXT,
    "LE_CRSE_LIST_NM" TEXT,
    "LE_CRSE_NM" TEXT,
    "PSNBY_THCC_CNTNT" TEXT,
    "THCC_OTHBC_YN" TEXT,
    "FA_RDNZC" NUMERIC,
    "FA_RDNMA" TEXT,
    "FA_RDNDA" TEXT
);

-- Table: seouldata_education_1307__NEIS_ACADEMY_INFO_GN
CREATE TABLE "aihub_education"."seouldata_education_1307__NEIS_ACADEMY_INFO_GN" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_ASNUM" NUMERIC,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "REG_YMD" TEXT,
    "REG_STTUS_NM" TEXT,
    "CAA_BEGIN_YMD" TEXT,
    "TOFOR_SMTOT" TEXT,
    "DTM_RCPTN_ABLTY_NMPR_SMTOT" TEXT,
    "REALM_SC_NM" TEXT,
    "LE_CRSE_LIST_NM" TEXT,
    "LE_CRSE_NM" TEXT,
    "THCC_OTHBC_YN" TEXT,
    "BRHS_ACA_YN" TEXT,
    "FA_RDNZC" TEXT,
    "FA_RDNMA" TEXT
);

-- Table: seouldata_education_1556__CHILD_SCHOOL_HYGIENE_DD
CREATE TABLE "aihub_education"."seouldata_education_1556__CHILD_SCHOOL_HYGIENE_DD" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "FXTM_DSNF_TRGT_YN" TEXT,
    "TP_04" TEXT,
    "QLWT_INSC_STBY_YN" TEXT,
    "MDST_CHK_RSLT_CD" TEXT,
    "ILMN_CHK_RSLT_CD" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_1559__CHILD_SCHOOL_HYGIENE_SB
CREATE TABLE "aihub_education"."seouldata_education_1559__CHILD_SCHOOL_HYGIENE_SB" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "ARQL_CHK_DT" TEXT,
    "ARQL_CHK_RSLT_TP_CD" TEXT,
    "FXTM_DSNF_TRGT_YN" TEXT,
    "FXTM_DSNF_CHK_DT" TEXT,
    "FXTM_DSNF_CHK_RSLT_TP_CD" TEXT,
    "TP_01" TEXT,
    "TP_02" TEXT,
    "TP_03" TEXT,
    "QLWT_INSC_DT" TEXT,
    "QLWT_INSC_STBY_YN" TEXT,
    "MDST_CHK_DT" TEXT,
    "ILMN_CHK_DT" TEXT,
    "ILMN_CHK_RSLT_CD" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_1560__CHILD_SCHOOL_HYGIENE_GS
CREATE TABLE "aihub_education"."seouldata_education_1560__CHILD_SCHOOL_HYGIENE_GS" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "ARQL_CHK_DT" TEXT,
    "ARQL_CHK_RSLT_TP_CD" TEXT,
    "FXTM_DSNF_TRGT_YN" TEXT,
    "FXTM_DSNF_CHK_DT" TEXT,
    "FXTM_DSNF_CHK_RSLT_TP_CD" TEXT,
    "TP_01" TEXT,
    "TP_03" TEXT,
    "UNWT_QLWT_INSC_YN" TEXT,
    "QLWT_INSC_DT" TEXT,
    "QLWT_INSC_STBY_YN" TEXT,
    "MDST_CHK_RSLT_CD" TEXT,
    "ILMN_CHK_DT" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_1606__CHILD_SCHOOL_HYGIENE_NW
CREATE TABLE "aihub_education"."seouldata_education_1606__CHILD_SCHOOL_HYGIENE_NW" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "ARQL_CHK_DT" TEXT,
    "ARQL_CHK_RSLT_TP_CD" TEXT,
    "FXTM_DSNF_CHK_RSLT_TP_CD" TEXT,
    "TP_01" TEXT,
    "TP_02" TEXT,
    "TP_03" TEXT,
    "TP_04" TEXT,
    "QLWT_INSC_DT" TEXT,
    "QLWT_INSC_STBY_YN" TEXT,
    "MDST_CHK_DT" TEXT,
    "MDST_CHK_RSLT_CD" TEXT,
    "ILMN_CHK_DT" TEXT,
    "ILMN_CHK_RSLT_CD" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_1612__CHILD_SCHOOL_HYGIENE_GD
CREATE TABLE "aihub_education"."seouldata_education_1612__CHILD_SCHOOL_HYGIENE_GD" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ARQL_CHK_RSLT_TP_CD" TEXT,
    "FXTM_DSNF_TRGT_YN" TEXT,
    "FXTM_DSNF_CHK_DT" TEXT,
    "FXTM_DSNF_CHK_RSLT_TP_CD" TEXT,
    "TP_01" TEXT,
    "TP_02" TEXT,
    "TP_03" TEXT,
    "TP_04" TEXT,
    "UNWT_QLWT_INSC_YN" TEXT,
    "MDST_CHK_DT" TEXT,
    "MDST_CHK_RSLT_CD" TEXT,
    "ILMN_CHK_RSLT_CD" TEXT
);

-- Table: seouldata_education_1615__CHILD_SCHOOL_HYGIENE_SP
CREATE TABLE "aihub_education"."seouldata_education_1615__CHILD_SCHOOL_HYGIENE_SP" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "ARQL_CHK_DT" TEXT,
    "ARQL_CHK_RSLT_TP_CD" TEXT,
    "FXTM_DSNF_TRGT_YN" TEXT,
    "FXTM_DSNF_CHK_DT" TEXT,
    "FXTM_DSNF_CHK_RSLT_TP_CD" TEXT,
    "TP_02" TEXT,
    "TP_03" TEXT,
    "QLWT_INSC_DT" TEXT,
    "QLWT_INSC_STBY_YN" TEXT,
    "MDST_CHK_DT" TEXT,
    "ILMN_CHK_DT" TEXT,
    "ILMN_CHK_RSLT_CD" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_307__SERVICE_ACADEMIC_INFO
CREATE TABLE "aihub_education"."seouldata_education_307__SERVICE_ACADEMIC_INFO" (
    "SERVICEID" NUMERIC,
    "SERVICENAME" TEXT,
    "SERVICESTARTDATE" TEXT,
    "SERVICEENDDATE" TEXT,
    "RESEARCHDEPART" TEXT,
    "SUMMARY" TEXT,
    "NEED" TEXT
);

-- Table: seouldata_education_318__LIFETIME_EDU_ORGAN
CREATE TABLE "aihub_education"."seouldata_education_318__LIFETIME_EDU_ORGAN" (
    "DEPT_NM" TEXT,
    "TEL" TEXT,
    "ADDR" TEXT,
    "HOMEPAGE_URL" TEXT,
    "MAP_LAT" NUMERIC,
    "MAP_LNG" TEXT
);

-- Table: seouldata_education_320__ONLINE_COURES
CREATE TABLE "aihub_education"."seouldata_education_320__ONLINE_COURES" (
    "ASP_ID" TEXT,
    "COURSE_ID" TEXT,
    "COURSE_CATEGORY_ID" NUMERIC,
    "CATEGORY_NM2" TEXT,
    "COURSE_NM" TEXT,
    "FEE" TEXT,
    "COURSE_GUBUN" TEXT,
    "WEEK_USE_YN" TEXT,
    "CLASS_NO" NUMERIC,
    "COURSE_REQUEST_DT" TEXT,
    "COURSE_DT" TEXT,
    "INSERT_DT" TEXT,
    "COURSE_REQUEST_STATE" TEXT,
    "CONTENTS_PREVIEW_WIDTH" NUMERIC,
    "CONTENTS_PREVIEW_HEIGHT" NUMERIC,
    "PASS_LOT_NM" TEXT,
    "DEPT_ID" TEXT,
    "DEPT_NAME" TEXT,
    "DEPT_GU" TEXT,
    "MAP_LATITUDE" NUMERIC,
    "MAP_LONGITUDE" TEXT,
    "RECOMMAND_YN" TEXT,
    "POPULARITY_YN" TEXT,
    "NEW_YN" TEXT,
    "STATUS" TEXT,
    "COURSE_IMAGE_FILE_PATH" TEXT,
    "EXTDATA_ID" TEXT,
    "SUBJECT_ID" TEXT,
    "PRE_URL" TEXT,
    "CONTENTS_ID" TEXT,
    "WEEKSEQ_NO" NUMERIC,
    "WEEK_MK_CNT" TEXT
);

-- Table: seouldata_education_321__OFFLINE_COURSE
CREATE TABLE "aihub_education"."seouldata_education_321__OFFLINE_COURSE" (
    "SITE_ID" TEXT,
    "ASP_ID" TEXT,
    "COURSE_ID" TEXT,
    "COURSE_GUBUN" TEXT,
    "COURSE_NM" TEXT,
    "COURSE_REQUEST_STR_DT" NUMERIC,
    "COURSE_REQUEST_END_DT" NUMERIC,
    "COURSE_STR_DT" TEXT,
    "COURSE_END_DT" TEXT,
    "COURSE_TARGET" TEXT,
    "CAPACITY" TEXT,
    "COURSE_APPLY_URL" TEXT,
    "INSERT_DT" NUMERIC,
    "UPDATE_DT" NUMERIC
);

-- Table: seouldata_education_4182__CHILD_SCHOOL_INSURANCE_GD
CREATE TABLE "aihub_education"."seouldata_education_4182__CHILD_SCHOOL_INSURANCE_GD" (
    "GD_OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_EN" TEXT,
    "INSURANCE_YN" TEXT,
    "COMPANY1" TEXT,
    "COMPANY3" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4183__CHILD_SCHOOL_BUS_GA
CREATE TABLE "aihub_education"."seouldata_education_4183__CHILD_SCHOOL_BUS_GA" (
    "GA_OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "OPRA_VHCNT" TEXT,
    "DCLR_VHCNT" TEXT,
    "PSG9_DCLR_VHCNT" TEXT,
    "PSG15_DCLR_VHCNT" TEXT
);

-- Table: seouldata_education_4187__CHILD_SCHOOL_INSURANCE_SM
CREATE TABLE "aihub_education"."seouldata_education_4187__CHILD_SCHOOL_INSURANCE_SM" (
    "SM_OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_EN" TEXT,
    "INSURANCE_YN" TEXT,
    "COMPANY1" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4188__CHILD_SCHOOL_BUILDING_SB
CREATE TABLE "aihub_education"."seouldata_education_4188__CHILD_SCHOOL_BUILDING_SB" (
    "SB_OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "ARCHYY" TEXT,
    "FLOORCNT" TEXT,
    "BLDGPRUSAREA" TEXT,
    "GROTTAR" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4194__CHILD_SCHOOL_SAFETY_EDU_GS
CREATE TABLE "aihub_education"."seouldata_education_4194__CHILD_SCHOOL_SAFETY_EDU_GS" (
    "OFFICEEDU_GS" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "FIRE_AVD_YN" TEXT,
    "FIRE_AVD_DT" TEXT,
    "GAS_CK_YN" TEXT,
    "GAS_CK_DT" TEXT,
    "FIRE_SAFE_YN" TEXT,
    "FIRE_SAFE_DT" TEXT,
    "ELECT_CK_DT" TEXT,
    "PLYG_CK_YN" TEXT,
    "PLYG_CK_DT" TEXT,
    "CCTV_IST_YN" TEXT,
    "CCTV_IST_TOTAL" TEXT,
    "CCTV_IST_IN" TEXT,
    "CCTV_IST_OUT" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4195__CHILD_SCHOOL_TEACHER_NW
CREATE TABLE "aihub_education"."seouldata_education_4195__CHILD_SCHOOL_TEACHER_NW" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "DRCNT" TEXT,
    "ADCNT" TEXT,
    "HDST_THCNT" TEXT,
    "ASPS_THCNT" TEXT,
    "GNRL_THCNT" TEXT,
    "SPCN_THCNT" TEXT,
    "NTCNT" TEXT,
    "SHCNT_THCNT" TEXT,
    "INCNT" TEXT,
    "OWCNT" TEXT,
    "HDST_TCHR_QACNT" TEXT,
    "RGTH_GD1_QACNT" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4197__CHILD_SCHOOL_INSURANCE_GJ
CREATE TABLE "aihub_education"."seouldata_education_4197__CHILD_SCHOOL_INSURANCE_GJ" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_EN" TEXT,
    "INSURANCE_YN" TEXT,
    "COMPANY2" TEXT,
    "PBNTTMNG" NUMERIC
);

-- Table: seouldata_education_4198__CHILD_SCHOOL_INFO_NW
CREATE TABLE "aihub_education"."seouldata_education_4198__CHILD_SCHOOL_INFO_NW" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "RPPNNAME" TEXT,
    "LDGRNAME" TEXT,
    "EDATE" TEXT,
    "ODATE" TEXT,
    "ADDR" TEXT,
    "TELNO" TEXT,
    "OPERTIME" TEXT,
    "CLCNT5" TEXT,
    "MIXCLCNT" TEXT,
    "PPCNT3" TEXT,
    "PPCNT4" TEXT,
    "SHPPCNT" TEXT
);

-- Table: seouldata_education_4202__CHILD_SCHOOL_INSURANCE_YD
CREATE TABLE "aihub_education"."seouldata_education_4202__CHILD_SCHOOL_INSURANCE_YD" (
    "OFFICEEDUTITLE" TEXT,
    "SUBOFFICEEDUTITLE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_CG" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_EN" TEXT,
    "INSURANCE_YN" TEXT,
    "COMPANY_MCLASSIFI" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDY" TEXT
);

-- Table: seouldata_education_4207__CHILD_SCHOOL_MEAL_GD
CREATE TABLE "aihub_education"."seouldata_education_4207__CHILD_SCHOOL_MEAL_GD" (
    "GD_OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "CONS_ENTS_NM" TEXT,
    "MLSR_KPCNT" NUMERIC,
    "SNGE_AGMT_NTRT_THCNT" TEXT,
    "CPRT_AGMT_NTRT_THCNT" TEXT,
    "CKCNT" TEXT,
    "CMCNT" TEXT,
    "MAS_MSPL_DCLR_YN" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4208__CHILD_SCHOOL_INSURANCE_DJ
CREATE TABLE "aihub_education"."seouldata_education_4208__CHILD_SCHOOL_INSURANCE_DJ" (
    "DJ_OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_EN" TEXT,
    "INSURANCE_YN" TEXT,
    "COMPANY1" TEXT,
    "COMPANY3" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4211__CHILD_SCHOOL_MEAL_SB
CREATE TABLE "aihub_education"."seouldata_education_4211__CHILD_SCHOOL_MEAL_SB" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "MLSR_OPRN_WAY_TP_CD" TEXT,
    "CONS_ENTS_NM" TEXT,
    "AL_KPCNT" TEXT,
    "MLSR_KPCNT" TEXT,
    "NTRT_TCHR_AGMT_YN" TEXT,
    "SNGE_AGMT_NTRT_THCNT" TEXT,
    "CKCNT" TEXT,
    "CMCNT" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4218__CHILD_SCHOOL_MEAL_GS
CREATE TABLE "aihub_education"."seouldata_education_4218__CHILD_SCHOOL_MEAL_GS" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "MLSR_OPRN_WAY_TP_CD" TEXT,
    "AL_KPCNT" TEXT,
    "MLSR_KPCNT" TEXT,
    "NTRT_TCHR_AGMT_YN" TEXT,
    "CPRT_AGMT_NTRT_THCNT" TEXT,
    "CKCNT" TEXT,
    "CMCNT" TEXT,
    "MAS_MSPL_DCLR_YN" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4225__CHILD_SCHOOL_INSURANCE_GN
CREATE TABLE "aihub_education"."seouldata_education_4225__CHILD_SCHOOL_INSURANCE_GN" (
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_EN" TEXT,
    "INSURANCE_YN" TEXT,
    "COMPANY1" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4226__CHILD_SCHOOL_YEAR_WORK_SP
CREATE TABLE "aihub_education"."seouldata_education_4226__CHILD_SCHOOL_YEAR_WORK_SP" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "YY1_UNDR_THCNT" TEXT,
    "YY1_ABV_YY2_UNDR_THCNT" TEXT,
    "YY4_ABV_YY6_UNDR_THCNT" TEXT,
    "YY6_ABV_THCNT" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4228__CHILD_SCHOOL_TEACHER_SC
CREATE TABLE "aihub_education"."seouldata_education_4228__CHILD_SCHOOL_TEACHER_SC" (
    "SC_OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "DRCNT" TEXT,
    "ADCNT" TEXT,
    "ASPS_THCNT" TEXT,
    "GNRL_THCNT" TEXT,
    "NTCNT" TEXT,
    "NTRT_THCNT" TEXT,
    "SHCNT_THCNT" TEXT,
    "INCNT" TEXT,
    "OWCNT" TEXT,
    "HDST_TCHR_QACNT" TEXT,
    "RGTH_GD2_QACNT" TEXT,
    "ASTH_QACNT" TEXT,
    "PBNTTMNG" NUMERIC
);

-- Table: seouldata_education_4229__CHILD_SCHOOL_TEACHER_GS
CREATE TABLE "aihub_education"."seouldata_education_4229__CHILD_SCHOOL_TEACHER_GS" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "DRCNT" TEXT,
    "ADCNT" TEXT,
    "HDST_THCNT" TEXT,
    "ASPS_THCNT" TEXT,
    "GNRL_THCNT" TEXT,
    "NTCNT" TEXT,
    "SHCNT_THCNT" TEXT,
    "INCNT" TEXT,
    "OWCNT" TEXT,
    "RGTH_GD1_QACNT" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4237__CHILD_SCHOOL_BUS_GS
CREATE TABLE "aihub_education"."seouldata_education_4237__CHILD_SCHOOL_BUS_GS" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "VHCL_OPRN_YN" TEXT,
    "OPRA_VHCNT" TEXT,
    "DCLR_VHCNT" TEXT,
    "PSG15_DCLR_VHCNT" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4239__CHILD_SCHOOL_MEAL_NW
CREATE TABLE "aihub_education"."seouldata_education_4239__CHILD_SCHOOL_MEAL_NW" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "MLSR_OPRN_WAY_TP_CD" TEXT,
    "CONS_ENTS_NM" TEXT,
    "MLSR_KPCNT" NUMERIC,
    "NTRT_TCHR_AGMT_YN" TEXT,
    "SNGE_AGMT_NTRT_THCNT" TEXT,
    "CPRT_AGMT_NTRT_THCNT" TEXT,
    "CKCNT" TEXT,
    "CMCNT" TEXT,
    "MAS_MSPL_DCLR_YN" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4241__CHILD_SCHOOL_SAFETY_EDU_SB
CREATE TABLE "aihub_education"."seouldata_education_4241__CHILD_SCHOOL_SAFETY_EDU_SB" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "FIRE_AVD_YN" TEXT,
    "FIRE_AVD_DT" TEXT,
    "GAS_CK_YN" TEXT,
    "FIRE_SAFE_YN" TEXT,
    "FIRE_SAFE_DT" TEXT,
    "ELECT_CK_YN" TEXT,
    "PLYG_CK_DT" TEXT,
    "PLYG_CK_RS_CD" TEXT,
    "CCTV_IST_YN" TEXT,
    "CCTV_IST_TOTAL" TEXT,
    "CCTV_IST_IN" TEXT,
    "CCTV_IST_OUT" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4242__CHILD_SCHOOL_CLASS_AREA_GB
CREATE TABLE "aihub_education"."seouldata_education_4242__CHILD_SCHOOL_CLASS_AREA_GB" (
    "GBOFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "CRCNT" TEXT,
    "PHGRINDRAREA" TEXT,
    "HLSPAREA" TEXT,
    "KTCHMSSPAREA" TEXT,
    "OTSPAREA" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4244__CHILD_SCHOOL_BUILDING_SP
CREATE TABLE "aihub_education"."seouldata_education_4244__CHILD_SCHOOL_BUILDING_SP" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "ARCHYY" TEXT,
    "BLDGPRUSAREA" TEXT,
    "GROTTAR" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4249__CHILD_SCHOOL_TEACHER_SP
CREATE TABLE "aihub_education"."seouldata_education_4249__CHILD_SCHOOL_TEACHER_SP" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "DRCNT" TEXT,
    "ADCNT" TEXT,
    "HDST_THCNT" TEXT,
    "ASPS_THCNT" TEXT,
    "GNRL_THCNT" TEXT,
    "SPCN_THCNT" TEXT,
    "NTCNT" TEXT,
    "NTRT_THCNT" TEXT,
    "SHCNT_THCNT" TEXT,
    "OWCNT" TEXT,
    "HDST_TCHR_QACNT" TEXT,
    "RGTH_GD1_QACNT" TEXT,
    "RGTH_GD2_QACNT" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4257__CHILD_SCHOOL_CLASS_AREA_GS
CREATE TABLE "aihub_education"."seouldata_education_4257__CHILD_SCHOOL_CLASS_AREA_GS" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "CRCNT" TEXT,
    "CLSRAREA" TEXT,
    "PHGRINDRAREA" TEXT,
    "HLSPAREA" TEXT,
    "OTSPAREA" TEXT,
    "PBNTTMNG" NUMERIC
);

-- Table: seouldata_education_4258__CHILD_SCHOOL_BUILDING_GA
CREATE TABLE "aihub_education"."seouldata_education_4258__CHILD_SCHOOL_BUILDING_GA" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "BLDGPRUSAREA" TEXT,
    "GROTTAR" TEXT
);

-- Table: seouldata_education_4263__CHILD_SCHOOL_INSURANCE_JR
CREATE TABLE "aihub_education"."seouldata_education_4263__CHILD_SCHOOL_INSURANCE_JR" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_YN" TEXT,
    "COMPANY1" TEXT,
    "COMPANY3" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4271__CHILD_SCHOOL_CLASS_AREA_SB
CREATE TABLE "aihub_education"."seouldata_education_4271__CHILD_SCHOOL_CLASS_AREA_SB" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "CRCNT" TEXT,
    "CLSRAREA" TEXT,
    "PHGRINDRAREA" TEXT,
    "HLSPAREA" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4272__CHILD_SCHOOL_SOCIETY_NW
CREATE TABLE "aihub_education"."seouldata_education_4272__CHILD_SCHOOL_SOCIETY_NW" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "SCHOOL_DS_YN" TEXT,
    "SCHOOL_DS_EN" TEXT,
    "EDUCATE_DS_YN" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4274__CHILD_SCHOOL_INSURANCE_DD
CREATE TABLE "aihub_education"."seouldata_education_4274__CHILD_SCHOOL_INSURANCE_DD" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_EN" TEXT,
    "COMPANY2" TEXT,
    "PBNTTMNG" NUMERIC
);

-- Table: seouldata_education_4277__CHILD_SCHOOL_SAFETY_EDU_YC
CREATE TABLE "aihub_education"."seouldata_education_4277__CHILD_SCHOOL_SAFETY_EDU_YC" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "FIRE_AVD_YN" TEXT,
    "FIRE_AVD_DT" TEXT,
    "GAS_CK_YN" TEXT,
    "GAS_CK_DT" TEXT,
    "FIRE_SAFE_YN" TEXT,
    "FIRE_SAFE_DT" TEXT,
    "ELECT_CK_YN" TEXT,
    "ELECT_CK_DT" TEXT,
    "PLYG_CK_YN" TEXT,
    "PLYG_CK_DT" TEXT,
    "PLYG_CK_RS_CD" TEXT,
    "CCTV_IST_YN" TEXT,
    "CCTV_IST_TOTAL" TEXT,
    "CCTV_IST_IN" TEXT,
    "CCTV_IST_OUT" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4283__CHILD_SCHOOL_INSURANCE_EP
CREATE TABLE "aihub_education"."seouldata_education_4283__CHILD_SCHOOL_INSURANCE_EP" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_EN" TEXT,
    "INSURANCE_YN" TEXT,
    "COMPANY1" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4287__CHILD_SCHOOL_LESSON_NW
CREATE TABLE "aihub_education"."seouldata_education_4287__CHILD_SCHOOL_LESSON_NW" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "AG3_LSN_DCNT" NUMERIC,
    "AG4_LSN_DCNT" NUMERIC,
    "AG5_LSN_DCNT" NUMERIC,
    "AFSC_PROS_LSN_DCNT" NUMERIC,
    "FDTN_KNDR_YN" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4289__CHILD_SCHOOL_SOCIETY_DD
CREATE TABLE "aihub_education"."seouldata_education_4289__CHILD_SCHOOL_SOCIETY_DD" (
    "DD_CS_OFFICEEDU" TEXT,
    "DD_CS_SUBOFFICEEDU" TEXT,
    "DD_CS_KINDERCODE" TEXT,
    "DD_CS_KINDERNAME" TEXT,
    "DD_CS_ESTB_PT" TEXT,
    "DD_CS_SCHOOL_DS_EN" TEXT,
    "DD_CS_PBNTTMNG" NUMERIC,
    "DD_CS_ADDR" TEXT
);

-- Table: seouldata_education_4293__CHILD_SCHOOL_SAFETY_EDU_DJ
CREATE TABLE "aihub_education"."seouldata_education_4293__CHILD_SCHOOL_SAFETY_EDU_DJ" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "FIRE_AVD_YN" TEXT,
    "FIRE_AVD_DT" TEXT,
    "GAS_CK_YN" TEXT,
    "GAS_CK_DT" TEXT,
    "FIRE_SAFE_YN" TEXT,
    "ELECT_CK_YN" TEXT,
    "ELECT_CK_DT" TEXT,
    "PLYG_CK_YN" TEXT,
    "PLYG_CK_DT" TEXT,
    "PLYG_CK_RS_CD" TEXT,
    "CCTV_IST_YN" TEXT,
    "CCTV_IST_TOTAL" TEXT,
    "CCTV_IST_IN" TEXT,
    "CCTV_IST_OUT" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4307__CHILD_SCHOOL_INSURANCE_GC
CREATE TABLE "aihub_education"."seouldata_education_4307__CHILD_SCHOOL_INSURANCE_GC" (
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_YN" TEXT,
    "COMPANY1" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4309__CHILD_SCHOOL_BUILDING_NW
CREATE TABLE "aihub_education"."seouldata_education_4309__CHILD_SCHOOL_BUILDING_NW" (
    "NW_OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "ARCHYY" TEXT,
    "FLOORCNT" TEXT,
    "BLDGPRUSAREA" TEXT,
    "GROTTAR" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4310__CHILD_SCHOOL_INSURANCE_GR
CREATE TABLE "aihub_education"."seouldata_education_4310__CHILD_SCHOOL_INSURANCE_GR" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_EN" TEXT,
    "INSURANCE_YN" TEXT,
    "COMPANY1" TEXT,
    "COMPANY2" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4312__CHILD_SCHOOL_SAFETY_EDU_SP
CREATE TABLE "aihub_education"."seouldata_education_4312__CHILD_SCHOOL_SAFETY_EDU_SP" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "FIRE_AVD_YN" TEXT,
    "FIRE_AVD_DT" TEXT,
    "GAS_CK_YN" TEXT,
    "GAS_CK_DT" TEXT,
    "FIRE_SAFE_YN" TEXT,
    "FIRE_SAFE_DT" TEXT,
    "ELECT_CK_YN" TEXT,
    "ELECT_CK_DT" TEXT,
    "PLYG_CK_DT" TEXT,
    "CCTV_IST_YN" TEXT,
    "CCTV_IST_TOTAL" TEXT,
    "CCTV_IST_IN" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4321__CHILD_SCHOOL_LESSON_GS
CREATE TABLE "aihub_education"."seouldata_education_4321__CHILD_SCHOOL_LESSON_GS" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "AG3_LSN_DCNT" NUMERIC,
    "AG4_LSN_DCNT" NUMERIC,
    "AG5_LSN_DCNT" NUMERIC,
    "SPCL_LSN_DCNT" NUMERIC,
    "AFSC_PROS_LSN_DCNT" NUMERIC,
    "LDNUM_BLW_YN" TEXT,
    "FDTN_KNDR_YN" TEXT,
    "PBNTTMNG" NUMERIC
);

-- Table: seouldata_education_4325__CHILD_SCHOOL_CLASS_AREA_NW
CREATE TABLE "aihub_education"."seouldata_education_4325__CHILD_SCHOOL_CLASS_AREA_NW" (
    "NWOFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "CRCNT" TEXT,
    "CLSRAREA" TEXT,
    "PHGRINDRAREA" TEXT,
    "HLSPAREA" TEXT,
    "KTCHMSSPAREA" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4326__CHILD_SCHOOL_INSURANCE_NW
CREATE TABLE "aihub_education"."seouldata_education_4326__CHILD_SCHOOL_INSURANCE_NW" (
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_EN" TEXT,
    "INSURANCE_YN" TEXT,
    "COMPANY2" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4329__CHILD_SCHOOL_INFO_GS
CREATE TABLE "aihub_education"."seouldata_education_4329__CHILD_SCHOOL_INFO_GS" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "RPPNNAME" TEXT,
    "LDGRNAME" TEXT,
    "EDATE" TEXT,
    "ODATE" TEXT,
    "HPADDR" TEXT,
    "OPERTIME" TEXT,
    "CLCNT4" TEXT,
    "MIXCLCNT" TEXT,
    "SHCLCNT" TEXT,
    "PPCNT3" TEXT,
    "PPCNT4" TEXT,
    "PPCNT5" TEXT,
    "MIXPPCNT" TEXT,
    "SHPPCNT" TEXT,
    "PBNTTMNG" NUMERIC
);

-- Table: seouldata_education_4335__CHILD_SCHOOL_TEACHER_SM
CREATE TABLE "aihub_education"."seouldata_education_4335__CHILD_SCHOOL_TEACHER_SM" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "ASPS_THCNT" TEXT,
    "GNRL_THCNT" TEXT,
    "SPCN_THCNT" TEXT,
    "NTCNT" TEXT,
    "NTRT_THCNT" TEXT,
    "OWCNT" TEXT,
    "HDST_TCHR_QACNT" TEXT,
    "RGTH_GD1_QACNT" TEXT,
    "RGTH_GD2_QACNT" TEXT,
    "ASTH_QACNT" TEXT,
    "PBNTTMNG" NUMERIC
);

-- Table: seouldata_education_4339__CHILD_SCHOOL_YEAR_WORK_DD
CREATE TABLE "aihub_education"."seouldata_education_4339__CHILD_SCHOOL_YEAR_WORK_DD" (
    "OFFICEEDUCATION_NAME" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "YY2_ABV_YY4_UNDR_THCNT" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4340__CHILD_SCHOOL_SAFETY_EDU_EP
CREATE TABLE "aihub_education"."seouldata_education_4340__CHILD_SCHOOL_SAFETY_EDU_EP" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "FIRE_AVD_YN" TEXT,
    "FIRE_AVD_DT" TEXT,
    "GAS_CK_YN" TEXT,
    "GAS_CK_DT" TEXT,
    "FIRE_SAFE_DT" TEXT,
    "ELECT_CK_YN" TEXT,
    "ELECT_CK_DT" TEXT,
    "PLYG_CK_YN" TEXT,
    "PLYG_CK_DT" TEXT,
    "PLYG_CK_RS_CD" TEXT,
    "CCTV_IST_YN" TEXT,
    "CCTV_IST_TOTAL" TEXT,
    "CCTV_IST_IN" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4346__CHILD_SCHOOL_YEAR_WORK_NW
CREATE TABLE "aihub_education"."seouldata_education_4346__CHILD_SCHOOL_YEAR_WORK_NW" (
    "NW_OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "YY1_UNDR_THCNT" TEXT,
    "YY2_ABV_YY4_UNDR_THCNT" TEXT,
    "YY6_ABV_THCNT" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4349__CHILD_SCHOOL_INFO_SP
CREATE TABLE "aihub_education"."seouldata_education_4349__CHILD_SCHOOL_INFO_SP" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "EDATE" TEXT,
    "ODATE" TEXT,
    "ADDR" TEXT,
    "HPADDR" TEXT,
    "OPERTIME" TEXT,
    "CLCNT4" TEXT,
    "MIXCLCNT" TEXT,
    "SHCLCNT" TEXT,
    "PPCNT4" TEXT,
    "PPCNT5" NUMERIC,
    "MIXPPCNT" TEXT,
    "SHPPCNT" TEXT,
    "PBNTTMNG" NUMERIC
);

-- Table: seouldata_education_4352__CHILD_SCHOOL_SOCIETY_SB
CREATE TABLE "aihub_education"."seouldata_education_4352__CHILD_SCHOOL_SOCIETY_SB" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "SCHOOL_DS_YN" TEXT,
    "EDUCATE_DS_YN" TEXT,
    "DUCATE_DS_EN" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4353__CHILD_SCHOOL_BUS_SB
CREATE TABLE "aihub_education"."seouldata_education_4353__CHILD_SCHOOL_BUS_SB" (
    "SB_OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "VHCL_OPRN_YN" TEXT,
    "OPRA_VHCNT" TEXT,
    "DCLR_VHCNT" TEXT,
    "PSG9_DCLR_VHCNT" TEXT,
    "PSG12_DCLR_VHCNT" TEXT,
    "PSG15_DCLR_VHCNT" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4354__CHILD_SCHOOL_INSURANCE_SP
CREATE TABLE "aihub_education"."seouldata_education_4354__CHILD_SCHOOL_INSURANCE_SP" (
    "SP_OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_EN" TEXT,
    "INSURANCE_YN" TEXT,
    "COMPANY2" TEXT,
    "COMPANY3" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4355__CHILD_SCHOOL_YEAR_WORK_SB
CREATE TABLE "aihub_education"."seouldata_education_4355__CHILD_SCHOOL_YEAR_WORK_SB" (
    "SB_OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "YY1_UNDR_THCNT" TEXT,
    "YY6_ABV_THCNT" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4364__CHILD_SCHOOL_TEACHER_EP
CREATE TABLE "aihub_education"."seouldata_education_4364__CHILD_SCHOOL_TEACHER_EP" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "DRCNT" TEXT,
    "HDST_THCNT" TEXT,
    "ASPS_THCNT" TEXT,
    "GNRL_THCNT" TEXT,
    "NTCNT" TEXT,
    "SHCNT_THCNT" TEXT,
    "INCNT" TEXT,
    "OWCNT" TEXT,
    "HDST_TCHR_QACNT" TEXT,
    "RGTH_GD1_QACNT" TEXT,
    "ASTH_QACNT" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4365__CHILD_SCHOOL_INSURANCE_GB
CREATE TABLE "aihub_education"."seouldata_education_4365__CHILD_SCHOOL_INSURANCE_GB" (
    "SUBOFFICEEDU" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_EN" TEXT,
    "INSURANCE_YN" TEXT,
    "COMPANY1" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4374__CHILD_SCHOOL_BUILDING_GS
CREATE TABLE "aihub_education"."seouldata_education_4374__CHILD_SCHOOL_BUILDING_GS" (
    "GS_OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "ARCHYY" TEXT,
    "BLDGPRUSAREA" TEXT,
    "GROTTAR" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4376__CHILD_SCHOOL_INSURANCE_SB
CREATE TABLE "aihub_education"."seouldata_education_4376__CHILD_SCHOOL_INSURANCE_SB" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_EN" TEXT,
    "COMPANY1" TEXT,
    "COMPANY2" TEXT,
    "COMPANY3" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4379__CHILD_SCHOOL_BUS_NW
CREATE TABLE "aihub_education"."seouldata_education_4379__CHILD_SCHOOL_BUS_NW" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "VHCL_OPRN_YN" TEXT,
    "OPRA_VHCNT" TEXT,
    "DCLR_VHCNT" TEXT,
    "PSG12_DCLR_VHCNT" TEXT,
    "PSG15_DCLR_VHCNT" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4386__CHILD_SCHOOL_CLASS_AREA_DB
CREATE TABLE "aihub_education"."seouldata_education_4386__CHILD_SCHOOL_CLASS_AREA_DB" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "CRCNT" TEXT,
    "CLSRAREA" TEXT,
    "PHGRINDRAREA" TEXT,
    "HLSPAREA" TEXT,
    "KTCHMSSPAREA" TEXT,
    "OTSPAREA" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4391__CHILD_SCHOOL_YEAR_WORK_DB
CREATE TABLE "aihub_education"."seouldata_education_4391__CHILD_SCHOOL_YEAR_WORK_DB" (
    "DB_OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "YY1_UNDR_THCNT" TEXT,
    "YY1_ABV_YY2_UNDR_THCNT" TEXT,
    "YY2_ABV_YY4_UNDR_THCNT" TEXT,
    "YY4_ABV_YY6_UNDR_THCNT" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4394__CHILD_SCHOOL_LESSON_SP
CREATE TABLE "aihub_education"."seouldata_education_4394__CHILD_SCHOOL_LESSON_SP" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "AG3_LSN_DCNT" NUMERIC,
    "AG4_LSN_DCNT" NUMERIC,
    "AG5_LSN_DCNT" NUMERIC,
    "MIX_AGE_LSN_DCNT" NUMERIC,
    "SPCL_LSN_DCNT" NUMERIC,
    "AFSC_PROS_LSN_DCNT" NUMERIC,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4396__CHILD_SCHOOL_TEACHER_SB
CREATE TABLE "aihub_education"."seouldata_education_4396__CHILD_SCHOOL_TEACHER_SB" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "DRCNT" TEXT,
    "ADCNT" TEXT,
    "ASPS_THCNT" TEXT,
    "GNRL_THCNT" TEXT,
    "SPCN_THCNT" TEXT,
    "NTCNT" TEXT,
    "NTRT_THCNT" TEXT,
    "INCNT" TEXT,
    "OWCNT" TEXT,
    "HDST_TCHR_QACNT" TEXT,
    "RGTH_GD1_QACNT" TEXT,
    "RGTH_GD2_QACNT" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4400__CHILD_SCHOOL_INSURANCE_MP
CREATE TABLE "aihub_education"."seouldata_education_4400__CHILD_SCHOOL_INSURANCE_MP" (
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_YN" TEXT,
    "COMPANY1" TEXT,
    "COMPANY3" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4403__CHILD_SCHOOL_BUILDING_SM
CREATE TABLE "aihub_education"."seouldata_education_4403__CHILD_SCHOOL_BUILDING_SM" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ARCHYY" TEXT,
    "FLOORCNT" TEXT,
    "GROTTAR" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4404__CHILD_SCHOOL_LESSON_GB
CREATE TABLE "aihub_education"."seouldata_education_4404__CHILD_SCHOOL_LESSON_GB" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "AG3_LSN_DCNT" NUMERIC,
    "AG4_LSN_DCNT" NUMERIC,
    "AG5_LSN_DCNT" NUMERIC,
    "MIX_AGE_LSN_DCNT" NUMERIC,
    "AFSC_PROS_LSN_DCNT" NUMERIC,
    "LDNUM_BLW_YN" TEXT,
    "FDTN_KNDR_YN" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4405__CHILD_SCHOOL_INSURANCE_SD
CREATE TABLE "aihub_education"."seouldata_education_4405__CHILD_SCHOOL_INSURANCE_SD" (
    "SD_OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_EN" TEXT,
    "INSURANCE_YN" TEXT,
    "COMPANY1" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4417__CHILD_SCHOOL_LESSON_DB
CREATE TABLE "aihub_education"."seouldata_education_4417__CHILD_SCHOOL_LESSON_DB" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "AG3_LSN_DCNT" NUMERIC,
    "AG4_LSN_DCNT" NUMERIC,
    "AG5_LSN_DCNT" NUMERIC,
    "AFSC_PROS_LSN_DCNT" NUMERIC,
    "LDNUM_BLW_YN" TEXT,
    "FDTN_KNDR_YN" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4426__CHILD_SCHOOL_BUS_SP
CREATE TABLE "aihub_education"."seouldata_education_4426__CHILD_SCHOOL_BUS_SP" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "VHCL_OPRN_YN" TEXT,
    "OPRA_VHCNT" TEXT,
    "PSG9_DCLR_VHCNT" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4428__CHILD_SCHOOL_INSURANCE_JN
CREATE TABLE "aihub_education"."seouldata_education_4428__CHILD_SCHOOL_INSURANCE_JN" (
    "JN_OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_YN" TEXT,
    "COMPANY1" TEXT
);

-- Table: seouldata_education_4431__CHILD_SCHOOL_SOCIETY_SP
CREATE TABLE "aihub_education"."seouldata_education_4431__CHILD_SCHOOL_SOCIETY_SP" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "SCHOOL_DS_YN" TEXT,
    "SCHOOL_DS_EN" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4434__CHILD_SCHOOL_INSURANCE_SC
CREATE TABLE "aihub_education"."seouldata_education_4434__CHILD_SCHOOL_INSURANCE_SC" (
    "OFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_EN" TEXT,
    "INSURANCE_YN" TEXT,
    "COMPANY2" TEXT,
    "COMPANY3" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_4444__CHILD_SCHOOL_INSURANCE_JG
CREATE TABLE "aihub_education"."seouldata_education_4444__CHILD_SCHOOL_INSURANCE_JG" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "COMPANY1" TEXT,
    "COMPANY3" TEXT,
    "PBNTTMNG" NUMERIC
);

-- Table: seouldata_education_4445__CHILD_SCHOOL_INSURANCE_GS
CREATE TABLE "aihub_education"."seouldata_education_4445__CHILD_SCHOOL_INSURANCE_GS" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_EN" TEXT,
    "INSURANCE_YN" TEXT,
    "COMPANY1" TEXT,
    "COMPANY2" TEXT,
    "COMPANY3" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4450__CHILD_SCHOOL_LESSON_GA
CREATE TABLE "aihub_education"."seouldata_education_4450__CHILD_SCHOOL_LESSON_GA" (
    "GA_OFFICEEDU" TEXT,
    "GA_SUBOFFICEEDU" TEXT,
    "GA_KINDERCODE" TEXT,
    "GA_KINDERNAME" TEXT,
    "GA_AG3_LSN_DCNT" NUMERIC,
    "GA_AG5_LSN_DCNT" NUMERIC,
    "GA_MIX_AGE_LSN_DCNT" NUMERIC,
    "GA_SPCL_LSN_DCNT" NUMERIC,
    "GA_LDNUM_BLW_YN" TEXT,
    "GA_FDTN_KNDR_YN" TEXT,
    "GA_ADDR" TEXT
);

-- Table: seouldata_education_4454__CHILD_SCHOOL_INSURANCE_DB
CREATE TABLE "aihub_education"."seouldata_education_4454__CHILD_SCHOOL_INSURANCE_DB" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_EN" TEXT,
    "COMPANY1" TEXT,
    "COMPANY3" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_4548__NEIS_SCHOOL_INFO_GA
CREATE TABLE "aihub_education"."seouldata_education_4548__NEIS_SCHOOL_INFO_GA" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNDA" TEXT,
    "ORG_TELNO" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "HS_SC_NM" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "HS_GNRL_BUSNS_SC_NM" TEXT,
    "DGHT_SC_NM" TEXT,
    "FOND_YMD" TEXT,
    "FOAS_MEMRD" TEXT,
    "DGHT_CRSE_SC_NM" TEXT,
    "ORD_SC_NM" TEXT,
    "DDDEP_NM" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_4549__NEIS_SCHOOL_INFO_YD
CREATE TABLE "aihub_education"."seouldata_education_4549__NEIS_SCHOOL_INFO_YD" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "JU_ORG_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNZC" NUMERIC,
    "ORG_RDNMA" TEXT,
    "ORG_RDNDA" TEXT,
    "ORG_TELNO" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "SPCLY_PURPS_HS_ORD_NM" TEXT,
    "FOND_YMD" TEXT,
    "FOAS_MEMRD" TEXT,
    "DGHT_CRSE_SC_NM" TEXT,
    "ORD_SC_NM" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_4550__NEIS_SCHOOL_INFO_SM
CREATE TABLE "aihub_education"."seouldata_education_4550__NEIS_SCHOOL_INFO_SM" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNMA" TEXT,
    "ORG_RDNDA" TEXT,
    "ORG_TELNO" TEXT,
    "HMPG_ADRES" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "HS_GNRL_BUSNS_SC_NM" TEXT,
    "SPCLY_PURPS_HS_ORD_NM" TEXT,
    "ENE_BFE_SEHF_SC_NM" TEXT,
    "FOND_YMD" NUMERIC,
    "FOAS_MEMRD" NUMERIC,
    "ORD_SC_NM" TEXT,
    "DDDEP_NM" TEXT
);

-- Table: seouldata_education_4551__NEIS_SCHOOL_INFO_GS
CREATE TABLE "aihub_education"."seouldata_education_4551__NEIS_SCHOOL_INFO_GS" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "JU_ORG_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNZC" NUMERIC,
    "ORG_RDNMA" TEXT,
    "ORG_RDNDA" TEXT,
    "ORG_TELNO" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "HS_SC_NM" TEXT,
    "HS_GNRL_BUSNS_SC_NM" TEXT,
    "SPCLY_PURPS_HS_ORD_NM" TEXT,
    "ENE_BFE_SEHF_SC_NM" TEXT,
    "DGHT_SC_NM" TEXT,
    "FOND_YMD" TEXT,
    "FOAS_MEMRD" TEXT,
    "ORD_SC_NM" TEXT,
    "DDDEP_NM" TEXT
);

-- Table: seouldata_education_4552__NEIS_SCHOOL_INFO_SP
CREATE TABLE "aihub_education"."seouldata_education_4552__NEIS_SCHOOL_INFO_SP" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "JU_ORG_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNMA" TEXT,
    "ORG_RDNDA" TEXT,
    "ORG_TELNO" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "HS_SC_NM" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "HS_GNRL_BUSNS_SC_NM" TEXT,
    "SPCLY_PURPS_HS_ORD_NM" TEXT,
    "ENE_BFE_SEHF_SC_NM" TEXT,
    "FOND_YMD" NUMERIC,
    "FOAS_MEMRD" NUMERIC,
    "ORD_SC_NM" TEXT,
    "DDDEP_NM" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_4553__NEIS_SCHOOL_INFO_YC
CREATE TABLE "aihub_education"."seouldata_education_4553__NEIS_SCHOOL_INFO_YC" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "JU_ORG_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNZC" NUMERIC,
    "ORG_RDNMA" TEXT,
    "ORG_TELNO" TEXT,
    "HMPG_ADRES" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "HS_SC_NM" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "HS_GNRL_BUSNS_SC_NM" TEXT,
    "FOND_YMD" TEXT,
    "FOAS_MEMRD" TEXT,
    "DGHT_CRSE_SC_NM" TEXT,
    "DDDEP_NM" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_4554__NEIS_SCHOOL_INFO_DJ
CREATE TABLE "aihub_education"."seouldata_education_4554__NEIS_SCHOOL_INFO_DJ" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "JU_ORG_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNZC" NUMERIC,
    "ORG_RDNMA" TEXT,
    "ORG_RDNDA" TEXT,
    "ORG_TELNO" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "HS_SC_NM" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "HS_GNRL_BUSNS_SC_NM" TEXT,
    "FOND_YMD" NUMERIC,
    "FOAS_MEMRD" NUMERIC,
    "DGHT_CRSE_SC_NM" TEXT,
    "ORD_SC_NM" TEXT,
    "DDDEP_NM" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_4557__NEIS_SCHOOL_INFO_MP
CREATE TABLE "aihub_education"."seouldata_education_4557__NEIS_SCHOOL_INFO_MP" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "JU_ORG_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNZC" NUMERIC,
    "ORG_RDNMA" TEXT,
    "ORG_TELNO" TEXT,
    "HMPG_ADRES" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "SPCLY_PURPS_HS_ORD_NM" TEXT,
    "ENE_BFE_SEHF_SC_NM" TEXT,
    "DGHT_SC_NM" TEXT,
    "FOND_YMD" NUMERIC,
    "FOAS_MEMRD" NUMERIC,
    "ORD_SC_NM" TEXT,
    "DDDEP_NM" TEXT
);

-- Table: seouldata_education_4559__NEIS_SCHOOL_INFO_EP
CREATE TABLE "aihub_education"."seouldata_education_4559__NEIS_SCHOOL_INFO_EP" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNMA" TEXT,
    "ORG_RDNDA" TEXT,
    "ORG_TELNO" TEXT,
    "HMPG_ADRES" TEXT,
    "COEDU_SC_NM" TEXT,
    "HS_SC_NM" TEXT,
    "HS_GNRL_BUSNS_SC_NM" TEXT,
    "SPCLY_PURPS_HS_ORD_NM" TEXT,
    "DGHT_SC_NM" TEXT,
    "FOND_YMD" NUMERIC,
    "FOAS_MEMRD" NUMERIC,
    "DGHT_CRSE_SC_NM" TEXT,
    "ORD_SC_NM" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_4560__NEIS_SCHOOL_INFO_DB
CREATE TABLE "aihub_education"."seouldata_education_4560__NEIS_SCHOOL_INFO_DB" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "JU_ORG_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNZC" NUMERIC,
    "ORG_RDNDA" TEXT,
    "ORG_TELNO" TEXT,
    "HMPG_ADRES" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "SPCLY_PURPS_HS_ORD_NM" TEXT,
    "ENE_BFE_SEHF_SC_NM" TEXT,
    "DGHT_SC_NM" TEXT,
    "FOND_YMD" TEXT,
    "FOAS_MEMRD" TEXT,
    "ORD_SC_NM" TEXT,
    "DDDEP_NM" TEXT
);

-- Table: seouldata_education_4561__NEIS_SCHOOL_INFO_SC
CREATE TABLE "aihub_education"."seouldata_education_4561__NEIS_SCHOOL_INFO_SC" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "JU_ORG_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNDA" TEXT,
    "ORG_TELNO" TEXT,
    "HMPG_ADRES" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "HS_SC_NM" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "SPCLY_PURPS_HS_ORD_NM" TEXT,
    "DGHT_SC_NM" TEXT,
    "FOND_YMD" NUMERIC,
    "FOAS_MEMRD" NUMERIC,
    "ORD_SC_NM" TEXT,
    "DDDEP_NM" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_4562__NEIS_SCHOOL_INFO_JG
CREATE TABLE "aihub_education"."seouldata_education_4562__NEIS_SCHOOL_INFO_JG" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "JU_ORG_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNMA" TEXT,
    "ORG_RDNDA" TEXT,
    "ORG_TELNO" TEXT,
    "HMPG_ADRES" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "HS_SC_NM" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "HS_GNRL_BUSNS_SC_NM" TEXT,
    "SPCLY_PURPS_HS_ORD_NM" TEXT,
    "ENE_BFE_SEHF_SC_NM" TEXT,
    "DGHT_SC_NM" TEXT,
    "FOND_YMD" NUMERIC,
    "FOAS_MEMRD" NUMERIC,
    "DGHT_CRSE_SC_NM" TEXT,
    "ORD_SC_NM" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_4563__NEIS_SCHOOL_INFO_JR
CREATE TABLE "aihub_education"."seouldata_education_4563__NEIS_SCHOOL_INFO_JR" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "JU_ORG_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNZC" NUMERIC,
    "ORG_RDNMA" TEXT,
    "ORG_RDNDA" TEXT,
    "ORG_TELNO" TEXT,
    "HMPG_ADRES" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "HS_SC_NM" TEXT,
    "HS_GNRL_BUSNS_SC_NM" TEXT,
    "ENE_BFE_SEHF_SC_NM" TEXT,
    "DGHT_SC_NM" TEXT,
    "FOND_YMD" TEXT,
    "FOAS_MEMRD" TEXT,
    "DGHT_CRSE_SC_NM" TEXT,
    "DDDEP_NM" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_4564__NEIS_SCHOOL_INFO_NW
CREATE TABLE "aihub_education"."seouldata_education_4564__NEIS_SCHOOL_INFO_NW" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNZC" NUMERIC,
    "ORG_RDNMA" TEXT,
    "ORG_TELNO" TEXT,
    "HMPG_ADRES" TEXT,
    "COEDU_SC_NM" TEXT,
    "HS_SC_NM" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "HS_GNRL_BUSNS_SC_NM" TEXT,
    "ENE_BFE_SEHF_SC_NM" TEXT,
    "FOND_YMD" NUMERIC,
    "FOAS_MEMRD" TEXT,
    "DGHT_CRSE_SC_NM" TEXT,
    "DDDEP_NM" TEXT
);

-- Table: seouldata_education_4565__NEIS_SCHOOL_INFO_GD
CREATE TABLE "aihub_education"."seouldata_education_4565__NEIS_SCHOOL_INFO_GD" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "JU_ORG_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNZC" NUMERIC,
    "ORG_RDNMA" TEXT,
    "ORG_RDNDA" TEXT,
    "ORG_TELNO" TEXT,
    "HMPG_ADRES" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "HS_SC_NM" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "HS_GNRL_BUSNS_SC_NM" TEXT,
    "ENE_BFE_SEHF_SC_NM" TEXT,
    "DGHT_SC_NM" TEXT,
    "FOND_YMD" NUMERIC,
    "FOAS_MEMRD" NUMERIC,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_4566__NEIS_SCHOOL_INFO_DD
CREATE TABLE "aihub_education"."seouldata_education_4566__NEIS_SCHOOL_INFO_DD" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "JU_ORG_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNZC" NUMERIC,
    "ORG_RDNDA" TEXT,
    "ORG_TELNO" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "HS_SC_NM" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "ENE_BFE_SEHF_SC_NM" TEXT,
    "FOND_YMD" TEXT,
    "FOAS_MEMRD" TEXT,
    "ORD_SC_NM" TEXT,
    "DDDEP_NM" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_4568__NEIS_SCHOOL_INFO_SD
CREATE TABLE "aihub_education"."seouldata_education_4568__NEIS_SCHOOL_INFO_SD" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "JU_ORG_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNMA" TEXT,
    "ORG_RDNDA" TEXT,
    "ORG_TELNO" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "HS_SC_NM" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "SPCLY_PURPS_HS_ORD_NM" TEXT,
    "ENE_BFE_SEHF_SC_NM" TEXT,
    "FOND_YMD" TEXT,
    "DGHT_CRSE_SC_NM" TEXT,
    "DDDEP_NM" TEXT
);

-- Table: seouldata_education_4570__NEIS_SCHOOL_INFO_GR
CREATE TABLE "aihub_education"."seouldata_education_4570__NEIS_SCHOOL_INFO_GR" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "JU_ORG_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_TELNO" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "HS_GNRL_BUSNS_SC_NM" TEXT,
    "SPCLY_PURPS_HS_ORD_NM" TEXT,
    "ENE_BFE_SEHF_SC_NM" TEXT,
    "DGHT_SC_NM" TEXT,
    "FOND_YMD" TEXT,
    "FOAS_MEMRD" TEXT,
    "ORD_SC_NM" TEXT,
    "DDDEP_NM" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_4571__NEIS_SCHOOL_INFO_GB
CREATE TABLE "aihub_education"."seouldata_education_4571__NEIS_SCHOOL_INFO_GB" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNZC" NUMERIC,
    "ORG_RDNMA" TEXT,
    "ORG_RDNDA" TEXT,
    "HMPG_ADRES" TEXT,
    "COEDU_SC_NM" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "SPCLY_PURPS_HS_ORD_NM" TEXT,
    "DGHT_SC_NM" TEXT,
    "FOND_YMD" TEXT,
    "FOAS_MEMRD" TEXT,
    "DGHT_CRSE_SC_NM" TEXT,
    "DDDEP_NM" TEXT
);

-- Table: seouldata_education_4572__NEIS_SCHOOL_INFO_YS
CREATE TABLE "aihub_education"."seouldata_education_4572__NEIS_SCHOOL_INFO_YS" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNZC" NUMERIC,
    "ORG_RDNMA" TEXT,
    "ORG_RDNDA" TEXT,
    "ORG_TELNO" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "HS_SC_NM" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "SPCLY_PURPS_HS_ORD_NM" TEXT,
    "FOND_YMD" NUMERIC,
    "FOAS_MEMRD" NUMERIC,
    "ORD_SC_NM" TEXT,
    "DDDEP_NM" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_4574__NEIS_SCHOOL_INFO_JN
CREATE TABLE "aihub_education"."seouldata_education_4574__NEIS_SCHOOL_INFO_JN" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "JU_ORG_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNZC" NUMERIC,
    "ORG_RDNMA" TEXT,
    "ORG_RDNDA" TEXT,
    "ORG_TELNO" TEXT,
    "HMPG_ADRES" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "HS_SC_NM" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "HS_GNRL_BUSNS_SC_NM" TEXT,
    "ENE_BFE_SEHF_SC_NM" TEXT,
    "DGHT_SC_NM" TEXT,
    "FOND_YMD" NUMERIC,
    "FOAS_MEMRD" NUMERIC,
    "DGHT_CRSE_SC_NM" TEXT,
    "ORD_SC_NM" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_4575__NEIS_SCHOOL_INFO_GC
CREATE TABLE "aihub_education"."seouldata_education_4575__NEIS_SCHOOL_INFO_GC" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "JU_ORG_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNMA" TEXT,
    "ORG_RDNDA" TEXT,
    "ORG_TELNO" TEXT,
    "HMPG_ADRES" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "HS_SC_NM" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "HS_GNRL_BUSNS_SC_NM" TEXT,
    "DGHT_SC_NM" TEXT,
    "FOND_YMD" TEXT,
    "FOAS_MEMRD" TEXT,
    "DDDEP_NM" TEXT
);

-- Table: seouldata_education_5188__GUROTOY_ITM
CREATE TABLE "aihub_education"."seouldata_education_5188__GUROTOY_ITM" (
    "C_ID" NUMERIC,
    "MAINTITLE" TEXT,
    "TOY_IDID" TEXT,
    "SUBJECT" TEXT,
    "FN" TEXT,
    "REGION" TEXT,
    "CREATED" TEXT,
    "ISSUED" TEXT,
    "HASFORMAT" TEXT,
    "MEDIUM" TEXT,
    "DCEXTENT" TEXT,
    "AGE" TEXT,
    "CODE_DESC" TEXT,
    "LOC_CODE" NUMERIC,
    "LOCATION" TEXT,
    "BRCH_CODE" NUMERIC,
    "BRCH_NAME" TEXT
);

-- Table: seouldata_education_5322__GB_INFO_EDU_CLASS
CREATE TABLE "aihub_education"."seouldata_education_5322__GB_INFO_EDU_CLASS" (
    "CLASS_NM" TEXT,
    "GB" TEXT,
    "LOC" TEXT,
    "EDU_PRD" TEXT,
    "EDU_TIME" TEXT,
    "TUITION" TEXT
);

-- Table: seouldata_education_5394__GUROLIB_ITM
CREATE TABLE "aihub_education"."seouldata_education_5394__GUROLIB_ITM" (
    "TITLE" TEXT,
    "AUTH" TEXT,
    "PUBL" TEXT,
    "PYB" TEXT,
    "CALL_NO" TEXT,
    "ISBN" TEXT,
    "LIB_IDID" TEXT,
    "CODE_DESC" TEXT,
    "BRCH_CODE" NUMERIC,
    "BRCH_NAME" TEXT,
    "LOCATION" TEXT
);

-- Table: seouldata_education_5404__NEIS_ACADEMY_INFO
CREATE TABLE "aihub_education"."seouldata_education_5404__NEIS_ACADEMY_INFO" (
    "ADMST_ZONE_NM" TEXT,
    "ACA_INSTI_SC_NM" TEXT,
    "ACA_ASNUM" NUMERIC,
    "ACA_NM" TEXT,
    "ESTBL_YMD" TEXT,
    "REG_YMD" NUMERIC,
    "REG_STTUS_NM" TEXT,
    "CAA_BEGIN_YMD" NUMERIC,
    "TOFOR_SMTOT" TEXT,
    "DTM_RCPTN_ABLTY_NMPR_SMTOT" TEXT,
    "REALM_SC_NM" TEXT,
    "LE_CRSE_LIST_NM" TEXT,
    "LE_CRSE_NM" TEXT,
    "PSNBY_THCC_CNTNT" TEXT,
    "THCC_OTHBC_YN" TEXT,
    "BRHS_ACA_YN" TEXT,
    "FA_RDNMA" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_5406__CHILD_SCHOOL_HYGIENE
CREATE TABLE "aihub_education"."seouldata_education_5406__CHILD_SCHOOL_HYGIENE" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "ARQL_CHK_DT" TEXT,
    "ARQL_CHK_RSLT_TP_CD" TEXT,
    "FXTM_DSNF_CHK_DT" TEXT,
    "FXTM_DSNF_CHK_RSLT_TP_CD" TEXT,
    "TP_04" TEXT,
    "UNWT_QLWT_INSC_YN" TEXT,
    "QLWT_INSC_DT" TEXT,
    "QLWT_INSC_STBY_YN" TEXT,
    "MDST_CHK_DT" TEXT,
    "MDST_CHK_RSLT_CD" TEXT,
    "ILMN_CHK_DT" TEXT,
    "ILMN_CHK_RSLT_CD" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_5407__CHILD_SCHOOL_YEAR_WORK
CREATE TABLE "aihub_education"."seouldata_education_5407__CHILD_SCHOOL_YEAR_WORK" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "YY1_UNDR_THCNT" TEXT,
    "YY2_ABV_YY4_UNDR_THCNT" TEXT,
    "YY6_ABV_THCNT" TEXT,
    "PBNTTMNG" NUMERIC,
    "CHILD_SCHOOL_ADDRESS" TEXT
);

-- Table: seouldata_education_5408__CHILD_SCHOOL_SOCIETY
CREATE TABLE "aihub_education"."seouldata_education_5408__CHILD_SCHOOL_SOCIETY" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "SEOUL_KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "SCHOOL_DS_YN" TEXT,
    "SEOUL_SCHOOL_DS_EN" TEXT,
    "EDUCATE_DS_YN" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_5410__CHILD_SCHOOL_MEAL
CREATE TABLE "aihub_education"."seouldata_education_5410__CHILD_SCHOOL_MEAL" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "MLSR_OPRN_WAY_TP_CD" TEXT,
    "CONS_ENTS_NM" TEXT,
    "MLSR_KPCNT" TEXT,
    "NTRT_TCHR_AGMT_YN" TEXT,
    "SNGE_AGMT_NTRT_THCNT" TEXT,
    "CKCNT" TEXT,
    "CMCNT" TEXT,
    "MAS_MSPL_DCLR_YN" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_5411__CHILD_SCHOOL_INFO
CREATE TABLE "aihub_education"."seouldata_education_5411__CHILD_SCHOOL_INFO" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "RPPNNAME" TEXT,
    "ODATE" TEXT,
    "ADDR" TEXT,
    "TELNO" TEXT,
    "OPERTIME" TEXT,
    "CLCNT3" TEXT,
    "CLCNT4" TEXT,
    "CLCNT5" TEXT,
    "MIXCLCNT" TEXT,
    "PPCNT3" TEXT,
    "PPCNT5" TEXT
);

-- Table: seouldata_education_5412__CHILD_SCHOOL_TEACHER
CREATE TABLE "aihub_education"."seouldata_education_5412__CHILD_SCHOOL_TEACHER" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "DRCNT" TEXT,
    "ADCNT" TEXT,
    "HDST_THCNT" TEXT,
    "ASPS_THCNT" TEXT,
    "GNRL_THCNT" TEXT,
    "SPCN_THCNT" TEXT,
    "NTCNT" TEXT,
    "NTRT_THCNT" TEXT,
    "SHCNT_THCNT" TEXT,
    "OWCNT" TEXT,
    "HDST_TCHR_QACNT" TEXT,
    "RGTH_GD1_QACNT" TEXT,
    "ASTH_QACNT" TEXT,
    "PBNTTMNG" NUMERIC
);

-- Table: seouldata_education_5413__CHILD_SCHOOL_BUILDING
CREATE TABLE "aihub_education"."seouldata_education_5413__CHILD_SCHOOL_BUILDING" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "ARCHYY" TEXT,
    "FLOORCNT" TEXT,
    "BLDGPRUSAREA" TEXT,
    "GROTTAR" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_education_5414__CHILD_SCHOOL_BUS
CREATE TABLE "aihub_education"."seouldata_education_5414__CHILD_SCHOOL_BUS" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "VHCL_OPRN_YN" TEXT,
    "OPRA_VHCNT" TEXT,
    "DCLR_VHCNT" TEXT,
    "PSG9_DCLR_VHCNT" TEXT,
    "PSG12_DCLR_VHCNT" TEXT,
    "PSG15_DCLR_VHCNT" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_5415__CHILD_SCHOOL_INSURANCE
CREATE TABLE "aihub_education"."seouldata_education_5415__CHILD_SCHOOL_INSURANCE" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "INSURANCE_NM" TEXT,
    "INSURANCE_EN" TEXT,
    "INSURANCE_YN" TEXT,
    "COMPANY1" TEXT,
    "COMPANY2" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_5416__CHILD_SCHOOL_CLASS_AREA
CREATE TABLE "aihub_education"."seouldata_education_5416__CHILD_SCHOOL_CLASS_AREA" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTABLISH" TEXT,
    "CRCNT" TEXT,
    "CLSRAREA" TEXT,
    "PHGRINDRAREA" TEXT,
    "HLSPAREA" TEXT,
    "KTCHMSSPAREA" TEXT,
    "ADDRESS" TEXT
);

-- Table: seouldata_education_5417__CHILD_SCHOOL_SAFETY_EDU
CREATE TABLE "aihub_education"."seouldata_education_5417__CHILD_SCHOOL_SAFETY_EDU" (
    "OFFICEEDU" TEXT,
    "SUBOFFICEEDU" TEXT,
    "KINDERCODE" TEXT,
    "KINDERNAME" TEXT,
    "ESTB_PT" TEXT,
    "FIRE_AVD_YN" TEXT,
    "FIRE_AVD_DT" TEXT,
    "GAS_CK_YN" TEXT,
    "GAS_CK_DT" TEXT,
    "FIRE_SAFE_YN" TEXT,
    "FIRE_SAFE_DT" TEXT,
    "ELECT_CK_YN" TEXT,
    "ELECT_CK_DT" TEXT,
    "PLYG_CK_DT" TEXT,
    "CCTV_IST_YN" TEXT,
    "CCTV_IST_TOTAL" TEXT,
    "CCTV_IST_IN" TEXT,
    "CCTV_IST_OUT" TEXT,
    "PBNTTMNG" NUMERIC,
    "ADDR" TEXT
);

-- Table: seouldata_education_5420__NEIS_SCHOOL_INFO
CREATE TABLE "aihub_education"."seouldata_education_5420__NEIS_SCHOOL_INFO" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "JU_ORG_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNDA" TEXT,
    "HMPG_ADRES" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "HS_SC_NM" TEXT,
    "HS_GNRL_BUSNS_SC_NM" TEXT,
    "FOND_YMD" NUMERIC,
    "FOAS_MEMRD" NUMERIC,
    "ORD_SC_NM" TEXT,
    "DDDEP_NM" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_5422__NEIS_SCH_MAJOR
CREATE TABLE "aihub_education"."seouldata_education_5422__NEIS_SCH_MAJOR" (
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "ORG_RDNMA" TEXT,
    "ORG_RDNDA" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "HS_SC_NM" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "HS_GNRL_BUSNS_SC_NM" TEXT,
    "SPCLY_PURPS_HS_ORD_NM" TEXT,
    "ENE_BFE_SEHF_SC_NM" TEXT,
    "DGHT_SC_NM" TEXT,
    "DGHT_CRSE_SC_NM" TEXT,
    "ORD_SC_NM" TEXT,
    "DDDEP_NM" TEXT,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_5423__NEIS_SCHOOL_INFO_HS
CREATE TABLE "aihub_education"."seouldata_education_5423__NEIS_SCHOOL_INFO_HS" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "JU_ORG_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNZC" NUMERIC,
    "ORG_RDNMA" TEXT,
    "ORG_RDNDA" TEXT,
    "ORG_TELNO" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "HS_SC_NM" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "HS_GNRL_BUSNS_SC_NM" TEXT,
    "SPCLY_PURPS_HS_ORD_NM" TEXT,
    "ENE_BFE_SEHF_SC_NM" TEXT,
    "FOND_YMD" NUMERIC,
    "FOAS_MEMRD" NUMERIC
);

-- Table: seouldata_education_5424__NEIS_SCHOOL_INFO_J_S
CREATE TABLE "aihub_education"."seouldata_education_5424__NEIS_SCHOOL_INFO_J_S" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "JU_ORG_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNZC" NUMERIC,
    "ORG_RDNMA" TEXT,
    "ORG_RDNDA" TEXT,
    "ORG_TELNO" TEXT,
    "COEDU_SC_NM" TEXT,
    "HS_SC_NM" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "HS_GNRL_BUSNS_SC_NM" TEXT,
    "SPCLY_PURPS_HS_ORD_NM" TEXT,
    "ENE_BFE_SEHF_SC_NM" TEXT,
    "FOND_YMD" NUMERIC,
    "FOAS_MEMRD" NUMERIC,
    "LOAD_DTM" TEXT
);

-- Table: seouldata_education_5426__NEIS_SCHOOL_INFO_M_S
CREATE TABLE "aihub_education"."seouldata_education_5426__NEIS_SCHOOL_INFO_M_S" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "JU_ORG_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNZC" NUMERIC,
    "ORG_RDNMA" TEXT,
    "ORG_RDNDA" TEXT,
    "ORG_TELNO" TEXT,
    "HMPG_ADRES" TEXT,
    "COEDU_SC_NM" TEXT,
    "ORG_FAXNO" TEXT,
    "HS_SC_NM" TEXT,
    "HS_GNRL_BUSNS_SC_NM" TEXT,
    "SPCLY_PURPS_HS_ORD_NM" TEXT,
    "ENE_BFE_SEHF_SC_NM" TEXT,
    "DGHT_SC_NM" TEXT,
    "FOND_YMD" NUMERIC,
    "FOAS_MEMRD" NUMERIC
);

-- Table: seouldata_education_5427__NEIS_SCHOOL_INFO_DS
CREATE TABLE "aihub_education"."seouldata_education_5427__NEIS_SCHOOL_INFO_DS" (
    "ATPT_OFCDC_SC_CODE" TEXT,
    "ATPT_OFCDC_SC_NM" TEXT,
    "SD_SCHUL_CODE" NUMERIC,
    "SCHUL_NM" TEXT,
    "ENG_SCHUL_NM" TEXT,
    "SCHUL_KND_SC_NM" TEXT,
    "LCTN_SC_NM" TEXT,
    "FOND_SC_NM" TEXT,
    "ORG_RDNZC" NUMERIC,
    "ORG_RDNMA" TEXT,
    "ORG_RDNDA" TEXT,
    "HMPG_ADRES" TEXT,
    "ORG_FAXNO" TEXT,
    "INDST_SPECL_CCCCL_EXST_YN" TEXT,
    "HS_GNRL_BUSNS_SC_NM" TEXT,
    "ENE_BFE_SEHF_SC_NM" TEXT,
    "FOAS_MEMRD" TEXT,
    "LOAD_DTM" TEXT
);
