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

-- Table: publicdata_welfare_1024__GWANGJU_CHILDREN_MEAL_CARD_MERCHANT
CREATE TABLE "aihub_welfare"."publicdata_welfare_1024__GWANGJU_CHILDREN_MEAL_CARD_MERCHANT" (
    "FRANCHISE" TEXT,
    "INDUSTRY_NAME" TEXT,
    "PHONE_NUMBER" TEXT,
    "MERCHANT_ADDRESS" TEXT
);

-- Table: publicdata_welfare_1082__STS_MEDICAL_WELFARE_FAC_ELDERLY_JEJU
CREATE TABLE "aihub_welfare"."publicdata_welfare_1082__STS_MEDICAL_WELFARE_FAC_ELDERLY_JEJU" (
    "EUPMYEON_DONG" TEXT,
    "FACILITY_NAME" TEXT,
    "GARDEN" NUMERIC,
    "PLANE" NUMERIC,
    "PRACTICIAN" NUMERIC,
    "LOCATION" TEXT,
    "INSTALLATION_DATE" TEXT,
    "PHONE_NUMBER" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_welfare_1086__BUSAN_CHILDREN_MEAL_CARD_MERCHANT
CREATE TABLE "aihub_welfare"."publicdata_welfare_1086__BUSAN_CHILDREN_MEAL_CARD_MERCHANT" (
    "TURN" NUMERIC,
    "MERCHANT_NAME_NAME" TEXT,
    "STREET_NAME_ADDRESS" TEXT,
    "ADDRESS" TEXT,
    "PHONE_NUMBER" TEXT,
    "SECTORS" TEXT,
    "LATITUDE" NUMERIC,
    "HARDNESS" NUMERIC,
    "MERCHANT_STANDARD_DATE" TEXT,
    "DATA_WORK_DATE" TEXT
);

-- Table: publicdata_welfare_111__COMPREHENSIVE_EVALUATION_RESULTS_MOGEF_
CREATE TABLE "aihub_welfare"."publicdata_welfare_111__COMPREHENSIVE_EVALUATION_RESULTS_MOGEF_" (
    "ANNUAL" NUMERIC,
    "TRIAL" TEXT,
    "CITY_GUN" TEXT,
    "EUPMYEON_DONG" TEXT,
    "FACILITY_NAME" TEXT,
    "INSTALLER" TEXT,
    "FACILITY" TEXT,
    "PUBLIC_PRIVATE" TEXT,
    "ADDRESS" TEXT,
    "COMPREHENSIVE_EVALUATION" TEXT,
    "CONSTRUCT" TEXT,
    "CIVIL_ENGINEERING" TEXT,
    "MACHINE" TEXT,
    "FIRE_FIGHTING" TEXT,
    "ELECTRICITY" TEXT,
    "GAS" TEXT,
    "NOTE" TEXT
);

-- Table: publicdata_welfare_11451__INCHEON_CHILDREN_MEAL_CARD_MERCHANT
CREATE TABLE "aihub_welfare"."publicdata_welfare_11451__INCHEON_CHILDREN_MEAL_CARD_MERCHANT" (
    "ANNUAL" NUMERIC,
    "FRANCHISE" TEXT,
    "TRIAL_NAME" TEXT,
    "CITIES_AND_COUNTIES" TEXT,
    "MATERIAL_MAP_NAME_ADDRESS" TEXT,
    "PHONE_NUMBER" TEXT,
    "LATITUDE" NUMERIC,
    "HARDNESS" NUMERIC
);

-- Table: publicdata_welfare_11451__STS_GENERAL_RESTAURANTS_JUNG_GU_INCHE
CREATE TABLE "aihub_welfare"."publicdata_welfare_11451__STS_GENERAL_RESTAURANTS_JUNG_GU_INCHE" (
    "INDUSTRY_NAME" TEXT,
    "BUSINESS_NAME" TEXT,
    "LOCATION" TEXT,
    "MATERIAL_PHONE_NUMBER" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_welfare_11737__CURRENT_STS_DAYCARE_CHILDREN_DAY_CARE
CREATE TABLE "aihub_welfare"."publicdata_welfare_11737__CURRENT_STS_DAYCARE_CHILDREN_DAY_CARE" (
    "SORTATION" TEXT,
    "Y_2009" NUMERIC,
    "Y_2010" NUMERIC,
    "Y_2011" NUMERIC,
    "Y_2012" NUMERIC,
    "Y_2013" NUMERIC,
    "Y_2014" NUMERIC,
    "Y_2015" NUMERIC,
    "Y_2016" NUMERIC,
    "Y_2017" NUMERIC,
    "Y_2018" NUMERIC,
    "Y_2019" NUMERIC,
    "Y_2020" NUMERIC,
    "Y_2021" NUMERIC
);

-- Table: publicdata_welfare_11737__SSIS_YEARLY_DAYCARE_CNT_I_STS
CREATE TABLE "aihub_welfare"."publicdata_welfare_11737__SSIS_YEARLY_DAYCARE_CNT_I_STS" (
    "SORTATION" TEXT,
    "Y_2009" NUMERIC,
    "Y_2010" NUMERIC,
    "Y_2011" NUMERIC,
    "Y_2012" NUMERIC,
    "Y_2013" NUMERIC,
    "Y_2014" NUMERIC,
    "Y_2015" NUMERIC,
    "Y_2016" NUMERIC,
    "Y_2017" NUMERIC,
    "Y_2018" NUMERIC,
    "Y_2019" NUMERIC,
    "Y_2020" NUMERIC,
    "Y_2021" NUMERIC
);

-- Table: publicdata_welfare_11913__CURRENT_STS_ELDERLY_LIVING_ALONE_CHUN
CREATE TABLE "aihub_welfare"."publicdata_welfare_11913__CURRENT_STS_ELDERLY_LIVING_ALONE_CHUN" (
    "TRIAL_NAME" TEXT,
    "CITIES_AND_COUNTIES" TEXT,
    "ADMINISTRATIVE_NAME" TEXT,
    "AGE" TEXT,
    "POPULATION" NUMERIC,
    "MALE_POPULATION" NUMERIC,
    "FEMALE_POPULATION" NUMERIC,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_welfare_11913__NUM_SINGLE_P_H_GWCC_EUP_MYEON_DONG
CREATE TABLE "aihub_welfare"."publicdata_welfare_11913__NUM_SINGLE_P_H_GWCC_EUP_MYEON_DONG" (
    "ADMINISTRATIVE_BUILDINGJ" TEXT,
    "BASE_YEARK" NUMERIC,
    "N_S_P_H_C" NUMERIC,
    "DATA_BASE_DTM" TEXT
);

-- Table: publicdata_welfare_125__STS_VOLUNTEER_FAC_SUYEONG_GU_BUSAN
CREATE TABLE "aihub_welfare"."publicdata_welfare_125__STS_VOLUNTEER_FAC_SUYEONG_GU_BUSAN" (
    "ANNUAL" NUMERIC,
    "DEMAND" TEXT,
    "FACILITY" TEXT,
    "PHONE_NUMBER" TEXT,
    "ADDRESS" TEXT
);

-- Table: publicdata_welfare_1331__CURRENT_STS_VILLAGE_HALL_MUNGYEONG_GYE
CREATE TABLE "aihub_welfare"."publicdata_welfare_1331__CURRENT_STS_VILLAGE_HALL_MUNGYEONG_GYE" (
    "ANNUAL" NUMERIC,
    "EUPMYEON_DONG" TEXT,
    "VILLAGE" TEXT,
    "LOCATION" TEXT,
    "CONSTRUCTION_YEAR" NUMERIC,
    "GRATITUDE" NUMERIC,
    "FLOORS" NUMERIC,
    "PHONE_NUMBER" TEXT
);

-- Table: publicdata_welfare_1338__SEOUL_GANGBUK_GU_SENIOR_CITIZENS_CNT
CREATE TABLE "aihub_welfare"."publicdata_welfare_1338__SEOUL_GANGBUK_GU_SENIOR_CITIZENS_CNT" (
    "ANNUAL" NUMERIC,
    "SAME_NAME" TEXT,
    "PATH" TEXT,
    "DIVISION" TEXT,
    "PHONE_NUMBER_PER_PATH" TEXT,
    "STREET_NAME_ADDRESS" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_welfare_1451__INCHEON_CHILDREN_MEAL_CARD_MERCHANT
CREATE TABLE "aihub_welfare"."publicdata_welfare_1451__INCHEON_CHILDREN_MEAL_CARD_MERCHANT" (
    "ANNUAL" NUMERIC,
    "FRANCHISE" TEXT,
    "TRIAL_NAME" TEXT,
    "CITIES_AND_COUNTIES" TEXT,
    "MATERIAL_MAP_NAME_ADDRESS" TEXT,
    "PHONE_NUMBER" TEXT,
    "LATITUDE" NUMERIC,
    "HARDNESS" NUMERIC
);

-- Table: publicdata_welfare_1543__JEJU_SEOGWIPO_CITY_SENIOR_CITIZEN_CNT
CREATE TABLE "aihub_welfare"."publicdata_welfare_1543__JEJU_SEOGWIPO_CITY_SENIOR_CITIZEN_CNT" (
    "EUPMYEON_DONG" TEXT,
    "PATH" TEXT,
    "LOCATION" TEXT,
    "PHONE_NUMBER" TEXT,
    "LATITUDE" NUMERIC,
    "HARDNESS" NUMERIC,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_welfare_1565__STS_KRN_LANGUAGE_EDU_OPERATORS_MARRIAG
CREATE TABLE "aihub_welfare"."publicdata_welfare_1565__STS_KRN_LANGUAGE_EDU_OPERATORS_MARRIAG" (
    "TRIAL" TEXT,
    "CITY_GUN" TEXT,
    "ADDRESS" TEXT,
    "PHONE_NUMBER" TEXT
);

-- Table: publicdata_welfare_1627__MOGEF_VIOLENCE_PREVENTION_EDU_CONTENT_
CREATE TABLE "aihub_welfare"."publicdata_welfare_1627__MOGEF_VIOLENCE_PREVENTION_EDU_CONTENT_" (
    "ANNUAL" NUMERIC,
    "TITLE" TEXT,
    "MANUFACTURER" TEXT,
    "PRODUCTION_YEAR" NUMERIC,
    "FIELD" TEXT,
    "EDUCATION" TEXT,
    "FORM" TEXT,
    "PUBLIC_NURI_TYPE" TEXT
);

-- Table: publicdata_welfare_1629__STS_LONG_TERM_CARE_FAC_NAM_GU_BUSAN
CREATE TABLE "aihub_welfare"."publicdata_welfare_1629__STS_LONG_TERM_CARE_FAC_NAM_GU_BUSAN" (
    "CONSECUTIVE_NUMBERS" NUMERIC,
    "FACILITY_TYPE" TEXT,
    "FACILITY_NAME" TEXT,
    "PHONE_NUMBER" TEXT,
    "FACILITY_LOCATION_ADDRESS" TEXT,
    "REPRESENTATIVE_NAME" TEXT,
    "INSTALLATION_DATE" TEXT
);

-- Table: publicdata_welfare_1640__REGIONAL_CHILDREN_CNT_CHANGWON_SOUTH_G
CREATE TABLE "aihub_welfare"."publicdata_welfare_1640__REGIONAL_CHILDREN_CNT_CHANGWON_SOUTH_G" (
    "FACILITY_NAME" TEXT,
    "ADDRESS" TEXT,
    "PHONE_NUMBER" TEXT
);

-- Table: publicdata_welfare_1641__SEO_GU_INCHEON_C_SERVICE_INVESTMENT_PR
CREATE TABLE "aihub_welfare"."publicdata_welfare_1641__SEO_GU_INCHEON_C_SERVICE_INVESTMENT_PR" (
    "ANNUAL" NUMERIC,
    "PROVISION" TEXT,
    "BUSINESS_NAME" TEXT,
    "TARGET" TEXT,
    "ADDRESS" TEXT,
    "PHONE_NUMBER" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_welfare_1658__CURRENT_STS_VILLAGE_HALL_YEONGCHEON_GY
CREATE TABLE "aihub_welfare"."publicdata_welfare_1658__CURRENT_STS_VILLAGE_HALL_YEONGCHEON_GY" (
    "TURN" NUMERIC,
    "FACILITY_NAME" TEXT,
    "LOCATION" TEXT
);

-- Table: publicdata_welfare_1685__PRESENT_SITUATION_SENIOR_CITIZENS_HALL
CREATE TABLE "aihub_welfare"."publicdata_welfare_1685__PRESENT_SITUATION_SENIOR_CITIZENS_HALL" (
    "CONSECUTIVE_NUMBERS" NUMERIC,
    "ADMINISTRATIVE_DONG" TEXT,
    "NAME_PER_SENIOR_CITIZEN" TEXT,
    "LOCATION" TEXT,
    "TOTAL_NUMBER_MEMBERS" NUMERIC,
    "MAN" NUMERIC,
    "WOMAN" NUMERIC,
    "REPRESENTATIVE" TEXT,
    "PHONE_NUMBER" TEXT,
    "DATA_BASE_DATE" TEXT
);

-- Table: publicdata_welfare_1749__MOGEF_SOCIAL_ENT_INFO
CREATE TABLE "aihub_welfare"."publicdata_welfare_1749__MOGEF_SOCIAL_ENT_INFO" (
    "INSTITUTIONAL_NAME" TEXT,
    "SOCIAL_SERVICE" TEXT,
    "REPRESENTATIVE" TEXT,
    "BUSINESS_INFORMATION" TEXT,
    "LOCATION" TEXT
);

-- Table: publicdata_welfare_1769__TP_PRESS_RELEASE
CREATE TABLE "aihub_welfare"."publicdata_welfare_1769__TP_PRESS_RELEASE" (
    "TURN" NUMERIC,
    "TITLE" TEXT,
    "REGISTRATION" TEXT,
    "KNIGHT" TEXT,
    "NUMBER_OF_INQUIRIES" NUMERIC,
    "DEPARTMENT" TEXT,
    "ATTACHMENTS" TEXT
);

-- Table: publicdata_welfare_176__CURRENT_STS_SENIOR_CITIZEN_CNT_SEONGDON
CREATE TABLE "aihub_welfare"."publicdata_welfare_176__CURRENT_STS_SENIOR_CITIZEN_CNT_SEONGDON" (
    "SAME_NAME" TEXT,
    "PATH" TEXT,
    "ADDRESS" TEXT,
    "BUILDING" TEXT,
    "PHONE_NUMBER" TEXT
);

-- Table: publicdata_welfare_177__TP_NAJU_HALL_FIRE_EXTINGUISHER_FAC_MNG_
CREATE TABLE "aihub_welfare"."publicdata_welfare_177__TP_NAJU_HALL_FIRE_EXTINGUISHER_FAC_MNG_" (
    "FLOOR" TEXT,
    "CONTROL_NUMBER" TEXT,
    "INSTALLATION_LOCATION" TEXT,
    "FIRE_EXTINGUISHER" TEXT,
    "STANDARD" TEXT
);

-- Table: publicdata_welfare_1795__INFO_SENIOR_CITIZEN_CNT_DAEDEOK_GU_DAE
CREATE TABLE "aihub_welfare"."publicdata_welfare_1795__INFO_SENIOR_CITIZEN_CNT_DAEDEOK_GU_DAE" (
    "CONSECUTIVE_NUMBERS" NUMERIC,
    "NAME_PER_SENIOR_CITIZEN" TEXT,
    "LOCATION_NUMBER_ADDRESS" TEXT,
    "LOCATION_MAP_NAME_ADDRESS" TEXT,
    "PHONE_NUMBER" TEXT,
    "DATA_BASE_DATE" TEXT
);

-- Table: publicdata_welfare_1797__TP_MNG_DISCLOSURE
CREATE TABLE "aihub_welfare"."publicdata_welfare_1797__TP_MNG_DISCLOSURE" (
    "COUNTERPART" TEXT,
    "ITEM" TEXT,
    "TREES" TEXT,
    "DISCLOSURE" TEXT,
    "REGULAR" TEXT,
    "ORGANIZER" TEXT
);

-- Table: publicdata_welfare_1836__EDU_STS_TP_RETIREMENT_STAFF_SU_CNT
CREATE TABLE "aihub_welfare"."publicdata_welfare_1836__EDU_STS_TP_RETIREMENT_STAFF_SU_CNT" (
    "FIELD" TEXT,
    "LECTURER" TEXT,
    "NUMBER_OF_PEOPLE" NUMERIC,
    "EDUCATIONAL_TIME" TEXT,
    "EDUCATIONAL_DATE" TEXT
);

-- Table: publicdata_welfare_1865__STS_DISABLED_PARKING_AREAS_HADONG_GUN_
CREATE TABLE "aihub_welfare"."publicdata_welfare_1865__STS_DISABLED_PARKING_AREAS_HADONG_GUN_" (
    "ANNUAL" NUMERIC,
    "FACILITY_NAME" TEXT,
    "TOWN" TEXT,
    "LOCATION_ROAD_NAME" TEXT,
    "PHONE_NUMBER" TEXT,
    "NOODLES" NUMERIC,
    "NOTE" TEXT
);

-- Table: publicdata_welfare_1873__STS_TP_AFFILIATE_WELFARE_SERVICE
CREATE TABLE "aihub_welfare"."publicdata_welfare_1873__STS_TP_AFFILIATE_WELFARE_SERVICE" (
    "CATEGORY" TEXT,
    "DETAILS" TEXT,
    "AFFILIATE" TEXT
);

-- Table: publicdata_welfare_1879__SEO_GU_SENIOR_CITIZENS_CNT_INCHEON
CREATE TABLE "aihub_welfare"."publicdata_welfare_1879__SEO_GU_SENIOR_CITIZENS_CNT_INCHEON" (
    "TURN" NUMERIC,
    "ADMINISTRATIVE_NAME" TEXT,
    "PATH" TEXT,
    "ZIP_CODE" NUMERIC,
    "LOCATION" TEXT,
    "PHONE_NUMBER" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_welfare_1989__TP_RENTAL_STS
CREATE TABLE "aihub_welfare"."publicdata_welfare_1989__TP_RENTAL_STS" (
    "STANDARDS" NUMERIC,
    "RENTAL_TYPE" TEXT,
    "NUMBER_OF_CASES" NUMERIC,
    "ONE_THOUSAND_WON" NUMERIC
);

-- Table: publicdata_welfare_1993__TOILET_DISABLED_HWASUN_GUN_JEONNAM
CREATE TABLE "aihub_welfare"."publicdata_welfare_1993__TOILET_DISABLED_HWASUN_GUN_JEONNAM" (
    "TRIAL" TEXT,
    "CITY_GUN" TEXT,
    "TOWN" TEXT,
    "COSMETICS" TEXT,
    "ADDRESS" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_welfare_2017__INFO_MOGEF_VOCATIONAL_EDU_TRAINING
CREATE TABLE "aihub_welfare"."publicdata_welfare_2017__INFO_MOGEF_VOCATIONAL_EDU_TRAINING" (
    "TRIAL" TEXT,
    "CENTER_NAME" TEXT,
    "TRAINING_PROCESS_NAME" TEXT,
    "TRAINING_START_DATE" TEXT,
    "TRAINING_END_DATE" TEXT
);

-- Table: publicdata_welfare_2028__STS_ELDERLY_LIVING_ALONE_SEO_GU_GWANGJ
CREATE TABLE "aihub_welfare"."publicdata_welfare_2028__STS_ELDERLY_LIVING_ALONE_SEO_GU_GWANGJ" (
    "ADMINISTRATIVE_BUILDING" TEXT,
    "AGE" TEXT,
    "TOTAL" NUMERIC,
    "OTHER" NUMERIC,
    "FEMALE" NUMERIC
);

-- Table: publicdata_welfare_203__INFO_WELFARE_FAC_ELDERLY_YONGIN_SI_GYEO
CREATE TABLE "aihub_welfare"."publicdata_welfare_203__INFO_WELFARE_FAC_ELDERLY_YONGIN_SI_GYEO" (
    "FACILITY" TEXT,
    "FACILITY_NAME" TEXT,
    "GARDEN" NUMERIC,
    "ADDRESS" TEXT,
    "PHONE_NUMBER" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_welfare_2042__STS_SENIOR_CITIZENS_CNT_HAMPYEONG_GUN_
CREATE TABLE "aihub_welfare"."publicdata_welfare_2042__STS_SENIOR_CITIZENS_CNT_HAMPYEONG_GUN_" (
    "PATH" TEXT,
    "ADDRESS" TEXT,
    "CONTACT" TEXT
);

-- Table: publicdata_welfare_2059__TOY_LIST_TOY_LIBRARIES_HAENAM_GUN_JEON
CREATE TABLE "aihub_welfare"."publicdata_welfare_2059__TOY_LIST_TOY_LIBRARIES_HAENAM_GUN_JEON" (
    "AREA" TEXT,
    "TOY" TEXT,
    "USAGE_AGE_MONTHS" NUMERIC,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_welfare_2065__TARGET_SELECTING_TP_BUSINESS_REAL_NAME
CREATE TABLE "aihub_welfare"."publicdata_welfare_2065__TARGET_SELECTING_TP_BUSINESS_REAL_NAME" (
    "TURN" NUMERIC,
    "BUSINESS_TITLE" TEXT,
    "DEPARTMENT" TEXT,
    "BUSINESS_INFORMATION" TEXT,
    "CONNECTION_ADDRESS" TEXT,
    "REGISTRATION" TEXT,
    "STANDARDS" NUMERIC
);

-- Table: publicdata_welfare_208__INFO_SENIOR_CITIZENS_CNT_YONGIN_SI_GYEO
CREATE TABLE "aihub_welfare"."publicdata_welfare_208__INFO_SENIOR_CITIZENS_CNT_YONGIN_SI_GYEO" (
    "EUPMYEON_DONG" TEXT,
    "NAME_PER_ROUTE" TEXT,
    "LOCATION" TEXT,
    "FLOORS" NUMERIC,
    "MEMBERS" NUMERIC,
    "HEATING" TEXT,
    "CONTACT" TEXT,
    "BACKLASH" TEXT,
    "FACILITY" NUMERIC,
    "DATA_BASED_DATE" TEXT
);

-- Table: publicdata_welfare_2093__CURRENT_STS_SENIOR_CITIZEN_CNT_OKCHEON
CREATE TABLE "aihub_welfare"."publicdata_welfare_2093__CURRENT_STS_SENIOR_CITIZEN_CNT_OKCHEON" (
    "ANNUAL" NUMERIC,
    "TOWN" TEXT,
    "PATH" TEXT,
    "RETURN_ADDRESS" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_welfare_2114__STS_SENIOR_CITIZENS_CNT_PYEONGTAEK_GYE
CREATE TABLE "aihub_welfare"."publicdata_welfare_2114__STS_SENIOR_CITIZENS_CNT_PYEONGTAEK_GYE" (
    "PATH" TEXT,
    "STREET_NAME_ADDRESS" TEXT,
    "PHONE_NUMBER" TEXT,
    "MANAGEMENT_NAME" TEXT,
    "MANAGEMENT_LETTER_NAME" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_welfare_2126__JONGNO_GU_SEOUL_PARKING_AREA_PERSONS_D
CREATE TABLE "aihub_welfare"."publicdata_welfare_2126__JONGNO_GU_SEOUL_PARKING_AREA_PERSONS_D" (
    "DIVISION" TEXT,
    "GUYOUNG_PARKING_LOT_NAME" TEXT,
    "ADDRESS" TEXT,
    "DIVISION_DD" NUMERIC,
    "DISABLED" NUMERIC
);

-- Table: publicdata_welfare_2151__CURRENT_STS_C_HALL_GYEONGSAN_GYEONGBUK
CREATE TABLE "aihub_welfare"."publicdata_welfare_2151__CURRENT_STS_C_HALL_GYEONGSAN_GYEONGBUK" (
    "PARLIAMENT" TEXT,
    "LOCATION" TEXT,
    "GRATITUDE" NUMERIC,
    "FLOORS" NUMERIC,
    "BUILDING_STRUCTURE" TEXT,
    "CONSTRUCTION_YEAR" NUMERIC
);

-- Table: publicdata_welfare_225__TP_PENSIONS_EXHAUSTION_FORECAST
CREATE TABLE "aihub_welfare"."publicdata_welfare_225__TP_PENSIONS_EXHAUSTION_FORECAST" (
    "YEAR" NUMERIC,
    "REVENUE" NUMERIC,
    "CONTRIBUTION" NUMERIC,
    "OPERATING_INCOME" NUMERIC,
    "TOTAL_EXPENDITURE" NUMERIC,
    "PAY" NUMERIC,
    "FISCAL_RESIN" NUMERIC,
    "FUNDING" NUMERIC
);

-- Table: publicdata_welfare_227__TP_SUBSCRIBER_COUNT_FORECAST
CREATE TABLE "aihub_welfare"."publicdata_welfare_227__TP_SUBSCRIBER_COUNT_FORECAST" (
    "YEAR" NUMERIC,
    "NUMBER_OF_SUBSCRIBERS" NUMERIC,
    "RETIREMENT" NUMERIC,
    "SURVIVOR" NUMERIC,
    "LINKED_PENSIONER" NUMERIC
);

-- Table: publicdata_welfare_232__PERFORMANCE_TP_AFFILIATE_WELFARE_SERVIC
CREATE TABLE "aihub_welfare"."publicdata_welfare_232__PERFORMANCE_TP_AFFILIATE_WELFARE_SERVIC" (
    "DIVISION" TEXT,
    "REGION" TEXT,
    "COMPANY_NAME" TEXT,
    "Y_2020" NUMERIC,
    "Y_2021" NUMERIC
);

-- Table: publicdata_welfare_234__TP_PRIVATE_SCHOOL_PENSION_SUBSCRIBER_ST
CREATE TABLE "aihub_welfare"."publicdata_welfare_234__TP_PRIVATE_SCHOOL_PENSION_SUBSCRIBER_ST" (
    "AGE" TEXT,
    "TOTAL" NUMERIC,
    "TEACHER" NUMERIC,
    "EMPLOYEE" NUMERIC,
    "KINDERGARTEN_S" NUMERIC,
    "KINDERGARTEN_E" NUMERIC,
    "ELEMENTARY_SCHOOL_TEACHER" NUMERIC,
    "ELEMENTARY_SCHOOL_STAFF" NUMERIC,
    "MIDDLE_SCHOOL_TEACHER" NUMERIC,
    "MIDDLE_SCHOOL_STAFF" NUMERIC,
    "HIGH_SCHOOL_TEACHER" NUMERIC,
    "HIGH_SCHOOL_STAFF" NUMERIC,
    "PROFESSIONAL" NUMERIC,
    "PROFESSIONAL_EMPLOYEE" NUMERIC,
    "UNIVERSITY_TEACHER" NUMERIC,
    "UNIVERSITY_EMPLOYEE" NUMERIC,
    "SPECIAL_SCHOOL_TEACHER" NUMERIC,
    "SPECIAL_SCHOOL_EMPLOYEE" NUMERIC,
    "CORPORATE_TEACHER" NUMERIC,
    "CORPORATE_EMPLOYEE" NUMERIC
);

-- Table: publicdata_welfare_2432__KYCI_SOLIAN_WHITE_COUNSELING_SCHOOL
CREATE TABLE "aihub_welfare"."publicdata_welfare_2432__KYCI_SOLIAN_WHITE_COUNSELING_SCHOOL" (
    "AREAJ" TEXT,
    "SCHOOL_LEVELK" TEXT,
    "SCHOOL_NML" TEXT
);

-- Table: publicdata_welfare_2653__STS_PER_GGBC_SENIOR_CITIZEN
CREATE TABLE "aihub_welfare"."publicdata_welfare_2653__STS_PER_GGBC_SENIOR_CITIZEN" (
    "SERIAL_NUMU" NUMERIC,
    "D_U_J_O_F" TEXT,
    "N_S_C_C_G" TEXT,
    "ROAD_NM_ADDRESSX" TEXT,
    "PHONE_NUMY" TEXT
);

-- Table: publicdata_welfare_2684__GGBC_REGIONAL_CHILDREN_CNT
CREATE TABLE "aihub_welfare"."publicdata_welfare_2684__GGBC_REGIONAL_CHILDREN_CNT" (
    "SERIAL_NUMF" NUMERIC,
    "FACILITY_NMG" TEXT,
    "GARDENH" NUMERIC,
    "PHONE_NUMI" TEXT,
    "M_E_C_C_U" TEXT
);

-- Table: publicdata_welfare_2686__STS_GGBC_CHILD_WELFARE_FAC
CREATE TABLE "aihub_welfare"."publicdata_welfare_2686__STS_GGBC_CHILD_WELFARE_FAC" (
    "SERIAL_NUMK" NUMERIC,
    "FACILITY_TYPEL" TEXT,
    "FACILITY_NMM" TEXT,
    "GARDENN" NUMERIC,
    "PHONE_NUMO" TEXT,
    "M_E_C_C_ZZ" TEXT
);

-- Table: publicdata_welfare_2693__GNYS_FAMILY_CNT_PROGRAM_O_STS
CREATE TABLE "aihub_welfare"."publicdata_welfare_2693__GNYS_FAMILY_CNT_PROGRAM_O_STS" (
    "SERIAL_NUME" NUMERIC,
    "PROGRAM_NMF" TEXT,
    "EVENT_CLASG" TEXT,
    "PLACEH" TEXT,
    "ACCEPTANCE_STARTI" TEXT,
    "END_APPLICATIONJ" TEXT,
    "START_OPERATIONK" TEXT,
    "OPERATION_TERMINATIONL" TEXT,
    "TARGETM" TEXT,
    "BASE_DTN" TEXT
);

-- Table: publicdata_welfare_2804__STS_GGIC_WELFARE_FAC_ELDERLY
CREATE TABLE "aihub_welfare"."publicdata_welfare_2804__STS_GGIC_WELFARE_FAC_ELDERLY" (
    "CITY_COUNTY_NMB" TEXT,
    "B_E_N_L" TEXT,
    "LOC_NUM_ADDRESSD" TEXT,
    "PHONE_NUME" TEXT,
    "RP_DTF" TEXT,
    "BUSINESS_STA_NMG" TEXT,
    "ADMISSION_CPH" NUMERIC,
    "DATA_BASE_DTI" TEXT
);

-- Table: publicdata_welfare_2812__STS_GGY_R_DISABLED
CREATE TABLE "aihub_welfare"."publicdata_welfare_2812__STS_GGY_R_DISABLED" (
    "CITY_COUNTY_NMV" TEXT,
    "LIFE_SAVINGW" TEXT,
    "TOWNSHIP_NMX" TEXT,
    "FAULT_TYPEY" TEXT,
    "T_N_P_D_R_DE" NUMERIC,
    "N_R_D_M_EA" NUMERIC,
    "N_W_D_R_F" NUMERIC,
    "T_N_S_D_P_G" NUMERIC,
    "SEVERELY_DISABLED_MAND" NUMERIC,
    "SEVERELY_DISABLED_WOMANE" NUMERIC,
    "T_N_P_D_N_S_J" NUMERIC,
    "MAN_MODEST_DISABILITIESG" NUMERIC,
    "WOMAN_MILD_DISABILITYH" NUMERIC
);

-- Table: publicdata_welfare_2837__GNYS_COLD_WAVE_REST_AREA
CREATE TABLE "aihub_welfare"."publicdata_welfare_2837__GNYS_COLD_WAVE_REST_AREA" (
    "SHELTER_NMI" TEXT,
    "ROAD_NM_ADDRESSJ" TEXT,
    "OLD_ADDRESSK" TEXT,
    "FACILITY_TYPEL" TEXT,
    "NUM_PEOPLE_AVAILABLEM" NUMERIC
);

-- Table: publicdata_welfare_2870__GNYS_DAYCARE_CNT_STS
CREATE TABLE "aihub_welfare"."publicdata_welfare_2870__GNYS_DAYCARE_CNT_STS" (
    "NUME" NUMERIC,
    "ADMINISTRATIVE_BUILDINGF" TEXT,
    "DAY_CARE_CENTERG" TEXT,
    "DAYCARE_CENTER_TYPEH" TEXT,
    "ADDRESSI" TEXT,
    "SCHOOL_VEHICLEJ" TEXT,
    "E_C_C_O_L" TEXT,
    "P_C_E_M" TEXT,
    "CHILDCARE_FACULTY_STAFFM" NUMERIC,
    "GARDENN" NUMERIC,
    "CHILD_CARE_MISTAKEO" NUMERIC,
    "CHILD_CARE_ROOM_AREAP" NUMERIC,
    "PHONE_NUMQ" TEXT
);

-- Table: publicdata_welfare_2885__STS_WELFARE_FAC_ELDERLY_INJE_GUN_GW
CREATE TABLE "aihub_welfare"."publicdata_welfare_2885__STS_WELFARE_FAC_ELDERLY_INJE_GUN_GW" (
    "REGIONO" TEXT,
    "PHONE_NUMP" TEXT,
    "ROAD_NM_ADDRESSQ" TEXT,
    "LAND_NUM_ADDRESSR" TEXT,
    "DATA_BASE_DTS" TEXT
);

-- Table: publicdata_welfare_2941__GGGJ_R_DISABLED_P_COUNT_STS
CREATE TABLE "aihub_welfare"."publicdata_welfare_2941__GGGJ_R_DISABLED_P_COUNT_STS" (
    "CITY_COUNTY_NMM" TEXT,
    "TOWNSHIP_NMN" TEXT,
    "FAULT_TYPEO" TEXT,
    "T_N_P_D_R_H" NUMERIC,
    "N_R_D_M_I" NUMERIC,
    "N_W_D_R_J" NUMERIC,
    "T_N_S_D_P_K" NUMERIC,
    "SEVERELY_DISABLED_MANT" NUMERIC,
    "SEVERELY_DISABLED_WOMANU" NUMERIC,
    "T_N_P_D_N_S_N" NUMERIC,
    "MAN_MODEST_DISABILITIESW" NUMERIC,
    "WOMAN_MILD_DISABILITYX" NUMERIC,
    "DATA_BASE_DTY" TEXT
);

-- Table: publicdata_welfare_2942__INFO_GWWJ_MEDICAL_WELFARE_FAC_ELDERLY
CREATE TABLE "aihub_welfare"."publicdata_welfare_2942__INFO_GWWJ_MEDICAL_WELFARE_FAC_ELDERLY" (
    "FACILITY_NMZ" TEXT,
    "OPERATING_ENTITYA" TEXT,
    "PHONE_NUMB" TEXT,
    "LOCC" TEXT,
    "LATITUDED" NUMERIC,
    "HARDNESSE" NUMERIC,
    "INS_DTF" TEXT,
    "GARDENG" NUMERIC,
    "PRESENT_MANH" NUMERIC,
    "PERSON_COMPANYI" NUMERIC
);

-- Table: publicdata_welfare_2948__STS_WELFARE_FAC_ELDERLY_GBYCG
CREATE TABLE "aihub_welfare"."publicdata_welfare_2948__STS_WELFARE_FAC_ELDERLY_GBYCG" (
    "SERIAL_NUMR" NUMERIC,
    "TOWNSHIPS" TEXT,
    "VIL_NMT" TEXT,
    "SENIOR_CITIZEN_CENTERU" TEXT,
    "ADDRESS_LOCV" TEXT,
    "YEAR_CONSTRUCTIONW" NUMERIC,
    "AREA_SCALEX" NUMERIC,
    "NUM_EMPLOYEESY" NUMERIC,
    "PHONE_NUMZ" TEXT,
    "BASE_DTA" TEXT
);

-- Table: publicdata_welfare_294__STS_MOGEF_YOUTH_COUNSELING_WELFARE_CNT
CREATE TABLE "aihub_welfare"."publicdata_welfare_294__STS_MOGEF_YOUTH_COUNSELING_WELFARE_CNT" (
    "REGION" TEXT,
    "CENTER_NAME" TEXT,
    "TRIAL_NAME" TEXT,
    "CITIES_AND_COUNTIES" TEXT,
    "ADDRESS" TEXT,
    "PHONE_NUMBER_1" TEXT,
    "PHONE_NUMBER_2" TEXT,
    "PHONE_NUMBER_3" TEXT,
    "HOME_PAGE" TEXT
);

-- Table: publicdata_welfare_3009__GNGJ_PER_PATH_INFO
CREATE TABLE "aihub_welfare"."publicdata_welfare_3009__GNGJ_PER_PATH_INFO" (
    "SERIAL_NUMN" NUMERIC,
    "COTTON_BALLO" TEXT,
    "N_S_C_C_T" TEXT,
    "ROAD_NM_ADDRESS_LOCQ" TEXT,
    "LATITUDER" TEXT,
    "HARDNESSS" TEXT,
    "RE_DTT" TEXT,
    "BASE_DTU" TEXT
);

-- Table: publicdata_welfare_3070__C_STS_GNYS_VOLUNTEER_DISCOUNT_MERCHANT
CREATE TABLE "aihub_welfare"."publicdata_welfare_3070__C_STS_GNYS_VOLUNTEER_DISCOUNT_MERCHANT" (
    "SERIAL_NUMP" NUMERIC,
    "COMPANY_NMQ" TEXT,
    "INDUSTRYR" TEXT,
    "ADDRESSS" TEXT,
    "DISCOUNT_RATET" TEXT,
    "BASE_DTU" TEXT
);

-- Table: publicdata_welfare_308__NORTH_GYEONGSANG_PROVINCE_CHILDREN_MEAL
CREATE TABLE "aihub_welfare"."publicdata_welfare_308__NORTH_GYEONGSANG_PROVINCE_CHILDREN_MEAL" (
    "TURN" NUMERIC,
    "FRANCHISE" TEXT,
    "MERCHANT_ADDRESS" TEXT,
    "DIVISION" TEXT,
    "SECTORS" TEXT,
    "SUBSCRIPTION_DATE" TEXT
);

-- Table: publicdata_welfare_3151__STS_GNGH_WELFARE_FAC_ELDERLY
CREATE TABLE "aihub_welfare"."publicdata_welfare_3151__STS_GNGH_WELFARE_FAC_ELDERLY" (
    "FACILITY_TYPEA" TEXT,
    "FACILITY_NMB" TEXT,
    "ROAD_NM_ADDRESSC" TEXT,
    "GARDEND" NUMERIC,
    "PHONE_NUME" TEXT,
    "FAX_FAXF" TEXT,
    "REPRESENTATIVEG" TEXT
);

-- Table: publicdata_welfare_3186__STS_GGBC_VOLUNTEER_DISCOUNT_MERCHANTS
CREATE TABLE "aihub_welfare"."publicdata_welfare_3186__STS_GGBC_VOLUNTEER_DISCOUNT_MERCHANTS" (
    "SERIAL_NUMD" NUMERIC,
    "SORTATIONE" TEXT,
    "WHERE_USEF" TEXT,
    "DISCOUNT_DETAILSG" TEXT,
    "DISCOUNT_RATEH" NUMERIC,
    "SPECIAL_NOTEI" TEXT,
    "CONTACT_USJ" TEXT
);

-- Table: publicdata_welfare_3305__GG_SW_WELFARE_SERVICE
CREATE TABLE "aihub_welfare"."publicdata_welfare_3305__GG_SW_WELFARE_SERVICE" (
    "FACILITY_NMD" TEXT,
    "BUSINESS_CLASE" TEXT,
    "PROGRAM_NMF" TEXT,
    "PROGRAM_CONTENTSG" TEXT,
    "TARGET_AREAH" TEXT,
    "S_U_Q_EA" TEXT,
    "NUM_PEOPLE_AVAILABLEJ" NUMERIC,
    "APPLICATION_METHODK" TEXT,
    "RATE_CLASL" TEXT,
    "USAGE_FEEM" NUMERIC,
    "DT_TIME_OPERATIONN" TEXT,
    "CONTACT_USO" TEXT,
    "BASE_DTP" TEXT
);

-- Table: publicdata_welfare_3385__STS_KOGAS_TECH_DONATION_P
CREATE TABLE "aihub_welfare"."publicdata_welfare_3385__STS_KOGAS_TECH_DONATION_P" (
    "DTJ" TEXT,
    "PLACE_DONATIONK" TEXT,
    "AMT_DONATIONL" NUMERIC,
    "REASON_DONATIONM" TEXT
);

-- Table: publicdata_welfare_3400__C_STS_PER_GNGH_SENIOR_CITIZEN_CNT
CREATE TABLE "aihub_welfare"."publicdata_welfare_3400__C_STS_PER_GNGH_SENIOR_CITIZEN_CNT" (
    "SEQUENCEB" NUMERIC,
    "E_M_DC" TEXT,
    "SENIOR_CITIZEN_CENTERD" TEXT,
    "ROAD_NM_ADDRESSE" TEXT,
    "LATITUDEF" NUMERIC,
    "HARDNESSG" NUMERIC,
    "DATA_BASE_DTH" TEXT
);

-- Table: publicdata_welfare_3403__STS_GG_SU_JOB_PRO_ELDERLY
CREATE TABLE "aihub_welfare"."publicdata_welfare_3403__STS_GG_SU_JOB_PRO_ELDERLY" (
    "PERFORMING_ORGANIZATIONN" TEXT,
    "TYPEO" TEXT,
    "BUSINESS_NMP" TEXT,
    "ASSIGNED_NUM_PEOPLEQ" NUMERIC,
    "CONTENTR" TEXT,
    "DATA_BASE_DTS" TEXT
);

-- Table: publicdata_welfare_3417__GNJJ_DAYCARE_CNT_STS
CREATE TABLE "aihub_welfare"."publicdata_welfare_3417__GNJJ_DAYCARE_CNT_STS" (
    "DISTINGUISHED_NMS" TEXT,
    "DAY_CARE_CENTERT" TEXT,
    "ADMINISTRATIVE_BUILDINGU" TEXT,
    "ADDRESSV" TEXT,
    "PHONE_NUMW" TEXT,
    "DATA_BASE_DTX" TEXT
);

-- Table: publicdata_welfare_3490__STS_GG_YJ_WELFARE_FAC_ELDERLY
CREATE TABLE "aihub_welfare"."publicdata_welfare_3490__STS_GG_YJ_WELFARE_FAC_ELDERLY" (
    "SERIAL_NUMI" NUMERIC,
    "FACILITY_TYPEJ" TEXT,
    "FACILITY_TYPEK" TEXT,
    "FACILITY_NML" TEXT,
    "PHONE_NUMM" TEXT,
    "FAX_NUMN" TEXT,
    "POSTAL_CDO" NUMERIC,
    "FACILITY_LOC_ADDRESSP" TEXT,
    "INS_DTQ" TEXT,
    "NM_MANAGEMENT_AGENCYR" TEXT,
    "ADMISSION_CPS" NUMERIC,
    "DATA_BASE_DTT" TEXT
);

-- Table: publicdata_welfare_3603__STS_GG_YEJ_WELFARE_FAC_ELDERLY
CREATE TABLE "aihub_welfare"."publicdata_welfare_3603__STS_GG_YEJ_WELFARE_FAC_ELDERLY" (
    "FACILITY_NML" TEXT,
    "FACILITY_TYPEM" TEXT,
    "LOC_MAP_NM_ADDRESSN" TEXT,
    "PHONE_NUMO" TEXT,
    "NM_MANAGEMENT_AGENCYP" TEXT,
    "DATA_BASE_DTQ" TEXT
);

-- Table: publicdata_welfare_3660__GGPJ_LEISURE_FAC_ELDERLY
CREATE TABLE "aihub_welfare"."publicdata_welfare_3660__GGPJ_LEISURE_FAC_ELDERLY" (
    "NUMI" NUMERIC,
    "FACILITY_NMJ" TEXT,
    "N_A_R_L_M_P" TEXT,
    "DATA_BASE_DTL" TEXT
);

-- Table: publicdata_welfare_3732__STS_PER_GGHN_SENIOR_CITIZEN
CREATE TABLE "aihub_welfare"."publicdata_welfare_3732__STS_PER_GGHN_SENIOR_CITIZEN" (
    "CITY_COUNTY_NMB" TEXT,
    "B_E_N_EA" TEXT,
    "LOC_NUM_ADDRESSD" TEXT,
    "PHONE_NUME" TEXT,
    "LICENSE_DTF" TEXT,
    "BUSINESS_STA_NMG" TEXT,
    "ADMISSION_CPH" NUMERIC,
    "DATA_BASE_DTI" TEXT
);

-- Table: publicdata_welfare_3760__STS_GGMP_WELFARE_FAC_ELDERLY
CREATE TABLE "aihub_welfare"."publicdata_welfare_3760__STS_GGMP_WELFARE_FAC_ELDERLY" (
    "SORTATIOND" TEXT,
    "FACILITY_CLASE" TEXT,
    "FACILITY_NMF" TEXT,
    "LOC_ADDRESSG" TEXT,
    "GARDENH" NUMERIC,
    "CONTACT_USI" TEXT,
    "DATA_BASE_DTJ" TEXT
);

-- Table: publicdata_welfare_4128__GWCC_CHILDREN_MEAL_CARD_MERCHANT
CREATE TABLE "aihub_welfare"."publicdata_welfare_4128__GWCC_CHILDREN_MEAL_CARD_MERCHANT" (
    "NM_MERCHANTE" TEXT,
    "MERCHANT_TYPE_CDF" NUMERIC,
    "CITY_PROVINCEG" TEXT,
    "NM_CITY_COUNTY_DISTRICTH" TEXT,
    "CITY_COUNTY_DISTRICT_CDI" NUMERIC,
    "LOC_MAP_NM_ADDRESSJ" TEXT,
    "LOC_NUM_ADDRESSK" TEXT,
    "LATITUDEL" NUMERIC,
    "HARDNESSM" NUMERIC,
    "PHONE_NUMN" TEXT,
    "W_O_S_T_Z" TEXT,
    "W_O_E_T_ZZ" TEXT,
    "S_O_S_T_VA" TEXT,
    "SATURDAY_CLOSING_TIMER" TEXT,
    "H_O_S_T_DE" TEXT,
    "H_O_E_T_XZ" TEXT,
    "DELIVERY_START_TIMEU" TEXT,
    "DELIVERY_END_TIMEV" TEXT,
    "NM_MANAGEMENT_AGENCYW" TEXT,
    "M_A_P_N_DE" TEXT,
    "DATA_BASE_DTY" TEXT
);

-- Table: publicdata_welfare_4203__GG_PJ_SHARING_STORE
CREATE TABLE "aihub_welfare"."publicdata_welfare_4203__GG_PJ_SHARING_STORE" (
    "STORE_NMW" TEXT,
    "INDUSTRYX" TEXT,
    "CONTENTS_SHARINGY" TEXT,
    "N_D_S_S_X" TEXT,
    "ROAD_NM_ADDRESSA" TEXT,
    "LAND_NUM_ADDRESSB" TEXT,
    "PHONE_NUMC" TEXT,
    "DATA_BASE_DTD" TEXT
);

-- Table: publicdata_welfare_4261__GGSN_WELFARE_CNT_O_PROGRAM
CREATE TABLE "aihub_welfare"."publicdata_welfare_4261__GGSN_WELFARE_CNT_O_PROGRAM" (
    "CITY_COUNTY_NMI" TEXT,
    "WELFARE_OFFICER_NMJ" TEXT,
    "TARGET_USEK" TEXT,
    "D_T_T_C_U_V" TEXT,
    "A_R_D_C_U_W" TEXT,
    "D_C_U_O_C_X" TEXT,
    "SORTATIONO" TEXT,
    "DETAILED_CLASP" TEXT,
    "PROGRAM_NMQ" TEXT,
    "PROGRAM_CONTENTSR" TEXT,
    "HOURS_USES" TEXT,
    "AMT_USEDT" NUMERIC,
    "U_A_C_S_XZ" TEXT,
    "ADDITIONAL_EXPENSESV" NUMERIC,
    "LOC_MAP_NM_ADDRESSW" TEXT,
    "PHONE_NUMX" TEXT,
    "POSTAL_CDY" NUMERIC,
    "LATITUDEZ" NUMERIC,
    "HARDNESSA" NUMERIC,
    "DATA_BASE_DTB" TEXT
);

-- Table: publicdata_welfare_4322__GGPJ_WELFARE_FAC_ELDERLY_HOME
CREATE TABLE "aihub_welfare"."publicdata_welfare_4322__GGPJ_WELFARE_FAC_ELDERLY_HOME" (
    "FACILITY_TYPES" TEXT,
    "SALARY_TYPET" TEXT,
    "NM_ORGANIZATIONU" TEXT,
    "INS_DTV" TEXT,
    "POSTAL_CDW" NUMERIC,
    "FACILITY_ADDRESSX" TEXT,
    "INSTITUTIONAL_PHONE_NUMY" TEXT,
    "BUSINESS_STAZ" TEXT,
    "HOME_PAY_QUOTAA" NUMERIC,
    "L_T_C_I_D_S_S" TEXT,
    "DATA_BASE_DTC" TEXT
);

-- Table: publicdata_welfare_4489__C_STS_SOCIAL_CONTRIBUTION_ACTIVITIES_K
CREATE TABLE "aihub_welfare"."publicdata_welfare_4489__C_STS_SOCIAL_CONTRIBUTION_ACTIVITIES_K" (
    "YEARX" NUMERIC,
    "ACTIVITY_NMY" TEXT,
    "TARGETZ" TEXT,
    "CONTENTA" TEXT
);

-- Table: publicdata_welfare_451__STS_BASIC_LIVING_SECURITY_RECIPIENTS_NA
CREATE TABLE "aihub_welfare"."publicdata_welfare_451__STS_BASIC_LIVING_SECURITY_RECIPIENTS_NA" (
    "TOWNSHIP_AND_TOWNSHIP" TEXT,
    "QUALIFICATION" TEXT,
    "NUMBER_HOUSEHOLDS" NUMERIC,
    "NUMBER_BENEFICIARIES" NUMERIC
);

-- Table: publicdata_welfare_471__C_SERVICE_INVESTMENT_PRO_SUYEONG_GU_BUS
CREATE TABLE "aihub_welfare"."publicdata_welfare_471__C_SERVICE_INVESTMENT_PRO_SUYEONG_GU_BUS" (
    "TURN" NUMERIC,
    "PROVISION" TEXT,
    "REPRESENTATIVE" TEXT,
    "ADDRESS" TEXT,
    "PHONE_NUMBER" TEXT,
    "BUSINESS_TYPE" TEXT,
    "DESIGNATED_DATE" TEXT,
    "PROVIDED_PERSONNEL" NUMERIC
);

-- Table: publicdata_welfare_4738__KDHC_SME_SU_P
CREATE TABLE "aihub_welfare"."publicdata_welfare_4738__KDHC_SME_SU_P" (
    "YEARC" NUMERIC,
    "BUSINESS_NMD" TEXT,
    "SUPPORT_AMT_1_M_WONE" NUMERIC,
    "NUM_COMPANIESF" NUMERIC
);

-- Table: publicdata_welfare_4876__STS_BENEFICIARIES_SSIS_WELFARE_PRO_CIT
CREATE TABLE "aihub_welfare"."publicdata_welfare_4876__STS_BENEFICIARIES_SSIS_WELFARE_PRO_CIT" (
    "BUSINESS_NMS" TEXT,
    "BASE_YEAR_MONTHT" TEXT,
    "CITY_PROVINCEU" TEXT,
    "C_C_C_D_VA" TEXT,
    "NUM_BENEFICIARIESW" NUMERIC,
    "N_S_D_H_DE" NUMERIC
);

-- Table: publicdata_welfare_487__CURRENT_STS_TP_PENSION_ACT_APPLICABLE_I
CREATE TABLE "aihub_welfare"."publicdata_welfare_487__CURRENT_STS_TP_PENSION_ACT_APPLICABLE_I" (
    "TURN" NUMERIC,
    "INSTITUTIONAL_NAME" TEXT,
    "SCHOOL_CLASS" TEXT,
    "REGION" TEXT,
    "ADDRESS" TEXT
);

-- Table: publicdata_welfare_4891__STS_BENEFICIARIES_SSIS_WELFARE_PRO_CIT
CREATE TABLE "aihub_welfare"."publicdata_welfare_4891__STS_BENEFICIARIES_SSIS_WELFARE_PRO_CIT" (
    "BUSINESS_NMX" TEXT,
    "BASE_YEAR_MONTHY" TEXT,
    "CITY_PROVINCEZ" TEXT,
    "NUM_BENEFICIARIESA" NUMERIC,
    "N_S_D_H_I" NUMERIC
);

-- Table: publicdata_welfare_4924__S_V_P_G_N_S_W_U_K_C
CREATE TABLE "aihub_welfare"."publicdata_welfare_4924__S_V_P_G_N_S_W_U_K_C" (
    "CITY_PROVINCEW" TEXT,
    "P_P_A_A" TEXT,
    "NUM_VOLUNTEERSY" NUMERIC
);

-- Table: publicdata_welfare_494__CURRENT_STS_VILLAGE_HALL_YEONCHEON_GUN_
CREATE TABLE "aihub_welfare"."publicdata_welfare_494__CURRENT_STS_VILLAGE_HALL_YEONCHEON_GUN_" (
    "VILLAGE" TEXT,
    "LOCATION_TOWN" TEXT,
    "ADDRESS" TEXT,
    "STREET_NAME_ADDRESS" TEXT,
    "LATITUDE" NUMERIC,
    "HARDNESS" NUMERIC,
    "BUILDING_YEAR" NUMERIC,
    "SIZE_SQUARE_METER" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_welfare_5022__C_STS_KSSN_N_SOCIAL_WELFARE_COUNCIL
CREATE TABLE "aihub_welfare"."publicdata_welfare_5022__C_STS_KSSN_N_SOCIAL_WELFARE_COUNCIL" (
    "CLASR" TEXT,
    "AREAS" TEXT,
    "COUNCIL_NMT" TEXT,
    "POSTAL_CDU" NUMERIC,
    "ADDRESSV" TEXT,
    "REPRESENTATIVE_CONTACTW" TEXT,
    "FAX_NUMX" TEXT
);

-- Table: publicdata_welfare_5025__KSSN_SOCIAL_WELFARE_VOLUNTEER_MNG_CNT
CREATE TABLE "aihub_welfare"."publicdata_welfare_5025__KSSN_SOCIAL_WELFARE_VOLUNTEER_MNG_CNT" (
    "DIVIDING_AREAH" TEXT,
    "MANAGEMENT_CENTER_NMI" TEXT,
    "CENTER_TYPEJ" TEXT,
    "CONTACT_USK" TEXT
);

-- Table: publicdata_welfare_5035__C_S_C_V_K_S_C_A_D_B_ZZ
CREATE TABLE "aihub_welfare"."publicdata_welfare_5035__C_S_C_V_K_S_C_A_D_B_ZZ" (
    "R_C_C_EA" TEXT,
    "NUM_PEOPLEJ" NUMERIC,
    "NUM_PEOPLEK" NUMERIC,
    "NUM_ACTIVITIESL" NUMERIC,
    "NUM_ACTIVITIESM" NUMERIC,
    "ACTIVITY_TIME_MANN" NUMERIC,
    "IT_TIME_ACTIVITIESO" NUMERIC
);

-- Table: publicdata_welfare_504__INFO_APP_VOLUNTEER_SERVICE_BORYEONG_CIT
CREATE TABLE "aihub_welfare"."publicdata_welfare_504__INFO_APP_VOLUNTEER_SERVICE_BORYEONG_CIT" (
    "LIBRARY" TEXT,
    "APPLICATION_DATE" TEXT,
    "APPLICATION_TIME_1" TEXT,
    "APPLICATION_TIME_2" TEXT,
    "APPLICATION_TIME_3" TEXT,
    "APPLICATION_TIME_4" TEXT,
    "APPLICATION_TIME_5" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_welfare_5179__INFO_H_EXAMINATION_INST_CWMA_CONST_WOR
CREATE TABLE "aihub_welfare"."publicdata_welfare_5179__INFO_H_EXAMINATION_INST_CWMA_CONST_WOR" (
    "SERIAL_NUMD" NUMERIC,
    "AREAE" TEXT,
    "N_E_I_T" TEXT,
    "ADDRESSG" TEXT
);

-- Table: publicdata_welfare_5181__INFO_KSSN_DOMESTIC_SOCIAL_CONTRIBUTION
CREATE TABLE "aihub_welfare"."publicdata_welfare_5181__INFO_KSSN_DOMESTIC_SOCIAL_CONTRIBUTION" (
    "GROUP_NMQ" TEXT,
    "NM_REPRESENTATIVER" TEXT,
    "REPRESENTATIVE_ADDRESSS" TEXT
);

-- Table: publicdata_welfare_529__STS_WELFARE_FAC_ELDERLY_SEO_GU_BUSAN
CREATE TABLE "aihub_welfare"."publicdata_welfare_529__STS_WELFARE_FAC_ELDERLY_SEO_GU_BUSAN" (
    "FACILITY_NAME" TEXT,
    "LOCATION_ADDRESS" TEXT,
    "LICENSE_DATE" TEXT,
    "ENTRANCE" NUMERIC
);

-- Table: publicdata_welfare_5430__SSIS_SOCIAL_SERVICE_PROVIDER_INFO
CREATE TABLE "aihub_welfare"."publicdata_welfare_5430__SSIS_SOCIAL_SERVICE_PROVIDER_INFO" (
    "NUMR" NUMERIC,
    "AREA_NMS" TEXT,
    "N_I_C_C_D_DE" NUMERIC
);

-- Table: publicdata_welfare_5616__N_SELF_SU_ENT_KR_SELF_SU_WELFARE_DEV_I
CREATE TABLE "aihub_welfare"."publicdata_welfare_5616__N_SELF_SU_ENT_KR_SELF_SU_WELFARE_DEV_I" (
    "NUMC" NUMERIC,
    "CITY_PROVINCED" TEXT,
    "C_C_C_D_Q" TEXT,
    "S_S_E_RC" TEXT,
    "ENTERPRISE_TYPEG" TEXT,
    "ADDRESSH" TEXT,
    "REPRESENTATIVEI" TEXT,
    "INDUSTRYJ" TEXT,
    "BUSINESS_CLASK" TEXT
);

-- Table: publicdata_welfare_5686__C_S_K_D_D_I_V_R_S_P_S_D_P_H
CREATE TABLE "aihub_welfare"."publicdata_welfare_5686__C_S_K_D_D_I_V_R_S_P_S_D_P_H" (
    "SERIAL_NUMQ" NUMERIC,
    "I_T_O_C" TEXT,
    "NM_ORGANIZATIONS" TEXT,
    "CONTACT_UST" TEXT,
    "CITY_PROVINCEU" TEXT,
    "C_C_C_D_G" TEXT,
    "DETAILED_ADDRESSW" TEXT,
    "VOCATIONAL_COUNSELINGX" TEXT,
    "JOB_EVALUATIONY" TEXT,
    "V_A_T_K" TEXT,
    "SUPPORTIVE_EMPLOYMENTA" TEXT,
    "EMPLOYMENT_PLACEMENTB" TEXT,
    "S_A_A_E_N" TEXT,
    "V_C_D_T_O" TEXT,
    "V_R_P_P" TEXT
);

-- Table: publicdata_welfare_5687__C_STS_INST_CARRYING_OUT_JOB_PRO_DISABL
CREATE TABLE "aihub_welfare"."publicdata_welfare_5687__C_STS_INST_CARRYING_OUT_JOB_PRO_DISABL" (
    "NUMF" NUMERIC,
    "AREAG" TEXT,
    "I_T_O_S" TEXT,
    "NM_ORGANIZATIONI" TEXT,
    "BUSINESS_TYPEJ" TEXT
);

-- Table: publicdata_welfare_5701__RESEARCH_KR_I_DISABLED
CREATE TABLE "aihub_welfare"."publicdata_welfare_5701__RESEARCH_KR_I_DISABLED" (
    "SERIAL_NUMW" NUMERIC,
    "RESEARCH_RP_NMX" TEXT,
    "DT_ISSUEY" TEXT,
    "RP_TYPEA" TEXT,
    "ISBNB" TEXT,
    "RESEARCH_PURPOSEC" TEXT
);

-- Table: publicdata_welfare_5729__HF_BOGEUMJARI_LOAN_HOUSING_T
CREATE TABLE "aihub_welfare"."publicdata_welfare_5729__HF_BOGEUMJARI_LOAN_HOUSING_T" (
    "PRODUCT_CLASE" NUMERIC,
    "PRODUCT_M_CLASF" NUMERIC,
    "PRODUCTG" NUMERIC,
    "AMTH" NUMERIC,
    "FLOATING_POINTI" TEXT,
    "DT_TIME_INITIAL_REJ" TEXT,
    "INITIAL_RE_POINTK" NUMERIC,
    "HOUSING_TYPEL" TEXT
);

-- Table: publicdata_welfare_5730__HF_BOGEUMJARI_LOAN_AGENCY
CREATE TABLE "aihub_welfare"."publicdata_welfare_5730__HF_BOGEUMJARI_LOAN_AGENCY" (
    "PRODUCT_CLASM" NUMERIC,
    "PRODUCT_M_CLASN" NUMERIC,
    "PRODUCTO" NUMERIC,
    "AMTP" NUMERIC,
    "FLOATING_POINTQ" TEXT,
    "DT_TIME_INITIAL_RER" TEXT,
    "INITIAL_RE_POINTS" NUMERIC,
    "LENDING_INSTITUTIONT" TEXT
);

-- Table: publicdata_welfare_5731__HF_NESTING_LOAN_APP
CREATE TABLE "aihub_welfare"."publicdata_welfare_5731__HF_NESTING_LOAN_APP" (
    "PRODUCT_CLASU" NUMERIC,
    "PRODUCT_M_CLASV" NUMERIC,
    "PRODUCTW" NUMERIC,
    "AMTX" NUMERIC,
    "FLOATING_POINTY" TEXT,
    "DT_TIME_INITIAL_REZ" TEXT,
    "INITIAL_RE_POINTA" NUMERIC,
    "PURPOSEB" TEXT
);

-- Table: publicdata_welfare_5732__HF_BOGEUMJARI_LOAN_LOAN_PERIOD
CREATE TABLE "aihub_welfare"."publicdata_welfare_5732__HF_BOGEUMJARI_LOAN_LOAN_PERIOD" (
    "PRODUCT_CLASC" NUMERIC,
    "PRODUCT_M_CLASD" NUMERIC,
    "PRODUCTE" NUMERIC,
    "AMTF" NUMERIC,
    "FLOATING_POINTG" TEXT,
    "DT_TIME_INITIAL_REH" TEXT,
    "INITIAL_RE_POINTI" NUMERIC,
    "LOAN_PERIODJ" NUMERIC
);

-- Table: publicdata_welfare_5733__HF_BOGEUMJARI_LOAN_REPAYMENT_METHOD
CREATE TABLE "aihub_welfare"."publicdata_welfare_5733__HF_BOGEUMJARI_LOAN_REPAYMENT_METHOD" (
    "PRODUCT_CLASK" NUMERIC,
    "PRODUCT_M_CLASL" NUMERIC,
    "PRODUCTM" NUMERIC,
    "AMTN" NUMERIC,
    "FLOATING_POINTO" TEXT,
    "DT_TIME_INITIAL_REP" TEXT,
    "INITIAL_RE_POINTQ" NUMERIC,
    "REDEMPTION_METHODR" TEXT
);

-- Table: publicdata_welfare_5734__HF_BOGEUMJARI_LOAN_POST_COLLATERAL_STS
CREATE TABLE "aihub_welfare"."publicdata_welfare_5734__HF_BOGEUMJARI_LOAN_POST_COLLATERAL_STS" (
    "PRODUCT_CLASS" NUMERIC,
    "PRODUCT_M_CLAST" NUMERIC,
    "PRODUCTU" NUMERIC,
    "AMTV" NUMERIC,
    "FLOATING_POINTW" TEXT,
    "DT_TIME_INITIAL_REX" TEXT,
    "INITIAL_RE_POINTY" NUMERIC,
    "EXEMPTION_SECURITY_STAZ" TEXT
);

-- Table: publicdata_welfare_5736__HF_BOGEUMJARI_LOAN_DOUBLE_INCOME_STS
CREATE TABLE "aihub_welfare"."publicdata_welfare_5736__HF_BOGEUMJARI_LOAN_DOUBLE_INCOME_STS" (
    "PRODUCT_CLASI" NUMERIC,
    "PRODUCT_M_CLASJ" NUMERIC,
    "PRODUCTK" NUMERIC,
    "AMTL" NUMERIC,
    "FLOATING_POINTM" TEXT,
    "DT_TIME_INITIAL_REN" TEXT,
    "INITIAL_RE_POINTO" NUMERIC,
    "DOUBLE_INCOME_STAP" TEXT
);

-- Table: publicdata_welfare_5737__HF_HOME_LOAN_NEWLYWED_COUPLES
CREATE TABLE "aihub_welfare"."publicdata_welfare_5737__HF_HOME_LOAN_NEWLYWED_COUPLES" (
    "PRODUCT_CLASQ" NUMERIC,
    "PRODUCT_M_CLASR" NUMERIC,
    "PRODUCTS" NUMERIC,
    "AMTT" NUMERIC,
    "FLOATING_POINTU" TEXT,
    "DT_TIME_INITIAL_REV" TEXT,
    "INITIAL_RE_POINTW" NUMERIC,
    "NEWLY_MARRIED_COUPLEX" TEXT
);

-- Table: publicdata_welfare_5738__HF_BOGEUMJARI_LOAN_FIRST_NEWLY_MARRIED
CREATE TABLE "aihub_welfare"."publicdata_welfare_5738__HF_BOGEUMJARI_LOAN_FIRST_NEWLY_MARRIED" (
    "PRODUCT_CLASY" NUMERIC,
    "PRODUCT_M_CLASZ" NUMERIC,
    "PRODUCTA" NUMERIC,
    "AMTB" NUMERIC,
    "FLOATING_POINTC" TEXT,
    "DT_TIME_INITIAL_RED" TEXT,
    "INITIAL_RE_POINTE" NUMERIC,
    "N_M_C_F_T_O_L_Y" TEXT
);

-- Table: publicdata_welfare_5739__HF_BOGEUMJARI_LOAN_FIRST_TIME_LOAN_STS
CREATE TABLE "aihub_welfare"."publicdata_welfare_5739__HF_BOGEUMJARI_LOAN_FIRST_TIME_LOAN_STS" (
    "PRODUCT_CLASG" NUMERIC,
    "PRODUCT_M_CLASH" NUMERIC,
    "PRODUCTI" NUMERIC,
    "AMTJ" NUMERIC,
    "FLOATING_POINTK" TEXT,
    "DT_TIME_INITIAL_REL" TEXT,
    "INITIAL_RE_POINTM" NUMERIC,
    "FIRST_TIME_LOAN_STAN" TEXT
);

-- Table: publicdata_welfare_5740__HF_BOGEUMJARI_LOAN_HOUSING_PENSION_R_A
CREATE TABLE "aihub_welfare"."publicdata_welfare_5740__HF_BOGEUMJARI_LOAN_HOUSING_PENSION_R_A" (
    "PRODUCT_CLASO" NUMERIC,
    "PRODUCT_M_CLASP" NUMERIC,
    "PRODUCTQ" NUMERIC,
    "AMTR" NUMERIC,
    "FLOATING_POINTS" TEXT,
    "INITIAL_RE_DTT" TEXT,
    "INITIAL_RE_POINTU" NUMERIC,
    "H_P_A_R_S_J" TEXT
);

-- Table: publicdata_welfare_5741__HF_BOGEUMJARI_LOAN_WHETHER_IT_BOGEUMJA
CREATE TABLE "aihub_welfare"."publicdata_welfare_5741__HF_BOGEUMJARI_LOAN_WHETHER_IT_BOGEUMJA" (
    "PRODUCT_CLASW" NUMERIC,
    "PRODUCT_M_CLASX" NUMERIC,
    "PRODUCTY" NUMERIC,
    "AMTZ" NUMERIC,
    "FLOATING_POINTA" TEXT,
    "DT_TIME_INITIAL_REB" TEXT,
    "INITIAL_RE_POINTC" NUMERIC,
    "R_O_H_L_S_RC" TEXT
);

-- Table: publicdata_welfare_583__CURRENT_STS_FOREIGN_RESIDENTS_GEOJE_GYE
CREATE TABLE "aihub_welfare"."publicdata_welfare_583__CURRENT_STS_FOREIGN_RESIDENTS_GEOJE_GYE" (
    "NATIONALITY" TEXT,
    "ILUN_MYEON" NUMERIC,
    "DONGBU_MYEON" NUMERIC,
    "SOUTHERN" NUMERIC,
    "GEOJE_MYEON" NUMERIC,
    "DUNDEOK_MYEON" NUMERIC,
    "PRIVATE" NUMERIC,
    "YEAR" NUMERIC,
    "SUBCONTRACTOR" NUMERIC,
    "JANGMOK_MYEON" NUMERIC,
    "JANGSEUNGPO_DONG" NUMERIC,
    "NEUNGPO_DONG" NUMERIC,
    "AH" NUMERIC,
    "OKPO_1_DONG" NUMERIC,
    "OKPO_2_DONG" NUMERIC,
    "JANGPYEONG_DONG" NUMERIC,
    "GOHYEON_DONG" NUMERIC,
    "SANGMUN_DONG" NUMERIC,
    "SUYANG_DONG" NUMERIC,
    "STANDARD_DATE" TEXT
);

-- Table: publicdata_welfare_5878__KYCI_N_YOUTH_COUNSELING_WELFARE_CNT
CREATE TABLE "aihub_welfare"."publicdata_welfare_5878__KYCI_N_YOUTH_COUNSELING_WELFARE_CNT" (
    "CENTER_NMJ" TEXT,
    "AREAK" TEXT,
    "NM_BRANCHL" TEXT,
    "POSTAL_CDM" NUMERIC,
    "ADDRESSN" TEXT,
    "Y_C_P_G" TEXT,
    "A_P_C_H" TEXT,
    "FAX_MACHINEQ" TEXT,
    "HOMEPAGER" TEXT
);

-- Table: publicdata_welfare_588__STS_WELFARE_FAC_ELDERLY_GOYANG_SI_GYEON
CREATE TABLE "aihub_welfare"."publicdata_welfare_588__STS_WELFARE_FAC_ELDERLY_GOYANG_SI_GYEON" (
    "ANNUAL" NUMERIC,
    "FACILITY_NAME" TEXT,
    "INSTITUTION" TEXT,
    "ADMISSION_NUMBER" NUMERIC,
    "ADDRESS" TEXT,
    "PHONE_NUMBER" TEXT
);

-- Table: publicdata_welfare_786__STS_SENIOR_CITIZENS_CNT_BORYEONG_CHUNGN
CREATE TABLE "aihub_welfare"."publicdata_welfare_786__STS_SENIOR_CITIZENS_CNT_BORYEONG_CHUNGN" (
    "ANNUAL" NUMERIC,
    "FACILITY_NAME" TEXT,
    "FACILITY" TEXT,
    "PHONE_NUMBER" TEXT,
    "FACILITY_LOCATION_ADDRESS" TEXT
);

-- Table: publicdata_welfare_796__CURRENT_STS_SENIOR_CITIZENS_CNT_MUJU_GU
CREATE TABLE "aihub_welfare"."publicdata_welfare_796__CURRENT_STS_SENIOR_CITIZENS_CNT_MUJU_GU" (
    "PATH" TEXT,
    "MATERIAL_MAP_NAME_ADDRESS" TEXT,
    "MATERIAL_SUPPORT_ADDRESS" TEXT,
    "LATITUDE" NUMERIC,
    "HARDNESS" NUMERIC,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_welfare_856__TP_OFFICE_EMPLOYEE_RETIREMENT_STS
CREATE TABLE "aihub_welfare"."publicdata_welfare_856__TP_OFFICE_EMPLOYEE_RETIREMENT_STS" (
    "YEAR" NUMERIC,
    "EMPLOYMENT_DATE" TEXT,
    "GENERAL_TECHNICAL_JOB" NUMERIC,
    "FUNCTIONAL_JOB" NUMERIC,
    "EMPLOYMENT" NUMERIC,
    "NOMINEE" NUMERIC
);

-- Table: publicdata_welfare_877__DJ_SISEOL_MEMORIAL_PARK_BONGAN_MONTHLY_
CREATE TABLE "aihub_welfare"."publicdata_welfare_877__DJ_SISEOL_MEMORIAL_PARK_BONGAN_MONTHLY_" (
    "YEAR" NUMERIC,
    "MONTH" NUMERIC,
    "TOTAL" NUMERIC,
    "FLEXIBLE_SUBTOTAL_SYSTEM" NUMERIC,
    "FLEXIBLE_TUBE" NUMERIC,
    "FLEXIBLE_OUT_WAY" NUMERIC,
    "COMBUSTION_FREE_SYSTEM" NUMERIC,
    "LEAD_FREE_JURISDICTION" NUMERIC,
    "UNCONNECTED_OUT_OF" NUMERIC
);

-- Table: publicdata_welfare_951__TP_PURCHASE_STS_LIST
CREATE TABLE "aihub_welfare"."publicdata_welfare_951__TP_PURCHASE_STS_LIST" (
    "CONTRACT_NAME" TEXT,
    "COMPANY_NAME" TEXT,
    "ONE_THOUSAND_WON" NUMERIC,
    "CONTRACT_DATE" TEXT,
    "CONTRACT_METHOD" TEXT,
    "DEPARTMENT" TEXT
);

-- Table: publicdata_welfare_961__TP_PRE_INFO_ANNOUNCEMENT
CREATE TABLE "aihub_welfare"."publicdata_welfare_961__TP_PRE_INFO_ANNOUNCEMENT" (
    "DIVISION" TEXT,
    "TITLE" TEXT,
    "CYCLE" TEXT
);

-- Table: publicdata_welfare_979__DEMAND_VOLUNTEER_CNT_GUNSAN_JEONBUK
CREATE TABLE "aihub_welfare"."publicdata_welfare_979__DEMAND_VOLUNTEER_CNT_GUNSAN_JEONBUK" (
    "ANNUAL" NUMERIC,
    "CLASSIFICATION" TEXT,
    "DEMAND" TEXT,
    "ADDRESS" TEXT,
    "CONTACT" TEXT
);

-- Table: seouldata_welfare_1170__JOB_COUNSEL
CREATE TABLE "aihub_welfare"."seouldata_welfare_1170__JOB_COUNSEL" (
    "BOARD_ID" TEXT,
    "CENTERNAME" TEXT,
    "TITLE" TEXT,
    "KOR_NAME" TEXT,
    "CREATE_DATE" TEXT,
    "READ_CNT" NUMERIC
);

-- Table: seouldata_welfare_1173__JOB_HUNT
CREATE TABLE "aihub_welfare"."seouldata_welfare_1173__JOB_HUNT" (
    "INFOID" TEXT,
    "MANAGE_ORGAN_NAME" TEXT,
    "PERSONINFO" TEXT,
    "JOBNAME" TEXT,
    "T_RESULT_NM" TEXT,
    "CONDITION_NAME" TEXT
);

-- Table: seouldata_welfare_1174__JOB_OFFER
CREATE TABLE "aihub_welfare"."seouldata_welfare_1174__JOB_OFFER" (
    "INFOID" TEXT,
    "MANAGE_ORGAN_NAME" TEXT,
    "COMPANYNAME" TEXT,
    "TITLE" TEXT,
    "WORKADDRESS_NM" TEXT,
    "WORKADDRESS" TEXT,
    "CLOSE_DATE" TEXT,
    "STATUS_NM" TEXT
);

-- Table: seouldata_welfare_121__FCLT_OPEN_INFO_O_L_I
CREATE TABLE "aihub_welfare"."seouldata_welfare_121__FCLT_OPEN_INFO_O_L_I" (
    "FCLT_NM" TEXT,
    "DISABLED_RESIDE_FCLT_CD" TEXT,
    "DISABLED_RESIDE_FCLT_KIND_NM" TEXT,
    "DISABLED_RESIDE_FCLT_KIND_DTL_NM" TEXT,
    "JRSD_SGG_NM" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_123__FCLT_OPEN_INFO
CREATE TABLE "aihub_welfare"."seouldata_welfare_123__FCLT_OPEN_INFO" (
    "WELFARE_FCLT_NM" TEXT,
    "WELFARE_FCLT_CD" TEXT,
    "WELFARE_FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "JRSD_SGG_NM" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_128__FCLT_OPEN_INFO_O_L_W_I
CREATE TABLE "aihub_welfare"."seouldata_welfare_128__FCLT_OPEN_INFO_O_L_W_I" (
    "FCLT_NM" TEXT,
    "ELDERLY_WELFARE_FCLT_CD" TEXT,
    "ELDERLY_WELFARE_FCLT_KIND_NM" TEXT,
    "ELDERLY_WELFARE_FCLT_KIND_DTL_NM" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_129__FCLT_OPEN_INFO_K_W_I
CREATE TABLE "aihub_welfare"."seouldata_welfare_129__FCLT_OPEN_INFO_K_W_I" (
    "FCLT_NM" TEXT,
    "CHILD_WELFARE_FCLT_CD" TEXT,
    "FCLT_KIND_NM" TEXT,
    "CHILD_WELFARE_FCLT_KIND_DTL_NM" TEXT,
    "JRSD_SGG_NM" TEXT,
    "CHILD_WELFARE_FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_131__FCLT_OPEN_INFO_O_W_S_I
CREATE TABLE "aihub_welfare"."seouldata_welfare_131__FCLT_OPEN_INFO_O_W_S_I" (
    "FCLT_NM" TEXT,
    "DISABLED_WELFARE_FCLT_CD" TEXT,
    "DISABLED_WELFARE_FCLT_KIND_NM" TEXT,
    "DISABLED_WELFARE_FCLT_KIND_DTL_NM" TEXT,
    "JRSD_SGG_NM" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1321__CHILD_CARE_INFO_G_J
CREATE TABLE "aihub_welfare"."seouldata_welfare_1321__CHILD_CARE_INFO_G_J" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "CRADDR" TEXT,
    "CRTELNO" TEXT,
    "NRTRROOMCNT" TEXT,
    "NRTRROOMSIZE" NUMERIC,
    "PLGRDCO" TEXT,
    "CCTVINSTLCNT" TEXT,
    "CRCAPAT" TEXT,
    "CRCHCNT" TEXT,
    "LA" NUMERIC,
    "LO" NUMERIC,
    "CRCARGBNAME" TEXT,
    "CRCNFMDT" TEXT,
    "CRABLDT" TEXT,
    "CRSPEC" TEXT,
    "CLASS_CNT_01" TEXT,
    "CLASS_CNT_05" TEXT,
    "CLASS_CNT_M2" TEXT,
    "CLASS_CNT_M5" TEXT,
    "CLASS_CNT_TOT" TEXT,
    "CHILD_CNT_03" TEXT,
    "CHILD_CNT_04" TEXT,
    "CHILD_CNT_M2" TEXT
);

-- Table: seouldata_welfare_1328__CHILD_CARE_INFO_S_C
CREATE TABLE "aihub_welfare"."seouldata_welfare_1328__CHILD_CARE_INFO_S_C" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "CRADDR" TEXT,
    "CRFAXNO" TEXT,
    "CRHOME" TEXT,
    "NRTRROOMCNT" TEXT,
    "NRTRROOMSIZE" TEXT,
    "PLGRDCO" TEXT,
    "CCTVINSTLCNT" TEXT,
    "CHCRTESCNT" TEXT,
    "CRCHCNT" TEXT,
    "LO" NUMERIC,
    "CRCARGBNAME" TEXT,
    "CRCNFMDT" TEXT,
    "CRPAUSEBEGINDT" TEXT,
    "CRPAUSEENDDT" TEXT,
    "CRABLDT" TEXT,
    "CRSPEC" TEXT,
    "CLASS_CNT_00" TEXT,
    "CLASS_CNT_01" TEXT,
    "CLASS_CNT_04" TEXT,
    "CLASS_CNT_M2" TEXT,
    "CLASS_CNT_M5" TEXT,
    "CLASS_CNT_SP" TEXT,
    "CLASS_CNT_TOT" TEXT,
    "CHILD_CNT_01" TEXT,
    "CHILD_CNT_02" TEXT,
    "CHILD_CNT_03" TEXT,
    "CHILD_CNT_M2" TEXT
);

-- Table: seouldata_welfare_1329__CHILD_CARE_INFO_G_S
CREATE TABLE "aihub_welfare"."seouldata_welfare_1329__CHILD_CARE_INFO_G_S" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "ZIPCODE" NUMERIC,
    "CRADDR" TEXT,
    "CRTELNO" TEXT,
    "CRFAXNO" TEXT,
    "NRTRROOMSIZE" TEXT,
    "PLGRDCO" TEXT,
    "CCTVINSTLCNT" TEXT,
    "CRCAPAT" TEXT,
    "CRCHCNT" TEXT,
    "LA" NUMERIC,
    "LO" NUMERIC,
    "CRCARGBNAME" TEXT,
    "CRCNFMDT" TEXT,
    "CRPAUSEBEGINDT" TEXT,
    "CRABLDT" TEXT,
    "DATASTDRDT" TEXT,
    "CLASS_CNT_00" TEXT,
    "CLASS_CNT_02" TEXT,
    "CLASS_CNT_03" TEXT,
    "CLASS_CNT_04" TEXT,
    "CLASS_CNT_05" TEXT,
    "CLASS_CNT_M2" TEXT,
    "CLASS_CNT_M5" TEXT,
    "CLASS_CNT_SP" TEXT,
    "CLASS_CNT_TOT" TEXT,
    "CHILD_CNT_02" TEXT,
    "CHILD_CNT_03" TEXT,
    "CHILD_CNT_04" TEXT,
    "CHILD_CNT_05" TEXT,
    "CHILD_CNT_M2" TEXT
);

-- Table: seouldata_welfare_1337__CHILD_CARE_INFO_M_P
CREATE TABLE "aihub_welfare"."seouldata_welfare_1337__CHILD_CARE_INFO_M_P" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "ZIPCODE" NUMERIC,
    "CRADDR" TEXT,
    "CRFAXNO" TEXT,
    "NRTRROOMCNT" TEXT,
    "NRTRROOMSIZE" TEXT,
    "CCTVINSTLCNT" TEXT,
    "CRCAPAT" TEXT,
    "CRCHCNT" TEXT,
    "LA" NUMERIC,
    "CRCNFMDT" TEXT,
    "CRPAUSEBEGINDT" TEXT,
    "CRPAUSEENDDT" TEXT,
    "CRABLDT" TEXT,
    "CRSPEC" TEXT,
    "CLASS_CNT_01" TEXT,
    "CLASS_CNT_02" TEXT,
    "CLASS_CNT_03" TEXT,
    "CLASS_CNT_04" TEXT,
    "CLASS_CNT_M2" TEXT,
    "CLASS_CNT_SP" TEXT,
    "CHILD_CNT_00" TEXT,
    "CHILD_CNT_02" TEXT,
    "CHILD_CNT_03" TEXT,
    "CHILD_CNT_04" TEXT,
    "CHILD_CNT_05" TEXT,
    "CHILD_CNT_M2" TEXT
);

-- Table: seouldata_welfare_1339__CHILD_CARE_INFO_G_C
CREATE TABLE "aihub_welfare"."seouldata_welfare_1339__CHILD_CARE_INFO_G_C" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "ZIPCODE" NUMERIC,
    "CRADDR" TEXT,
    "CRTELNO" TEXT,
    "NRTRROOMCNT" TEXT,
    "NRTRROOMSIZE" TEXT,
    "CCTVINSTLCNT" TEXT,
    "CRCAPAT" TEXT,
    "CRCHCNT" TEXT,
    "CRCNFMDT" TEXT,
    "CRPAUSEENDDT" TEXT,
    "DATASTDRDT" TEXT,
    "CRSPEC" TEXT,
    "CLASS_CNT_03" TEXT,
    "CLASS_CNT_04" TEXT,
    "CLASS_CNT_05" TEXT,
    "CLASS_CNT_M5" TEXT,
    "CLASS_CNT_SP" TEXT,
    "CHILD_CNT_00" TEXT,
    "CHILD_CNT_01" TEXT,
    "CHILD_CNT_02" TEXT,
    "CHILD_CNT_05" TEXT,
    "CHILD_CNT_M2" TEXT,
    "EM_CNT_TOT" TEXT
);

-- Table: seouldata_welfare_1347__CHILD_CARE_INFO_E_P
CREATE TABLE "aihub_welfare"."seouldata_welfare_1347__CHILD_CARE_INFO_E_P" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "ZIPCODE" NUMERIC,
    "CRADDR" TEXT,
    "CRFAXNO" TEXT,
    "NRTRROOMCNT" TEXT,
    "NRTRROOMSIZE" TEXT,
    "PLGRDCO" TEXT,
    "CRCAPAT" TEXT,
    "LA" NUMERIC,
    "LO" NUMERIC,
    "CRCARGBNAME" TEXT,
    "CRPAUSEBEGINDT" TEXT,
    "CRABLDT" TEXT,
    "DATASTDRDT" TEXT,
    "CRSPEC" TEXT,
    "CLASS_CNT_01" TEXT,
    "CLASS_CNT_03" TEXT,
    "CLASS_CNT_04" TEXT,
    "CLASS_CNT_05" TEXT,
    "CLASS_CNT_M5" TEXT,
    "CLASS_CNT_TOT" TEXT,
    "CHILD_CNT_00" TEXT,
    "CHILD_CNT_03" TEXT,
    "CHILD_CNT_04" TEXT,
    "EM_CNT_A7" TEXT
);

-- Table: seouldata_welfare_1348__CHILD_CARE_INFO_S_M
CREATE TABLE "aihub_welfare"."seouldata_welfare_1348__CHILD_CARE_INFO_S_M" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "ZIPCODE" NUMERIC,
    "CRADDR" TEXT,
    "CRTELNO" TEXT,
    "NRTRROOMCNT" TEXT,
    "NRTRROOMSIZE" TEXT,
    "PLGRDCO" TEXT,
    "CHCRTESCNT" TEXT,
    "CRCHCNT" TEXT,
    "LA" NUMERIC,
    "LO" NUMERIC,
    "CRCNFMDT" TEXT,
    "CRPAUSEBEGINDT" TEXT,
    "CRPAUSEENDDT" TEXT,
    "DATASTDRDT" TEXT,
    "CLASS_CNT_00" TEXT,
    "CLASS_CNT_02" TEXT,
    "CLASS_CNT_04" TEXT,
    "CLASS_CNT_M2" TEXT,
    "CLASS_CNT_M5" TEXT,
    "CLASS_CNT_SP" TEXT,
    "CLASS_CNT_TOT" TEXT,
    "CHILD_CNT_00" TEXT,
    "CHILD_CNT_02" TEXT,
    "CHILD_CNT_03" TEXT,
    "CHILD_CNT_04" TEXT,
    "CHILD_CNT_M2" TEXT
);

-- Table: seouldata_welfare_1354__CHILD_CARE_INFO_D_B
CREATE TABLE "aihub_welfare"."seouldata_welfare_1354__CHILD_CARE_INFO_D_B" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "ZIPCODE" NUMERIC,
    "CRTELNO" TEXT,
    "CRHOME" TEXT,
    "NRTRROOMCNT" TEXT,
    "NRTRROOMSIZE" TEXT,
    "PLGRDCO" TEXT,
    "CHCRTESCNT" TEXT,
    "CRCAPAT" TEXT,
    "CRCHCNT" TEXT,
    "LA" NUMERIC,
    "LO" NUMERIC,
    "CRCARGBNAME" TEXT,
    "CRPAUSEENDDT" TEXT,
    "DATASTDRDT" TEXT,
    "CLASS_CNT_00" TEXT,
    "CLASS_CNT_01" TEXT,
    "CLASS_CNT_02" TEXT,
    "CLASS_CNT_03" TEXT,
    "CLASS_CNT_04" TEXT,
    "CLASS_CNT_05" TEXT,
    "CLASS_CNT_M2" TEXT,
    "CLASS_CNT_SP" TEXT,
    "CLASS_CNT_TOT" TEXT,
    "CHILD_CNT_00" TEXT,
    "CHILD_CNT_02" TEXT,
    "CHILD_CNT_05" TEXT,
    "CHILD_CNT_M2" TEXT
);

-- Table: seouldata_welfare_135__FCLT_OPEN_INFO_O_M_I
CREATE TABLE "aihub_welfare"."seouldata_welfare_135__FCLT_OPEN_INFO_O_M_I" (
    "FCLT_NM" TEXT,
    "ELDERLY_MEDI_WELFARE_FCLT_CD" TEXT,
    "FCLT_KIND_NM" TEXT,
    "ELDERLY_MEDI_WELFARE_FCLT_KIND_DTL_NM" TEXT,
    "JRSD_SGG_NM" TEXT,
    "ELDERLY_MEDI_WELFARE_FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1361__CHILD_CARE_INFO_G_B
CREATE TABLE "aihub_welfare"."seouldata_welfare_1361__CHILD_CARE_INFO_G_B" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "ZIPCODE" NUMERIC,
    "CRADDR" TEXT,
    "CRTELNO" TEXT,
    "CRFAXNO" TEXT,
    "NRTRROOMCNT" TEXT,
    "NRTRROOMSIZE" TEXT,
    "PLGRDCO" TEXT,
    "CHCRTESCNT" TEXT,
    "CRCAPAT" TEXT,
    "CRCHCNT" TEXT,
    "CRCARGBNAME" TEXT,
    "CRCNFMDT" TEXT,
    "CRPAUSEENDDT" TEXT,
    "CRABLDT" TEXT,
    "DATASTDRDT" TEXT,
    "CRSPEC" TEXT,
    "CLASS_CNT_00" TEXT,
    "CLASS_CNT_01" TEXT,
    "CLASS_CNT_02" TEXT,
    "CLASS_CNT_04" TEXT,
    "CLASS_CNT_M5" TEXT,
    "CLASS_CNT_SP" TEXT,
    "CLASS_CNT_TOT" TEXT,
    "CHILD_CNT_00" TEXT,
    "CHILD_CNT_02" TEXT,
    "CHILD_CNT_03" TEXT,
    "CHILD_CNT_05" TEXT,
    "CHILD_CNT_M2" TEXT
);

-- Table: seouldata_welfare_1366__CHILD_CARE_INFO_D_J
CREATE TABLE "aihub_welfare"."seouldata_welfare_1366__CHILD_CARE_INFO_D_J" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "ZIPCODE" NUMERIC,
    "CRADDR" TEXT,
    "CRTELNO" TEXT,
    "CRFAXNO" TEXT,
    "CRHOME" TEXT,
    "NRTRROOMCNT" TEXT,
    "NRTRROOMSIZE" TEXT,
    "PLGRDCO" TEXT,
    "CCTVINSTLCNT" TEXT,
    "CHCRTESCNT" TEXT,
    "CRCAPAT" TEXT,
    "LA" NUMERIC,
    "LO" NUMERIC,
    "CRCARGBNAME" TEXT,
    "CRCNFMDT" TEXT,
    "CRPAUSEBEGINDT" TEXT,
    "CRPAUSEENDDT" TEXT,
    "DATASTDRDT" TEXT,
    "CRSPEC" TEXT,
    "CLASS_CNT_00" TEXT,
    "CLASS_CNT_01" TEXT,
    "CLASS_CNT_02" TEXT,
    "CLASS_CNT_03" TEXT,
    "CLASS_CNT_05" TEXT,
    "CLASS_CNT_M2" TEXT,
    "CLASS_CNT_M5" TEXT,
    "CLASS_CNT_TOT" TEXT,
    "CHILD_CNT_04" TEXT,
    "CHILD_CNT_05" TEXT,
    "CHILD_CNT_M2" TEXT,
    "EM_CNT_A7" TEXT
);

-- Table: seouldata_welfare_1387__CHILD_CARE_INFO_G_R
CREATE TABLE "aihub_welfare"."seouldata_welfare_1387__CHILD_CARE_INFO_G_R" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "ZIPCODE" NUMERIC,
    "CRADDR" TEXT,
    "CRTELNO" TEXT,
    "CRFAXNO" TEXT,
    "CRHOME" TEXT,
    "NRTRROOMCNT" TEXT,
    "NRTRROOMSIZE" TEXT,
    "PLGRDCO" TEXT,
    "CCTVINSTLCNT" TEXT,
    "CHCRTESCNT" TEXT,
    "CRCAPAT" TEXT,
    "CRCHCNT" TEXT,
    "LA" NUMERIC,
    "LO" NUMERIC,
    "CRCARGBNAME" TEXT,
    "CRCNFMDT" TEXT,
    "CRPAUSEBEGINDT" TEXT,
    "CRPAUSEENDDT" TEXT,
    "CRABLDT" TEXT,
    "DATASTDRDT" TEXT,
    "CRSPEC" TEXT
);

-- Table: seouldata_welfare_1394__CHILD_CARE_INFO_D_D
CREATE TABLE "aihub_welfare"."seouldata_welfare_1394__CHILD_CARE_INFO_D_D" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "ZIPCODE" NUMERIC,
    "CRADDR" TEXT,
    "CRTELNO" TEXT,
    "CRFAXNO" TEXT,
    "CRHOME" TEXT,
    "NRTRROOMSIZE" TEXT,
    "PLGRDCO" TEXT,
    "CRCAPAT" TEXT,
    "CRCHCNT" TEXT,
    "LA" NUMERIC,
    "LO" NUMERIC,
    "CRCARGBNAME" TEXT,
    "CRPAUSEBEGINDT" TEXT,
    "CRPAUSEENDDT" TEXT,
    "DATASTDRDT" TEXT,
    "CRSPEC" TEXT,
    "CLASS_CNT_02" TEXT,
    "CLASS_CNT_03" TEXT,
    "CLASS_CNT_04" TEXT,
    "CLASS_CNT_M2" TEXT,
    "CLASS_CNT_M5" TEXT,
    "CLASS_CNT_SP" TEXT,
    "CLASS_CNT_TOT" TEXT,
    "CHILD_CNT_00" TEXT,
    "CHILD_CNT_01" TEXT,
    "CHILD_CNT_04" TEXT
);

-- Table: seouldata_welfare_1399__CHILD_CARE_INFO_G_D
CREATE TABLE "aihub_welfare"."seouldata_welfare_1399__CHILD_CARE_INFO_G_D" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "ZIPCODE" NUMERIC,
    "CRADDR" TEXT,
    "CRTELNO" TEXT,
    "CRFAXNO" TEXT,
    "CRHOME" TEXT,
    "NRTRROOMCNT" TEXT,
    "NRTRROOMSIZE" TEXT,
    "PLGRDCO" TEXT,
    "CCTVINSTLCNT" TEXT,
    "CHCRTESCNT" TEXT,
    "CRCAPAT" TEXT,
    "CRCHCNT" TEXT,
    "LA" NUMERIC,
    "LO" NUMERIC,
    "CRCARGBNAME" TEXT,
    "CRCNFMDT" TEXT,
    "CRPAUSEBEGINDT" TEXT,
    "CRPAUSEENDDT" TEXT,
    "CRSPEC" TEXT,
    "CLASS_CNT_00" TEXT,
    "CLASS_CNT_01" TEXT,
    "CLASS_CNT_02" TEXT,
    "CLASS_CNT_04" TEXT,
    "CLASS_CNT_05" TEXT,
    "CLASS_CNT_M2" TEXT,
    "CLASS_CNT_M5" TEXT,
    "CLASS_CNT_TOT" TEXT,
    "CHILD_CNT_00" TEXT,
    "CHILD_CNT_02" TEXT,
    "CHILD_CNT_03" TEXT,
    "CHILD_CNT_M2" TEXT
);

-- Table: seouldata_welfare_140__FCLT_OPEN_INFO_O_W_I
CREATE TABLE "aihub_welfare"."seouldata_welfare_140__FCLT_OPEN_INFO_O_W_I" (
    "FCLT_NM" TEXT,
    "FCLT_CD" TEXT,
    "FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "ELDERLY_LEISURE_JRSD_SGG_SE" TEXT,
    "ELDERLY_LEISURE_JRSD_SGG_CD" NUMERIC,
    "JRSD_SGG_NM" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1420__CHILD_CARE_INFO_G_A
CREATE TABLE "aihub_welfare"."seouldata_welfare_1420__CHILD_CARE_INFO_G_A" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "ZIPCODE" NUMERIC,
    "CRADDR" TEXT,
    "CRTELNO" TEXT,
    "CRFAXNO" TEXT,
    "NRTRROOMCNT" TEXT,
    "NRTRROOMSIZE" TEXT,
    "CCTVINSTLCNT" TEXT,
    "CHCRTESCNT" TEXT,
    "CRCAPAT" TEXT,
    "CRCHCNT" TEXT,
    "LA" NUMERIC,
    "LO" NUMERIC,
    "CRCARGBNAME" TEXT,
    "CRCNFMDT" TEXT,
    "CRPAUSEENDDT" TEXT,
    "CRABLDT" TEXT,
    "DATASTDRDT" TEXT,
    "CLASS_CNT_00" TEXT,
    "CLASS_CNT_01" TEXT,
    "CLASS_CNT_03" TEXT,
    "CLASS_CNT_04" TEXT,
    "CHILD_CNT_00" TEXT,
    "CHILD_CNT_02" TEXT,
    "CHILD_CNT_03" TEXT,
    "CHILD_CNT_04" TEXT,
    "CHILD_CNT_05" TEXT,
    "EM_CNT_A2" TEXT
);

-- Table: seouldata_welfare_1429__CHILD_CARE_INFO_J_G
CREATE TABLE "aihub_welfare"."seouldata_welfare_1429__CHILD_CARE_INFO_J_G" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "ZIPCODE" NUMERIC,
    "CRADDR" TEXT,
    "CRTELNO" TEXT,
    "CRHOME" TEXT,
    "NRTRROOMCNT" TEXT,
    "NRTRROOMSIZE" NUMERIC,
    "CCTVINSTLCNT" TEXT,
    "CHCRTESCNT" TEXT,
    "CRCAPAT" TEXT,
    "CRCHCNT" TEXT,
    "LA" NUMERIC,
    "LO" NUMERIC,
    "CRCARGBNAME" TEXT,
    "CRCNFMDT" TEXT,
    "CRPAUSEBEGINDT" TEXT,
    "CRPAUSEENDDT" TEXT,
    "DATASTDRDT" TEXT,
    "CRSPEC" TEXT,
    "CLASS_CNT_01" TEXT,
    "CLASS_CNT_03" TEXT,
    "CLASS_CNT_05" TEXT,
    "CLASS_CNT_M2" TEXT,
    "CLASS_CNT_M5" TEXT,
    "CLASS_CNT_SP" TEXT,
    "CLASS_CNT_TOT" TEXT,
    "CHILD_CNT_00" TEXT,
    "CHILD_CNT_02" TEXT,
    "CHILD_CNT_03" TEXT,
    "CHILD_CNT_04" TEXT,
    "CHILD_CNT_05" TEXT
);

-- Table: seouldata_welfare_1436__CHILD_CARE_INFO_G_N
CREATE TABLE "aihub_welfare"."seouldata_welfare_1436__CHILD_CARE_INFO_G_N" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "ZIPCODE" NUMERIC,
    "CRADDR" TEXT,
    "CRTELNO" TEXT,
    "CRFAXNO" TEXT,
    "NRTRROOMCNT" TEXT,
    "NRTRROOMSIZE" TEXT,
    "PLGRDCO" TEXT,
    "CHCRTESCNT" TEXT,
    "CRCAPAT" TEXT,
    "CRCHCNT" TEXT,
    "LA" NUMERIC,
    "LO" NUMERIC,
    "CRCARGBNAME" TEXT,
    "CRCNFMDT" TEXT,
    "CRPAUSEBEGINDT" TEXT,
    "CRABLDT" TEXT,
    "DATASTDRDT" TEXT,
    "CRSPEC" TEXT,
    "CLASS_CNT_00" TEXT,
    "CLASS_CNT_01" TEXT,
    "CLASS_CNT_02" TEXT,
    "CLASS_CNT_03" TEXT,
    "CLASS_CNT_04" TEXT,
    "CLASS_CNT_05" TEXT,
    "CLASS_CNT_M2" TEXT,
    "CLASS_CNT_M5" TEXT,
    "CHILD_CNT_00" TEXT,
    "CHILD_CNT_01" TEXT,
    "CHILD_CNT_05" TEXT,
    "CHILD_CNT_M2" TEXT
);

-- Table: seouldata_welfare_1438__CHILD_CARE_INFO_S_D
CREATE TABLE "aihub_welfare"."seouldata_welfare_1438__CHILD_CARE_INFO_S_D" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "ZIPCODE" NUMERIC,
    "CRADDR" TEXT,
    "CRTELNO" TEXT,
    "CRFAXNO" TEXT,
    "CRHOME" TEXT,
    "NRTRROOMCNT" TEXT,
    "NRTRROOMSIZE" TEXT,
    "PLGRDCO" TEXT,
    "CCTVINSTLCNT" TEXT,
    "CHCRTESCNT" TEXT,
    "CRCAPAT" TEXT,
    "CRCHCNT" TEXT,
    "CRCARGBNAME" TEXT,
    "CRCNFMDT" TEXT,
    "CRPAUSEENDDT" TEXT,
    "CRABLDT" TEXT,
    "DATASTDRDT" TEXT,
    "CRSPEC" TEXT,
    "CLASS_CNT_01" TEXT,
    "CLASS_CNT_05" TEXT,
    "CLASS_CNT_M5" TEXT,
    "CLASS_CNT_SP" TEXT,
    "CLASS_CNT_TOT" TEXT,
    "CHILD_CNT_01" TEXT,
    "CHILD_CNT_02" TEXT,
    "CHILD_CNT_03" TEXT,
    "CHILD_CNT_04" TEXT,
    "CHILD_CNT_M2" TEXT
);

-- Table: seouldata_welfare_1440__CHILD_CARE_INFO_Y_D
CREATE TABLE "aihub_welfare"."seouldata_welfare_1440__CHILD_CARE_INFO_Y_D" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "ZIPCODE" NUMERIC,
    "CRADDR" TEXT,
    "CRTELNO" TEXT,
    "CRFAXNO" TEXT,
    "NRTRROOMCNT" TEXT,
    "NRTRROOMSIZE" TEXT,
    "PLGRDCO" TEXT,
    "CCTVINSTLCNT" TEXT,
    "CHCRTESCNT" TEXT,
    "CRCAPAT" TEXT,
    "LO" NUMERIC,
    "CRCARGBNAME" TEXT,
    "CRPAUSEBEGINDT" TEXT,
    "CRPAUSEENDDT" TEXT,
    "CRABLDT" TEXT,
    "DATASTDRDT" TEXT,
    "CRSPEC" TEXT,
    "CLASS_CNT_00" TEXT,
    "CLASS_CNT_01" TEXT,
    "CLASS_CNT_02" TEXT,
    "CLASS_CNT_04" TEXT,
    "CLASS_CNT_05" TEXT,
    "CLASS_CNT_M5" TEXT,
    "CLASS_CNT_SP" TEXT,
    "CLASS_CNT_TOT" TEXT,
    "CHILD_CNT_03" TEXT,
    "CHILD_CNT_04" TEXT,
    "CHILD_CNT_05" TEXT,
    "CHILD_CNT_M2" TEXT
);

-- Table: seouldata_welfare_1449__CHILD_CARE_INFO_N_W
CREATE TABLE "aihub_welfare"."seouldata_welfare_1449__CHILD_CARE_INFO_N_W" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "ZIPCODE" NUMERIC,
    "CRADDR" TEXT,
    "CRTELNO" TEXT,
    "CRFAXNO" TEXT,
    "CRHOME" TEXT,
    "NRTRROOMCNT" TEXT,
    "NRTRROOMSIZE" TEXT,
    "CRCAPAT" TEXT,
    "CRCHCNT" TEXT,
    "LA" NUMERIC,
    "LO" NUMERIC,
    "CRCARGBNAME" TEXT,
    "CRCNFMDT" TEXT,
    "CRPAUSEBEGINDT" TEXT,
    "CRABLDT" TEXT,
    "DATASTDRDT" TEXT,
    "CRSPEC" TEXT,
    "CLASS_CNT_00" TEXT,
    "CLASS_CNT_M5" TEXT,
    "CLASS_CNT_TOT" TEXT,
    "CHILD_CNT_02" TEXT,
    "CHILD_CNT_03" TEXT,
    "CHILD_CNT_05" TEXT,
    "CHILD_CNT_M2" TEXT
);

-- Table: seouldata_welfare_1459__CHILD_CARE_INFO_S_B
CREATE TABLE "aihub_welfare"."seouldata_welfare_1459__CHILD_CARE_INFO_S_B" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "CRADDR" TEXT,
    "CRTELNO" TEXT,
    "CRFAXNO" TEXT,
    "CRHOME" TEXT,
    "NRTRROOMCNT" TEXT,
    "PLGRDCO" TEXT,
    "CCTVINSTLCNT" TEXT,
    "CHCRTESCNT" TEXT,
    "CRCHCNT" TEXT,
    "LO" NUMERIC,
    "CRCARGBNAME" TEXT,
    "CRPAUSEENDDT" TEXT,
    "CRABLDT" TEXT,
    "CLASS_CNT_00" TEXT,
    "CLASS_CNT_01" TEXT,
    "CLASS_CNT_02" TEXT,
    "CLASS_CNT_03" TEXT,
    "CLASS_CNT_05" TEXT,
    "CLASS_CNT_M5" TEXT,
    "CLASS_CNT_SP" TEXT,
    "CHILD_CNT_00" TEXT,
    "CHILD_CNT_01" TEXT,
    "CHILD_CNT_02" TEXT,
    "CHILD_CNT_03" TEXT,
    "CHILD_CNT_04" TEXT
);

-- Table: seouldata_welfare_145__FCLT_OPEN_INFO_R_O_W_I
CREATE TABLE "aihub_welfare"."seouldata_welfare_145__FCLT_OPEN_INFO_R_O_W_I" (
    "FCLT_NM" TEXT,
    "FCLT_CD" TEXT,
    "HOME_ELDERY_FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "HOME_ELDERY_RPRSNTV" TEXT,
    "JRSD_SGG_NM" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1470__CHILD_CARE_INFO_Y_C
CREATE TABLE "aihub_welfare"."seouldata_welfare_1470__CHILD_CARE_INFO_Y_C" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "ZIPCODE" NUMERIC,
    "CRADDR" TEXT,
    "CRTELNO" TEXT,
    "CRFAXNO" TEXT,
    "CRHOME" TEXT,
    "NRTRROOMSIZE" TEXT,
    "PLGRDCO" TEXT,
    "CCTVINSTLCNT" TEXT,
    "CHCRTESCNT" TEXT,
    "CRCAPAT" TEXT,
    "CRCHCNT" TEXT,
    "LA" NUMERIC,
    "LO" NUMERIC,
    "CRCARGBNAME" TEXT,
    "CRCNFMDT" TEXT,
    "CRPAUSEBEGINDT" TEXT,
    "DATASTDRDT" TEXT,
    "CRSPEC" TEXT,
    "CLASS_CNT_00" TEXT,
    "CLASS_CNT_01" TEXT,
    "CLASS_CNT_02" TEXT,
    "CLASS_CNT_03" TEXT,
    "CLASS_CNT_04" TEXT,
    "CLASS_CNT_05" TEXT,
    "CLASS_CNT_SP" TEXT,
    "CHILD_CNT_00" TEXT,
    "CHILD_CNT_02" TEXT,
    "CHILD_CNT_03" TEXT,
    "CHILD_CNT_05" TEXT,
    "CHILD_CNT_M2" TEXT
);

-- Table: seouldata_welfare_1482__CHILD_CARE_INFO_Y_S
CREATE TABLE "aihub_welfare"."seouldata_welfare_1482__CHILD_CARE_INFO_Y_S" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "ZIPCODE" NUMERIC,
    "CRADDR" TEXT,
    "CRTELNO" TEXT,
    "CRHOME" TEXT,
    "NRTRROOMSIZE" TEXT,
    "PLGRDCO" TEXT,
    "CCTVINSTLCNT" TEXT,
    "CHCRTESCNT" TEXT,
    "CRCAPAT" TEXT,
    "CRCHCNT" TEXT,
    "LA" NUMERIC,
    "LO" NUMERIC,
    "CRCARGBNAME" TEXT,
    "CRCNFMDT" TEXT,
    "CRPAUSEBEGINDT" TEXT,
    "CRABLDT" TEXT,
    "DATASTDRDT" TEXT,
    "CRSPEC" TEXT,
    "CLASS_CNT_00" TEXT,
    "CLASS_CNT_01" TEXT,
    "CLASS_CNT_02" TEXT,
    "CLASS_CNT_03" TEXT,
    "CLASS_CNT_05" TEXT,
    "CLASS_CNT_M2" TEXT,
    "CLASS_CNT_M5" TEXT,
    "CLASS_CNT_SP" TEXT,
    "CLASS_CNT_TOT" TEXT,
    "CHILD_CNT_01" TEXT,
    "CHILD_CNT_02" TEXT,
    "CHILD_CNT_03" TEXT,
    "CHILD_CNT_04" TEXT,
    "CHILD_CNT_05" TEXT
);

-- Table: seouldata_welfare_149__FCLT_OPEN_INFO_O_R_S_S_I
CREATE TABLE "aihub_welfare"."seouldata_welfare_149__FCLT_OPEN_INFO_O_R_S_S_I" (
    "FCLT_NM" TEXT,
    "DISABLED_LOCAL_FCLT_CD" TEXT,
    "FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "DISABLED_LOCAL_RPRSNTV" TEXT,
    "DISABLED_LOCAL_JRSD_SGG_CD" NUMERIC,
    "JRSD_SGG_NM" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_14__GLOBAL_JOB_COUNSEL_RST
CREATE TABLE "aihub_welfare"."seouldata_welfare_14__GLOBAL_JOB_COUNSEL_RST" (
    "YYYYMM" TEXT,
    "CATEGORY_NM" TEXT,
    "TYPE1" NUMERIC,
    "TYPE2" NUMERIC,
    "TYPE3" NUMERIC,
    "TYPE4" NUMERIC,
    "TYPE5" NUMERIC,
    "TYPE6" NUMERIC,
    "TYPE_SUM" NUMERIC
);

-- Table: seouldata_welfare_1517__FCLT_OPEN_INFO_J_N
CREATE TABLE "aihub_welfare"."seouldata_welfare_1517__FCLT_OPEN_INFO_J_N" (
    "FCLT_NM" TEXT,
    "JNO_WELFARE_FCLT_CD" TEXT,
    "FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "JRSD_SGG_SE" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1518__FCLT_OPEN_INFO_Y_D
CREATE TABLE "aihub_welfare"."seouldata_welfare_1518__FCLT_OPEN_INFO_Y_D" (
    "YDP_WELFARE_FCLT_NM" TEXT,
    "YDP_WELFARE_FCLT_CD" TEXT,
    "YDP_WELFARE_FCLT_KIND_NM" TEXT,
    "YDP_WELFARE_FCLT_KIND_DTL_NM" TEXT,
    "YDP_WELFARE_JRSD_SGG_SE" TEXT,
    "YDP_WELFARE_JRSD_SGG_NM" TEXT,
    "YDP_WELFARE_FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1520__FCLT_OPEN_INFO_S_M
CREATE TABLE "aihub_welfare"."seouldata_welfare_1520__FCLT_OPEN_INFO_S_M" (
    "FCLT_NM" TEXT,
    "SDM_WELFARE_FCLT_CD" TEXT,
    "FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "SDM_WELFARE_JRSD_SGG_NM" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1521__FCLT_OPEN_INFO_D_B
CREATE TABLE "aihub_welfare"."seouldata_welfare_1521__FCLT_OPEN_INFO_D_B" (
    "FCLT_NM" TEXT,
    "DB_WELFARE_FCLT_CD" TEXT,
    "FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "DB_WELFARE_JRSD_SGG_SE" TEXT,
    "DB_WELFARE_RPRSNTV" TEXT,
    "DB_WELFARE_JRSD_SGG_CD" NUMERIC,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1522__FCLT_OPEN_INFO_E_P
CREATE TABLE "aihub_welfare"."seouldata_welfare_1522__FCLT_OPEN_INFO_E_P" (
    "FCLT_NM" TEXT,
    "EP_WELFARE_FCLT_CD" TEXT,
    "EP_WELFARE_FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "EP_WELFARE_JRSD_SGG_SE" TEXT,
    "RPRSNTV" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1523__FCLT_OPEN_INFO_N_W
CREATE TABLE "aihub_welfare"."seouldata_welfare_1523__FCLT_OPEN_INFO_N_W" (
    "FCLT_NM" TEXT,
    "NW_WELFARE_FCLT_CD" TEXT,
    "NW_WELFARE_FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "NW_WELFARE_JRSD_SGG_SE" TEXT
);

-- Table: seouldata_welfare_1524__FCLT_OPEN_INFO_D_J
CREATE TABLE "aihub_welfare"."seouldata_welfare_1524__FCLT_OPEN_INFO_D_J" (
    "FCLT_NM" TEXT,
    "DJ_WELFARE_FCLT_CD" TEXT,
    "DJ_WELFARE_FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "DJ_WELFARE_RPRSNTV" TEXT,
    "JRSD_SGG_NM" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1525__FCLT_OPEN_INFO_D_D
CREATE TABLE "aihub_welfare"."seouldata_welfare_1525__FCLT_OPEN_INFO_D_D" (
    "FCLT_NM" TEXT,
    "FCLT_CD" TEXT,
    "FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "RPRSNTV" TEXT,
    "JRSD_SGG_CD" NUMERIC,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1526__FCLT_OPEN_INFO_S_D
CREATE TABLE "aihub_welfare"."seouldata_welfare_1526__FCLT_OPEN_INFO_S_D" (
    "FCLT_NM" TEXT,
    "FCLT_CD" TEXT,
    "FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "JRSD_SGG_NM" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1527__FCLT_OPEN_INFO_S_P
CREATE TABLE "aihub_welfare"."seouldata_welfare_1527__FCLT_OPEN_INFO_S_P" (
    "FCLT_NM" TEXT,
    "SP_WELFARE_FCLT_CD" TEXT,
    "FCLT_KIND_NM" TEXT,
    "SP_WELFARE_FCLT_KIND_DTL_NM" TEXT,
    "SP_WELFARE_RPRSNTV" TEXT,
    "SP_WELFARE_FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1528__FCLT_OPEN_INFO_G_J
CREATE TABLE "aihub_welfare"."seouldata_welfare_1528__FCLT_OPEN_INFO_G_J" (
    "FCLT_NM" TEXT,
    "GJ_WELFARE_FCLT_CD" TEXT,
    "FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "RPRSNTV" TEXT,
    "JRSD_SGG_NM" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1529__FCLT_OPEN_INFO_G_N
CREATE TABLE "aihub_welfare"."seouldata_welfare_1529__FCLT_OPEN_INFO_G_N" (
    "FCLT_NM" TEXT,
    "GN_WELFARE_FCLT_CD" TEXT,
    "FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "GN_WELFARE_RPRSNTV" TEXT,
    "GN_WELFARE_FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_152__FCLT_OPEN_INFO_S_S_I
CREATE TABLE "aihub_welfare"."seouldata_welfare_152__FCLT_OPEN_INFO_S_S_I" (
    "FCLT_NM" TEXT,
    "DISABLED_PSY_FCLT_CD" TEXT,
    "DISABLED_PSY_FCLT_KIND_NM" TEXT,
    "DISABLED_PSY_FCLT_KIND_DTL_NM" TEXT,
    "DISABLED_PSY_JRSD_SGG_SE" TEXT,
    "RPRSNTV" TEXT,
    "JRSD_SGG_NM" TEXT
);

-- Table: seouldata_welfare_1530__FCLT_OPEN_INFO_G_R
CREATE TABLE "aihub_welfare"."seouldata_welfare_1530__FCLT_OPEN_INFO_G_R" (
    "FCLT_NM" TEXT,
    "FCLT_CD" TEXT,
    "FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "JRSD_SGG_SE" TEXT
);

-- Table: seouldata_welfare_1531__FCLT_OPEN_INFO_S_B
CREATE TABLE "aihub_welfare"."seouldata_welfare_1531__FCLT_OPEN_INFO_S_B" (
    "FCLT_NM" TEXT,
    "SB_WELFARE_FCLT_CD" TEXT,
    "SB_WELFARE_FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "SB_WELFARE_RPRSNTV" TEXT,
    "JRSD_SGG_NM" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1532__FCLT_OPEN_INFO_S_C
CREATE TABLE "aihub_welfare"."seouldata_welfare_1532__FCLT_OPEN_INFO_S_C" (
    "FCLT_NM" TEXT,
    "SC_WELFARE_FCLT_CD" TEXT,
    "FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1533__FCLT_OPEN_INFO_G_S
CREATE TABLE "aihub_welfare"."seouldata_welfare_1533__FCLT_OPEN_INFO_G_S" (
    "FCLT_NM" TEXT,
    "GS_WELFARE_FCLT_CD" TEXT,
    "GS_WELFARE_FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1534__FCLT_OPEN_INFO_J_R
CREATE TABLE "aihub_welfare"."seouldata_welfare_1534__FCLT_OPEN_INFO_J_R" (
    "FCLT_NM" TEXT,
    "FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "JRSD_SGG_CD" NUMERIC,
    "JRSD_SGG_NM" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1535__FCLT_OPEN_INFO_Y_C
CREATE TABLE "aihub_welfare"."seouldata_welfare_1535__FCLT_OPEN_INFO_Y_C" (
    "FCLT_NM" TEXT,
    "YC_WELFARE_FCLT_CD" TEXT,
    "FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1536__FCLT_OPEN_INFO_G_B
CREATE TABLE "aihub_welfare"."seouldata_welfare_1536__FCLT_OPEN_INFO_G_B" (
    "FCLT_NM" TEXT,
    "GB_WELFARE_FCLT_CD" TEXT,
    "FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "GB_WELFARE_JRSD_SGG_SE" TEXT,
    "GB_WELFARE_RPRSNTV" TEXT,
    "JRSD_SGG_NM" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1537__FCLT_OPEN_INFO_G_C
CREATE TABLE "aihub_welfare"."seouldata_welfare_1537__FCLT_OPEN_INFO_G_C" (
    "GC_WELFARE_FCLT_NM" TEXT,
    "GC_WELFARE_FCLT_CD" TEXT,
    "GC_WELFARE_FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "GC_WELFARE_JRSD_SGG_CD" NUMERIC,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1538__FCLT_OPEN_INFO_G_A
CREATE TABLE "aihub_welfare"."seouldata_welfare_1538__FCLT_OPEN_INFO_G_A" (
    "FCLT_NM" TEXT,
    "FCLT_CD" TEXT,
    "FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "JRSD_SGG_NM" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1539__FCLT_OPEN_INFO_G_D
CREATE TABLE "aihub_welfare"."seouldata_welfare_1539__FCLT_OPEN_INFO_G_D" (
    "FCLT_NM" TEXT,
    "FCLT_CD" TEXT,
    "FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "JRSD_SGG_NM" TEXT,
    "FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1540__FCLT_OPEN_INFO_Y_S
CREATE TABLE "aihub_welfare"."seouldata_welfare_1540__FCLT_OPEN_INFO_Y_S" (
    "FCLT_NM" TEXT,
    "YS_WELFARE_FCLT_CD" TEXT,
    "YS_WELFARE_FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "YS_WELFARE_RPRSNTV" TEXT,
    "YS_WELFARE_FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1541__FCLT_OPEN_INFO_M_P
CREATE TABLE "aihub_welfare"."seouldata_welfare_1541__FCLT_OPEN_INFO_M_P" (
    "FCLT_NM" TEXT,
    "MP_WELFARE_FCLT_CD" TEXT,
    "MP_WELFARE_FCLT_KIND_NM" TEXT,
    "FCLT_KIND_DTL_NM" TEXT,
    "MP_WELFARE_RPRSNTV" TEXT,
    "MP_WELFARE_FCLT_ADDR" TEXT
);

-- Table: seouldata_welfare_1547__GD_TN_BBS5
CREATE TABLE "aihub_welfare"."seouldata_welfare_1547__GD_TN_BBS5" (
    "NAME" TEXT,
    "PHONE" TEXT,
    "DONG" TEXT
);

-- Table: seouldata_welfare_17__GLOBAL_JOB_COUNSEL_QTRST
CREATE TABLE "aihub_welfare"."seouldata_welfare_17__GLOBAL_JOB_COUNSEL_QTRST" (
    "YYYY" TEXT,
    "CATEGORY_NM" TEXT,
    "Q1" NUMERIC,
    "QR1" NUMERIC,
    "Q2" NUMERIC,
    "QR2" NUMERIC,
    "Q3" NUMERIC,
    "QR3" NUMERIC,
    "Q4" NUMERIC,
    "QR4" NUMERIC,
    "Q_SUM" NUMERIC,
    "QR_SUM" NUMERIC,
    "PQ_SUM" NUMERIC,
    "PQR_SUM" NUMERIC
);

-- Table: seouldata_welfare_189__STAT_CHILD_GENDER_INFO
CREATE TABLE "aihub_welfare"."seouldata_welfare_189__STAT_CHILD_GENDER_INFO" (
    "STYEAR" TEXT,
    "AGE" NUMERIC,
    "AGENM" TEXT,
    "MPNTOT" NUMERIC,
    "MPN0101" NUMERIC,
    "MPN0302" NUMERIC,
    "MPN0401" NUMERIC,
    "MPN0501" NUMERIC,
    "FPNTOT" NUMERIC,
    "FPN0101" NUMERIC,
    "FPN0302" NUMERIC,
    "FPN0401" NUMERIC,
    "FPN0501" NUMERIC
);

-- Table: seouldata_welfare_18__GLOBAL_JOB_COUNSEL_LNG_TYPE_RST
CREATE TABLE "aihub_welfare"."seouldata_welfare_18__GLOBAL_JOB_COUNSEL_LNG_TYPE_RST" (
    "YYYYMM" TEXT,
    "CATEGORY_NM" TEXT,
    "TYPE0" NUMERIC,
    "TYPE1" NUMERIC,
    "TYPE2" NUMERIC,
    "TYPE4" NUMERIC,
    "TYPE5" NUMERIC,
    "TYPE6" NUMERIC,
    "TYPE7" NUMERIC,
    "TYPE8" NUMERIC,
    "TYPE9" NUMERIC,
    "TYPE10" NUMERIC,
    "TYPE11" NUMERIC,
    "TYPE12" NUMERIC,
    "TYPE13" NUMERIC,
    "TYPE14" NUMERIC,
    "TYPE15" NUMERIC,
    "TYPE_SUM" NUMERIC
);

-- Table: seouldata_welfare_190__STAT_ONE_PER_CHILD_INFO
CREATE TABLE "aihub_welfare"."seouldata_welfare_190__STAT_ONE_PER_CHILD_INFO" (
    "STYEAR" TEXT,
    "ARCODE" NUMERIC,
    "ARCODENM" TEXT,
    "CHILDMPN" NUMERIC,
    "CHILDFPN" NUMERIC,
    "TEACHERMPN" NUMERIC,
    "TEACHERFPN" NUMERIC,
    "TEACHERRATE" NUMERIC
);

-- Table: seouldata_welfare_191__STAT_SISUL_SATISFIED_INFO
CREATE TABLE "aihub_welfare"."seouldata_welfare_191__STAT_SISUL_SATISFIED_INFO" (
    "STYEAR" TEXT,
    "ARCODE" NUMERIC,
    "ARCODENM" TEXT,
    "GUBUN" NUMERIC,
    "GUBUNNM" TEXT,
    "CNTOT" TEXT,
    "CN0101" TEXT,
    "CN0201" TEXT,
    "CN0301" TEXT,
    "CN0302" TEXT,
    "CN0401" TEXT,
    "CN0501" TEXT,
    "CN0603" TEXT
);

-- Table: seouldata_welfare_192__STAT_SISUL_ENTRY_NUMBER_INFO
CREATE TABLE "aihub_welfare"."seouldata_welfare_192__STAT_SISUL_ENTRY_NUMBER_INFO" (
    "STYEAR" TEXT,
    "ARCODE" NUMERIC,
    "ARCODENM" TEXT,
    "PNTOT" NUMERIC,
    "PN0101" NUMERIC,
    "PN0201" NUMERIC,
    "PN0301" NUMERIC,
    "PN0302" NUMERIC,
    "PN0401" NUMERIC,
    "PN0501" NUMERIC,
    "PN0603" NUMERIC
);

-- Table: seouldata_welfare_194__STAT_TEACHER_INFO
CREATE TABLE "aihub_welfare"."seouldata_welfare_194__STAT_TEACHER_INFO" (
    "STYEAR" TEXT,
    "CRTYPE" NUMERIC,
    "CRTYPENM" TEXT,
    "TOTTOT" TEXT,
    "TOT10" TEXT,
    "TOT20" TEXT,
    "TOT30" TEXT,
    "TOT40" TEXT,
    "TOT50" TEXT,
    "TOT60" TEXT,
    "TOT70" TEXT,
    "TOT80" TEXT,
    "TOT90" TEXT
);

-- Table: seouldata_welfare_195__STAT_SISUL_FIXED_NUMBER_INFO
CREATE TABLE "aihub_welfare"."seouldata_welfare_195__STAT_SISUL_FIXED_NUMBER_INFO" (
    "STYEAR" TEXT,
    "ARCODE" NUMERIC,
    "ARCODENM" TEXT,
    "CNTOT" NUMERIC,
    "CN0101" NUMERIC,
    "CN0201" NUMERIC,
    "CN0301" NUMERIC,
    "CN0302" NUMERIC,
    "CN0401" NUMERIC,
    "CN0501" NUMERIC,
    "CN0603" NUMERIC
);

-- Table: seouldata_welfare_196__STAT_TEACHER_AREA_TYPE_INFO
CREATE TABLE "aihub_welfare"."seouldata_welfare_196__STAT_TEACHER_AREA_TYPE_INFO" (
    "STYEAR" TEXT,
    "ARCODE" NUMERIC,
    "ARCODENM" TEXT,
    "TOT" NUMERIC,
    "FPNTOT" NUMERIC,
    "MPNTOT" NUMERIC,
    "FPN10" NUMERIC,
    "MPN10" NUMERIC,
    "FPN20" NUMERIC,
    "MPN20" NUMERIC,
    "FPN30" NUMERIC,
    "MPN30" NUMERIC,
    "FPN40" NUMERIC,
    "MPN40" NUMERIC,
    "FPN50" NUMERIC,
    "MPN50" NUMERIC,
    "FPN60" NUMERIC,
    "MPN60" NUMERIC,
    "FPN70" NUMERIC,
    "MPN70" NUMERIC,
    "FPN80" NUMERIC,
    "MPN80" NUMERIC
);

-- Table: seouldata_welfare_198__STAT_CHILD_NUMBER_INFO
CREATE TABLE "aihub_welfare"."seouldata_welfare_198__STAT_CHILD_NUMBER_INFO" (
    "STYEAR" TEXT,
    "ARCODE" NUMERIC,
    "ARCODENM" TEXT,
    "CNTTOT" NUMERIC,
    "CNT0101" NUMERIC,
    "CNT0201" NUMERIC,
    "CNT0301" NUMERIC,
    "CNT0302" NUMERIC,
    "CNT0401" NUMERIC,
    "CNT0501" NUMERIC,
    "CNT0603" NUMERIC
);

-- Table: seouldata_welfare_199__STAT_TEACHER_GENDER_INFO
CREATE TABLE "aihub_welfare"."seouldata_welfare_199__STAT_TEACHER_GENDER_INFO" (
    "STYEAR" TEXT,
    "CRTYPE" NUMERIC,
    "CRTYPENM" TEXT,
    "MPNTOT" NUMERIC,
    "FPNTOT" NUMERIC,
    "MPN10" NUMERIC,
    "FPN10" NUMERIC,
    "MPN20" NUMERIC,
    "FPN20" NUMERIC,
    "MPN30" NUMERIC,
    "FPN30" NUMERIC,
    "MPN40" NUMERIC,
    "FPN40" NUMERIC,
    "MPN50" NUMERIC,
    "FPN50" NUMERIC,
    "MPN60" NUMERIC,
    "FPN60" NUMERIC,
    "MPN70" NUMERIC,
    "FPN70" NUMERIC,
    "MPN80" NUMERIC,
    "FPN80" NUMERIC,
    "MPN90" NUMERIC,
    "FPN90" TEXT
);

-- Table: seouldata_welfare_24__GLOBAL_GALLERY
CREATE TABLE "aihub_welfare"."seouldata_welfare_24__GLOBAL_GALLERY" (
    "ARTICLE_SEQ" NUMERIC,
    "BOARD_SEQ" NUMERIC,
    "TITLE" TEXT,
    "CONTS" TEXT,
    "VIEW_CNT" NUMERIC,
    "REG_DT" TEXT,
    "REG_NM" TEXT,
    "THUMB" TEXT
);

-- Table: seouldata_welfare_25__GLOBAL_CENTER_NEWS
CREATE TABLE "aihub_welfare"."seouldata_welfare_25__GLOBAL_CENTER_NEWS" (
    "ARTICLE_SEQ" NUMERIC,
    "BOARD_SEQ" NUMERIC,
    "TITLE" TEXT,
    "CONTS" TEXT,
    "VIEW_CNT" NUMERIC,
    "REG_DT" TEXT,
    "REG_NM" TEXT,
    "EVT_PLACE" TEXT,
    "EVT_START_DT" TEXT,
    "EVT_END_DT" TEXT,
    "THUMB" TEXT
);

-- Table: seouldata_welfare_2__GLOBAL_JOB_COUNSEL_TYPEDIV
CREATE TABLE "aihub_welfare"."seouldata_welfare_2__GLOBAL_JOB_COUNSEL_TYPEDIV" (
    "YYYYMM" TEXT,
    "CATEGORY_NM1" TEXT,
    "CATEGORY_NM2" TEXT,
    "TYPE1" NUMERIC,
    "TYPE2" NUMERIC,
    "TYPE3" NUMERIC,
    "TYPE4" NUMERIC,
    "TYPE5" NUMERIC,
    "TYPE6" NUMERIC,
    "TYPE_SUM" NUMERIC
);

-- Table: seouldata_welfare_345__IOT_VDATA020
CREATE TABLE "aihub_welfare"."seouldata_welfare_345__IOT_VDATA020" (
    "ORGAN_NM" TEXT,
    "TRNSMIT_SERVER_NO" NUMERIC,
    "DATA_NO" TEXT,
    "COLUMN0" TEXT,
    "COLUMN1" TEXT,
    "COLUMN2" TEXT,
    "REGIST_DT" TEXT
);

-- Table: seouldata_welfare_355__IOT_VDATA023
CREATE TABLE "aihub_welfare"."seouldata_welfare_355__IOT_VDATA023" (
    "ORGAN_NM" TEXT,
    "TRNSMIT_SERVER_NO" NUMERIC,
    "DATA_NO" TEXT,
    "COLUMN0" NUMERIC,
    "COLUMN1" NUMERIC,
    "COLUMN2" TEXT,
    "COLUMN3" NUMERIC,
    "COLUMN4" TEXT,
    "COLUMN5" TEXT,
    "COLUMN6" TEXT,
    "COLUMN7" TEXT,
    "COLUMN8" TEXT,
    "COLUMN9" TEXT,
    "COLUMN10" TEXT,
    "COLUMN11" TEXT,
    "COLUMN12" TEXT,
    "COLUMN13" TEXT,
    "COLUMN14" TEXT,
    "COLUMN15" TEXT,
    "COLUMN16" TEXT,
    "COLUMN17" TEXT,
    "COLUMN18" TEXT,
    "COLUMN19" TEXT,
    "COLUMN20" TEXT,
    "REGIST_DT" TEXT
);

-- Table: seouldata_welfare_361__IOT_VDATA022
CREATE TABLE "aihub_welfare"."seouldata_welfare_361__IOT_VDATA022" (
    "ORGAN_NM" TEXT,
    "TRNSMIT_SERVER_NO" NUMERIC,
    "DATA_NO" TEXT,
    "COLUMN0" NUMERIC,
    "COLUMN1" TEXT,
    "COLUMN2" TEXT,
    "COLUMN3" TEXT,
    "COLUMN4" NUMERIC,
    "COLUMN5" TEXT,
    "REGIST_DT" TEXT
);

-- Table: seouldata_welfare_446__TB_ADP_WAIT_ANIMAL_PHOTO_VIEW
CREATE TABLE "aihub_welfare"."seouldata_welfare_446__TB_ADP_WAIT_ANIMAL_PHOTO_VIEW" (
    "ANIMAL_NO" NUMERIC,
    "PHOTO_KND" TEXT,
    "PHOTO_NO" TEXT,
    "PHOTO_URL" TEXT
);

-- Table: seouldata_welfare_447__TB_ADP_WAIT_ANIMAL_VIEW
CREATE TABLE "aihub_welfare"."seouldata_welfare_447__TB_ADP_WAIT_ANIMAL_VIEW" (
    "ANIMAL_NO" NUMERIC,
    "NM" TEXT,
    "ENTRNC_DATE" TEXT,
    "SPCS" TEXT,
    "BREEDS" TEXT,
    "SEXDSTN" TEXT,
    "AGE" TEXT,
    "BDWGH" NUMERIC,
    "ADP_STTUS" TEXT,
    "TMPR_PRTC_STTUS" TEXT,
    "INTRCN_MVP_URL" TEXT,
    "INTRCN_CN" TEXT,
    "TMPR_PRTC_CN" TEXT
);

-- Table: seouldata_welfare_468__TV_EDUAPPLYLIST
CREATE TABLE "aihub_welfare"."seouldata_welfare_468__TV_EDUAPPLYLIST" (
    "EDUYY" TEXT,
    "SISUL_NAME" TEXT,
    "EDU_NAME" TEXT,
    "EDUGISU" TEXT,
    "EDUFRDATE" TEXT,
    "EDUTODATE" TEXT,
    "CAPACNT" TEXT,
    "APLYCNT" TEXT,
    "EDUSTATE" TEXT,
    "ADDR" TEXT,
    "TEL" TEXT
);

-- Table: seouldata_welfare_52__LAMP_SCPGMTB
CREATE TABLE "aihub_welfare"."seouldata_welfare_52__LAMP_SCPGMTB" (
    "UP_ID" NUMERIC,
    "UP_NM" TEXT,
    "SALE_COM_CD" NUMERIC,
    "SALE_COM_NM" TEXT,
    "BAS_CD" NUMERIC,
    "BAS_NM" TEXT,
    "ITEM_CD" NUMERIC,
    "ITEM_NM" TEXT,
    "CLS_CD" NUMERIC,
    "CLS_NM" TEXT,
    "PGM_CD" TEXT,
    "PGM_NM" TEXT,
    "FG_CD" NUMERIC,
    "FG_NM" TEXT,
    "YYMM" NUMERIC,
    "TARGET_CD" TEXT,
    "TARGET_NM" TEXT,
    "MM_QTY" NUMERIC,
    "START_T" TEXT,
    "END_T" TEXT,
    "AREA_CD" TEXT,
    "U_PRICE" NUMERIC,
    "START_DAY" TEXT,
    "REAL_ST_DT" TEXT,
    "REAL_ED_DT" TEXT,
    "DT_WEEK_CD" NUMERIC,
    "RGL_QTY" NUMERIC,
    "CLOSE_YN" TEXT,
    "USER_NM" TEXT
);

-- Table: seouldata_welfare_5340__GB_HOME_LONG_TERM_CARE
CREATE TABLE "aihub_welfare"."seouldata_welfare_5340__GB_HOME_LONG_TERM_CARE" (
    "ORGAN_NM" TEXT,
    "ORGAN_TEL" TEXT,
    "ORGAN_FAX" TEXT,
    "ORGAN_GB" TEXT,
    "REG_DT" TEXT,
    "ORGAN_ADDR" TEXT
);

-- Table: seouldata_welfare_5354__GB_SENIOR_CENTER
CREATE TABLE "aihub_welfare"."seouldata_welfare_5354__GB_SENIOR_CENTER" (
    "NO" TEXT,
    "DONG_NM" TEXT,
    "SENIOR_CENTER" TEXT,
    "GB" TEXT,
    "TEL_NO" TEXT,
    "ROAD_ADDR" TEXT
);

-- Table: seouldata_welfare_5381__GD_NOTICE_VIEW
CREATE TABLE "aihub_welfare"."seouldata_welfare_5381__GD_NOTICE_VIEW" (
    "IDX" NUMERIC,
    "NAME" TEXT,
    "SUBJECT" TEXT,
    "CONTENT" TEXT,
    "REGDATE" TEXT,
    "HIT" TEXT,
    "FILE1" TEXT,
    "FILE2" TEXT,
    "FILE3" TEXT,
    "FILE4" TEXT,
    "FILE5" TEXT,
    "FILE6" TEXT
);

-- Table: seouldata_welfare_5387__SDM_CHLDCR_NOTICE
CREATE TABLE "aihub_welfare"."seouldata_welfare_5387__SDM_CHLDCR_NOTICE" (
    "BOARD_IDX" TEXT,
    "BOARD_SUBJECT" TEXT,
    "BOARD_CONTENT" TEXT,
    "BOARD_HIT" TEXT,
    "BOARD_REGDATE" TEXT,
    "BOARD_FILE1" TEXT,
    "BOARD_FILE2" TEXT,
    "BOARD_FILE4" TEXT,
    "BOARD_FILE5" TEXT
);

-- Table: seouldata_welfare_5398__INFO_HAPPYCARD
CREATE TABLE "aihub_welfare"."seouldata_welfare_5398__INFO_HAPPYCARD" (
    "CATEGORY" TEXT,
    "COMPANY_NAME" TEXT,
    "ADDR" TEXT,
    "OFFICE_TEL" TEXT,
    "SUPPORT" TEXT
);

-- Table: seouldata_welfare_642__TN_FCLTY_STTUS_INFO10073
CREATE TABLE "aihub_welfare"."seouldata_welfare_642__TN_FCLTY_STTUS_INFO10073" (
    "CLTUR_EVENT_ETC_NM" TEXT,
    "SVC_CL_CODE" NUMERIC,
    "SVC_CL_NM" TEXT,
    "ATDRC_CODE" NUMERIC,
    "ATDRC_NM" TEXT,
    "AGE_SE_CODE" NUMERIC,
    "AGE_SE_NM" TEXT,
    "FCLTY_CL_CODE" NUMERIC,
    "FCLTY_CL_NM" TEXT,
    "X_CRDNT_VALUE" NUMERIC,
    "Y_CRDNT_VALUE" NUMERIC,
    "ZIP" TEXT,
    "BASS_ADRES" TEXT,
    "DETAIL_ADRES" TEXT,
    "RNTFEE_FREE_AT" TEXT,
    "RNTFEE" TEXT,
    "GUIDANCE_URL" TEXT,
    "REGIST_DT" TEXT,
    "UPDT_DT" TEXT
);

-- Table: seouldata_welfare_644__TN_FCLTY_STTUS_INFO10071
CREATE TABLE "aihub_welfare"."seouldata_welfare_644__TN_FCLTY_STTUS_INFO10071" (
    "CLTUR_EVENT_ETC_NM" TEXT,
    "SVC_CL_CODE" NUMERIC,
    "SVC_CL_NM" TEXT,
    "ATDRC_CODE" NUMERIC,
    "ATDRC_NM" TEXT,
    "AGE_SE_CODE" NUMERIC,
    "AGE_SE_NM" TEXT,
    "FCLTY_CL_CODE" NUMERIC,
    "FCLTY_CL_NM" TEXT,
    "X_CRDNT_VALUE" NUMERIC,
    "Y_CRDNT_VALUE" NUMERIC,
    "ZIP" TEXT,
    "BASS_ADRES" TEXT,
    "DETAIL_ADRES" TEXT,
    "RNTFEE_FREE_AT" TEXT,
    "RNTFEE" TEXT,
    "GUIDANCE_URL" TEXT,
    "REGIST_DT" TEXT,
    "UPDT_DT" TEXT
);

-- Table: seouldata_welfare_646__TN_FCLTY_STTUS_INFO1003
CREATE TABLE "aihub_welfare"."seouldata_welfare_646__TN_FCLTY_STTUS_INFO1003" (
    "FCLTY_ID" TEXT,
    "FCLTY_NM" TEXT,
    "SVC_CL_CODE" NUMERIC,
    "SVC_CL_NM" TEXT,
    "ATDRC_CODE" NUMERIC,
    "ATDRC_NM" TEXT,
    "AGE_SE_CODE" NUMERIC,
    "AGE_SE_NM" TEXT,
    "X_CRDNT_VALUE" NUMERIC,
    "Y_CRDNT_VALUE" NUMERIC,
    "ZIP" NUMERIC,
    "BASS_ADRES" TEXT,
    "DETAIL_ADRES" TEXT,
    "RNTFEE_FREE_AT" TEXT,
    "RNTFEE" TEXT,
    "SEMSTR_BEGIN_TIME" NUMERIC,
    "SEMSTR_END_TIME" NUMERIC,
    "VCTN_BEGIN_TIME" NUMERIC,
    "VCTN_END_TIME" NUMERIC,
    "SAT_OPER_AT" TEXT,
    "SAT_OPER_BEGIN_TIME" NUMERIC,
    "SAT_OPER_END_TIME" NUMERIC,
    "REGIST_DT" TEXT,
    "UPDT_DT" TEXT
);

-- Table: seouldata_welfare_647__TN_FCLTY_STTUS_INFO1002
CREATE TABLE "aihub_welfare"."seouldata_welfare_647__TN_FCLTY_STTUS_INFO1002" (
    "FCLTY_ID" TEXT,
    "FCLTY_NM" TEXT,
    "SVC_CL_CODE" NUMERIC,
    "SVC_CL_NM" TEXT,
    "ATDRC_CODE" NUMERIC,
    "ATDRC_NM" TEXT,
    "AGE_SE_CODE" NUMERIC,
    "AGE_SE_NM" TEXT,
    "X_CRDNT_VALUE" NUMERIC,
    "Y_CRDNT_VALUE" NUMERIC,
    "ZIP" NUMERIC,
    "BASS_ADRES" TEXT,
    "DETAIL_ADRES" TEXT,
    "SITE_ENNC" TEXT,
    "SITE_URL" TEXT,
    "RNTFEE_FREE_AT" TEXT,
    "RNTFEE" TEXT,
    "WKDAY_BEGIN_TIME" NUMERIC,
    "WKDAY_END_TIME" NUMERIC,
    "USE_TIME_SE_CODE" TEXT,
    "USE_TIME_SE_NM" TEXT,
    "BEGIN_TIME1" NUMERIC,
    "END_TIME1" NUMERIC,
    "BEGIN_TIME2" NUMERIC,
    "END_TIME2" NUMERIC,
    "BEGIN_TIME3" NUMERIC,
    "END_TIME3" NUMERIC,
    "SAT_OPER_AT" TEXT,
    "SAT_OPER_BEGIN_TIME" NUMERIC,
    "SAT_OPER_END_TIME" NUMERIC,
    "REGIST_DT" TEXT,
    "UPDT_DT" TEXT
);

-- Table: seouldata_welfare_648__TN_FCLTY_STTUS_INFO1001
CREATE TABLE "aihub_welfare"."seouldata_welfare_648__TN_FCLTY_STTUS_INFO1001" (
    "FCLTY_ID" TEXT,
    "FCLTY_NM" TEXT,
    "SVC_CL_CODE" NUMERIC,
    "SVC_CL_NM" TEXT,
    "ATDRC_CODE" NUMERIC,
    "ATDRC_NM" TEXT,
    "AGE_SE_CODE" NUMERIC,
    "AGE_SE_NM" TEXT,
    "X_CRDNT_VALUE" NUMERIC,
    "Y_CRDNT_VALUE" NUMERIC,
    "ZIP" NUMERIC,
    "BASS_ADRES" TEXT,
    "DETAIL_ADRES" TEXT,
    "FOND_DE" TEXT,
    "RNTFEE_FREE_AT" TEXT,
    "RNTFEE" TEXT,
    "PRVUSE_AR" NUMERIC,
    "SEMSTR_BEGIN_TIME" NUMERIC,
    "SEMSTR_END_TIME" NUMERIC,
    "VCTN_BEGIN_TIME" NUMERIC,
    "VCTN_END_TIME" NUMERIC,
    "DSCR_RESTDE_BEGIN_TIME" NUMERIC,
    "DSCR_RESTDE_END_TIME" NUMERIC,
    "SAT_OPER_AT" TEXT,
    "SAT_OPER_BEGIN_TIME" NUMERIC,
    "SAT_OPER_END_TIME" NUMERIC,
    "MT_RNTFEE_FREE_AT" TEXT,
    "MT_SELF_ALOTM" TEXT,
    "MT_RNTFEE" NUMERIC,
    "DE_RNTFEE_FREE_AT" TEXT,
    "DE_SELF_ALOTM" TEXT,
    "DE_RNTFEE" TEXT,
    "ORDTM_CARE_PSNCPA_CO" TEXT,
    "ONCE_CARE_PSNCPA_CO" TEXT,
    "PRVUSE_AR_M2" TEXT,
    "ATDRC_CODE_ARRAY" TEXT,
    "REGIST_DT" TEXT,
    "UPDT_DT" TEXT
);

-- Table: seouldata_welfare_649__TN_FCLTY_STTUS_INFO2001
CREATE TABLE "aihub_welfare"."seouldata_welfare_649__TN_FCLTY_STTUS_INFO2001" (
    "CLTUR_EVENT_ETC_NM" TEXT,
    "SVC_CL_CODE" TEXT,
    "SVC_CL_NM" TEXT,
    "ATDRC_CODE" NUMERIC,
    "ATDRC_NM" TEXT,
    "AGE_SE_CODE" NUMERIC,
    "AGE_SE_NM" TEXT,
    "X_CRDNT_VALUE" NUMERIC,
    "Y_CRDNT_VALUE" NUMERIC,
    "ZIP" TEXT,
    "BASS_ADRES" TEXT,
    "DETAIL_ADRES" TEXT,
    "RNTFEE_FREE_AT" TEXT,
    "RNTFEE" TEXT,
    "EVENT_PD_BGNDE" TEXT,
    "EVENT_PD_ENDDE" TEXT,
    "GUIDANCE_URL" TEXT,
    "EVENT_FCLTY_NM" TEXT,
    "REGIST_DT" TEXT,
    "UPDT_DT" TEXT
);

-- Table: seouldata_welfare_651__TN_FCLTY_STTUS_INFO10075
CREATE TABLE "aihub_welfare"."seouldata_welfare_651__TN_FCLTY_STTUS_INFO10075" (
    "CLTUR_EVENT_ETC_NM" TEXT,
    "SVC_CL_CODE" NUMERIC,
    "SVC_CL_NM" TEXT,
    "ATDRC_CODE" NUMERIC,
    "ATDRC_NM" TEXT,
    "AGE_SE_CODE" NUMERIC,
    "AGE_SE_NM" TEXT,
    "FCLTY_CL_CODE" NUMERIC,
    "FCLTY_CL_NM" TEXT,
    "X_CRDNT_VALUE" NUMERIC,
    "Y_CRDNT_VALUE" NUMERIC,
    "ZIP" NUMERIC,
    "BASS_ADRES" TEXT,
    "DETAIL_ADRES" TEXT,
    "RNTFEE_FREE_AT" TEXT,
    "RNTFEE" TEXT,
    "GUIDANCE_URL" TEXT,
    "REGIST_DT" TEXT,
    "UPDT_DT" TEXT
);

-- Table: seouldata_welfare_652__TN_FCLTY_STTUS_INFO10074
CREATE TABLE "aihub_welfare"."seouldata_welfare_652__TN_FCLTY_STTUS_INFO10074" (
    "CLTUR_EVENT_ETC_NM" TEXT,
    "SVC_CL_CODE" NUMERIC,
    "SVC_CL_NM" TEXT,
    "ATDRC_CODE" NUMERIC,
    "ATDRC_NM" TEXT,
    "AGE_SE_CODE" NUMERIC,
    "AGE_SE_NM" TEXT,
    "FCLTY_CL_CODE" NUMERIC,
    "FCLTY_CL_NM" TEXT,
    "X_CRDNT_VALUE" NUMERIC,
    "Y_CRDNT_VALUE" NUMERIC,
    "ZIP" NUMERIC,
    "BASS_ADRES" TEXT,
    "DETAIL_ADRES" TEXT,
    "RNTFEE_FREE_AT" TEXT,
    "RNTFEE" TEXT,
    "GUIDANCE_URL" TEXT,
    "REGIST_DT" TEXT,
    "UPDT_DT" TEXT
);

-- Table: seouldata_welfare_680__SAFE_OPEN_BOX
CREATE TABLE "aihub_welfare"."seouldata_welfare_680__SAFE_OPEN_BOX" (
    "ADDRDETAIL" TEXT,
    "ANSIMINM" TEXT,
    "ANSIMIADDR" TEXT,
    "WGSXPT" NUMERIC,
    "WGSYPT" NUMERIC
);

-- Table: seouldata_welfare_714__VIEW_AMENITIES_INFO
CREATE TABLE "aihub_welfare"."seouldata_welfare_714__VIEW_AMENITIES_INFO" (
    "SEQ" TEXT,
    "SISULNAME" TEXT,
    "GU" TEXT,
    "ADDR" TEXT,
    "TEL" TEXT,
    "HOMEPAGE" TEXT,
    "HIT" TEXT,
    "ST1" TEXT,
    "ST2" TEXT,
    "ST3" TEXT,
    "ST4" TEXT,
    "ST5" TEXT,
    "ST9" TEXT,
    "ST10" TEXT,
    "ST11" TEXT,
    "ST12" TEXT
);

-- Table: seouldata_welfare_716__TOURIST_FOOD_INFO
CREATE TABLE "aihub_welfare"."seouldata_welfare_716__TOURIST_FOOD_INFO" (
    "SEQ" NUMERIC,
    "SISULNAME" TEXT,
    "GU" TEXT,
    "ADDR" TEXT,
    "TEL" TEXT,
    "HOMEPAGE" TEXT,
    "HIT" TEXT,
    "ST1" TEXT,
    "ST2" TEXT,
    "ST3" TEXT,
    "ST4" TEXT,
    "ST5" TEXT,
    "ST6" TEXT,
    "ST7" TEXT,
    "ST9" TEXT,
    "ST10" TEXT,
    "ST11" TEXT,
    "ST12" TEXT
);

-- Table: seouldata_welfare_717__SUBWAY_TOUR_INFO
CREATE TABLE "aihub_welfare"."seouldata_welfare_717__SUBWAY_TOUR_INFO" (
    "NO" TEXT,
    "LINE" TEXT,
    "LINE_NAME" TEXT,
    "STATION" TEXT,
    "STATION_IMAGE" TEXT,
    "COURSE1" TEXT,
    "COURSE2" TEXT,
    "ELEVATER" TEXT,
    "ELEVATER_TXT" TEXT,
    "STATION_IMAGE2" TEXT,
    "USEYN" TEXT,
    "ICON_PATH" TEXT,
    "EXIT_INFO" TEXT,
    "TELNO_INFO" TEXT,
    "TIME_INFO1" TEXT,
    "TIME_INFO2" TEXT,
    "TIME_INFO3" TEXT,
    "TIME_INFO4" TEXT
);

-- Table: seouldata_welfare_718__MA_ITEM_TB
CREATE TABLE "aihub_welfare"."seouldata_welfare_718__MA_ITEM_TB" (
    "ITEM_BIG_NM" TEXT,
    "ITEM_MID_NM" TEXT,
    "ITEM_SML_NM" TEXT,
    "ITEM_SEQ" TEXT,
    "ITEM_NM" TEXT,
    "BRAND_NM" TEXT,
    "PROD_YM" TEXT,
    "ITEM_SIZE" TEXT
);

-- Table: seouldata_welfare_719__MA_UPPER_FOOD_TB
CREATE TABLE "aihub_welfare"."seouldata_welfare_719__MA_UPPER_FOOD_TB" (
    "UPPER_FOOD_BIG_NM" TEXT,
    "UPPER_FOOD_MID_NM" TEXT,
    "UPPER_FOOD_SML_NM" TEXT,
    "UPPER_FOOD_SEQ" NUMERIC,
    "UPPER_FOOD_NM" TEXT,
    "UPPER_FOOD_DES" TEXT
);

-- Table: seouldata_welfare_756__TB_VMC_RECRUIT
CREATE TABLE "aihub_welfare"."seouldata_welfare_756__TB_VMC_RECRUIT" (
    "NUM" NUMERIC,
    "W_NO" NUMERIC,
    "LANG_CD" TEXT,
    "DISPLAY" TEXT,
    "SUBJECT" TEXT,
    "STATE_CD" TEXT,
    "COMPANY_NO" TEXT,
    "NATION_CD" TEXT,
    "WORKAREA_CD" TEXT,
    "WORKDAY_CD" TEXT,
    "WORKHOURS_ST" TEXT,
    "WORKHOURS_ED" TEXT,
    "EMPFORM_CD" TEXT,
    "WEEKENDWORK_CD" TEXT,
    "WORKPAY" TEXT,
    "WORKMEN" TEXT,
    "WORKSERVICE" TEXT,
    "WORKSUBWAY" TEXT,
    "NATION" TEXT,
    "WORKPATTERN" TEXT,
    "WORKAREA" TEXT,
    "WORKTIME" TEXT,
    "CONTENTS" TEXT,
    "AFILE1" TEXT,
    "AFILE1_ORG" TEXT,
    "AFILE2" TEXT,
    "AFILE2_ORG" TEXT,
    "HIT" TEXT,
    "WDATE" TEXT,
    "TA_DATE" TEXT,
    "MB_NAME" TEXT,
    "APPLY_OPEN" TEXT,
    "TR_LANGS" TEXT,
    "IS_NOTICE_TEXT" TEXT,
    "IS_CHARGED_CONTENT_COPYRIGHT" TEXT
);

-- Table: seouldata_welfare_757__TB_VMC_WEBZINE
CREATE TABLE "aihub_welfare"."seouldata_welfare_757__TB_VMC_WEBZINE" (
    "NUM" NUMERIC,
    "YEAR_CD" TEXT,
    "SUBJECT" TEXT,
    "IMG1" TEXT,
    "LINKURL" TEXT,
    "WDATE" TEXT,
    "MB_ID" TEXT,
    "MB_NAME" TEXT
);

-- Table: seouldata_welfare_77__CHILD_CARE_INFO
CREATE TABLE "aihub_welfare"."seouldata_welfare_77__CHILD_CARE_INFO" (
    "SIGUNNAME" TEXT,
    "STCODE" NUMERIC,
    "CRNAME" TEXT,
    "CRTYPENAME" TEXT,
    "CRSTATUSNAME" TEXT,
    "ZIPCODE" NUMERIC,
    "CRADDR" TEXT,
    "CRTELNO" TEXT,
    "CRFAXNO" TEXT,
    "NRTRROOMCNT" NUMERIC,
    "NRTRROOMSIZE" NUMERIC,
    "PLGRDCO" NUMERIC,
    "CCTVINSTLCNT" NUMERIC,
    "CHCRTESCNT" NUMERIC,
    "CRCAPAT" NUMERIC,
    "CRCHCNT" NUMERIC,
    "LO" NUMERIC,
    "CRCARGBNAME" TEXT,
    "CRCNFMDT" TEXT,
    "CRPAUSEBEGINDT" TEXT,
    "CRPAUSEENDDT" TEXT,
    "CRABLDT" TEXT,
    "DATASTDRDT" TEXT,
    "CRSPEC" TEXT,
    "CLASS_CNT_00" NUMERIC,
    "CLASS_CNT_02" NUMERIC,
    "CLASS_CNT_03" NUMERIC,
    "CLASS_CNT_04" NUMERIC,
    "CLASS_CNT_M2" NUMERIC,
    "CLASS_CNT_SP" NUMERIC,
    "CHILD_CNT_00" NUMERIC,
    "CHILD_CNT_01" NUMERIC,
    "CHILD_CNT_02" NUMERIC,
    "CHILD_CNT_03" NUMERIC,
    "CHILD_CNT_04" NUMERIC,
    "CHILD_CNT_M2" NUMERIC
);

-- Table: seouldata_welfare_854__ODSN_BUILDING_INFO
CREATE TABLE "aihub_welfare"."seouldata_welfare_854__ODSN_BUILDING_INFO" (
    "ID" TEXT,
    "NM" TEXT,
    "ADDR_OLD" TEXT,
    "ADDR" TEXT,
    "PERMISSION_DT" NUMERIC,
    "STATE" TEXT,
    "STOP_DT" TEXT,
    "SUSPENSION_START_DT" TEXT,
    "SUSPENSION_END_DT" TEXT,
    "RE_OPEN_DT" TEXT,
    "AREA" TEXT,
    "POST" TEXT,
    "ENTRNC_PSNCPA" TEXT,
    "CTLF_NUM" TEXT,
    "TOTAL_NUM" TEXT,
    "XCODE" TEXT,
    "YCODE" TEXT,
    "PERMISSION_NO" TEXT,
    "DETAIL_STAT_NM" TEXT
);

-- Table: seouldata_welfare_85__TB_ELEC_WHEEL_CHR_CHARGE
CREATE TABLE "aihub_welfare"."seouldata_welfare_85__TB_ELEC_WHEEL_CHR_CHARGE" (
    "FCLTYNM" TEXT,
    "CTPRVNNM" TEXT,
    "SIGNGUNM" TEXT,
    "SIGNGUCODE" NUMERIC,
    "RDNMADR" TEXT,
    "LNMADR" TEXT,
    "LATITUDE" NUMERIC,
    "LONGITUDE" NUMERIC,
    "INSTLLCDESC" TEXT,
    "WEEKDAYOPEROPENHHMM" TEXT,
    "WEEKDAYOPERCOLSEHHMM" TEXT,
    "SATOPEROPEROPENHHMM" TEXT,
    "SATOPERCLOSEHHMM" TEXT,
    "HOLIDAYOPEROPENHHMM" TEXT,
    "HOLIDAYCLOSEOPENHHMM" TEXT,
    "SMTMUSECO" NUMERIC,
    "AIRINJECTORYN" TEXT,
    "MOBLPHONCHRSTNYN" TEXT,
    "INSTITUTIONNM" TEXT,
    "INSTITUTIONPHONENUMBER" TEXT,
    "REFERENCEDATE" TEXT,
    "INSTTCODE" NUMERIC,
    "WORK_DTTM" TEXT
);

-- Table: seouldata_welfare_938__WOMAN_SAFE_AREA_INFO
CREATE TABLE "aihub_welfare"."seouldata_welfare_938__WOMAN_SAFE_AREA_INFO" (
    "ID" TEXT,
    "BR_NM" TEXT,
    "GU_NM" TEXT,
    "NM" TEXT,
    "ADDR" TEXT
);

-- Table: seouldata_welfare_943__VOLUNTEER_UNIV
CREATE TABLE "aihub_welfare"."seouldata_welfare_943__VOLUNTEER_UNIV" (
    "SCHOOL_NAME" TEXT,
    "ACTIVE_YEAR" TEXT,
    "ACTIVE_TERM" TEXT,
    "BATCH_CNT" TEXT,
    "WORK_DTTM" TEXT
);
