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

-- Table: publicdata_transportation_10045__ICTR_ESCALATOR_I_STS
CREATE TABLE "aihub_transport"."publicdata_transportation_10045__ICTR_ESCALATOR_I_STS" (
    "LINE" NUMERIC,
    "HISTORY_NAME" TEXT,
    "ESCALATOR_OUTSIDE" NUMERIC,
    "INSIDE_THE_ESCALATOR" NUMERIC
);

-- Table: publicdata_transportation_10045__ICTR_HISTORICAL_DEPTH_HEIGHT
CREATE TABLE "aihub_transport"."publicdata_transportation_10045__ICTR_HISTORICAL_DEPTH_HEIGHT" (
    "LINE" NUMERIC,
    "STATION_NAME" TEXT,
    "DEPTH_AND_HEIGHT" NUMERIC,
    "NOTE" TEXT
);

-- Table: publicdata_transportation_10046__ICTR_ELEVATOR_I_STS
CREATE TABLE "aihub_transport"."publicdata_transportation_10046__ICTR_ELEVATOR_I_STS" (
    "LINE" NUMERIC,
    "HISTORY_NAME" TEXT,
    "ELEVATOR" NUMERIC,
    "INSIDE_THE_ELEVATOR" NUMERIC,
    "WHEELCHAIR_LIFT" NUMERIC
);

-- Table: publicdata_transportation_10046__ICTR_HISTORICAL_DEPTH_HEIGHT
CREATE TABLE "aihub_transport"."publicdata_transportation_10046__ICTR_HISTORICAL_DEPTH_HEIGHT" (
    "LINE" NUMERIC,
    "STATION_NAME" TEXT,
    "DEPTH_AND_HEIGHT" NUMERIC,
    "NOTE" TEXT
);

-- Table: publicdata_transportation_10077__CURRENT_STS_ICTR_HISTORIC_FLOO
CREATE TABLE "aihub_transport"."publicdata_transportation_10077__CURRENT_STS_ICTR_HISTORIC_FLOO" (
    "STATION_NAME" TEXT,
    "LOCATION" TEXT,
    "GRATITUDE" NUMERIC,
    "RESCUE" TEXT
);

-- Table: publicdata_transportation_10077__ICTR_INCHEON_SUBWAY_STATION_AD
CREATE TABLE "aihub_transport"."publicdata_transportation_10077__ICTR_INCHEON_SUBWAY_STATION_AD" (
    "DIVISION" TEXT,
    "STATION_NAME" TEXT,
    "PHONE_NUMBER" TEXT,
    "ADDRESS" TEXT
);

-- Table: publicdata_transportation_1019__SELMETRO_HISTORICAL_WHEELCHAIR_
CREATE TABLE "aihub_transport"."publicdata_transportation_1019__SELMETRO_HISTORICAL_WHEELCHAIR_" (
    "ANNUAL" NUMERIC,
    "LINE" NUMERIC,
    "STATION_NAME" TEXT,
    "EQUIPMENT" TEXT,
    "AORY" TEXT,
    "ELEVATOR_NUMBER" TEXT
);

-- Table: publicdata_transportation_1023__SELMETRO_STATION_DISTANCE
CREATE TABLE "aihub_transport"."publicdata_transportation_1023__SELMETRO_STATION_DISTANCE" (
    "ANNUAL" NUMERIC,
    "LINE" NUMERIC,
    "STATION_NAME" TEXT,
    "STATION_DISTANCE_KM" NUMERIC,
    "CUMULATIVE_KM" NUMERIC
);

-- Table: publicdata_transportation_1027__STS_SELMETRO_HISTORY_O
CREATE TABLE "aihub_transport"."publicdata_transportation_1027__STS_SELMETRO_HISTORY_O" (
    "ANNUAL" NUMERIC,
    "LINE" TEXT,
    "STATION_NAME" TEXT,
    "AREA_SQUARE_METER" NUMERIC,
    "HISTORICAL_STRUCTURE" TEXT,
    "PLATFORM" TEXT,
    "ENTRANCE" NUMERIC,
    "TRANSIT_LINE" TEXT
);

-- Table: publicdata_transportation_10354__EX_HI_PASS_TERMINAL_S_OFFICE_I
CREATE TABLE "aihub_transport"."publicdata_transportation_10354__EX_HI_PASS_TERMINAL_S_OFFICE_I" (
    "HEADQUARTERS" TEXT,
    "NAME" TEXT,
    "BUSINESS_CALL" TEXT,
    "PHONE_NUMBER" TEXT,
    "FAX_NUMBER" TEXT,
    "ZIP_CODE" TEXT,
    "ADDRESS" TEXT
);

-- Table: publicdata_transportation_10354__HIGH_PASS_UTILIZATION_RATIO_EX
CREATE TABLE "aihub_transport"."publicdata_transportation_10354__HIGH_PASS_UTILIZATION_RATIO_EX" (
    "DIVISION" NUMERIC,
    "BUSINESS_OFFICE" TEXT,
    "HIGH_PASS_USAGE_RATE" NUMERIC,
    "NOTE" TEXT
);

-- Table: publicdata_transportation_1054__SELMETRO_BID_ANNOUNCEMENT_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_1054__SELMETRO_BID_ANNOUNCEMENT_INFO" (
    "ANNUAL" NUMERIC,
    "NOMINATION" TEXT,
    "CONTRACT_METHOD" TEXT,
    "BIDDING_DATE" TEXT
);

-- Table: publicdata_transportation_1055__NUM_MONTHLY_TRANSFERS_SELMETRO
CREATE TABLE "aihub_transport"."publicdata_transportation_1055__NUM_MONTHLY_TRANSFERS_SELMETRO" (
    "ANNUAL" NUMERIC,
    "LINE" NUMERIC,
    "REVERSE_NUMBER" NUMERIC,
    "STATION_NAME" TEXT,
    "JANUARY_2022" NUMERIC,
    "FEBRUARY_2022" NUMERIC,
    "APRIL_2022" NUMERIC
);

-- Table: publicdata_transportation_1056__NUM_PEOPLE_GETTING_OFF_SELMETRO
CREATE TABLE "aihub_transport"."publicdata_transportation_1056__NUM_PEOPLE_GETTING_OFF_SELMETRO" (
    "ANNUAL" NUMERIC,
    "LINE" NUMERIC,
    "REVERSE_NUMBER" NUMERIC,
    "STATION_NAME" TEXT,
    "JANUARY_2022" NUMERIC,
    "FEBRUARY_2022" NUMERIC,
    "MARCH_2022" NUMERIC,
    "APRIL_2022" NUMERIC,
    "MAY_2022" NUMERIC
);

-- Table: publicdata_transportation_1058__SELMETRO_MONTHLY_NUM_RIDERS
CREATE TABLE "aihub_transport"."publicdata_transportation_1058__SELMETRO_MONTHLY_NUM_RIDERS" (
    "ANNUAL" NUMERIC,
    "LINE" NUMERIC,
    "REVERSE_NUMBER" NUMERIC,
    "STATION_NAME" TEXT,
    "JANUARY_2022" NUMERIC,
    "FEBRUARY_2022" NUMERIC,
    "APRIL_2022" NUMERIC,
    "MAY_2022" NUMERIC
);

-- Table: publicdata_transportation_1059__NUM_PEOPLE_TRANSPORTED_SELMETRO
CREATE TABLE "aihub_transport"."publicdata_transportation_1059__NUM_PEOPLE_TRANSPORTED_SELMETRO" (
    "ANNUAL" NUMERIC,
    "LINE" NUMERIC,
    "REVERSE_NUMBER" NUMERIC,
    "STATION_NAME" TEXT,
    "JANUARY_2022" NUMERIC,
    "MARCH_2022" NUMERIC,
    "APRIL_2022" NUMERIC,
    "MAY_2022" NUMERIC
);

-- Table: publicdata_transportation_1062__SELMETRO_HISTORICAL_AREA_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_1062__SELMETRO_HISTORICAL_AREA_INFO" (
    "LINE" NUMERIC,
    "STATION_NAME" TEXT,
    "WAITING_ROOM" NUMERIC,
    "PLATFORM" NUMERIC
);

-- Table: publicdata_transportation_1064__SELMETRO_HISTORICAL_ARCHITECTUR
CREATE TABLE "aihub_transport"."publicdata_transportation_1064__SELMETRO_HISTORICAL_ARCHITECTUR" (
    "ANNUAL" NUMERIC,
    "LINE" NUMERIC,
    "STATION_NAME" TEXT,
    "FORM" TEXT,
    "LENGTH_METER" NUMERIC,
    "FLOORS" TEXT,
    "AREA_SQUARE_METER" NUMERIC,
    "COMPLETION" NUMERIC
);

-- Table: publicdata_transportation_1065__INFO_NUM_PEOPLE_DISABILITIES_PE
CREATE TABLE "aihub_transport"."publicdata_transportation_1065__INFO_NUM_PEOPLE_DISABILITIES_PE" (
    "ANNUAL" NUMERIC,
    "LINE" NUMERIC,
    "REVERSE_NUMBER" NUMERIC,
    "STATION_NAME" TEXT,
    "DIVISION" TEXT,
    "JANUARY_2022" NUMERIC,
    "FEBRUARY_2022" NUMERIC,
    "MARCH_2022" NUMERIC,
    "APRIL_2022" NUMERIC,
    "MAY_2022" NUMERIC
);

-- Table: publicdata_transportation_1066__STS_EQUIPMENT_FAC_ONE_TICKET_SE
CREATE TABLE "aihub_transport"."publicdata_transportation_1066__STS_EQUIPMENT_FAC_ONE_TICKET_SE" (
    "ANNUAL" NUMERIC,
    "LINE" NUMERIC,
    "REVERSE_NUMBER" NUMERIC,
    "HISTORY_NAME" TEXT,
    "VENDOR" NUMERIC,
    "REFUNDER" NUMERIC,
    "UNMANNED_SETTLEMENT" NUMERIC,
    "VOUCHER" NUMERIC,
    "SELLER" NUMERIC,
    "PORTABLE" NUMERIC,
    "RACING" NUMERIC
);

-- Table: publicdata_transportation_1068__INFO_NUM_ELDERLY_PEOPLE_GETTING
CREATE TABLE "aihub_transport"."publicdata_transportation_1068__INFO_NUM_ELDERLY_PEOPLE_GETTING" (
    "ANNUAL" NUMERIC,
    "LINE" NUMERIC,
    "REVERSE_NUMBER" NUMERIC,
    "STATION_NAME" TEXT,
    "DIVISION" TEXT,
    "JANUARY_2022" NUMERIC,
    "FEBRUARY_2022" NUMERIC,
    "MARCH_2022" NUMERIC,
    "APRIL_2022" NUMERIC,
    "MAY_2022" NUMERIC
);

-- Table: publicdata_transportation_1073__NUM_PASSENGERS_SELMETRO_WINDING
CREATE TABLE "aihub_transport"."publicdata_transportation_1073__NUM_PASSENGERS_SELMETRO_WINDING" (
    "ANNUAL" NUMERIC,
    "LINE" NUMERIC,
    "REVERSE_NUMBER" NUMERIC,
    "STATION_NAME" TEXT,
    "JANUARY_F" NUMERIC,
    "AFTER_JANUARY" NUMERIC,
    "JANUARY_S" NUMERIC,
    "JANUARY_GREAT_POWER" NUMERIC,
    "JANUARY_1_TICKET" NUMERIC,
    "JANUARY_O" NUMERIC,
    "FEBRUARY_F" NUMERIC,
    "AFTER_FEBRUARY" NUMERIC,
    "FEBRUARY_S" NUMERIC,
    "FEBRUARY_BIG_POWER" NUMERIC,
    "FEBRUARY_1_TICKET" NUMERIC,
    "FEBRUARY_O" NUMERIC,
    "MARCH_F" NUMERIC,
    "LATE_MARCH" NUMERIC,
    "MARCH_S" NUMERIC,
    "MARCH_GREAT_POWER" NUMERIC,
    "MARCH_1_TICKET" NUMERIC,
    "MARCH_O" NUMERIC,
    "APRIL_BUDDHA" NUMERIC,
    "LATE_APRIL" NUMERIC,
    "APRIL_S" NUMERIC,
    "APRIL_GREAT_POWER" NUMERIC,
    "APRIL_1_TICKET" NUMERIC,
    "APRIL_O" NUMERIC,
    "FUND_IN_MAY" NUMERIC,
    "LATER_IN_MAY" NUMERIC,
    "MAY_S" NUMERIC,
    "MAY_GREAT_POWER" NUMERIC,
    "MAY_1_TICKET" NUMERIC,
    "MAY_O" NUMERIC
);

-- Table: publicdata_transportation_10858__NUM_PEOPLE_GETTING_OFF_BTC_TIM
CREATE TABLE "aihub_transport"."publicdata_transportation_10858__NUM_PEOPLE_GETTING_OFF_BTC_TIM" (
    "REVERSE_NUMBER" NUMERIC,
    "STATION_NAME" TEXT,
    "YEAR_MONTH_DAY" TEXT,
    "DAY_OF_THE_WEEK" TEXT,
    "DIVISION" TEXT,
    "TOTAL" NUMERIC,
    "H_01_02" NUMERIC,
    "H_02_03" NUMERIC,
    "H_03_04" NUMERIC,
    "H_04_05" NUMERIC,
    "H_05_06" NUMERIC,
    "H_06_07" NUMERIC,
    "H_07_08" NUMERIC,
    "H_08_09" NUMERIC,
    "H_09_10" NUMERIC,
    "H_10_11" NUMERIC,
    "H_11_12" NUMERIC,
    "H_12_13" NUMERIC,
    "H_13_14" NUMERIC,
    "H_14_15" NUMERIC,
    "H_15_16" NUMERIC,
    "H_16_17" NUMERIC,
    "H_17_18" NUMERIC,
    "H_18_19" NUMERIC,
    "H_19_20" NUMERIC,
    "H_20_21" NUMERIC,
    "H_21_22" NUMERIC,
    "H_22_23" NUMERIC,
    "H_23_24" NUMERIC,
    "H_24_01" NUMERIC
);

-- Table: publicdata_transportation_10858__STS_SAFETY_DOOR_BTC_BUSAN_METR
CREATE TABLE "aihub_transport"."publicdata_transportation_10858__STS_SAFETY_DOOR_BTC_BUSAN_METR" (
    "REVERSE_NUMBER" NUMERIC,
    "STATION_NAME" TEXT,
    "INSTALLATION_DATE" TEXT
);

-- Table: publicdata_transportation_11061__SELMETRO_ELEVATOR_I_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_11061__SELMETRO_ELEVATOR_I_INFO" (
    "ANNUAL" NUMERIC,
    "LINE" TEXT,
    "STATION_NAME" TEXT,
    "EQUIPMENT" TEXT,
    "AORY" TEXT,
    "ELEVATOR_NUMBER" TEXT,
    "OPERATING_SECTION" TEXT,
    "INSTALLATION_LOCATION" TEXT
);

-- Table: publicdata_transportation_11061__SELMETRO_HISTORICAL_CULTURE_AR
CREATE TABLE "aihub_transport"."publicdata_transportation_11061__SELMETRO_HISTORICAL_CULTURE_AR" (
    "LINE" NUMERIC,
    "STATION_NAME" TEXT,
    "LOCATION" TEXT,
    "ORNAMENT" TEXT,
    "TYPE" TEXT,
    "WRITER" TEXT,
    "QUANTITY" NUMERIC
);

-- Table: publicdata_transportation_11062__SELMETRO_ELEVATOR_I_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_11062__SELMETRO_ELEVATOR_I_INFO" (
    "ANNUAL" NUMERIC,
    "LINE" TEXT,
    "STATION_NAME" TEXT,
    "EQUIPMENT" TEXT,
    "AORY" TEXT,
    "ELEVATOR_NUMBER" TEXT,
    "OPERATING_SECTION" TEXT,
    "INSTALLATION_LOCATION" TEXT
);

-- Table: publicdata_transportation_11062__SELMETRO_HISTORICAL_AREA_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_11062__SELMETRO_HISTORICAL_AREA_INFO" (
    "LINE" NUMERIC,
    "STATION_NAME" TEXT,
    "WAITING_ROOM" NUMERIC,
    "PLATFORM" NUMERIC
);

-- Table: publicdata_transportation_11065__INFO_NUM_PEOPLE_DISABILITIES_P
CREATE TABLE "aihub_transport"."publicdata_transportation_11065__INFO_NUM_PEOPLE_DISABILITIES_P" (
    "ANNUAL" NUMERIC,
    "LINE" NUMERIC,
    "REVERSE_NUMBER" NUMERIC,
    "STATION_NAME" TEXT,
    "DIVISION" TEXT,
    "JANUARY_2022" NUMERIC,
    "FEBRUARY_2022" NUMERIC,
    "MARCH_2022" NUMERIC,
    "APRIL_2022" NUMERIC,
    "MAY_2022" NUMERIC
);

-- Table: publicdata_transportation_11065__SELMETRO_ELEVATOR_I_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_11065__SELMETRO_ELEVATOR_I_INFO" (
    "ANNUAL" NUMERIC,
    "LINE" TEXT,
    "STATION_NAME" TEXT,
    "EQUIPMENT" TEXT,
    "AORY" TEXT,
    "ELEVATOR_NUMBER" TEXT,
    "OPERATING_SECTION" TEXT,
    "INSTALLATION_LOCATION" TEXT
);

-- Table: publicdata_transportation_11068__INFO_NUM_ELDERLY_PEOPLE_GETTIN
CREATE TABLE "aihub_transport"."publicdata_transportation_11068__INFO_NUM_ELDERLY_PEOPLE_GETTIN" (
    "ANNUAL" NUMERIC,
    "LINE" NUMERIC,
    "REVERSE_NUMBER" NUMERIC,
    "STATION_NAME" TEXT,
    "DIVISION" TEXT,
    "JANUARY_2022" NUMERIC,
    "FEBRUARY_2022" NUMERIC,
    "MARCH_2022" NUMERIC,
    "APRIL_2022" NUMERIC,
    "MAY_2022" NUMERIC
);

-- Table: publicdata_transportation_11068__SELMETRO_ELEVATOR_I_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_11068__SELMETRO_ELEVATOR_I_INFO" (
    "ANNUAL" NUMERIC,
    "LINE" TEXT,
    "STATION_NAME" TEXT,
    "EQUIPMENT" TEXT,
    "AORY" TEXT,
    "ELEVATOR_NUMBER" TEXT,
    "OPERATING_SECTION" TEXT,
    "INSTALLATION_LOCATION" TEXT
);

-- Table: publicdata_transportation_11072__I_QUANTITY_SELMETRO_COMMODITY_
CREATE TABLE "aihub_transport"."publicdata_transportation_11072__I_QUANTITY_SELMETRO_COMMODITY_" (
    "NO" NUMERIC,
    "LINE_HONOR" NUMERIC,
    "STATION_NAME" TEXT,
    "SMALL_SIZE" NUMERIC,
    "MEDIUM_SIZE" NUMERIC,
    "BIG_SIZE" NUMERIC,
    "CONTROLLER" NUMERIC,
    "LINE_NUME" NUMERIC
);

-- Table: publicdata_transportation_11072__SELMETRO_COMMODITY_STORAGE_BOX
CREATE TABLE "aihub_transport"."publicdata_transportation_11072__SELMETRO_COMMODITY_STORAGE_BOX" (
    "NO" NUMERIC,
    "LINE_HONOR" NUMERIC,
    "STATION_NAME" TEXT,
    "LOCATION_INFO" TEXT
);

-- Table: publicdata_transportation_1108__STS_SELMETRO_UNMANNED_CIVIL_SER
CREATE TABLE "aihub_transport"."publicdata_transportation_1108__STS_SELMETRO_UNMANNED_CIVIL_SER" (
    "ANNUAL" NUMERIC,
    "LINE" NUMERIC,
    "STATION_NAME" TEXT,
    "INSTALLMENT" NUMERIC,
    "CONTRACTOR_NAME" TEXT,
    "DEVICE_TYPE" TEXT
);

-- Table: publicdata_transportation_11108__SELMETRO_ELEVATOR_I_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_11108__SELMETRO_ELEVATOR_I_INFO" (
    "ANNUAL" NUMERIC,
    "LINE" TEXT,
    "STATION_NAME" TEXT,
    "EQUIPMENT" TEXT,
    "AORY" TEXT,
    "ELEVATOR_NUMBER" TEXT,
    "OPERATING_SECTION" TEXT,
    "INSTALLATION_LOCATION" TEXT
);

-- Table: publicdata_transportation_11108__STS_SELMETRO_UNMANNED_CIVIL_SE
CREATE TABLE "aihub_transport"."publicdata_transportation_11108__STS_SELMETRO_UNMANNED_CIVIL_SE" (
    "ANNUAL" NUMERIC,
    "LINE" NUMERIC,
    "STATION_NAME" TEXT,
    "INSTALLMENT" NUMERIC,
    "CONTRACTOR_NAME" TEXT,
    "DEVICE_TYPE" TEXT
);

-- Table: publicdata_transportation_1122__DAILY_USE_NUBIZA_CHANGWON_GYEON
CREATE TABLE "aihub_transport"."publicdata_transportation_1122__DAILY_USE_NUBIZA_CHANGWON_GYEON" (
    "YEAR_MONTH_DAY" TEXT,
    "NUMBER_OF_USE" NUMERIC
);

-- Table: publicdata_transportation_1124__PARKING_LOT_STS_CHANGWON_SOUTH_
CREATE TABLE "aihub_transport"."publicdata_transportation_1124__PARKING_LOT_STS_CHANGWON_SOUTH_" (
    "ANNUAL" NUMERIC,
    "DIVISION" TEXT,
    "CONTACTS" TEXT,
    "NINE" TEXT,
    "EUPMYEON_DONG" TEXT,
    "PARKING_LOT" TEXT,
    "TENDON" TEXT,
    "NORMAL" NUMERIC,
    "DISABLED" NUMERIC,
    "ECO_FRIENDLY" NUMERIC,
    "NOTE" TEXT
);

-- Table: publicdata_transportation_1142__DETAILS_STREET_SECURITY_LAMP_FA
CREATE TABLE "aihub_transport"."publicdata_transportation_1142__DETAILS_STREET_SECURITY_LAMP_FA" (
    "DATE_OF_RECEIPT" TEXT,
    "DECLARATION" TEXT,
    "TYPE" TEXT,
    "BREAKDOWN" TEXT,
    "REPAIR_DATE" TEXT,
    "REPAIR_CONTENT" TEXT,
    "PROCESSING_RESULTS" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_transportation_1149__AVERAGE_DAILY_DRIVING_DISTANCE_
CREATE TABLE "aihub_transport"."publicdata_transportation_1149__AVERAGE_DAILY_DRIVING_DISTANCE_" (
    "DIVISION" NUMERIC,
    "TRIAL" TEXT,
    "PURPOSE" TEXT,
    "CAR_TYPE" TEXT,
    "DYNASTY" TEXT,
    "DAILY_AVERAGE_MILEAGE" NUMERIC
);

-- Table: publicdata_transportation_1169__STS_ILLEGAL_PARKING_CONTROL_SEO
CREATE TABLE "aihub_transport"."publicdata_transportation_1169__STS_ILLEGAL_PARKING_CONTROL_SEO" (
    "VIOLATION_DATE" TEXT,
    "VIOLATION_TIME" TEXT,
    "NAME_PLACE_VIOLATION" TEXT
);

-- Table: publicdata_transportation_1179__STS_ILLEGAL_PARKING_CONTROL_SEO
CREATE TABLE "aihub_transport"."publicdata_transportation_1179__STS_ILLEGAL_PARKING_CONTROL_SEO" (
    "ENFORCEMENT_AGENCY" TEXT,
    "CRACKDOWN" TEXT,
    "ENFORCEMENT_TIME" TEXT,
    "INTERSECTION" TEXT,
    "STANDARD_DATE" TEXT
);

-- Table: publicdata_transportation_117__NUM_CARS_REGISTERED_YEAR_BUSAN
CREATE TABLE "aihub_transport"."publicdata_transportation_117__NUM_CARS_REGISTERED_YEAR_BUSAN" (
    "YEAR" NUMERIC,
    "TOTAL" NUMERIC,
    "PASSENGER" NUMERIC,
    "VAN" NUMERIC,
    "FREIGHT" NUMERIC,
    "SPECIAL" NUMERIC,
    "NOTE" TEXT
);

-- Table: publicdata_transportation_11923__CURRENT_STS_CAR_REG_CHUNCHEON_
CREATE TABLE "aihub_transport"."publicdata_transportation_11923__CURRENT_STS_CAR_REG_CHUNCHEON_" (
    "CAR_TYPE" TEXT,
    "TOLERANCE" NUMERIC,
    "OWN_CAR" NUMERIC,
    "BUSINESS" NUMERIC,
    "COMMERCIAL" NUMERIC,
    "STANDARD_DATE" TEXT
);

-- Table: publicdata_transportation_11923__STS_VEHICLE_REG_JANGSEONG_GUN_
CREATE TABLE "aihub_transport"."publicdata_transportation_11923__STS_VEHICLE_REG_JANGSEONG_GUN_" (
    "CAR_TYPE" TEXT,
    "TOLERANCE" NUMERIC,
    "OWN_CAR" NUMERIC,
    "BUSINESS" NUMERIC,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_transportation_1207__MONTHLY_STS_ILLEGAL_PARKING_CON
CREATE TABLE "aihub_transport"."publicdata_transportation_1207__MONTHLY_STS_ILLEGAL_PARKING_CON" (
    "TRIAL_NAME" TEXT,
    "CITIES_AND_COUNTIES" TEXT,
    "CRACKDOWN" TEXT,
    "NUMBER_OF_CRACKDOWNS" NUMERIC
);

-- Table: publicdata_transportation_1211__INFO_ILLEGAL_PARKING_VIOLATIONS
CREATE TABLE "aihub_transport"."publicdata_transportation_1211__INFO_ILLEGAL_PARKING_VIOLATIONS" (
    "SORTATION" TEXT,
    "VIOLATION_DATE" TEXT,
    "VIOLATION_TIME" TEXT,
    "PLACE_VIOLATION" TEXT,
    "DATE_IMPOSITION_FINE" TEXT,
    "DATA_BASE_DATE" TEXT
);

-- Table: publicdata_transportation_1214__MOLIT_DICTIONARY_AERONAUTICAL_T
CREATE TABLE "aihub_transport"."publicdata_transportation_1214__MOLIT_DICTIONARY_AERONAUTICAL_T" (
    "TERM" TEXT,
    "KOREAN_NAME" TEXT,
    "ABBREVIATIONS" TEXT,
    "COMMENTARY" TEXT
);

-- Table: publicdata_transportation_1219__KNR_RAILWAY_COMMON_SENSE
CREATE TABLE "aihub_transport"."publicdata_transportation_1219__KNR_RAILWAY_COMMON_SENSE" (
    "POST_NUMBER" NUMERIC,
    "TITLE" TEXT,
    "CONTENTS" TEXT,
    "REGISTRATION_DATE" TEXT
);

-- Table: publicdata_transportation_1227__STS_ILLEGAL_PARKING_CONTROL_DON
CREATE TABLE "aihub_transport"."publicdata_transportation_1227__STS_ILLEGAL_PARKING_CONTROL_DON" (
    "VIOLATION_DATE" TEXT,
    "VIOLATION_TIME" TEXT,
    "NAME_PLACE_VIOLATION" TEXT
);

-- Table: publicdata_transportation_1232__MONTHLY_STS_ILLEGAL_PARKING_CON
CREATE TABLE "aihub_transport"."publicdata_transportation_1232__MONTHLY_STS_ILLEGAL_PARKING_CON" (
    "MONTH_ENFORCEMENT" TEXT,
    "NUMBER_CRACKDOWNS" NUMERIC
);

-- Table: publicdata_transportation_1306__INFO_STREET_EQUIVALENT_WARFARE_
CREATE TABLE "aihub_transport"."publicdata_transportation_1306__INFO_STREET_EQUIVALENT_WARFARE_" (
    "SUBJECT_ID" NUMERIC,
    "ADMINISTRATIVE_BUILDING" TEXT,
    "INSTALLATION_LOCATION" TEXT,
    "DIVISION" TEXT,
    "LAMP_QUANTITY" NUMERIC,
    "MANAGEMENT_AGENCY" TEXT,
    "LATITUDE" NUMERIC,
    "HARDNESS" NUMERIC,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_transportation_1316__BUSAN_TRN_FAC_MNG_SYS_TRAFFIC_S
CREATE TABLE "aihub_transport"."publicdata_transportation_1316__BUSAN_TRN_FAC_MNG_SYS_TRAFFIC_S" (
    "CONTROL_NUMBER" TEXT,
    "CITIES_AND_COUNTIES" TEXT,
    "SAME_NAME" TEXT,
    "LI_NAME" TEXT,
    "TENDON" TEXT,
    "ROAD_NAME" TEXT,
    "CORD" NUMERIC,
    "DONG_CODE" NUMERIC,
    "RECODE" NUMERIC,
    "INTERSECTION" TEXT,
    "HARDNESS" NUMERIC,
    "LATITUDE" NUMERIC
);

-- Table: publicdata_transportation_1317__CURRENT_STS_INTERN_LOGISTICS_CO
CREATE TABLE "aihub_transport"."publicdata_transportation_1317__CURRENT_STS_INTERN_LOGISTICS_CO" (
    "MUTUAL_NAME" TEXT,
    "BUSINESS_STATUS" TEXT,
    "CORPORATION" TEXT,
    "STREET_NAME_ADDRESS" TEXT
);

-- Table: publicdata_transportation_1339__STS_ILLEGAL_PARKING_CONTROL_SUS
CREATE TABLE "aihub_transport"."publicdata_transportation_1339__STS_ILLEGAL_PARKING_CONTROL_SUS" (
    "DATE_ENFORCEMENT_DATE" TEXT,
    "CONTROL_TIME" TEXT,
    "PLACE_CONTROL" TEXT
);

-- Table: publicdata_transportation_13780__GGGJ_EUP_MYEON_DONG_CD
CREATE TABLE "aihub_transport"."publicdata_transportation_13780__GGGJ_EUP_MYEON_DONG_CD" (
    "ADMINISTRATIVE_NMD" TEXT,
    "ADMINISTRATIVE_DONG_CDE" NUMERIC,
    "LEGAL_NMF" TEXT,
    "CD_LEGAL_DONGG" NUMERIC,
    "LEGAL_CLASSH" TEXT,
    "STATUTORY_CLUB_CDI" NUMERIC
);

-- Table: publicdata_transportation_13780__GGGJ_MEDIAN_STRIP
CREATE TABLE "aihub_transport"."publicdata_transportation_13780__GGGJ_MEDIAN_STRIP" (
    "GEOGRAPHICAL_FEATURE_CDJ" TEXT,
    "MANAGEMENT_NUMK" NUMERIC,
    "A_D_O" TEXT,
    "LEGAL_AREAM" TEXT,
    "ADMINISTRATIVE_AGENCYN" TEXT,
    "ROAD_SET_NUMO" NUMERIC,
    "POINT_LOCP" TEXT,
    "LOC_END_POINTQ" TEXT,
    "INS_DTR" TEXT,
    "KINDS" TEXT,
    "EXTT" TEXT,
    "STORM_SURGEU" NUMERIC,
    "HEIGHTV" NUMERIC,
    "NOTEW" TEXT,
    "NUMX" TEXT
);

-- Table: publicdata_transportation_1379__TAXI_STAND_ANSAN_GYEONGGI_PROVI
CREATE TABLE "aihub_transport"."publicdata_transportation_1379__TAXI_STAND_ANSAN_GYEONGGI_PROVI" (
    "MANAGEMENT_NAME" TEXT,
    "PLATFORM" TEXT,
    "PLATFORM_LOCATION_ADDRESS" TEXT,
    "PLATFORM_STRUCTURE" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_transportation_1395__CURRENT_STS_REGISTERED_INTERN_L
CREATE TABLE "aihub_transport"."publicdata_transportation_1395__CURRENT_STS_REGISTERED_INTERN_L" (
    "COMPANY_NAME" TEXT,
    "CORPORATE" TEXT,
    "LOCATION" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_transportation_1504__MONTHLY_CRACKDOWN_ILLEGAL_PARKI
CREATE TABLE "aihub_transport"."publicdata_transportation_1504__MONTHLY_CRACKDOWN_ILLEGAL_PARKI" (
    "CITIES_AND_COUNTIES" TEXT,
    "PENALTY" TEXT,
    "CRACKDOWN" TEXT,
    "ENFORCEMENT" NUMERIC,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_transportation_1541__MONTHLY_STS_ILLEGAL_PARKING_CON
CREATE TABLE "aihub_transport"."publicdata_transportation_1541__MONTHLY_STS_ILLEGAL_PARKING_CON" (
    "TRIAL_NAME" TEXT,
    "CITIES_AND_COUNTIES" TEXT,
    "CRACKDOWN" TEXT,
    "NUMBER_OF_CRACKDOWNS" NUMERIC
);

-- Table: publicdata_transportation_1564__CURRENT_STS_PASSENGERS_BUS_STOP
CREATE TABLE "aihub_transport"."publicdata_transportation_1564__CURRENT_STS_PASSENGERS_BUS_STOP" (
    "RECTIFICATION" TEXT,
    "STOP_NUMBER_ARS_ID" NUMERIC,
    "KWON_JONG_SEON" TEXT,
    "RIDING" TEXT,
    "TRANSACTION_CNT" NUMERIC
);

-- Table: publicdata_transportation_1574__STS_PARKING_CONTROL_SEOCHO_GU_S
CREATE TABLE "aihub_transport"."publicdata_transportation_1574__STS_PARKING_CONTROL_SEOCHO_GU_S" (
    "CITIES_AND_COUNTIES" TEXT,
    "CRACKDOWN" TEXT,
    "NUMBER_OF_CRACKDOWNS" NUMERIC
);

-- Table: publicdata_transportation_1587__STS_ILLEGAL_PARKING_CONTROL_YEO
CREATE TABLE "aihub_transport"."publicdata_transportation_1587__STS_ILLEGAL_PARKING_CONTROL_YEO" (
    "CRACKDOWN" TEXT,
    "NUMBER_OF_CRACKDOWNS" NUMERIC,
    "MANAGEMENT_DEPARTMENT" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_transportation_159__ICTR_INCHEON_SUBWAY_STATION_ADDR
CREATE TABLE "aihub_transport"."publicdata_transportation_159__ICTR_INCHEON_SUBWAY_STATION_ADDR" (
    "DIVISION" TEXT,
    "STATION_NAME" TEXT,
    "PHONE_NUMBER" TEXT,
    "ADDRESS" TEXT
);

-- Table: publicdata_transportation_1618__STS_PARKING_CONTROL_SUWON_GYEON
CREATE TABLE "aihub_transport"."publicdata_transportation_1618__STS_PARKING_CONTROL_SUWON_GYEON" (
    "CITIES_AND_COUNTIES" TEXT,
    "DISTINCTION" TEXT,
    "CRACKDOWN" TEXT,
    "INTERMITTENT" TEXT,
    "NUMBER_OF_CRACKDOWNS" NUMERIC,
    "ENFORCEMENT" NUMERIC,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_transportation_1635__MONTHLY_CRACKDOWN_ILLEGAL_PARKI
CREATE TABLE "aihub_transport"."publicdata_transportation_1635__MONTHLY_CRACKDOWN_ILLEGAL_PARKI" (
    "CRACKDOWN" TEXT,
    "NUMBER_OF_CRACKDOWNS" NUMERIC
);

-- Table: publicdata_transportation_1748__STS_PARKING_CONTROL_JUNGNANG_GU
CREATE TABLE "aihub_transport"."publicdata_transportation_1748__STS_PARKING_CONTROL_JUNGNANG_GU" (
    "TRIAL_NAME" TEXT,
    "CITIES_AND_COUNTIES" TEXT,
    "CRACKDOWN" TEXT,
    "NUMBER_OF_CRACKDOWNS" NUMERIC
);

-- Table: publicdata_transportation_1802__KCG_GUIDE_SHIP_SITE_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_1802__KCG_GUIDE_SHIP_SITE_INFO" (
    "MUTUAL_NAME" TEXT,
    "BUSINESS_LOCATION" TEXT,
    "OFFICE_NUMBER" TEXT
);

-- Table: publicdata_transportation_1850__STS_REGISTERED_INTERN_LOGISTICS
CREATE TABLE "aihub_transport"."publicdata_transportation_1850__STS_REGISTERED_INTERN_LOGISTICS" (
    "ANNUAL" NUMERIC,
    "REGISTRATION_NUMBER" NUMERIC,
    "COMPANY_NAME" TEXT,
    "ADDRESS" TEXT,
    "TOWNSHIP" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_transportation_1871__TOTAL_NUM_PARKING_VIOLATIONS_GU
CREATE TABLE "aihub_transport"."publicdata_transportation_1871__TOTAL_NUM_PARKING_VIOLATIONS_GU" (
    "HOUSEHOLD" TEXT,
    "CITIES" TEXT,
    "DISPLACEMENT" NUMERIC,
    "COLLEGATION" NUMERIC,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_transportation_1917__CURRENT_STS_BUS_LINES_TOWNSHIP_
CREATE TABLE "aihub_transport"."publicdata_transportation_1917__CURRENT_STS_BUS_LINES_TOWNSHIP_" (
    "DIVISION" TEXT,
    "ROUTE_NUMBER" TEXT,
    "ROUTE" TEXT,
    "NOTE" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_transportation_1921__CURRENT_STS_BUS_ROUTES_JEJU_CIT
CREATE TABLE "aihub_transport"."publicdata_transportation_1921__CURRENT_STS_BUS_ROUTES_JEJU_CIT" (
    "DIVISION" TEXT,
    "ROUTE_NUMBER" NUMERIC,
    "ROUTE_INFORMATION" TEXT,
    "NOTE" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_transportation_1940__KOTSA_AUTOMOBILE_MANUFACTURING_
CREATE TABLE "aihub_transport"."publicdata_transportation_1940__KOTSA_AUTOMOBILE_MANUFACTURING_" (
    "DATE_OF_RECEIPT" TEXT,
    "PRODUCER" TEXT,
    "NOMINATION" TEXT,
    "MODEL_YEAR" NUMERIC
);

-- Table: publicdata_transportation_1996__STS_KOTSA_N_HIGHWAY_FAC
CREATE TABLE "aihub_transport"."publicdata_transportation_1996__STS_KOTSA_N_HIGHWAY_FAC" (
    "REGION" TEXT,
    "COMPANY_NAME" TEXT,
    "LOCATION" TEXT,
    "COMPLETION_DATE" TEXT,
    "PURPOSE" TEXT,
    "ROUND_TRIP" NUMERIC,
    "AUTOMATIC_CIRCULATION" NUMERIC,
    "FIXED_CIRCULATION" NUMERIC,
    "TOWING" NUMERIC,
    "CARGO" NUMERIC,
    "HYPOTHESIS" NUMERIC,
    "TOTAL" NUMERIC
);

-- Table: publicdata_transportation_2056__LIST_BUS_STOPS_JUNGANG_RO_SEOUL
CREATE TABLE "aihub_transport"."publicdata_transportation_2056__LIST_BUS_STOPS_JUNGANG_RO_SEOUL" (
    "STANDARD_ID" NUMERIC,
    "ARS_ID" NUMERIC,
    "RECTIFICATION" TEXT,
    "X_COORDINATES" NUMERIC,
    "Y_COORDINATE" NUMERIC
);

-- Table: publicdata_transportation_206__MAJOR_SPECIFICATIONS_KALIS_P_BRI
CREATE TABLE "aihub_transport"."publicdata_transportation_206__MAJOR_SPECIFICATIONS_KALIS_P_BRI" (
    "FACILITY_NAME" TEXT,
    "ADDRESS" TEXT,
    "BRIDGE_TYPE" TEXT,
    "BRIDGE_EXTENSION" NUMERIC,
    "LANE_NUMBER" NUMERIC,
    "SPAN_NUMBER" NUMERIC,
    "MAXIMUM_SPAN_COUNT" NUMERIC
);

-- Table: publicdata_transportation_2094__INFO_SEIZURE_ILLEGAL_PARKING_VE
CREATE TABLE "aihub_transport"."publicdata_transportation_2094__INFO_SEIZURE_ILLEGAL_PARKING_VE" (
    "CITIES_AND_COUNTIES" TEXT,
    "PENALTY" TEXT,
    "PROCESSING_STATE" TEXT,
    "SEIZURE_DATE" TEXT,
    "MAIN_TAX" NUMERIC,
    "ADDITIONAL_MONEY" NUMERIC,
    "UNPAID_AMOUNT" NUMERIC,
    "DISTINCTION" TEXT,
    "CRACKDOWN" TEXT,
    "INTERSECTION" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_transportation_2107__ROUTE_NO_TABLE_RURAL_BUSES_CHEO
CREATE TABLE "aihub_transport"."publicdata_transportation_2107__ROUTE_NO_TABLE_RURAL_BUSES_CHEO" (
    "TOWN" TEXT,
    "ROUTE_NUMBER" NUMERIC,
    "STARTING_POINT" TEXT,
    "PASSAGE_1" TEXT,
    "PASSAGE_2" TEXT,
    "THROUGH_3" TEXT,
    "PASSAGE_4" TEXT,
    "PASSAGE_5" TEXT,
    "TERMINAL" TEXT,
    "DIRECTION" TEXT
);

-- Table: publicdata_transportation_2153__I_STS_BUS_INFO_BOARD_GURI_GYEON
CREATE TABLE "aihub_transport"."publicdata_transportation_2153__I_STS_BUS_INFO_BOARD_GURI_GYEON" (
    "RECTIFICATION" TEXT,
    "STOP" TEXT,
    "ROAD_NAME" TEXT,
    "BUS_MODEL" TEXT,
    "INSTALLATION_YEAR" NUMERIC,
    "EUPMYEONG_DONG" TEXT,
    "MANAGEMENT_NAME" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_transportation_2161__STS_REGISTERED_INTERN_LOGISTICS
CREATE TABLE "aihub_transport"."publicdata_transportation_2161__STS_REGISTERED_INTERN_LOGISTICS" (
    "ANNUAL" NUMERIC,
    "COMPANY_NAME" TEXT,
    "REPRESENTATIVE" TEXT,
    "PHONE_NUMBER" TEXT,
    "STREET_NAME_ADDRESS" TEXT,
    "LATITUDE" NUMERIC,
    "HARDNESS" NUMERIC,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_transportation_2175__L_INFO_CCTV_I_GWANGJU_GYEONGGI
CREATE TABLE "aihub_transport"."publicdata_transportation_2175__L_INFO_CCTV_I_GWANGJU_GYEONGGI" (
    "ANNUAL" NUMERIC,
    "CONTROL_NUMBER" NUMERIC,
    "ADMINISTRATIVE_BUILDING" TEXT,
    "ADDRESS" TEXT,
    "EMERGENCY_BELL" TEXT,
    "LATITUDE" NUMERIC,
    "HARDNESS" NUMERIC
);

-- Table: publicdata_transportation_2207__GGGJ_ROAD_SIGN
CREATE TABLE "aihub_transport"."publicdata_transportation_2207__GGGJ_ROAD_SIGN" (
    "GEOGRAPHICAL_FEATURE_CDK" TEXT,
    "MANAGEMENT_NUML" NUMERIC,
    "A_D_H" TEXT,
    "LEGAL_AREAN" TEXT,
    "ADMINISTRATIVE_AGENCYO" TEXT,
    "ROAD_SET_NUMP" NUMERIC,
    "LOC_POINTQ" TEXT,
    "POSITION_DIRECTIONR" TEXT,
    "COVER_TYPES" TEXT,
    "COVER_NMT" TEXT,
    "LANDLORD_TYPEU" TEXT,
    "HEIGHTV" NUMERIC,
    "STANDARDW" TEXT,
    "INS_DTX" NUMERIC,
    "ACQUISITION_CLASY" TEXT,
    "ACQUISITION_AMTZ" NUMERIC,
    "MANAGEMENT_DEPARTMENTA" TEXT,
    "USEFUL_LIFEB" NUMERIC,
    "NOTEC" TEXT,
    "HARDNESSD" NUMERIC,
    "LATITUDEE" NUMERIC
);

-- Table: publicdata_transportation_2211__GGGJ_FALLING_STONE_PREVENTION_F
CREATE TABLE "aihub_transport"."publicdata_transportation_2211__GGGJ_FALLING_STONE_PREVENTION_F" (
    "GEOGRAPHICAL_FEATURE_CDF" TEXT,
    "MANAGEMENT_NUMG" NUMERIC,
    "A_D_CV" TEXT,
    "LEGAL_AREAI" TEXT,
    "ADMINISTRATIVE_AGENCYJ" TEXT,
    "ROAD_SET_NUMK" NUMERIC,
    "POINT_LOCL" TEXT,
    "LOC_END_POINTM" TEXT,
    "DIRECTIONN" TEXT,
    "INS_DTO" TEXT,
    "P_F_C_F" TEXT,
    "QUALITY_MATERIALQ" TEXT,
    "EXTR" NUMERIC,
    "HEIGHTS" NUMERIC,
    "ACQUISITION_CLAST" TEXT,
    "ACQUISITION_AMTU" TEXT,
    "MANAGEMENT_DEPARTMENTV" TEXT,
    "USEFUL_LIFEW" NUMERIC,
    "NOTEX" TEXT,
    "NUMY" NUMERIC
);

-- Table: publicdata_transportation_2324__C_STS_GB_KC_FOOD_DISTRIBUTION_B
CREATE TABLE "aihub_transport"."publicdata_transportation_2324__C_STS_GB_KC_FOOD_DISTRIBUTION_B" (
    "SERIAL_NUMB" NUMERIC,
    "BUSINESS_NMC" TEXT,
    "BUSINESS_NMD" TEXT,
    "ROAD_NM_LOCE" TEXT,
    "LOC_NUMF" TEXT,
    "LOCAL_TELEPHONE_NUMG" TEXT,
    "ZIP_CD_ROAD_NMH" NUMERIC,
    "DATA_BASE_DTI" TEXT
);

-- Table: publicdata_transportation_2338__STS_GGBC_VE_TAX_DEFERRED_VE_LIC
CREATE TABLE "aihub_transport"."publicdata_transportation_2338__STS_GGBC_VE_TAX_DEFERRED_VE_LIC" (
    "SERIAL_NUMP" NUMERIC,
    "RETENTION_DTQ" TEXT,
    "VEHICLE_NUMR" TEXT,
    "NUM_ARREARSS" NUMERIC,
    "AMT_ARREARST" NUMERIC,
    "PLACE_DETENTIONU" TEXT,
    "RETURN_DTV" TEXT
);

-- Table: publicdata_transportation_2359__GG_YP_VE_REG_STS
CREATE TABLE "aihub_transport"."publicdata_transportation_2359__GG_YP_VE_REG_STS" (
    "SORTATIONE" TEXT,
    "SUMF" NUMERIC,
    "TOLERANCEG" NUMERIC,
    "ONE_OWNH" NUMERIC,
    "BUSINESS_USEI" NUMERIC
);

-- Table: publicdata_transportation_2447__GGPJ_PARKING_VIOLATION_STS
CREATE TABLE "aihub_transport"."publicdata_transportation_2447__GGPJ_PARKING_VIOLATION_STS" (
    "MODEL_CARA" TEXT,
    "DT_TIME_CRACKDOWNB" TEXT,
    "CRACKDOWN_BUILDINGC" TEXT,
    "PLACE_CRACKDOWND" TEXT,
    "BASE_DTE" TEXT
);

-- Table: publicdata_transportation_2483__STS_GGUP_BUS_STOP
CREATE TABLE "aihub_transport"."publicdata_transportation_2483__STS_GGUP_BUS_STOP" (
    "STATION_TYPEO" TEXT,
    "STOP_NUMP" NUMERIC,
    "NM_BUS_STOPQ" TEXT,
    "LATITUDER" NUMERIC,
    "HARDNESSS" NUMERIC,
    "BENCH_PRESENCET" TEXT,
    "FAUCET_STAU" TEXT,
    "LIGHTING_STAV" TEXT,
    "BUS_INF_SYS_BIS_PRESENTW" TEXT,
    "DATA_BASE_DTX" TEXT
);

-- Table: publicdata_transportation_2524__NUM_PASSENGERS_STATION_BUCHEON_
CREATE TABLE "aihub_transport"."publicdata_transportation_2524__NUM_PASSENGERS_STATION_BUCHEON_" (
    "DT_TIMEL" TEXT,
    "KKACHIUL_STATION_SYSM" NUMERIC,
    "MAGPIE_RIDEN" NUMERIC,
    "G_O_K_S_U" NUMERIC,
    "B_S_C_S_S_V" NUMERIC,
    "B_S_C_S_R_W" NUMERIC,
    "G_O_B_S_C_S_X" NUMERIC,
    "SPRING_CALENDARS" NUMERIC,
    "REVERSE_SPRING_RIDET" NUMERIC,
    "SPRING_TRAINU" NUMERIC,
    "S_E_S_S_VA" NUMERIC,
    "NEW_EAST_STATION_RIDEW" NUMERIC,
    "N_E_S_D_DE" NUMERIC,
    "B_C_H_S_XZ" NUMERIC,
    "B_B_C_H_S_A" NUMERIC,
    "G_O_B_C_H_S_BB" NUMERIC,
    "HOMOLOGOUS_SYSB" NUMERIC,
    "SANGDONG_STATION_RIDEC" NUMERIC,
    "G_O_S_S_EA" NUMERIC
);

-- Table: publicdata_transportation_2540__GGAY_SPACE_INFO_SYS_ROAD_SIGNAG
CREATE TABLE "aihub_transport"."publicdata_transportation_2540__GGAY_SPACE_INFO_SYS_ROAD_SIGNAG" (
    "MANAGEMENT_NUMC" NUMERIC,
    "HEIGHTD" NUMERIC,
    "HORIZONTAL_STANDARDE" NUMERIC,
    "VERTICAL_SPECIFICATIONF" NUMERIC,
    "STANDARDG" TEXT,
    "JURISDICTIONH" TEXT,
    "INS_DTI" TEXT
);

-- Table: publicdata_transportation_2541__C_STS_GGAY_SPATIAL_INFO_SYS_CRO
CREATE TABLE "aihub_transport"."publicdata_transportation_2541__C_STS_GGAY_SPATIAL_INFO_SYS_CRO" (
    "MANAGEMENT_NUMJ" NUMERIC,
    "WIDTH_CROSSWALKK" NUMERIC,
    "CROSSWALK_LENGTHL" NUMERIC,
    "JURISDICTIONM" TEXT,
    "INS_DTN" TEXT
);

-- Table: publicdata_transportation_2563__GNGH_LONG_TERM_UNLEASHED_VE_TOW
CREATE TABLE "aihub_transport"."publicdata_transportation_2563__GNGH_LONG_TERM_UNLEASHED_VE_TOW" (
    "NUMC" NUMERIC,
    "DT_RECEPTIOND" TEXT,
    "MODEL_CARE" TEXT,
    "COLORF" TEXT,
    "ADMINISTRATIVE_BUILDINGG" TEXT,
    "TOWING_DTH" TEXT
);

-- Table: publicdata_transportation_2571__C_STS_GNGH_CITY_BUS_SERVICE
CREATE TABLE "aihub_transport"."publicdata_transportation_2571__C_STS_GNGH_CITY_BUS_SERVICE" (
    "BUSINESS_CLASJ" TEXT,
    "ROUTE_NUMK" TEXT,
    "STARTING_POINTL" TEXT,
    "LAST_STOPM" TEXT,
    "FIRST_ROUNDN" TEXT,
    "LAST_TRAINO" TEXT,
    "ALLOC_INTERVALP" TEXT,
    "NUM_VEHICLES_OPERATIONQ" NUMERIC,
    "DISTANCE_KILOMETERSR" NUMERIC,
    "STOPOVERS" TEXT
);

-- Table: publicdata_transportation_2610__TF_STS_GNGH_WIDE_AREA_TF_INFO_S
CREATE TABLE "aihub_transport"."publicdata_transportation_2610__TF_STS_GNGH_WIDE_AREA_TF_INFO_S" (
    "ROAD_NUMU" NUMERIC,
    "ROAD_NMV" TEXT,
    "DIRECTIONW" TEXT,
    "STARTING_POINTX" TEXT,
    "LAST_POINTY" TEXT,
    "ZONE_LENGTHZ" NUMERIC,
    "START_POINT_CDA" NUMERIC,
    "END_POINT_CDB" NUMERIC,
    "AVG_SPEEDC" NUMERIC,
    "TRAFFIC_VOLUMED" NUMERIC,
    "TRAFFIC_CONDITIONSE" TEXT,
    "DT_TIMEF" TEXT
);

-- Table: publicdata_transportation_2631__GNYS_FREIGHT_CARRIER_STS
CREATE TABLE "aihub_transport"."publicdata_transportation_2631__GNYS_FREIGHT_CARRIER_STS" (
    "INDUSTRYG" TEXT,
    "MUTUALH" TEXT,
    "BUSINESS_OFFICE_ADDRESSI" TEXT,
    "PHONE_NUMJ" TEXT
);

-- Table: publicdata_transportation_2746__GGAS_CROSSWALK_L_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_2746__GGAS_CROSSWALK_L_INFO" (
    "CITY_PROVINCEU" TEXT,
    "NM_CITY_COUNTY_DISTRICTV" TEXT,
    "LATITUDEW" NUMERIC,
    "HARDNESSX" NUMERIC,
    "DATA_BASE_DTY" TEXT
);

-- Table: publicdata_transportation_2770__GGAY_SPATIAL_INFO_SYS_TF_LIGHT_
CREATE TABLE "aihub_transport"."publicdata_transportation_2770__GGAY_SPATIAL_INFO_SYS_TF_LIGHT_" (
    "MANAGEMENT_NUMZ" NUMERIC,
    "TRAFFIC_LIGHT_NUMA" NUMERIC,
    "T_L_S_EA" TEXT,
    "JURISDICTIONC" TEXT,
    "INS_DTD" TEXT
);

-- Table: publicdata_transportation_2772__TF_SIGNAGE_STS_GGAY_SPATIAL_INF
CREATE TABLE "aihub_transport"."publicdata_transportation_2772__TF_SIGNAGE_STS_GGAY_SPATIAL_INF" (
    "MANAGEMENT_NUMM" NUMERIC,
    "HEIGHTN" NUMERIC,
    "JURISDICTIONO" TEXT,
    "INS_DTP" TEXT
);

-- Table: publicdata_transportation_2774__C_STS_GGAY_SPACE_INFO_SYS_SPEED
CREATE TABLE "aihub_transport"."publicdata_transportation_2774__C_STS_GGAY_SPACE_INFO_SYS_SPEED" (
    "MANAGEMENT_NUMY" NUMERIC,
    "STORM_SURGEZ" NUMERIC,
    "EXTA" NUMERIC,
    "JURISDICTIONB" TEXT,
    "INS_DTC" TEXT
);

-- Table: publicdata_transportation_2807__STS_GGY_BUS_STOP
CREATE TABLE "aihub_transport"."publicdata_transportation_2807__STS_GGY_BUS_STOP" (
    "STANDARD_ID_BUS_STOPJ" NUMERIC,
    "BUS_STOP_NUMK" NUMERIC,
    "NM_BUS_STOPL" TEXT,
    "TRANSIT_ROUTEM" TEXT,
    "LATITUDEN" NUMERIC,
    "HARDNESSO" NUMERIC
);

-- Table: publicdata_transportation_2846__M_BOARDING_LEAVING_P_KORAIL_PYE
CREATE TABLE "aihub_transport"."publicdata_transportation_2846__M_BOARDING_LEAVING_P_KORAIL_PYE" (
    "OPERATION_YEAR_MONTHU" TEXT,
    "UP_DOWN_CLASV" TEXT,
    "UNITW" TEXT,
    "NUM_PASSENGERSX" NUMERIC,
    "N_P_W_G_O_T_DE" NUMERIC
);

-- Table: publicdata_transportation_2860__MOIS_GUIDE_SHIP_OPERATOR
CREATE TABLE "aihub_transport"."publicdata_transportation_2860__MOIS_GUIDE_SHIP_OPERATOR" (
    "NUMR" NUMERIC,
    "LICENSING_AGENCYS" TEXT,
    "MUTUALT" TEXT,
    "SORTATIONU" TEXT,
    "REPRESENTATIVE_NMV" TEXT,
    "ADDRESSW" TEXT
);

-- Table: publicdata_transportation_2867__MOIS_N_HOLIDAY_FREE_PARKING_LOT
CREATE TABLE "aihub_transport"."publicdata_transportation_2867__MOIS_N_HOLIDAY_FREE_PARKING_LOT" (
    "YEAR_WORKG" NUMERIC,
    "HOLIDAY_CLASH" TEXT,
    "NUMI" NUMERIC,
    "RESOURCE_NMJ" TEXT,
    "M_I_C_Q" TEXT,
    "NM_ORGANIZATIONL" TEXT,
    "NM_PERSON_CHARGEM" TEXT,
    "CONTACT_USN" TEXT,
    "CITY_PROVINCEO" TEXT,
    "C_C_C_D_V" TEXT,
    "ADDRESSQ" TEXT,
    "DETAILED_ADDRESSR" TEXT,
    "PARKING_LOT_TYPES" TEXT,
    "HOLIDAY_OPEN_DAYT" TEXT,
    "HOLIDAY_OPEN_DAYU" TEXT,
    "HOLIDAY_OPEN_DAYV" TEXT,
    "HOLIDAY_OPEN_DAYW" TEXT,
    "HOLIDAY_OPENING_HOURSX" TEXT,
    "HOLIDAY_OPENING_HOURSY" TEXT,
    "HOLIDAY_OPENING_HOURSZ" TEXT,
    "HOLIDAY_OPENING_HOURSA" TEXT,
    "NOTES_REFERENCEB" TEXT,
    "HARDNESSC" NUMERIC,
    "LATITUDED" NUMERIC
);

-- Table: publicdata_transportation_2939__C_STS_GNGH_CITY_BUS_STOP
CREATE TABLE "aihub_transport"."publicdata_transportation_2939__C_STS_GNGH_CITY_BUS_STOP" (
    "SERIAL_NUMD" TEXT,
    "CITY_COUNTY_NME" TEXT,
    "ADMINISTRATIVE_BUILDINGF" TEXT,
    "NM_BUS_STOPG" TEXT,
    "CD_NUMH" NUMERIC,
    "LOCI" TEXT,
    "MANAGEMENT_DEPARTMENTJ" TEXT,
    "CONTACT_USK" TEXT,
    "DATA_BASE_DTL" TEXT
);

-- Table: publicdata_transportation_2987__STS_GGAS_BUS_INFO_TERMINAL
CREATE TABLE "aihub_transport"."publicdata_transportation_2987__STS_GGAS_BUS_INFO_TERMINAL" (
    "NM_BUS_STOPU" TEXT,
    "DEVICE_TYPEV" TEXT,
    "TYPEW" TEXT,
    "ADDRESSX" TEXT,
    "LATITUDEY" NUMERIC,
    "HARDNESSZ" NUMERIC,
    "INS_YEARA" NUMERIC,
    "DATA_BASE_DTB" TEXT
);

-- Table: publicdata_transportation_3005__GNGJ_TOBACCO_RETAILER_REG_STS
CREATE TABLE "aihub_transport"."publicdata_transportation_3005__GNGJ_TOBACCO_RETAILER_REG_STS" (
    "SERIAL_NUMV" NUMERIC,
    "BUSINESS_NMW" TEXT,
    "BUSINESS_ADDRESSX" TEXT,
    "B_R_N_A_C" TEXT,
    "B_A_P_C_DE" TEXT,
    "DESIGNATED_DTA" TEXT,
    "CORPORATE_CLASB" TEXT,
    "BUSINESS_CLASC" TEXT,
    "BASE_DTD" TEXT
);

-- Table: publicdata_transportation_3021__STS_VIOLATION_GGMP_PARKING_C
CREATE TABLE "aihub_transport"."publicdata_transportation_3021__STS_VIOLATION_GGMP_PARKING_C" (
    "TOTAL_YEAR_MONTHV" TEXT,
    "CITY_COUNTY_NMW" TEXT,
    "NUM_IMPOSED_CASESX" NUMERIC,
    "NUM_COLLECTIONSY" NUMERIC,
    "DATA_BASE_DTZ" TEXT
);

-- Table: publicdata_transportation_3028__STS_GGMP_ROAD_OCCUPANCY_EXCAVAT
CREATE TABLE "aihub_transport"."publicdata_transportation_3028__STS_GGMP_ROAD_OCCUPANCY_EXCAVAT" (
    "PERMISSION_YEAR_NUMS" TEXT,
    "PERMISSION_DTT" TEXT,
    "END_OCCUPATION_DTU" TEXT,
    "PURPOSE_OCCUPATIONV" TEXT,
    "LOCW" TEXT,
    "METER_LENGTHX" NUMERIC,
    "WIDTH_METERY" NUMERIC,
    "TUBE_METERZ" NUMERIC,
    "DATA_BASE_DTA" TEXT
);

-- Table: publicdata_transportation_3032__I_STS_GG_SU_BUS_ARRIVAL_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_3032__I_STS_GG_SU_BUS_ARRIVAL_INFO" (
    "SERIAL_NUMB" NUMERIC,
    "NM_BUS_STOPC" TEXT,
    "BUS_STOP_NUMD" NUMERIC,
    "YEAR_INSE" NUMERIC,
    "EQUIPMENT_TYPEF" TEXT,
    "EQUIPMENT_TYPEG" TEXT
);

-- Table: publicdata_transportation_3057__MOIS_GUIDE_SHIP
CREATE TABLE "aihub_transport"."publicdata_transportation_3057__MOIS_GUIDE_SHIP" (
    "NUMK" NUMERIC,
    "ADMINISTRATIVE_AGENCYL" TEXT,
    "VESSEL_NMM" TEXT,
    "SHIP_TYPEN" TEXT,
    "BUSINESS_CLASO" TEXT,
    "RE_CLASP" TEXT,
    "TONNAGEQ" NUMERIC
);

-- Table: publicdata_transportation_3059__STS_PASSENGERS_MOIS_GUIDE_LINE
CREATE TABLE "aihub_transport"."publicdata_transportation_3059__STS_PASSENGERS_MOIS_GUIDE_LINE" (
    "YEARR" NUMERIC,
    "REGIONS" TEXT,
    "SUMT" NUMERIC,
    "JANU" NUMERIC,
    "FEBV" NUMERIC,
    "MARW" NUMERIC,
    "APRX" NUMERIC,
    "MAYY" NUMERIC,
    "JUNZ" NUMERIC,
    "JULA" NUMERIC,
    "AUGB" NUMERIC,
    "SEPTC" NUMERIC,
    "OCTD" NUMERIC,
    "NOVE" NUMERIC,
    "DECF" NUMERIC
);

-- Table: publicdata_transportation_3067__STS_GG_PC_ANTI_SLIP_FAC
CREATE TABLE "aihub_transport"."publicdata_transportation_3067__STS_GG_PC_ANTI_SLIP_FAC" (
    "CITY_PROVINCEW" TEXT,
    "NM_CITY_COUNTY_DISTRICTX" TEXT,
    "N_T_M_M_N_O" TEXT,
    "AREAZ" NUMERIC,
    "EXTA" NUMERIC,
    "P_F_T_RC" TEXT,
    "ROAD_PAVEMENT_MATERIALC" TEXT,
    "INS_ADDRESSD" TEXT,
    "LATITUDEE" NUMERIC,
    "HARDNESSF" NUMERIC
);

-- Table: publicdata_transportation_3077__I_STS_GNGH_SHADE_FILM
CREATE TABLE "aihub_transport"."publicdata_transportation_3077__I_STS_GNGH_SHADE_FILM" (
    "SERIAL_NUMG" NUMERIC,
    "E_M_DH" TEXT,
    "LOC_INS_SITEI" TEXT,
    "SHADE_DIAMETERJ" NUMERIC
);

-- Table: publicdata_transportation_3148__GNMY_TRN_CARD_CHG_STATION
CREATE TABLE "aihub_transport"."publicdata_transportation_3148__GNMY_TRN_CARD_CHG_STATION" (
    "CHARGING_STATION_CLASO" TEXT,
    "NM_MERCHANTP" TEXT,
    "PHONE_NUMQ" TEXT,
    "ADDRESSR" TEXT,
    "MINIMUM_CHARGING_UNITS" TEXT,
    "DATA_BASE_DTT" TEXT
);

-- Table: publicdata_transportation_3149__STS_GGPT_ROAD_OCCUPANCY_EXCAVAT
CREATE TABLE "aihub_transport"."publicdata_transportation_3149__STS_GGPT_ROAD_OCCUPANCY_EXCAVAT" (
    "SERIAL_NUMU" TEXT,
    "LOCV" TEXT,
    "PURPOSE_OCCUPATIONW" TEXT,
    "PERMISSION_DTX" TEXT,
    "END_OCCUPATION_DTY" TEXT,
    "DATA_BASE_DTZ" TEXT
);

-- Table: publicdata_transportation_3161__C_STS_GGBC_BUS_ONLY_LANE_TF_FIN
CREATE TABLE "aihub_transport"."publicdata_transportation_3161__C_STS_GGBC_BUS_ONLY_LANE_TF_FIN" (
    "DT_TIME_CRACKDOWNV" TEXT,
    "LAW_VIOLATIONW" TEXT,
    "INTERRUPT_CLAS_OUTPUTX" TEXT,
    "VEHICLE_CLASY" TEXT,
    "BORROWED_NMZ" TEXT,
    "MAIN_TAX_IMPOSEDA" NUMERIC,
    "PROCESSING_STAB" TEXT,
    "PRE_NT_SENDING_DTC" TEXT,
    "D_D_A_N_ZZ" TEXT,
    "DATA_CLASE" TEXT,
    "CONTROL_GROUPF" NUMERIC,
    "BUYING_PHOTOSG" NUMERIC
);

-- Table: publicdata_transportation_3196__P_TRN_PASSENGERS_SEOUL_METROPOL
CREATE TABLE "aihub_transport"."publicdata_transportation_3196__P_TRN_PASSENGERS_SEOUL_METROPOL" (
    "BOARDING_ROUTEP" TEXT,
    "MARKED_MANQ" TEXT,
    "PERSONNELR" NUMERIC,
    "UNITS" TEXT
);

-- Table: publicdata_transportation_3197__C_STS_GGBC_BICYCLE_ROADS
CREATE TABLE "aihub_transport"."publicdata_transportation_3197__C_STS_GGBC_BICYCLE_ROADS" (
    "SERIAL_NUMT" NUMERIC,
    "ROUTE_NMU" TEXT,
    "STARTING_POINTV" TEXT,
    "LAST_STOPW" TEXT,
    "BICYCLE_ROAD_TYPEX" TEXT,
    "TOTAL_LENGTH_EXT_KMY" TEXT,
    "D_B_R_K_X" TEXT,
    "N_D_B_R_K_Y" TEXT,
    "BICYCLE_PATH_KMB" TEXT,
    "BICYCLE_LANE_KMC" TEXT
);

-- Table: publicdata_transportation_3200__INFO_ARRIVAL_ARRIVAL_PASSENGERS
CREATE TABLE "aihub_transport"."publicdata_transportation_3200__INFO_ARRIVAL_ARRIVAL_PASSENGERS" (
    "TRACK_NMG" TEXT,
    "STATION_NMH" TEXT,
    "DOWN_BOUND_TRAINI" NUMERIC,
    "DOWNWARD_DESCENTJ" NUMERIC,
    "UPWARD_RIDEK" NUMERIC,
    "UPWARD_STEPPINGL" NUMERIC
);

-- Table: publicdata_transportation_3217__C_STS_GETTING_OUT_KORAIL_STATIO
CREATE TABLE "aihub_transport"."publicdata_transportation_3217__C_STS_GETTING_OUT_KORAIL_STATIO" (
    "STATION_NMM" TEXT,
    "UNITN" TEXT,
    "NUM_PASSENGERSO" NUMERIC,
    "NUM_PEOPLE_GETTING_OFFP" NUMERIC
);

-- Table: publicdata_transportation_3301__GGHN_ILLEGAL_PARKING_C_SYS_MONI
CREATE TABLE "aihub_transport"."publicdata_transportation_3301__GGHN_ILLEGAL_PARKING_C_SYS_MONI" (
    "MONITOR_NMA" TEXT,
    "NM_CONTROL_AREAB" TEXT,
    "ADDRESS_RESTRICTED_AREAC" TEXT
);

-- Table: publicdata_transportation_3346__TERMINOLOGY_DEFINITION_KORAIL_R
CREATE TABLE "aihub_transport"."publicdata_transportation_3346__TERMINOLOGY_DEFINITION_KORAIL_R" (
    "SORTATIONL" TEXT,
    "STATISTICAL_NMM" TEXT,
    "TERM_NMN" TEXT,
    "TERMINOLOGY_DESCRIPTIONO" TEXT
);

-- Table: publicdata_transportation_3408__STS_GGJ_CRACKDOWN_PARKING_VIOLA
CREATE TABLE "aihub_transport"."publicdata_transportation_3408__STS_GGJ_CRACKDOWN_PARKING_VIOLA" (
    "SERIAL_NUMF" NUMERIC,
    "D_L_P_V_Z" TEXT,
    "N_C_Q_ZZ" NUMERIC,
    "DATA_BASE_DTI" TEXT
);

-- Table: publicdata_transportation_3453__GGGJ_BUS_LINE_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_3453__GGGJ_BUS_LINE_INFO" (
    "FIELDZ" TEXT,
    "ROUTE_NUMA" TEXT,
    "STARTING_POINTB" TEXT,
    "STOPOVERC" TEXT,
    "REVOLVING_CARD" TEXT,
    "STARTING_TIMEE" TEXT,
    "LAST_STOP_SERIESF" TEXT,
    "NOTEG" TEXT,
    "DATA_BASE_DTH" TEXT
);

-- Table: publicdata_transportation_3457__GGGJ_BUS_ROUTE_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_3457__GGGJ_BUS_ROUTE_INFO" (
    "ROUTE_NUMT" TEXT,
    "STARTING_POINTU" TEXT,
    "STOPOVERV" TEXT,
    "LAST_STOPW" TEXT,
    "FIRST_TRAIN_UPX" TEXT,
    "LAST_TRAIN_UPY" TEXT,
    "FIRST_DOWN_TRAINZ" TEXT,
    "LAST_TRAIN_GOING_DOWNA" TEXT,
    "ALLOC_INTERVALB" NUMERIC,
    "DATA_BASE_DTC" TEXT
);

-- Table: publicdata_transportation_3470__GGGJ_SPEED_BUMP
CREATE TABLE "aihub_transport"."publicdata_transportation_3470__GGGJ_SPEED_BUMP" (
    "GEOGRAPHICAL_FEATURE_CDW" TEXT,
    "MANAGEMENT_NUMX" NUMERIC,
    "A_D_DE" TEXT,
    "LEGAL_AREAZ" TEXT,
    "MAP_NUMA" TEXT,
    "ADMINISTRATIVE_AGENCYB" TEXT,
    "ROAD_SET_NUMC" NUMERIC,
    "CONSTRUCTION_NUMD" TEXT,
    "INS_DTE" TEXT,
    "STORM_SURGEF" NUMERIC,
    "EXTG" NUMERIC,
    "HEIGHTH" NUMERIC,
    "DAILY_TRAFFIC_VOLUMEI" TEXT,
    "QUALITY_MATERIALJ" TEXT,
    "BENEFICIARYK" TEXT,
    "SPECIAL_NOTEL" TEXT,
    "ACQUISITION_CLASM" TEXT,
    "ACQUISITION_AMTN" TEXT,
    "MANAGEMENT_DEPARTMENTO" TEXT,
    "USEFUL_LIFEP" NUMERIC,
    "NOTEQ" TEXT,
    "C_I_S_RC" TEXT,
    "SHAPE_FINAL_REVISION_DTS" TEXT,
    "SHAPE_FINAL_MODIFIER_NMT" TEXT,
    "P_L_M_D_U" TEXT,
    "P_L_M_N_V" TEXT,
    "NUMW" TEXT
);

-- Table: publicdata_transportation_3478__STS_GGJ_SPATIAL_INFO_SYS_PAVEME
CREATE TABLE "aihub_transport"."publicdata_transportation_3478__STS_GGJ_SPATIAL_INFO_SYS_PAVEME" (
    "MANAGEMENT_NUMI" NUMERIC,
    "EXTJ" NUMERIC,
    "M_D_A_D_F" TEXT,
    "CONSTRUCTION_START_DTL" TEXT,
    "C_C_D_H" TEXT
);

-- Table: publicdata_transportation_3631__GNJJ_BUS_INFO_GUIDE_I_STS
CREATE TABLE "aihub_transport"."publicdata_transportation_3631__GNJJ_BUS_INFO_GUIDE_I_STS" (
    "NUMB" NUMERIC,
    "BUS_STOPC" NUMERIC,
    "NM_BUS_STOPD" TEXT,
    "DIRECTIONE" TEXT,
    "SORTATIONF" TEXT,
    "ADDRESSG" TEXT,
    "INS_YEARH" TEXT,
    "DATA_BASE_DTI" TEXT
);

-- Table: publicdata_transportation_3780__GGGJ_MEDIAN_STRIP
CREATE TABLE "aihub_transport"."publicdata_transportation_3780__GGGJ_MEDIAN_STRIP" (
    "GEOGRAPHICAL_FEATURE_CDJ" TEXT,
    "MANAGEMENT_NUMK" NUMERIC,
    "A_D_O" TEXT,
    "LEGAL_AREAM" TEXT,
    "ADMINISTRATIVE_AGENCYN" TEXT,
    "ROAD_SET_NUMO" NUMERIC,
    "POINT_LOCP" TEXT,
    "LOC_END_POINTQ" TEXT,
    "INS_DTR" TEXT,
    "KINDS" TEXT,
    "EXTT" TEXT,
    "STORM_SURGEU" NUMERIC,
    "HEIGHTV" NUMERIC,
    "NOTEW" TEXT,
    "NUMX" TEXT
);

-- Table: publicdata_transportation_3799__GGGJ_AISLE_BOX
CREATE TABLE "aihub_transport"."publicdata_transportation_3799__GGGJ_AISLE_BOX" (
    "GEOGRAPHICAL_FEATURE_CDK" TEXT,
    "MANAGEMENT_NUML" NUMERIC,
    "A_D_ZZ" TEXT,
    "LEGAL_AREAN" TEXT,
    "ADMINISTRATIVE_AGENCYO" TEXT,
    "ROAD_SET_NUMP" NUMERIC,
    "CONSTRUCTION_NUMQ" TEXT,
    "LOCR" TEXT,
    "TRANSVERSES" NUMERIC,
    "LENGTHT" NUMERIC,
    "HEIGHTU" NUMERIC,
    "QUALITY_MATERIALV" TEXT,
    "PURPOSE_INSW" TEXT,
    "DRAINAGE_FACILITIESX" TEXT,
    "INS_DTY" TEXT
);

-- Table: publicdata_transportation_3801__GGGJ_BUS_STOP
CREATE TABLE "aihub_transport"."publicdata_transportation_3801__GGGJ_BUS_STOP" (
    "GEOGRAPHICAL_FEATURE_CDM" TEXT,
    "MANAGEMENT_NUMN" NUMERIC,
    "ADMINISTRATIVE_AGENCYO" TEXT,
    "A_D_Y" TEXT,
    "LEGAL_AREAQ" TEXT,
    "LEGAL_CLASSR" TEXT,
    "ROAD_SET_NUMS" NUMERIC,
    "CONSTRUCTION_NUMT" TEXT,
    "INS_DTU" TEXT,
    "BUS_STOP_TYPEV" TEXT,
    "NM_BUS_STOPW" TEXT,
    "BUS_STOP_TYPEX" TEXT,
    "BUS_STOP_UNIQUE_NUMY" TEXT,
    "ACQUISITION_CLASZ" TEXT,
    "ACQUISITION_AMTA" NUMERIC,
    "MANAGEMENT_DEPARTMENTB" TEXT,
    "USEFUL_LIFEC" NUMERIC,
    "SHELTER_INS_STAD" TEXT,
    "INS_PRESENT_BITE" TEXT,
    "THERMAL_CHAIR_INS_STAF" TEXT,
    "NOTEG" TEXT,
    "HARDNESSH" NUMERIC,
    "LATITUDEI" NUMERIC
);

-- Table: publicdata_transportation_3808__NUM_CRACKDOWNS_GGHN_ILLEGAL_PAR
CREATE TABLE "aihub_transport"."publicdata_transportation_3808__NUM_CRACKDOWNS_GGHN_ILLEGAL_PAR" (
    "PERIOD_CRACKDOWNJ" TEXT,
    "CONTROL_CLASK" TEXT,
    "PLACE_CRACKDOWNL" TEXT,
    "NUM_CRACKDOWNSM" NUMERIC
);

-- Table: publicdata_transportation_3835__GGGJ_STONEWORK
CREATE TABLE "aihub_transport"."publicdata_transportation_3835__GGGJ_STONEWORK" (
    "GEOGRAPHICAL_FEATURE_CDG" TEXT,
    "MANAGEMENT_NUMH" NUMERIC,
    "A_D_L" TEXT,
    "LEGAL_AREAJ" TEXT,
    "ADMINISTRATIVE_AGENCYK" TEXT,
    "ROAD_SET_NUML" NUMERIC,
    "CONSTRUCTION_NUMM" TEXT,
    "POINT_LOCN" TEXT,
    "LOC_END_POINTO" TEXT,
    "DIRECTIONP" TEXT,
    "INS_DTQ" TEXT,
    "QUALITY_MATERIALR" TEXT,
    "STRUCTURES" TEXT,
    "EXTT" NUMERIC,
    "STORM_SURGEU" NUMERIC,
    "HEIGHT_MAXV" NUMERIC,
    "MINIMUM_HEIGHTW" NUMERIC,
    "NOTEX" TEXT,
    "NUMY" TEXT
);

-- Table: publicdata_transportation_3836__GGGJ_RETAINING_WALL
CREATE TABLE "aihub_transport"."publicdata_transportation_3836__GGGJ_RETAINING_WALL" (
    "GEOGRAPHICAL_FEATURE_CDZ" TEXT,
    "MANAGEMENT_NUMA" NUMERIC,
    "A_D_XZ" TEXT,
    "LEGAL_AREAC" TEXT,
    "ADMINISTRATIVE_AGENCYD" TEXT,
    "ROAD_SET_NUME" NUMERIC,
    "CONSTRUCTION_NUMF" TEXT,
    "POINT_LOCG" TEXT,
    "LOC_END_POINTH" TEXT,
    "DIRECTIONI" TEXT,
    "INS_DTJ" TEXT,
    "QUALITY_MATERIALK" TEXT,
    "STRUCTUREL" TEXT,
    "EXTM" NUMERIC,
    "STORM_SURGEN" NUMERIC,
    "HEIGHT_MAXO" NUMERIC,
    "MINIMUM_HEIGHTP" NUMERIC,
    "NUMQ" TEXT
);

-- Table: publicdata_transportation_3850__GGGJ_ADJACENT_AREA_TRAVEL_ROUTE
CREATE TABLE "aihub_transport"."publicdata_transportation_3850__GGGJ_ADJACENT_AREA_TRAVEL_ROUTE" (
    "GEOGRAPHICAL_FEATURE_CDI" TEXT,
    "DESTINATIONJ" TEXT,
    "TRANSIT_ROUTEK" TEXT
);

-- Table: publicdata_transportation_3856__GGGJ_RURAL_ROAD
CREATE TABLE "aihub_transport"."publicdata_transportation_3856__GGGJ_RURAL_ROAD" (
    "GEOGRAPHICAL_FEATURE_CDT" TEXT,
    "ROUTE_NMU" TEXT,
    "ROUTE_NUMV" TEXT,
    "ROAD_TYPEW" TEXT,
    "ROUTE_DESIGNATION_DTX" TEXT,
    "STARTING_POINTY" TEXT,
    "LAST_STOPZ" TEXT,
    "MAJOR_AREA_PROGRESSA" TEXT,
    "EXT_ROUTEB" NUMERIC
);

-- Table: publicdata_transportation_3949__GG_YP_ROTATION_INTERSECTION_ACC
CREATE TABLE "aihub_transport"."publicdata_transportation_3949__GG_YP_ROTATION_INTERSECTION_ACC" (
    "YEAR_ESTABLISHMENTY" NUMERIC,
    "NM_ROTATING_INTERSETZ" TEXT,
    "LOCA" TEXT,
    "X_CORB" NUMERIC,
    "Y_CORC" NUMERIC,
    "DT_ACCIDENTD" NUMERIC,
    "B_A_E_P" TEXT,
    "ACCIDENT_TYPEF" TEXT,
    "DEATHG" NUMERIC,
    "SERIOUS_INJURYH" NUMERIC,
    "SLIGHT_INJURYI" NUMERIC,
    "INJURYJ" NUMERIC,
    "WEATHER_CONDITIONSK" TEXT,
    "VIOLATION_LAWL" TEXT
);

-- Table: publicdata_transportation_3992__GG_SU_BUS_STS
CREATE TABLE "aihub_transport"."publicdata_transportation_3992__GG_SU_BUS_STS" (
    "SORTATIONX" TEXT,
    "ROUTE_NUMY" TEXT,
    "DISPATCH_INTERVALZ" TEXT,
    "STARTING_POINTA" TEXT,
    "STOPOVERB" TEXT,
    "LAST_STOPC" TEXT,
    "DATA_BASE_DTD" TEXT
);

-- Table: publicdata_transportation_39__ICTR_HISTORICAL_DEPTH_HEIGHT
CREATE TABLE "aihub_transport"."publicdata_transportation_39__ICTR_HISTORICAL_DEPTH_HEIGHT" (
    "LINE" NUMERIC,
    "STATION_NAME" TEXT,
    "DEPTH_AND_HEIGHT" NUMERIC,
    "NOTE" TEXT
);

-- Table: publicdata_transportation_4031__STS_GG_SW_CITY_BUS_ROUTES
CREATE TABLE "aihub_transport"."publicdata_transportation_4031__STS_GG_SW_CITY_BUS_ROUTES" (
    "COMPANY_NMZ" TEXT,
    "INDUSTRYA" TEXT,
    "ROUTE_NMB" TEXT,
    "ROUTE_TYPEC" TEXT,
    "ROUTE_STAD" TEXT,
    "TYPE_OPERATIONE" TEXT,
    "CHANGE_APPROVAL_DTF" TEXT,
    "FIRST_AUTHORIZATION_DTG" TEXT,
    "TRANSPORTATION_START_DTH" TEXT,
    "NUM_ACCREDITEDI" NUMERIC,
    "NUM_REGISTERED_UNITSJ" NUMERIC,
    "NUM_AUTHORIZATIONSK" NUMERIC,
    "ONE_WAY_STREETL" NUMERIC,
    "DEGREE_FLEXIONM" NUMERIC,
    "INTERCITY_SYS_NUMN" TEXT,
    "I_D_S_W" TEXT,
    "REMOTE_LINEP" TEXT,
    "STARTING_STOPQ" TEXT,
    "END_STOPR" TEXT,
    "COMPETENT_AUTHORITYS" TEXT,
    "COMPANY_IDT" NUMERIC,
    "ROUTE_IDU" NUMERIC,
    "DATA_BASE_DTV" TEXT
);

-- Table: publicdata_transportation_407__CCTV_STS_ILLEGAL_PARKING_CONTROL
CREATE TABLE "aihub_transport"."publicdata_transportation_407__CCTV_STS_ILLEGAL_PARKING_CONTROL" (
    "ANNUAL" NUMERIC,
    "PURPOSE" TEXT,
    "INSTALLATION_YEAR" NUMERIC,
    "CAMERA_NAME" TEXT,
    "INSTALLATION_ADDRESS" TEXT,
    "ADMINISTRATIVE_BUILDING" TEXT,
    "COURT_DONG" TEXT,
    "HARDNESS" NUMERIC,
    "LATITUDE" NUMERIC,
    "NOTE" TEXT
);

-- Table: publicdata_transportation_4088__GNJJ_BUS_STOP
CREATE TABLE "aihub_transport"."publicdata_transportation_4088__GNJJ_BUS_STOP" (
    "NUMZ" NUMERIC,
    "BUS_STOP_IDA" NUMERIC,
    "NM_BUS_STOPB" TEXT,
    "HARDNESSC" NUMERIC,
    "LATITUDED" NUMERIC,
    "DATA_BASE_DTE" TEXT
);

-- Table: publicdata_transportation_4090__GNJJ_BUS_ROUTE_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_4090__GNJJ_BUS_ROUTE_INFO" (
    "NUMF" NUMERIC,
    "ROUTE_NUMG" NUMERIC,
    "ROUTE_IDH" NUMERIC,
    "SORTATIONI" TEXT,
    "FIELDJ" TEXT,
    "DISTANCE_KMK" NUMERIC,
    "NUM_TRIPSL" NUMERIC,
    "OPERATION_START_DTM" TEXT,
    "TRANSPORTATION_COMPANYN" TEXT,
    "DATA_BASE_DTO" TEXT
);

-- Table: publicdata_transportation_4173__STS_GG_GURI_CITY_ILLEGAL_PARKIN
CREATE TABLE "aihub_transport"."publicdata_transportation_4173__STS_GG_GURI_CITY_ILLEGAL_PARKIN" (
    "DT_CRACKDOWNS" TEXT,
    "CONTROL_CLAST" TEXT,
    "DISPATCH_CLASU" TEXT,
    "CRACKDOWN_LOCV" TEXT,
    "SHIPMENT_RESULTW" TEXT,
    "DATA_BASE_DTX" TEXT
);

-- Table: publicdata_transportation_4190__STS_GG_PC_FREIGHT_FW_ARRANGEMEN
CREATE TABLE "aihub_transport"."publicdata_transportation_4190__STS_GG_PC_FREIGHT_FW_ARRANGEMEN" (
    "NUMU" NUMERIC,
    "MUTUAL_COMPANY_NMV" TEXT,
    "M_O_R_N_A_J" TEXT,
    "DT_PERMISSION_DTX" TEXT,
    "BUSINESS_STAY" TEXT
);

-- Table: publicdata_transportation_4200__GG_YP_BUS_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_4200__GG_YP_BUS_INFO" (
    "NUMY" NUMERIC,
    "ROUTE_NUMZ" TEXT,
    "STARTING_POINTA" TEXT,
    "STOPOVERB" TEXT,
    "LAST_STOPC" TEXT,
    "DISTANCED" NUMERIC,
    "RECALLE" TEXT,
    "ALGEBRAIC_NUMF" NUMERIC,
    "S_P_D_T_EA" TEXT,
    "L_S_D_T_F" TEXT,
    "REMARK_CHANGES_ETCI" TEXT,
    "BASE_DTJ" TEXT
);

-- Table: publicdata_transportation_4231__GW_DH
CREATE TABLE "aihub_transport"."publicdata_transportation_4231__GW_DH" (
    "CITY_PROVINCED" TEXT,
    "NM_CITY_COUNTY_DISTRICTE" TEXT,
    "ROADF" TEXT,
    "ROUTE_NUMG" TEXT,
    "TOTAL_EXTH" NUMERIC,
    "PACKAGING_EXTI" NUMERIC,
    "UNPACKED_EXTJ" NUMERIC,
    "PACKING_RATE_PERCENTAGEK" NUMERIC,
    "M_A_P_N_U" TEXT,
    "NM_MANAGEMENT_AGENCYM" TEXT,
    "DATA_BASE_DTN" TEXT
);

-- Table: publicdata_transportation_4358__C_STS_PARKING_VIOLATION_C_L_GUR
CREATE TABLE "aihub_transport"."publicdata_transportation_4358__C_STS_PARKING_VIOLATION_C_L_GUR" (
    "TOTAL_YEARB" NUMERIC,
    "CITY_COUNTY_NMC" TEXT,
    "REGULATORY_DT_TIME_INFD" TEXT,
    "PLACE_CRACKDOWNE" TEXT,
    "HOW_CRACK_DOWNF" TEXT,
    "DATA_BASE_DTG" TEXT
);

-- Table: publicdata_transportation_4396__KORAIL_STATION_NAME_HANGUL_ENGL
CREATE TABLE "aihub_transport"."publicdata_transportation_4396__KORAIL_STATION_NAME_HANGUL_ENGL" (
    "NUMK" NUMERIC,
    "STATION_NML" TEXT,
    "ENGLISH_LANGUAGEM" TEXT,
    "CHINESE_CHARACTERSN" TEXT,
    "ADDRESSO" TEXT
);

-- Table: publicdata_transportation_4397__P_GETTING_OUT_KORAIL_METROPOLIT
CREATE TABLE "aihub_transport"."publicdata_transportation_4397__P_GETTING_OUT_KORAIL_METROPOLIT" (
    "STATION_NMP" TEXT,
    "RIDINGQ" NUMERIC,
    "STOPOVERR" NUMERIC
);

-- Table: publicdata_transportation_453__CURRENT_STS_CCTV_ROAD_MNG_EX_MAI
CREATE TABLE "aihub_transport"."publicdata_transportation_453__CURRENT_STS_CCTV_ROAD_MNG_EX_MAI" (
    "ROUTE_NUMBER" NUMERIC,
    "ROUTE_NAME" TEXT,
    "CCTV_NAME" TEXT,
    "SIGNIFICANCE" NUMERIC,
    "DIRECTION" TEXT,
    "INSTALLATION" TEXT,
    "OPERATING_STATE" TEXT
);

-- Table: publicdata_transportation_454__CURRENT_STS_CCTV_ROAD_MNG_EX_TUN
CREATE TABLE "aihub_transport"."publicdata_transportation_454__CURRENT_STS_CCTV_ROAD_MNG_EX_TUN" (
    "HEADQUARTERS" TEXT,
    "BRANCH" TEXT,
    "ROUTE_NUMBER" NUMERIC,
    "ROUTE_NAME" TEXT,
    "TUNNEL_NAME" TEXT,
    "SIGNIFICANCE" NUMERIC,
    "DIRECTION" TEXT,
    "LOCATION" TEXT
);

-- Table: publicdata_transportation_457__STS_SECTION_VULNERABLE_FREEZING_
CREATE TABLE "aihub_transport"."publicdata_transportation_457__STS_SECTION_VULNERABLE_FREEZING_" (
    "CONTROL_NUMBER" NUMERIC,
    "MAIN" TEXT,
    "BRANCH" TEXT,
    "ROUTE" TEXT,
    "SIGHT" NUMERIC,
    "TERMINAL" NUMERIC,
    "DIRECTION" TEXT,
    "EXTENSION_KM" NUMERIC
);

-- Table: publicdata_transportation_45__ICTR_ESCALATOR_I_STS
CREATE TABLE "aihub_transport"."publicdata_transportation_45__ICTR_ESCALATOR_I_STS" (
    "LINE" NUMERIC,
    "HISTORY_NAME" TEXT,
    "ESCALATOR_OUTSIDE" NUMERIC,
    "INSIDE_THE_ESCALATOR" NUMERIC
);

-- Table: publicdata_transportation_46__ICTR_ELEVATOR_I_STS
CREATE TABLE "aihub_transport"."publicdata_transportation_46__ICTR_ELEVATOR_I_STS" (
    "LINE" NUMERIC,
    "HISTORY_NAME" TEXT,
    "ELEVATOR" NUMERIC,
    "INSIDE_THE_ELEVATOR" NUMERIC,
    "WHEELCHAIR_LIFT" NUMERIC
);

-- Table: publicdata_transportation_4825__KRRI_KRN_RAILWAY_S
CREATE TABLE "aihub_transport"."publicdata_transportation_4825__KRRI_KRN_RAILWAY_S" (
    "SPECIFICATION_NUMD" TEXT,
    "SPECIFICATION_NME" TEXT,
    "E_S_N_XZ" TEXT,
    "MAJOR_FIELDG" TEXT,
    "INTERMEDIATE_FIELDH" TEXT,
    "DT_ENACTMENTI" TEXT,
    "LAST_REVISION_DTJ" TEXT,
    "RELATED_SPECIFICATIONSK" TEXT
);

-- Table: publicdata_transportation_5315__SRSRT_PASSENGER_FREIGHT
CREATE TABLE "aihub_transport"."publicdata_transportation_5315__SRSRT_PASSENGER_FREIGHT" (
    "STARTING_STATIONR" TEXT,
    "ARRIVING_STATIONS" TEXT,
    "BASIC_FARET" NUMERIC
);

-- Table: publicdata_transportation_5777__C_STS_KORAIL_RENTAL_ASSETS
CREATE TABLE "aihub_transport"."publicdata_transportation_5777__C_STS_KORAIL_RENTAL_ASSETS" (
    "ASSET_LOCX" TEXT,
    "FACILITY_NMY" TEXT,
    "T_C_P_S_F" TEXT,
    "T_C_P_S_E_G" TEXT,
    "R_A_S_M_H" NUMERIC,
    "A_R_C_V_N_I_I" NUMERIC
);

-- Table: publicdata_transportation_5778__TERMINOLOGY_KORAIL_RAILWAY
CREATE TABLE "aihub_transport"."publicdata_transportation_5778__TERMINOLOGY_KORAIL_RAILWAY" (
    "NUMD" NUMERIC,
    "TERM_NME" TEXT,
    "GLOSSARY_TERMSF" TEXT
);

-- Table: publicdata_transportation_5779__C_STS_KORAIL_RENTAL_MNG
CREATE TABLE "aihub_transport"."publicdata_transportation_5779__C_STS_KORAIL_RENTAL_MNG" (
    "AFFILIATIONG" TEXT,
    "STATIONH" TEXT,
    "LOCI" TEXT,
    "INDICATION_PROPERTYJ" TEXT,
    "SQUARE_METER_LANDK" NUMERIC,
    "SQUARE_METER_BUILDINGL" NUMERIC,
    "D_U_P_S" TEXT
);

-- Table: publicdata_transportation_5806__MOF_PORT_TOTAL_COST_PRO_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_5806__MOF_PORT_TOTAL_COST_PRO_INFO" (
    "FISCAL_YEARN" NUMERIC,
    "MANAGEMENT_NUMO" NUMERIC,
    "SORTATIONP" TEXT,
    "INSTITUTIONQ" TEXT,
    "REGISTERED_AGENCY_CDR" NUMERIC,
    "NM_COMPETENT_AGENCYS" TEXT,
    "TOTAL_BUSINESS_NMT" TEXT,
    "P_B_P_M" TEXT,
    "E_E_N" TEXT,
    "GROUNDS_SUPPORTW" TEXT,
    "N_T_S_S_P" TEXT,
    "BUSINESS_SIZEY" TEXT,
    "P_E_S_D_RC" TEXT,
    "P_E_E_D_S" TEXT,
    "BUSINESS_START_AREA_NMB" TEXT,
    "B_S_D_A_U" TEXT,
    "B_T_A_N_V" TEXT,
    "D_P_T_A_W" TEXT,
    "P_F_S_C_X" TEXT,
    "F_S_I_S_Y" TEXT,
    "F_R_V_S_Z" TEXT,
    "RESULT_NT_STAI" TEXT,
    "LAST_REVISION_DTJ" TEXT
);

-- Table: publicdata_transportation_5840__NUM_OS_MAIN_LINE_O_KORAIL
CREATE TABLE "aihub_transport"."publicdata_transportation_5840__NUM_OS_MAIN_LINE_O_KORAIL" (
    "OPERATION_DTK" TEXT,
    "OPERATION_DAY_CLASL" TEXT,
    "MAIN_LINE_OPERATIONM" TEXT,
    "TRAIN_MODELN" TEXT,
    "NUM_TRAIN_OPERATIONSO" NUMERIC
);

-- Table: publicdata_transportation_5847__NUM_PEOPLE_GETTING_OFF_KTX_GWAN
CREATE TABLE "aihub_transport"."publicdata_transportation_5847__NUM_PEOPLE_GETTING_OFF_KTX_GWAN" (
    "OPERATION_DTB" TEXT,
    "NUM_PASSENGERSC" NUMERIC,
    "N_P_W_G_O_T_X" NUMERIC
);

-- Table: publicdata_transportation_5848__NUM_PEOPLE_GETTING_OFF_TRAIN_T_
CREATE TABLE "aihub_transport"."publicdata_transportation_5848__NUM_PEOPLE_GETTING_OFF_TRAIN_T_" (
    "OPERATION_DTE" TEXT,
    "TRAIN_TYPEF" TEXT,
    "NUM_PASSENGERSG" NUMERIC,
    "N_P_W_G_O_T_VA" NUMERIC
);

-- Table: publicdata_transportation_5855__KORAIL_GYEONGIN_LINE_NUM_PEOPLE
CREATE TABLE "aihub_transport"."publicdata_transportation_5855__KORAIL_GYEONGIN_LINE_NUM_PEOPLE" (
    "OPERATION_DTU" TEXT,
    "RAILWAY_LINEV" TEXT,
    "TIME_ZONE_CLASW" TEXT,
    "SUBWAY_STATIONX" TEXT,
    "NUM_PASSENGERS_TRAINY" NUMERIC,
    "N_P_G_O_T_J" NUMERIC
);

-- Table: publicdata_transportation_5856__NUM_PEOPLE_GETTING_OFF_STATION_
CREATE TABLE "aihub_transport"."publicdata_transportation_5856__NUM_PEOPLE_GETTING_OFF_STATION_" (
    "OPERATION_DTA" TEXT,
    "STOP_STATIONB" TEXT,
    "TRAIN_MODELC" TEXT,
    "UP_DOWN_CLASD" TEXT,
    "NUM_PASSENGERSE" NUMERIC,
    "N_P_W_G_O_T_P" NUMERIC
);

-- Table: publicdata_transportation_5859__POST_EVN_MOF_PORT_CONST_PRO
CREATE TABLE "aihub_transport"."publicdata_transportation_5859__POST_EVN_MOF_PORT_CONST_PRO" (
    "ORDERING_AGENCYS" TEXT,
    "TARGET_PROJECTT" TEXT,
    "CONSTRUCTION_OVERVIEWU" TEXT,
    "T_C_C_1_M_W_A" NUMERIC,
    "CONSTRUCTION_YEARW" NUMERIC,
    "C_C_Y_C" NUMERIC,
    "P_E_C_S_D_DE" TEXT,
    "P_E_C_E_D_EA" TEXT
);

-- Table: publicdata_transportation_5860__MOF_PORT_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_5860__MOF_PORT_INFO" (
    "N_M_C_F" TEXT,
    "PERMANENT_PORTIONB" TEXT,
    "PORTMANC" TEXT,
    "ADMINISTRATIVE_AGENCYD" TEXT,
    "PORT_LOCE" TEXT,
    "PORT_AREAF" TEXT,
    "AREA_WATERG" NUMERIC,
    "AREA_LANDH" NUMERIC,
    "DESIGN_WAVE_HEIGHTI" TEXT,
    "DESIGN_WAVE_DIRECTIONJ" TEXT,
    "HIGHEST_TIDE_LEVELK" TEXT,
    "AVG_SEA_LEVELL" TEXT,
    "UNDERSEA_GEOLOGYM" TEXT,
    "BREAKWATER_LENGTHN" NUMERIC,
    "LENGTH_INNER_WALLO" NUMERIC,
    "D_S_D_L_U" NUMERIC,
    "S_P_I_V" NUMERIC,
    "SANGOKSU_DONGR" NUMERIC,
    "FIELD_FLOOR_AREAS" NUMERIC,
    "BERTH_BERTHT" NUMERIC,
    "UNLOADING_CP_NUMU" NUMERIC,
    "OTHER_FACILITIES_STAV" TEXT,
    "MAJOR_HANDLING_CARGOW" TEXT
);

-- Table: publicdata_transportation_5867__P_KORAIL_RAILWAY
CREATE TABLE "aihub_transport"."publicdata_transportation_5867__P_KORAIL_RAILWAY" (
    "DTJ" TEXT,
    "TRAIN_TYPEK" TEXT,
    "ROUTEL" TEXT,
    "P_T_P_H" NUMERIC
);

-- Table: publicdata_transportation_5868__NUM_PASSENGERS_KORAIL_BUNDANG_L
CREATE TABLE "aihub_transport"."publicdata_transportation_5868__NUM_PASSENGERS_KORAIL_BUNDANG_L" (
    "BOARDING_STATIONN" TEXT,
    "STOPOVER_STATIONO" TEXT,
    "NUM_USERSP" NUMERIC
);

-- Table: publicdata_transportation_618__STS_AGM_INSPECTION_IPAB_VESSELS
CREATE TABLE "aihub_transport"."publicdata_transportation_618__STS_AGM_INSPECTION_IPAB_VESSELS" (
    "INSPECTION_YEAR" NUMERIC,
    "TYPE_SHIP" TEXT,
    "SHIP_WEIGHT" TEXT,
    "INSPECTION_FEE_KRW_1_000" NUMERIC,
    "NUMBER_CASES_DEFAULT" NUMERIC,
    "NUMBER_CASES_SURCHARGE" NUMERIC
);

-- Table: publicdata_transportation_620__STS_PEOPLE_GETTING_OFF_DTRO_STAT
CREATE TABLE "aihub_transport"."publicdata_transportation_620__STS_PEOPLE_GETTING_OFF_DTRO_STAT" (
    "MONTH" NUMERIC,
    "WORK" NUMERIC,
    "STATION_NUMBER" NUMERIC,
    "STATION_NAME" TEXT,
    "DEATH_PERSON" TEXT,
    "H_05_06" NUMERIC,
    "H_06_07" NUMERIC,
    "H_07_08" NUMERIC,
    "H_08_09" NUMERIC,
    "H_09_10" NUMERIC,
    "H_10_11" NUMERIC,
    "H_11_12" NUMERIC,
    "H_12_13" NUMERIC,
    "H_13_14" NUMERIC,
    "H_14_15" NUMERIC,
    "H_15_16" NUMERIC,
    "H_16_17" NUMERIC,
    "H_17_18" NUMERIC,
    "H_18_19" NUMERIC,
    "H_19_20" NUMERIC,
    "H_20_21" NUMERIC,
    "H_21_22" NUMERIC,
    "H_22_23" NUMERIC,
    "H_23_24" NUMERIC,
    "FIRST_ORDER" NUMERIC
);

-- Table: publicdata_transportation_6218__KORAIL_SELECTIVE_PASSENGERS_TRN
CREATE TABLE "aihub_transport"."publicdata_transportation_6218__KORAIL_SELECTIVE_PASSENGERS_TRN" (
    "SHARPNESSL" TEXT,
    "S_E_T_R_VA" NUMERIC,
    "HIGH_SPEED_TRAIN_ROOMN" NUMERIC,
    "S_S_H_S_T_DE" NUMERIC,
    "HIGH_SPEED_TRAIN_OTHERP" NUMERIC,
    "NEW_VIL_SPECIAL_OFFICEQ" TEXT,
    "SAEMAEUL_GENERAL_OFFICER" TEXT,
    "STANDING_NEW_VILS" TEXT,
    "SAEMAEUL_GUITART" TEXT,
    "MUGUNGHWA_SPECIAL_ROOMU" TEXT,
    "MUGUNGHWA_GENERAL_ROOMV" TEXT,
    "STANDING_ROOM_MUGUNGHWAW" TEXT,
    "MUGUNGHWA_GUITARX" TEXT,
    "N_R_S_C_T_I" TEXT
);

-- Table: publicdata_transportation_6227__KORAIL_SELECTIVE_PASSENGER_TRAN
CREATE TABLE "aihub_transport"."publicdata_transportation_6227__KORAIL_SELECTIVE_PASSENGER_TRAN" (
    "SHARPNESSY" TEXT,
    "HIGH_SPEED_TRAINZ" NUMERIC,
    "NEW_VILA" TEXT,
    "MUGUNGHWAB" TEXT,
    "COMMUTER_TRAINC" TEXT
);

-- Table: publicdata_transportation_622__EX_HI_PASS_TERMINAL_S_OFFICE_INF
CREATE TABLE "aihub_transport"."publicdata_transportation_622__EX_HI_PASS_TERMINAL_S_OFFICE_INF" (
    "HEADQUARTERS" TEXT,
    "NAME" TEXT,
    "BUSINESS_CALL" TEXT,
    "PHONE_NUMBER" TEXT,
    "FAX_NUMBER" TEXT,
    "ZIP_CODE" TEXT,
    "ADDRESS" TEXT
);

-- Table: publicdata_transportation_636__CURRENT_STS_AUTOMOBILE_DEALERS_J
CREATE TABLE "aihub_transport"."publicdata_transportation_636__CURRENT_STS_AUTOMOBILE_DEALERS_J" (
    "ADMINISTRATION" TEXT,
    "COMPANY_NAME" TEXT,
    "REGISTRATION_DATE" TEXT,
    "LOCATION" TEXT,
    "CONTACT" TEXT,
    "NOTE" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_transportation_6389__STS_R_VESSELS_UNDER_MOF_VESSELS
CREATE TABLE "aihub_transport"."publicdata_transportation_6389__STS_R_VESSELS_UNDER_MOF_VESSELS" (
    "_WALL_MONTHLYS" TEXT,
    "TONE_CLAST" TEXT,
    "SORTATIONU" TEXT,
    "SUM_TOTALV" NUMERIC,
    "Y_5_UNDERW" NUMERIC,
    "Y_5_10_UNDERX" NUMERIC,
    "Y_10_15_UNDERY" NUMERIC,
    "Y_15_20_UNDERZ" NUMERIC,
    "Y_20_25_UNDERA" NUMERIC,
    "Y_25_30_UNDERB" NUMERIC,
    "Y_30_35_UNDERC" NUMERIC,
    "Y_35_MORED" NUMERIC
);

-- Table: publicdata_transportation_6540__KDN_TRAIN_SCHEDULE_FARE_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_6540__KDN_TRAIN_SCHEDULE_FARE_INFO" (
    "NUME" NUMERIC,
    "TRAIN_TYPEF" NUMERIC,
    "TRAIN_NMG" TEXT,
    "ONE_PLACE_DEPARTUREH" TEXT,
    "DEPARTURE_TIMEI" TEXT,
    "DESTINATIONJ" TEXT,
    "TIME_ARRIVALK" TEXT,
    "SPECIAL_ROOM_RATEL" NUMERIC,
    "GENERAL_FREIGHTM" NUMERIC
);

-- Table: publicdata_transportation_6541__KDN_GWANGJU_BUS_ROUTE_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_6541__KDN_GWANGJU_BUS_ROUTE_INFO" (
    "LIST_NUMN" NUMERIC,
    "ROUTE_NUMO" NUMERIC,
    "ROUTE_NMP" TEXT,
    "NM_STARTING_STATIONQ" TEXT,
    "LAST_STOP_NMR" TEXT,
    "FIRST_TRAIN_TIMES" TEXT,
    "TIME_LAST_TRAINT" TEXT,
    "ALLOC_INTERVALU" TEXT
);

-- Table: publicdata_transportation_6542__KDN_NAJU_BUS_SCHEDULE_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_6542__KDN_NAJU_BUS_SCHEDULE_INFO" (
    "W_W_C_0_W_1_W_K" NUMERIC,
    "STOP_IDW" NUMERIC,
    "TIME_ORDERX" NUMERIC,
    "ROUTE_IDY" NUMERIC,
    "TIMEZ" TEXT
);

-- Table: publicdata_transportation_6607__KORAIL_KTX_FARE_T
CREATE TABLE "aihub_transport"."publicdata_transportation_6607__KORAIL_KTX_FARE_T" (
    "PERIODP" TEXT,
    "ENTIRE_SETQ" TEXT,
    "SETR" TEXT,
    "F_C_T_H_V" TEXT,
    "F_C_B_T_H_W" NUMERIC,
    "S_R_F_G_T_H_X" TEXT,
    "S_R_R_B_G_T_H_Y" NUMERIC,
    "F_G_M_T_Z" TEXT,
    "F_C_B_M_T_ZZ" NUMERIC,
    "S_R_R_G_M_T_VA" TEXT,
    "S_R_R_B_G_M_T_CV" NUMERIC,
    "F_C_D_B_DE" TEXT,
    "F_B_R_D_B_XZ" TEXT,
    "S_R_R_R_D_B_D_W_A" TEXT,
    "S_R_R_B_G_D_B_BB" TEXT
);

-- Table: publicdata_transportation_6608__KORAIL_MUGUNGHWA_TRAIN_FARE_T
CREATE TABLE "aihub_transport"."publicdata_transportation_6608__KORAIL_MUGUNGHWA_TRAIN_FARE_T" (
    "PERIODE" TEXT,
    "SETF" TEXT,
    "STARTING_STATIONG" TEXT,
    "ARRIVING_STATIONH" TEXT,
    "FREIGHT_TODAY_HOLIDAYI" NUMERIC,
    "S_R_F_T_H_H" NUMERIC,
    "FREIGHT_MONTH_THURSDAYK" NUMERIC,
    "S_R_R_M_T_J" NUMERIC,
    "DAY_BEFORE_FAREM" TEXT,
    "D_B_S_R_R_L" TEXT
);

-- Table: publicdata_transportation_6609__KORAIL_COMMUTER_TRAIN_FARE_T
CREATE TABLE "aihub_transport"."publicdata_transportation_6609__KORAIL_COMMUTER_TRAIN_FARE_T" (
    "SETO" TEXT,
    "STARTING_STATIONP" TEXT,
    "ARRIVING_STATIONQ" TEXT,
    "D_B_S_K_P" TEXT,
    "INTER_STATION_FREIGHTS" NUMERIC
);

-- Table: publicdata_transportation_6612__KORAIL_SAEMAEUL_TRAIN_FARE_T
CREATE TABLE "aihub_transport"."publicdata_transportation_6612__KORAIL_SAEMAEUL_TRAIN_FARE_T" (
    "BASE_DTL" TEXT,
    "SETM" TEXT,
    "STARTING_STATIONN" TEXT,
    "ARRIVING_STATIONO" TEXT,
    "FREIGHT_TODAY_HOLIDAYP" NUMERIC,
    "S_R_F_T_H_EA" NUMERIC,
    "FREIGHT_MONTH_THURSDAYR" NUMERIC,
    "S_R_R_M_T_G" NUMERIC,
    "DAY_BEFORE_FARET" TEXT,
    "D_B_S_R_R_I" TEXT
);

-- Table: publicdata_transportation_6667__KORAIL_SCREEN_DOOR_I_YEAR_MONTH
CREATE TABLE "aihub_transport"."publicdata_transportation_6667__KORAIL_SCREEN_DOOR_I_YEAR_MONTH" (
    "NUMW" NUMERIC,
    "ROUTEX" TEXT,
    "STATION_NMY" TEXT,
    "YEARZ" NUMERIC,
    "MONTHA" NUMERIC
);

-- Table: publicdata_transportation_6671__STS_KORAIL_FREIGHT_STATION
CREATE TABLE "aihub_transport"."publicdata_transportation_6671__STS_KORAIL_FREIGHT_STATION" (
    "AREAX" TEXT,
    "STATION_NMY" TEXT
);

-- Table: publicdata_transportation_6673__C_STS_LIFTING_FAC_KORAIL
CREATE TABLE "aihub_transport"."publicdata_transportation_6673__C_STS_LIFTING_FAC_KORAIL" (
    "OPERATING_INSTITUTIONG" TEXT,
    "ROUTEH" TEXT,
    "STATION_NMI" TEXT,
    "ELEVATORJ" NUMERIC,
    "ESCALATORK" NUMERIC,
    "WHEELCHAIR_LIFTL" NUMERIC,
    "DISABLED_RAMPM" TEXT
);

-- Table: publicdata_transportation_6678__MOIS_GUIDE_SHIP_DOCK
CREATE TABLE "aihub_transport"."publicdata_transportation_6678__MOIS_GUIDE_SHIP_DOCK" (
    "NUMK" NUMERIC,
    "ADMINISTRATIVE_AGENCYL" TEXT,
    "PURPOSE_CLASM" TEXT,
    "NM_DOCKN" TEXT,
    "ADDRESSO" TEXT
);

-- Table: publicdata_transportation_704__DSRC_INFO_INTELLIGENT_TRAFFIC_IN
CREATE TABLE "aihub_transport"."publicdata_transportation_704__DSRC_INFO_INTELLIGENT_TRAFFIC_IN" (
    "PROCESSING_DATE" TEXT,
    "SECTION_NAME" TEXT,
    "SIGHT" TEXT,
    "TERMINAL" TEXT,
    "SPEED" NUMERIC
);

-- Table: publicdata_transportation_71__STS_MAJOR_CONST_PRO_SUYEONG_GU_BU
CREATE TABLE "aihub_transport"."publicdata_transportation_71__STS_MAJOR_CONST_PRO_SUYEONG_GU_BU" (
    "ANNUAL" NUMERIC,
    "CONSTRUCTION_NAME" TEXT,
    "CONSTRUCTION_OUTLINE" TEXT,
    "CONSTRUCTION_PERIOD" TEXT,
    "OFFICIAL" TEXT,
    "PHONE_NUMBER" TEXT
);

-- Table: publicdata_transportation_724__INCHEON_SEO_GU_BICYCLE_FAC
CREATE TABLE "aihub_transport"."publicdata_transportation_724__INCHEON_SEO_GU_BICYCLE_FAC" (
    "CATEGORY" TEXT,
    "INSTALLATION_LOCATION" TEXT,
    "ADDRESS" TEXT,
    "TOTAL_NUMBER_OF_STORAGE" NUMERIC,
    "AIR_INJECTION" TEXT,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_transportation_858__NUM_PEOPLE_GETTING_OFF_BTC_TIME_
CREATE TABLE "aihub_transport"."publicdata_transportation_858__NUM_PEOPLE_GETTING_OFF_BTC_TIME_" (
    "REVERSE_NUMBER" NUMERIC,
    "STATION_NAME" TEXT,
    "YEAR_MONTH_DAY" TEXT,
    "DAY_OF_THE_WEEK" TEXT,
    "DIVISION" TEXT,
    "TOTAL" NUMERIC,
    "H_01_02" NUMERIC,
    "H_02_03" NUMERIC,
    "H_03_04" NUMERIC,
    "H_04_05" NUMERIC,
    "H_05_06" NUMERIC,
    "H_06_07" NUMERIC,
    "H_07_08" NUMERIC,
    "H_08_09" NUMERIC,
    "H_09_10" NUMERIC,
    "H_10_11" NUMERIC,
    "H_11_12" NUMERIC,
    "H_12_13" NUMERIC,
    "H_13_14" NUMERIC,
    "H_14_15" NUMERIC,
    "H_15_16" NUMERIC,
    "H_16_17" NUMERIC,
    "H_17_18" NUMERIC,
    "H_18_19" NUMERIC,
    "H_19_20" NUMERIC,
    "H_20_21" NUMERIC,
    "H_21_22" NUMERIC,
    "H_22_23" NUMERIC,
    "H_23_24" NUMERIC,
    "H_24_01" NUMERIC
);

-- Table: publicdata_transportation_876__BUSAN_INTELLIGENT_TRAFFIC_INFO_T
CREATE TABLE "aihub_transport"."publicdata_transportation_876__BUSAN_INTELLIGENT_TRAFFIC_INFO_T" (
    "PROCESSING_DATE" TEXT,
    "SECTION_NAME" TEXT,
    "SIGHT" TEXT,
    "TERMINAL" TEXT,
    "COLLECTOR" TEXT,
    "SPEED" NUMERIC,
    "TRAFFIC" NUMERIC
);

-- Table: publicdata_transportation_878__BUSAN_INTELLIGENT_TRN_INFO_RSE_I
CREATE TABLE "aihub_transport"."publicdata_transportation_878__BUSAN_INTELLIGENT_TRN_INFO_RSE_I" (
    "PROCESSING_DATE" TEXT,
    "SIGHT" TEXT,
    "TIME_PASS_TIME" TEXT,
    "TERMINAL" TEXT,
    "TERMINAL_PASSAGE_TIME" TEXT,
    "SPEED" NUMERIC,
    "PASSING_TIME" NUMERIC
);

-- Table: publicdata_transportation_879__BUSAN_INTELLIGENT_TRAFFIC_INFO_L
CREATE TABLE "aihub_transport"."publicdata_transportation_879__BUSAN_INTELLIGENT_TRAFFIC_INFO_L" (
    "LINK_NUMBER" NUMERIC,
    "LINK_NAME" TEXT,
    "SIGHT" TEXT,
    "TERMINAL" TEXT
);

-- Table: publicdata_transportation_881__BUSAN_INTELLIGENT_TRN_TRAFFIC_IN
CREATE TABLE "aihub_transport"."publicdata_transportation_881__BUSAN_INTELLIGENT_TRN_TRAFFIC_IN" (
    "PROCESSING_DATE" TEXT,
    "SECTION_NAME" TEXT,
    "SPEED" NUMERIC
);

-- Table: publicdata_transportation_917__SELMETRO_ELEVATOR_I_INFO
CREATE TABLE "aihub_transport"."publicdata_transportation_917__SELMETRO_ELEVATOR_I_INFO" (
    "ANNUAL" NUMERIC,
    "LINE" TEXT,
    "STATION_NAME" TEXT,
    "EQUIPMENT" TEXT,
    "AORY" TEXT,
    "ELEVATOR_NUMBER" TEXT,
    "OPERATING_SECTION" TEXT,
    "INSTALLATION_LOCATION" TEXT
);

-- Table: publicdata_transportation_924__INFO_USE_HAPPINESS_TAXI_HAPCHEON
CREATE TABLE "aihub_transport"."publicdata_transportation_924__INFO_USE_HAPPINESS_TAXI_HAPCHEON" (
    "YEAR" TEXT,
    "TOWN" TEXT,
    "VILLAGE_NAME" TEXT,
    "NUMBER_OF_TIMES" NUMERIC,
    "NUMBER_OF_PEOPLE" NUMERIC
);

-- Table: publicdata_transportation_946__SELMETRO_MONTHLY_DROP_OFF_NUM
CREATE TABLE "aihub_transport"."publicdata_transportation_946__SELMETRO_MONTHLY_DROP_OFF_NUM" (
    "ANNUAL" NUMERIC,
    "LINE" NUMERIC,
    "REVERSE_NUMBER" NUMERIC,
    "STATION_NAME" TEXT,
    "JANUARY_2022" NUMERIC,
    "FEBRUARY_2022" NUMERIC,
    "MARCH_2022" NUMERIC,
    "APRIL_2022" NUMERIC,
    "MAY_2022" NUMERIC
);

-- Table: publicdata_transportation_953__SELMETRO_LINE_18_HISTORIC_COORDI
CREATE TABLE "aihub_transport"."publicdata_transportation_953__SELMETRO_LINE_18_HISTORIC_COORDI" (
    "ANNUAL" NUMERIC,
    "LINE" NUMERIC,
    "REVERSE_NUMBER" NUMERIC,
    "STATION_NAME" TEXT,
    "HARDNESS" NUMERIC,
    "LATITUDE" NUMERIC,
    "DATA_STANDARD_DATE" TEXT
);

-- Table: publicdata_transportation_965__STS_ILLEGAL_PARKING_CONTROL_DALS
CREATE TABLE "aihub_transport"."publicdata_transportation_965__STS_ILLEGAL_PARKING_CONTROL_DALS" (
    "REGULATORY_BODY" TEXT,
    "VIOLATION_DATE" TEXT,
    "VIOLATION_TIME" TEXT,
    "NAME_PLACE_VIOLATION" TEXT,
    "DEPARTMENT_CHARGE" TEXT,
    "BASE_DATE" TEXT
);

-- Table: seouldata_transportation_1154__TB_ROAD_GPS_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_1154__TB_ROAD_GPS_INFO" (
    "BUSINAME" TEXT,
    "CONSTRAINTCAR" TEXT,
    "DIRECTIONNAME" TEXT,
    "LANDMARK" TEXT,
    "LIGHTCD" TEXT,
    "LINECOUNT" TEXT,
    "LINESTRUCT" TEXT,
    "LINETYPE" TEXT,
    "ORGANNAME" TEXT,
    "POLICEORG" TEXT,
    "POSITIONX" NUMERIC,
    "POSITIONY" NUMERIC,
    "ROADLINENAME" TEXT,
    "ROADPLACENAME" TEXT,
    "ROADWAYNAME" TEXT,
    "SECTIONMETER" TEXT,
    "SPEEDLIMIT" TEXT,
    "WORK_DTTM" TEXT
);

-- Table: seouldata_transportation_1159__SEARCH_LAST_TRAIN_TIME_BY_I_D_SE
CREATE TABLE "aihub_transport"."seouldata_transportation_1159__SEARCH_LAST_TRAIN_TIME_BY_I_D_SE" (
    "FR_CODE" TEXT,
    "STATION_CD" NUMERIC,
    "STATION_NM" TEXT,
    "SUBWAYENAME" TEXT,
    "LEFTTIME" TEXT,
    "WEEK_TAG" TEXT,
    "INOUT_TAG" TEXT
);

-- Table: seouldata_transportation_1171__SEOUL_METRO_FACI_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_1171__SEOUL_METRO_FACI_INFO" (
    "STATION_ID" NUMERIC,
    "STATION_NM" TEXT,
    "FACI_NM" TEXT,
    "STUP_LCTN" TEXT,
    "LOCATION" TEXT,
    "USE_YN" TEXT,
    "GUBUN" TEXT
);

-- Table: seouldata_transportation_1177__SEARCH_FIRST_AND_LAST_TRAINBY_LI
CREATE TABLE "aihub_transport"."seouldata_transportation_1177__SEARCH_FIRST_AND_LAST_TRAINBY_LI" (
    "LINE_NUM" TEXT,
    "INOUT_TAG" TEXT,
    "WEEK_TAG" TEXT,
    "STATION_CD" NUMERIC,
    "FR_CODE" TEXT,
    "STATION_NM" TEXT,
    "FIRST_TIME" NUMERIC,
    "F_ORIGINSTATION" NUMERIC,
    "F_DESTSTATION" NUMERIC,
    "F_SUBWAYSNAME" TEXT,
    "F_SUBWAYENAME" TEXT,
    "LAST_TIME" NUMERIC,
    "L_ORIGINSTATION" NUMERIC,
    "L_DESTSTATION" NUMERIC,
    "L_SUBWAYSNAME" TEXT,
    "L_SUBWAYENAME" TEXT
);

-- Table: seouldata_transportation_1178__SEOUL_METRO_ST_AREA
CREATE TABLE "aihub_transport"."seouldata_transportation_1178__SEOUL_METRO_ST_AREA" (
    "STATION_ID" NUMERIC,
    "EXIT_NO" TEXT,
    "AREA_NAME" TEXT
);

-- Table: seouldata_transportation_1180__PUBLIC_PARKING_TIKET
CREATE TABLE "aihub_transport"."seouldata_transportation_1180__PUBLIC_PARKING_TIKET" (
    "BASE_YM" TEXT,
    "CARNAME" TEXT,
    "CARNUM" NUMERIC,
    "CARNUMM" TEXT,
    "CARCNT" NUMERIC,
    "CARCNTM" TEXT
);

-- Table: seouldata_transportation_1196__LIST_T_B_SE_F_M_PROGRAM_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_1196__LIST_T_B_SE_F_M_PROGRAM_INFO" (
    "SCHEDULE_SEQ" TEXT,
    "CHANNEL_CODE" TEXT,
    "CHANNEL_NAME" TEXT,
    "PROGRAM_ID" TEXT,
    "PROGRAM_NAME" TEXT,
    "PROGRAM_TYPE" TEXT,
    "PROGRAM_MC" TEXT,
    "PROGRAM_URL" TEXT,
    "EPISODE_SUBJECT" TEXT,
    "DISPLAY_NAME" TEXT,
    "ON_DATE" TEXT,
    "ON_TIME" TEXT,
    "VIEW_TIME" TEXT,
    "RUNTIME" NUMERIC,
    "AUDIO_TYPE" TEXT,
    "PROGRAM_DESCRIPTION" TEXT
);

-- Table: seouldata_transportation_1197__LIST_T_B_S_T_V_PROGRAM_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_1197__LIST_T_B_S_T_V_PROGRAM_INFO" (
    "SCHEDULE_SEQ" NUMERIC,
    "CHANNEL_CODE" TEXT,
    "CHANNEL_NAME" TEXT,
    "PROGRAM_ID" TEXT,
    "PROGRAM_NAME" TEXT,
    "PROGRAM_TYPE" TEXT,
    "PROGRAM_MC" TEXT,
    "PROGRAM_URL" TEXT,
    "ON_DATE" TEXT,
    "ON_TIME" TEXT,
    "RUNTIME" NUMERIC,
    "PROGRAM_DESCRIPTION" TEXT
);

-- Table: seouldata_transportation_1201__SEARCH_INFO_BY_SUBWAY_NAME_SERVI
CREATE TABLE "aihub_transport"."seouldata_transportation_1201__SEARCH_INFO_BY_SUBWAY_NAME_SERVI" (
    "STATION_CD" TEXT,
    "STATION_NM" TEXT,
    "LINE_NUM" TEXT,
    "FR_CODE" TEXT
);

-- Table: seouldata_transportation_1232__STATION_ADRES_TELNO
CREATE TABLE "aihub_transport"."seouldata_transportation_1232__STATION_ADRES_TELNO" (
    "LINE" TEXT,
    "STATN_NM" TEXT,
    "ADRES" TEXT,
    "RDNMADR" TEXT,
    "TELNO" TEXT
);

-- Table: seouldata_transportation_1234__SMRT_SCN_FCLTS_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_1234__SMRT_SCN_FCLTS_INFO" (
    "SN" TEXT,
    "LINE_NUM" TEXT,
    "STATN_NM" TEXT,
    "EQPMN" TEXT,
    "ISSNO" TEXT,
    "LIFTING_STROKE" TEXT,
    "INSTL_HG" TEXT,
    "OPRAT_LT" TEXT
);

-- Table: seouldata_transportation_1235__STATION_DSTNC_REQRE_TIME_HM
CREATE TABLE "aihub_transport"."seouldata_transportation_1235__STATION_DSTNC_REQRE_TIME_HM" (
    "LINE" TEXT,
    "STATN_NM" TEXT,
    "MNT" TEXT,
    "DSTNC" TEXT,
    "ACMTL" TEXT
);

-- Table: seouldata_transportation_1236__METRO_STN_BUILDING_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_1236__METRO_STN_BUILDING_INFO" (
    "STN_LINE" TEXT,
    "STN_NM" TEXT,
    "STN_TYPE" TEXT,
    "STN_LEN" NUMERIC,
    "STN_FLOOR_CNT" TEXT,
    "STN_AREA" TEXT,
    "STN_CPLT_YEAR" TEXT
);

-- Table: seouldata_transportation_1242__ODBLR_DSPSN_CVNTL
CREATE TABLE "aihub_transport"."seouldata_transportation_1242__ODBLR_DSPSN_CVNTL" (
    "LINE" TEXT,
    "STATN_NM" TEXT,
    "EXTRL_ELVTR" TEXT,
    "INNER_ELVTR" TEXT,
    "EXTRL_ESCLTR" TEXT,
    "INNER_ESCLTR" TEXT,
    "WHEELCHAIR_LIFT" TEXT,
    "HRZNTLTY_ATMC_FTPTH" TEXT,
    "RM" TEXT
);

-- Table: seouldata_transportation_1247__TOURIST_SPOT_AROUND_SUBWAY_EXIT
CREATE TABLE "aihub_transport"."seouldata_transportation_1247__TOURIST_SPOT_AROUND_SUBWAY_EXIT" (
    "SEQ_NO" TEXT,
    "AREA_NM" TEXT,
    "STAT_NM" TEXT,
    "STAT_CD" NUMERIC,
    "STATLN_NM" TEXT,
    "STATOUT_NO" TEXT,
    "ETC_ST" TEXT,
    "URL_ST" TEXT
);

-- Table: seouldata_transportation_180__IDM_STAT_MONTH_VIEW
CREATE TABLE "aihub_transport"."seouldata_transportation_180__IDM_STAT_MONTH_VIEW" (
    "APPLY_YEAR" TEXT,
    "APPLY_MONTH" NUMERIC,
    "NEWREGCOUNT" NUMERIC,
    "CHA_CHA" NUMERIC,
    "CHA_SUS" NUMERIC,
    "CHA_CLO" NUMERIC,
    "CHA_TRA" NUMERIC,
    "CHA_INH" NUMERIC,
    "CHA_MER" NUMERIC,
    "CHA_MOV" NUMERIC,
    "CHA_STA" NUMERIC,
    "CHA_ETC" NUMERIC,
    "CHANGETOTALCOUNT" NUMERIC,
    "PENALTY_01" NUMERIC,
    "PENALTY_02" NUMERIC,
    "PENALTY_03" NUMERIC,
    "PENALTY_04" NUMERIC,
    "PENALTY_05" NUMERIC,
    "PENALTY_06" NUMERIC,
    "PENALTY_07" NUMERIC,
    "PENALTYTOTALCOUNT" NUMERIC
);

-- Table: seouldata_transportation_181__IDM_STAT_GU
CREATE TABLE "aihub_transport"."seouldata_transportation_181__IDM_STAT_GU" (
    "APPLY_YEAR" TEXT,
    "APPLY_MONTH" NUMERIC,
    "GUNAME" TEXT,
    "GUCODE" NUMERIC,
    "NEWREGCOUNT" NUMERIC,
    "CHA_CHA" NUMERIC,
    "CHA_SUS" NUMERIC,
    "CHA_CLO" NUMERIC,
    "CHA_TRA" NUMERIC,
    "CHA_INH" NUMERIC,
    "CHA_MER" NUMERIC,
    "CHA_MOV" NUMERIC,
    "CHA_STA" NUMERIC,
    "CHA_ETC" NUMERIC,
    "CHANGETOTALCOUNT" NUMERIC,
    "PENALTY_01" NUMERIC,
    "PENALTY_02" NUMERIC,
    "PENALTY_03" NUMERIC,
    "PENALTY_04" NUMERIC,
    "PENALTY_05" NUMERIC,
    "PENALTY_06" NUMERIC,
    "PENALTY_07" NUMERIC,
    "PENALTYTOTALCOUNT" NUMERIC
);

-- Table: seouldata_transportation_182__SERVICE_FORWARDER_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_182__SERVICE_FORWARDER_INFO" (
    "SEQ" NUMERIC,
    "COMPANY" TEXT,
    "LICENSE_DATE" TEXT,
    "ADDR1" TEXT,
    "ADDR2" TEXT,
    "SANGTAE_CD" NUMERIC,
    "SANGTAE_NM" TEXT,
    "PRTCD" NUMERIC,
    "PRTNM" TEXT,
    "TEL" TEXT,
    "NATION" TEXT,
    "BOHUM_DATE1" TEXT,
    "BOHUM_DATE2" TEXT,
    "CHANGE_DATE" TEXT,
    "REASON_CD" TEXT,
    "CD_NM" TEXT
);

-- Table: seouldata_transportation_188__RDT_ROUT_DATA_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_188__RDT_ROUT_DATA_INFO" (
    "RNUM" NUMERIC,
    "ROD_NUM" TEXT,
    "ADA_CDE_NM" TEXT,
    "FNC_CDE_NM" TEXT,
    "SIZ_CDE_NM1" TEXT,
    "SIZ_CDE_NM2" TEXT,
    "COW_CDE_NM" TEXT
);

-- Table: seouldata_transportation_208__LOST_ARTICLE_BIZ_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_208__LOST_ARTICLE_BIZ_INFO" (
    "IDX" NUMERIC,
    "CODE" TEXT,
    "GIYUG" TEXT,
    "COMPANY" TEXT
);

-- Table: seouldata_transportation_209__LOST_ARTICLE_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_209__LOST_ARTICLE_INFO" (
    "ID" NUMERIC,
    "STATUS" TEXT,
    "REG_DATE" TEXT,
    "GET_DATE" TEXT,
    "GET_THING" TEXT,
    "TAKE_PLACE" TEXT,
    "TAKE_ID" TEXT,
    "GET_NAME" TEXT,
    "CATE" TEXT,
    "GET_AREA" TEXT,
    "GET_POSITION" TEXT,
    "GET_GOOD" TEXT,
    "READ_CNT" NUMERIC
);

-- Table: seouldata_transportation_221__TB_BUS_RUN_DISTANCE
CREATE TABLE "aihub_transport"."seouldata_transportation_221__TB_BUS_RUN_DISTANCE" (
    "RUN_DT" TEXT,
    "ROUTE_NAME" TEXT,
    "FNL_RCOGN_CNT" NUMERIC,
    "RUN_DISTANCE" NUMERIC
);

-- Table: seouldata_transportation_237__SERVICE_ROJUM_MINWON
CREATE TABLE "aihub_transport"."seouldata_transportation_237__SERVICE_ROJUM_MINWON" (
    "INDEXS" NUMERIC,
    "GU_NM" TEXT,
    "REGIST_DATE" TEXT,
    "COL1" NUMERIC,
    "COL2" NUMERIC,
    "COL3" NUMERIC,
    "COL4" NUMERIC,
    "COL5" NUMERIC,
    "COL6" NUMERIC,
    "COL7" NUMERIC,
    "COL8" NUMERIC
);

-- Table: seouldata_transportation_249__SERVICE_PLACE
CREATE TABLE "aihub_transport"."seouldata_transportation_249__SERVICE_PLACE" (
    "ADMIN_NO" TEXT,
    "TYPE" TEXT,
    "SECTION" TEXT,
    "TAX_SET" TEXT,
    "SI_NM" TEXT,
    "GU_NM" TEXT,
    "BJ_NM" TEXT,
    "BONBUN" TEXT,
    "BUBUN" TEXT,
    "MUL_FROMDATE" TEXT,
    "MUL_TODATE" NUMERIC,
    "JYADDR_NEW" TEXT,
    "JYADDR_BON" TEXT,
    "JYADDR_BU" TEXT,
    "AREA_SIZE" NUMERIC
);

-- Table: seouldata_transportation_256__SERVICER_GAPAN_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_256__SERVICER_GAPAN_INFO" (
    "GAPAN_NO" TEXT,
    "SI_NM" TEXT,
    "GU_NM" TEXT,
    "BJ_NM" TEXT,
    "TYPE" TEXT,
    "BONBUN" NUMERIC,
    "BUBUN" NUMERIC,
    "WITH_DORO_NM" TEXT,
    "WITH_INFO" TEXT,
    "FT_TYP" TEXT,
    "FT_SEL" TEXT,
    "FACIL_L" NUMERIC,
    "FACIL_W" NUMERIC,
    "FACIL_H" NUMERIC,
    "PLACE_L" NUMERIC,
    "PLACE_H" NUMERIC,
    "PLACE_A" NUMERIC,
    "SECTION" TEXT,
    "MUL_FROMDATE" TEXT,
    "MUL_TODATE" TEXT
);

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

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

-- Table: seouldata_transportation_394__TB_TRAFIC_ELVTR
CREATE TABLE "aihub_transport"."seouldata_transportation_394__TB_TRAFIC_ELVTR" (
    "TYPE" TEXT,
    "NODE_WKT" TEXT,
    "NODE_ID" NUMERIC,
    "NODE_CODE" TEXT,
    "SGG_NM" TEXT,
    "EMD_CD" NUMERIC,
    "EMD_NM" TEXT,
    "SW_CD" TEXT,
    "SW_NM" TEXT
);

-- Table: seouldata_transportation_448__TB_USE_DAYSTATUS_VIEW
CREATE TABLE "aihub_transport"."seouldata_transportation_448__TB_USE_DAYSTATUS_VIEW" (
    "PARKING_DIV_CD" TEXT,
    "PARKING_NM" TEXT,
    "USE_CNT" TEXT,
    "USE_MIN" TEXT,
    "DT" TEXT
);

-- Table: seouldata_transportation_480__TB_TRAFIC_UNDPASS
CREATE TABLE "aihub_transport"."seouldata_transportation_480__TB_TRAFIC_UNDPASS" (
    "TYPE" TEXT,
    "NODE_WKT" TEXT,
    "NODE_ID" TEXT,
    "NODE_CODE" TEXT,
    "LINK_WKT" TEXT,
    "LINK_ID" TEXT,
    "LINK_CODE" NUMERIC,
    "STRT_NODE_ID" TEXT,
    "END_NODE_ID" TEXT,
    "LINK_LEN" NUMERIC,
    "SGG_CD" NUMERIC,
    "SGG_NM" TEXT,
    "EMD_CD" NUMERIC,
    "EMD_NM" TEXT,
    "SW_CD" TEXT,
    "SW_NM" TEXT,
    "TP_LF" TEXT,
    "TP_EV" TEXT
);

-- Table: seouldata_transportation_481__CARD_SUBWAY_TIME
CREATE TABLE "aihub_transport"."seouldata_transportation_481__CARD_SUBWAY_TIME" (
    "USE_MON" TEXT,
    "LINE_NUM" TEXT,
    "SUB_STA_NM" TEXT,
    "FOUR_RIDE_NUM" TEXT,
    "FOUR_ALIGHT_NUM" TEXT,
    "FIVE_RIDE_NUM" TEXT,
    "FIVE_ALIGHT_NUM" TEXT,
    "SIX_RIDE_NUM" TEXT,
    "SIX_ALIGHT_NUM" TEXT,
    "SEVEN_RIDE_NUM" TEXT,
    "SEVEN_ALIGHT_NUM" TEXT,
    "EIGHT_RIDE_NUM" TEXT,
    "EIGHT_ALIGHT_NUM" TEXT,
    "NINE_RIDE_NUM" TEXT,
    "NINE_ALIGHT_NUM" TEXT,
    "TEN_RIDE_NUM" TEXT,
    "TEN_ALIGHT_NUM" TEXT,
    "ELEVEN_RIDE_NUM" TEXT,
    "ELEVEN_ALIGHT_NUM" TEXT,
    "TWELVE_RIDE_NUM" TEXT,
    "TWELVE_ALIGHT_NUM" TEXT,
    "THIRTEEN_RIDE_NUM" TEXT,
    "THIRTEEN_ALIGHT_NUM" TEXT,
    "FOURTEEN_RIDE_NUM" TEXT,
    "FOURTEEN_ALIGHT_NUM" TEXT,
    "FIFTEEN_RIDE_NUM" TEXT,
    "FIFTEEN_ALIGHT_NUM" TEXT,
    "SIXTEEN_RIDE_NUM" TEXT,
    "SIXTEEN_ALIGHT_NUM" TEXT,
    "SEVENTEEN_RIDE_NUM" TEXT,
    "SEVENTEEN_ALIGHT_NUM" TEXT,
    "EIGHTEEN_RIDE_NUM" TEXT,
    "EIGHTEEN_ALIGHT_NUM" TEXT,
    "NINETEEN_RIDE_NUM" TEXT,
    "NINETEEN_ALIGHT_NUM" TEXT,
    "TWENTY_RIDE_NUM" TEXT,
    "TWENTY_ALIGHT_NUM" TEXT,
    "TWENTY_ONE_RIDE_NUM" TEXT,
    "TWENTY_ONE_ALIGHT_NUM" TEXT,
    "TWENTY_TWO_RIDE_NUM" TEXT,
    "TWENTY_TWO_ALIGHT_NUM" TEXT,
    "TWENTY_THREE_RIDE_NUM" TEXT,
    "TWENTY_THREE_ALIGHT_NUM" TEXT,
    "MIDNIGHT_RIDE_NUM" TEXT,
    "MIDNIGHT_ALIGHT_NUM" TEXT,
    "ONE_RIDE_NUM" TEXT,
    "ONE_ALIGHT_NUM" TEXT,
    "WORK_DT" TEXT
);

-- Table: seouldata_transportation_482__CARD_BUS_TIME_NEW
CREATE TABLE "aihub_transport"."seouldata_transportation_482__CARD_BUS_TIME_NEW" (
    "USE_MON" TEXT,
    "BUS_ROUTE_NO" TEXT,
    "BUS_ROUTE_NM" TEXT,
    "STND_BSST_ID" NUMERIC,
    "BSST_ARS_NO" TEXT,
    "BUS_STA_NM" TEXT,
    "MIDNIGHT_RIDE_NUM" TEXT,
    "MIDNIGHT_ALIGHT_NUM" TEXT,
    "ONE_RIDE_NUM" TEXT,
    "ONE_ALIGHT_NUM" TEXT,
    "TWO_RIDE_NUM" TEXT,
    "TWO_ALIGHT_NUM" TEXT,
    "THREE_RIDE_NUM" TEXT,
    "THREE_ALIGHT_NUM" TEXT,
    "FOUR_RIDE_NUM" TEXT,
    "FOUR_ALIGHT_NUM" TEXT,
    "FIVE_RIDE_NUM" TEXT,
    "FIVE_ALIGHT_NUM" TEXT,
    "SIX_RIDE_NUM" TEXT,
    "SIX_ALIGHT_NUM" TEXT,
    "SEVEN_RIDE_NUM" TEXT,
    "SEVEN_ALIGHT_NUM" TEXT,
    "EIGHT_RIDE_NUM" TEXT,
    "EIGHT_ALIGHT_NUM" TEXT,
    "NINE_RIDE_NUM" TEXT,
    "NINE_ALIGHT_NUM" TEXT,
    "TEN_RIDE_NUM" TEXT,
    "TEN_ALIGHT_NUM" TEXT,
    "ELEVEN_RIDE_NUM" TEXT,
    "ELEVEN_ALIGHT_NUM" TEXT,
    "TWELVE_RIDE_NUM" TEXT,
    "TWELVE_ALIGHT_NUM" TEXT,
    "THIRTEEN_RIDE_NUM" TEXT,
    "THIRTEEN_ALIGHT_NUM" TEXT,
    "FOURTEEN_RIDE_NUM" TEXT,
    "FOURTEEN_ALIGHT_NUM" TEXT,
    "FIFTEEN_RIDE_NUM" TEXT,
    "FIFTEEN_ALIGHT_NUM" TEXT,
    "SIXTEEN_RIDE_NUM" TEXT,
    "SIXTEEN_ALIGHT_NUM" TEXT,
    "SEVENTEEN_RIDE_NUM" TEXT,
    "SEVENTEEN_ALIGHT_NUM" TEXT,
    "EIGHTEEN_RIDE_NUM" TEXT,
    "EIGHTEEN_ALIGHT_NUM" TEXT,
    "NINETEEN_RIDE_NUM" TEXT,
    "NINETEEN_ALIGHT_NUM" TEXT
);

-- Table: seouldata_transportation_5002__CSCY_PUBLIC_VIEW_G_C
CREATE TABLE "aihub_transport"."seouldata_transportation_5002__CSCY_PUBLIC_VIEW_G_C" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "GC_CAR_CUSTODY_SIDO" TEXT,
    "GC_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_5003__CSCY_PUBLIC_VIEW_E_P
CREATE TABLE "aihub_transport"."seouldata_transportation_5003__CSCY_PUBLIC_VIEW_E_P" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "EP_CAR_CUSTODY_SIDO" TEXT,
    "EP_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_5004__CSCY_PUBLIC_VIEW_G_N
CREATE TABLE "aihub_transport"."seouldata_transportation_5004__CSCY_PUBLIC_VIEW_G_N" (
    "CSDY_YYYY" TEXT,
    "GN_CAR_CUSTODY_CSDY_MM" NUMERIC,
    "GN_CAR_CUSTODY_SIDO" TEXT,
    "GN_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_5005__CSCY_PUBLIC_VIEW_S_C
CREATE TABLE "aihub_transport"."seouldata_transportation_5005__CSCY_PUBLIC_VIEW_S_C" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "SIDO" TEXT,
    "SC_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" NUMERIC
);

-- Table: seouldata_transportation_5006__CSCY_PUBLIC_VIEW_G_R
CREATE TABLE "aihub_transport"."seouldata_transportation_5006__CSCY_PUBLIC_VIEW_G_R" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "GR_CAR_CUSTODY_SIDO" TEXT,
    "GR_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_5007__CSCY_PUBLIC_VIEW_S_D
CREATE TABLE "aihub_transport"."seouldata_transportation_5007__CSCY_PUBLIC_VIEW_S_D" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "SD_CAR_CUSTODY_SIDO" TEXT,
    "SD_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_5008__CSCY_PUBLIC_VIEW_G_J
CREATE TABLE "aihub_transport"."seouldata_transportation_5008__CSCY_PUBLIC_VIEW_G_J" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "GJ_CAR_CUSTODY_SIDO" TEXT,
    "GJ_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" NUMERIC
);

-- Table: seouldata_transportation_5009__CSCY_PUBLIC_VIEW_D_D
CREATE TABLE "aihub_transport"."seouldata_transportation_5009__CSCY_PUBLIC_VIEW_D_D" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "DDM_CAR_CUSTODY_SIDO" TEXT,
    "DDM_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_5010__CSCY_PUBLIC_VIEW_S_P
CREATE TABLE "aihub_transport"."seouldata_transportation_5010__CSCY_PUBLIC_VIEW_S_P" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "SP_CAR_CUSTODY_SIDO" TEXT,
    "SP_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" NUMERIC
);

-- Table: seouldata_transportation_5011__CSCY_PUBLIC_VIEW_G_B
CREATE TABLE "aihub_transport"."seouldata_transportation_5011__CSCY_PUBLIC_VIEW_G_B" (
    "GB_CAR_CUSTODY_CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "SIDO" TEXT,
    "GB_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" NUMERIC
);

-- Table: seouldata_transportation_5012__CSCY_PUBLIC_VIEW_Y_S
CREATE TABLE "aihub_transport"."seouldata_transportation_5012__CSCY_PUBLIC_VIEW_Y_S" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "SIDO" TEXT,
    "YS_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_5013__CSCY_PUBLIC_VIEW_G_S
CREATE TABLE "aihub_transport"."seouldata_transportation_5013__CSCY_PUBLIC_VIEW_G_S" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "GS_CAR_CUSTODY_SIDO" TEXT,
    "GS_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_5014__CSCY_PUBLIC_VIEW_S_M
CREATE TABLE "aihub_transport"."seouldata_transportation_5014__CSCY_PUBLIC_VIEW_S_M" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "SIDO" TEXT,
    "SDD_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" NUMERIC
);

-- Table: seouldata_transportation_5015__CSCY_PUBLIC_VIEW_N_W
CREATE TABLE "aihub_transport"."seouldata_transportation_5015__CSCY_PUBLIC_VIEW_N_W" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "NW_CAR_CUSTODY_SIDO" TEXT,
    "NW_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_5016__CSCY_PUBLIC_VIEW_J_N
CREATE TABLE "aihub_transport"."seouldata_transportation_5016__CSCY_PUBLIC_VIEW_J_N" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "JNO_CAR_CUSTODY_SIDO" TEXT,
    "JNO_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_5017__CSCY_PUBLIC_VIEW_S_B
CREATE TABLE "aihub_transport"."seouldata_transportation_5017__CSCY_PUBLIC_VIEW_S_B" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "SB_CAR_CUSTODY_SIDO" TEXT,
    "SB_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_5018__CSCY_PUBLIC_VIEW_J_G
CREATE TABLE "aihub_transport"."seouldata_transportation_5018__CSCY_PUBLIC_VIEW_J_G" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "JG_CAR_CUSTODY_SIDO" TEXT,
    "JG_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_5019__CSCY_PUBLIC_VIEW_D_B
CREATE TABLE "aihub_transport"."seouldata_transportation_5019__CSCY_PUBLIC_VIEW_D_B" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "SIDO" TEXT,
    "DB_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_5020__CSCY_PUBLIC_VIEW_Y_C
CREATE TABLE "aihub_transport"."seouldata_transportation_5020__CSCY_PUBLIC_VIEW_Y_C" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "YC_CAR_CUSTODY_SIDO" TEXT,
    "YC_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_5021__CSCY_PUBLIC_VIEW_D_J
CREATE TABLE "aihub_transport"."seouldata_transportation_5021__CSCY_PUBLIC_VIEW_D_J" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "SIDO" TEXT,
    "DJ_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_5022__T_N_C_S_D_Y_P_U_B_L_I_C_V_I_E_W_
CREATE TABLE "aihub_transport"."seouldata_transportation_5022__T_N_C_S_D_Y_P_U_B_L_I_C_V_I_E_W_" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "GD_CAR_CUSTODY_SIDO" TEXT,
    "GD_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_5023__CSCY_PUBLIC_VIEW_M_P
CREATE TABLE "aihub_transport"."seouldata_transportation_5023__CSCY_PUBLIC_VIEW_M_P" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "MP_CAR_CUSTODY_SIDO" TEXT,
    "MP_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_5024__CSCY_PUBLIC_VIEW_G_A
CREATE TABLE "aihub_transport"."seouldata_transportation_5024__CSCY_PUBLIC_VIEW_G_A" (
    "GA_CAR_CUSTODY_CSDY_YYYY" TEXT,
    "GA_CAR_CUSTODY_CSDY_MM" NUMERIC,
    "GA_CAR_CUSTODY_SIDO" TEXT,
    "GA_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "GA_CAR_CUSTODY_CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_5025__CSCY_PUBLIC_VIEW_Y_D
CREATE TABLE "aihub_transport"."seouldata_transportation_5025__CSCY_PUBLIC_VIEW_Y_D" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "SIDO" TEXT,
    "YDP_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_5026__CSCY_PUBLIC_VIEW_J_R
CREATE TABLE "aihub_transport"."seouldata_transportation_5026__CSCY_PUBLIC_VIEW_J_R" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "JNG_CAR_CUSTODY_SIDO" TEXT,
    "JNG_CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_510__TB_TRAFIC_BRDGE
CREATE TABLE "aihub_transport"."seouldata_transportation_510__TB_TRAFIC_BRDGE" (
    "TYPE" TEXT,
    "NODE_WKT" TEXT,
    "NODE_ID" TEXT,
    "NODE_CODE" TEXT,
    "LINK_WKT" TEXT,
    "LINK_ID" TEXT,
    "LINK_CODE" NUMERIC,
    "STRT_NODE_ID" TEXT,
    "END_NODE_ID" TEXT,
    "LINK_LEN" NUMERIC,
    "SGG_NM" TEXT,
    "EMD_NM" TEXT
);

-- Table: seouldata_transportation_5147__TB_OPENDATA_FIXEDCCTV_J_N
CREATE TABLE "aihub_transport"."seouldata_transportation_5147__TB_OPENDATA_FIXEDCCTV_J_N" (
    "ADDRESS" TEXT,
    "LATITUDE" NUMERIC,
    "LONGITUDE" TEXT,
    "PSTINST_CD" TEXT,
    "REGLT_SPOT_NM" TEXT,
    "JN_SPT_KIND_CD" TEXT
);

-- Table: seouldata_transportation_5153__GANGNAM_CHILD_SAVE_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_5153__GANGNAM_CHILD_SAVE_INFO" (
    "ID" TEXT,
    "KIND" TEXT,
    "NM" TEXT,
    "ADDR" TEXT,
    "YCODE" NUMERIC,
    "XCODE" NUMERIC,
    "MANAGE_NM" TEXT,
    "MANAGE_POL" TEXT,
    "CCTV_YN" TEXT,
    "CCTV_NM" TEXT,
    "SAVE_ROAD_WIDTH" TEXT,
    "DATA_DATE" TEXT
);

-- Table: seouldata_transportation_5161__TB_OPENDATA_FIXEDCCTV_Y_D
CREATE TABLE "aihub_transport"."seouldata_transportation_5161__TB_OPENDATA_FIXEDCCTV_Y_D" (
    "ADRES" TEXT,
    "LATITUDE" NUMERIC,
    "LONGITUDE" NUMERIC,
    "PSTINST_CD_NM" TEXT,
    "REGLT_SPOT_NM" TEXT
);

-- Table: seouldata_transportation_5165__GANGNAM_RENT_CAR_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_5165__GANGNAM_RENT_CAR_INFO" (
    "ID" TEXT,
    "OFFICE_NM" TEXT,
    "OFFICE_FLAG" TEXT,
    "ADDRESS" TEXT,
    "ADDRESS_OLD" TEXT,
    "YCODE" NUMERIC,
    "XCODE" NUMERIC,
    "CAR_ADDRESS" TEXT,
    "CAR_ADDRESS_OLD" TEXT,
    "MAXCAR" TEXT,
    "TOTAL_CNT" TEXT,
    "CAR_CNT" TEXT,
    "VAN_CNT" TEXT,
    "ELEC_CAR_CNT" TEXT,
    "ELEC_VAN_CNT" TEXT,
    "COMPACT_CHARGE" TEXT,
    "SMALL_CHARGE" TEXT,
    "MIDDLE_CHARGE" TEXT,
    "LARGE_CHARGE" TEXT,
    "VAN_CHARGE" TEXT,
    "LEISURE_CHARGE" TEXT,
    "INCOME_CHARGE" TEXT,
    "OPEN_TM" TEXT,
    "CLOSE_TM" TEXT,
    "WEEK_OPEN_TM" TEXT,
    "WEEK_CLOSE_TM" TEXT,
    "HOLIDAY_OPEN_TM" TEXT,
    "HOLIDAY_CLOSE_TM" TEXT,
    "HAVEOFF" TEXT,
    "HOMEPAGE" TEXT,
    "REPRSNT_NM" TEXT,
    "TEL" TEXT,
    "CHECK_DATE" TEXT
);

-- Table: seouldata_transportation_5171__TB_OPENDATA_FIXEDCCTV_G_N
CREATE TABLE "aihub_transport"."seouldata_transportation_5171__TB_OPENDATA_FIXEDCCTV_G_N" (
    "ADRES" TEXT,
    "LATITUDE" NUMERIC,
    "LONGITUDE" NUMERIC,
    "PSTINST_CD" TEXT,
    "REGLT_SPOT_NM" TEXT,
    "SPT_KIND_CD" TEXT
);

-- Table: seouldata_transportation_5192__TB_OPENDATA_FIXEDCCTV_J_G
CREATE TABLE "aihub_transport"."seouldata_transportation_5192__TB_OPENDATA_FIXEDCCTV_J_G" (
    "ADRES" TEXT,
    "LATITUDE" NUMERIC,
    "LONGITUDE" NUMERIC,
    "PSTINST_CD_NM" TEXT,
    "REGLT_SPOT_NM" TEXT
);

-- Table: seouldata_transportation_5201__TB_OPENDATA_FIXEDCCTV_S_B
CREATE TABLE "aihub_transport"."seouldata_transportation_5201__TB_OPENDATA_FIXEDCCTV_S_B" (
    "ADRES" TEXT,
    "S_B_LATITUDE" NUMERIC,
    "LONGITUDE" NUMERIC,
    "S_B_PSTINST_CD" TEXT,
    "REGLT_SPOT_NM" TEXT
);

-- Table: seouldata_transportation_5228__TB_OPENDATA_FIXEDCCTV_N_W
CREATE TABLE "aihub_transport"."seouldata_transportation_5228__TB_OPENDATA_FIXEDCCTV_N_W" (
    "ADRES" TEXT,
    "LATITUDE" NUMERIC,
    "LONGITUDE" NUMERIC,
    "PSTINST_CODE" TEXT,
    "REGLT_SPOT_NM" TEXT
);

-- Table: seouldata_transportation_5229__TB_OPENDATA_FIXEDCCTV_E_P
CREATE TABLE "aihub_transport"."seouldata_transportation_5229__TB_OPENDATA_FIXEDCCTV_E_P" (
    "CCTV_ADDRESS" TEXT,
    "LATITUDE" NUMERIC,
    "LONGITUDE" NUMERIC,
    "PSTINST_CD" TEXT,
    "REGLT_SPOT_NM" TEXT,
    "EP_SPT_KIND_CD" TEXT
);

-- Table: seouldata_transportation_5230__TB_OPENDATA_FIXEDCCTV_G_B
CREATE TABLE "aihub_transport"."seouldata_transportation_5230__TB_OPENDATA_FIXEDCCTV_G_B" (
    "ADRES" TEXT,
    "LATITUDE" NUMERIC,
    "LONGITUDE" NUMERIC,
    "PSTINST_CD" TEXT,
    "REGLT_SPOT_NM" TEXT,
    "GB_SPT_KIND_CD" TEXT
);

-- Table: seouldata_transportation_5231__TB_OPENDATA_FIXEDCCTV_S_M
CREATE TABLE "aihub_transport"."seouldata_transportation_5231__TB_OPENDATA_FIXEDCCTV_S_M" (
    "ADRES" TEXT,
    "LATITUDE" NUMERIC,
    "LONGITUDE" NUMERIC,
    "S_M_PSTINST_CD" TEXT,
    "REGLT_SPOT_NM" TEXT
);

-- Table: seouldata_transportation_5232__TB_OPENDATA_FIXEDCCTV_Y_S
CREATE TABLE "aihub_transport"."seouldata_transportation_5232__TB_OPENDATA_FIXEDCCTV_Y_S" (
    "Y_S_ADRES" TEXT,
    "LATITUDE" NUMERIC,
    "LONGITUDE" NUMERIC,
    "Y_S_PSTINST_CD" TEXT,
    "REGLT_SPOT_NM" TEXT
);

-- Table: seouldata_transportation_5233__TB_OPENDATA_FIXEDCCTV_D_B
CREATE TABLE "aihub_transport"."seouldata_transportation_5233__TB_OPENDATA_FIXEDCCTV_D_B" (
    "ADRES" TEXT,
    "LATITUDE" NUMERIC,
    "LONGITUDE" NUMERIC,
    "PSTINST_CD" TEXT,
    "REGLT_SPOT_NM" TEXT
);

-- Table: seouldata_transportation_5234__TB_OPENDATA_FIXEDCCTV_S_P
CREATE TABLE "aihub_transport"."seouldata_transportation_5234__TB_OPENDATA_FIXEDCCTV_S_P" (
    "ADRES" TEXT,
    "LATITUDE" NUMERIC,
    "LONGITUDE" NUMERIC,
    "PSTINST_CD" TEXT,
    "REGLT_SPOT_NM" TEXT,
    "SPT_KIND_CD" TEXT
);

-- Table: seouldata_transportation_5235__TB_OPENDATA_FIXEDCCTV_G_D
CREATE TABLE "aihub_transport"."seouldata_transportation_5235__TB_OPENDATA_FIXEDCCTV_G_D" (
    "ADRES" TEXT,
    "LATITUDE" NUMERIC,
    "LONGITUDE" TEXT,
    "PSTINST_CD" TEXT,
    "REGLT_SPOT_NM" TEXT,
    "GD_SPT_KIND_CD" TEXT
);

-- Table: seouldata_transportation_5237__TB_OPENDATA_FIXEDCCTV_D_J
CREATE TABLE "aihub_transport"."seouldata_transportation_5237__TB_OPENDATA_FIXEDCCTV_D_J" (
    "ADRES" TEXT,
    "LATITUDE" NUMERIC,
    "LONGITUDE" NUMERIC,
    "D_J_PSTINST_CD" TEXT,
    "D_J_REGLT_SPOT_NM" TEXT
);

-- Table: seouldata_transportation_5238__TB_OPENDATA_FIXEDCCTV_Y_C
CREATE TABLE "aihub_transport"."seouldata_transportation_5238__TB_OPENDATA_FIXEDCCTV_Y_C" (
    "ADRES" TEXT,
    "Y_C_LATITUDE" NUMERIC,
    "Y_C_LONGITUDE" NUMERIC,
    "Y_C_PSTINST_CD" TEXT,
    "REGLT_SPOT_NM" TEXT
);

-- Table: seouldata_transportation_5239__TB_OPENDATA_FIXEDCCTV_S_C
CREATE TABLE "aihub_transport"."seouldata_transportation_5239__TB_OPENDATA_FIXEDCCTV_S_C" (
    "ADRES" TEXT,
    "LATITUDE" NUMERIC,
    "LONGITUDE" NUMERIC,
    "PSTINST_CD" TEXT,
    "REGLT_SPOT_NM" TEXT
);

-- Table: seouldata_transportation_5397__NANUMCAR_SPOT_LIST
CREATE TABLE "aihub_transport"."seouldata_transportation_5397__NANUMCAR_SPOT_LIST" (
    "LA" NUMERIC,
    "LO" NUMERIC,
    "POSITN_CD" TEXT,
    "ELCTYVHCLE_AT" TEXT,
    "ADRES" TEXT,
    "POSITN_NM" TEXT
);

-- Table: seouldata_transportation_570__TB_LIVE_PRIOR_PARKING_ZONE
CREATE TABLE "aihub_transport"."seouldata_transportation_570__TB_LIVE_PRIOR_PARKING_ZONE" (
    "PRKCMPRTNO" TEXT,
    "LATITUDE" NUMERIC,
    "LONGITUDE" NUMERIC,
    "PRKCMPRTNM" TEXT,
    "RDNMADR" TEXT,
    "LNMADR" TEXT,
    "OPERTYPE" TEXT,
    "USETIMEINFO" TEXT,
    "USEPD" TEXT,
    "PARKINGCHRGE" TEXT,
    "DSCNTINFO" TEXT,
    "METPAY" TEXT,
    "METPAYREFND" TEXT,
    "RCEPTSTARTDATE" TEXT,
    "RCEPTENDDATE" TEXT,
    "RCEPTMTH" TEXT,
    "REQSTDOC" TEXT,
    "PHONENUMBER" TEXT,
    "INSTITUTIONNM" TEXT,
    "REFERENCEDATE" TEXT,
    "INSTTCODE" TEXT,
    "INSTTNM" TEXT,
    "WORK_DTTM" TEXT
);

-- Table: seouldata_transportation_59__KSCC_PATTERN_STATION
CREATE TABLE "aihub_transport"."seouldata_transportation_59__KSCC_PATTERN_STATION" (
    "CRTR_DT" TEXT,
    "PASNG_PTTRN" TEXT,
    "TOT_PSGRCNT" NUMERIC,
    "TOT_PSGRCNT_PEPL" NUMERIC,
    "TOT_PSGRCNT_CHILD" NUMERIC,
    "TOT_PSGRCNT_BYNGR" NUMERIC,
    "TOT_PSGRCNT_ODPSN" NUMERIC,
    "TOT_PSGRCNT_DABLPSN" NUMERIC
);

-- Table: seouldata_transportation_61__TPSS_ROUTE_SECTION_USER
CREATE TABLE "aihub_transport"."seouldata_transportation_61__TPSS_ROUTE_SECTION_USER" (
    "CRTR_DT" TEXT,
    "ROUTE_ID" NUMERIC,
    "START_STTN_ID" NUMERIC,
    "ARV_STTN_ID" NUMERIC,
    "STTN_ORD" NUMERIC,
    "LOADPSGR_TOT_DD" NUMERIC,
    "LOADPSGR_TOT_0HH" NUMERIC,
    "LOADPSGR_TOT_1HH" NUMERIC,
    "LOADPSGR_TOT_2HH" NUMERIC,
    "LOADPSGR_TOT_3HH" NUMERIC,
    "LOADPSGR_TOT_4HH" NUMERIC,
    "LOADPSGR_TOT_5HH" NUMERIC,
    "LOADPSGR_TOT_6HH" NUMERIC,
    "LOADPSGR_TOT_7HH" NUMERIC,
    "LOADPSGR_TOT_8HH" NUMERIC,
    "LOADPSGR_TOT_9HH" NUMERIC,
    "LOADPSGR_TOT_10HH" NUMERIC,
    "LOADPSGR_TOT_11HH" NUMERIC,
    "LOADPSGR_TOT_12HH" NUMERIC,
    "LOADPSGR_TOT_13HH" NUMERIC,
    "LOADPSGR_TOT_14HH" NUMERIC,
    "LOADPSGR_TOT_15HH" NUMERIC,
    "LOADPSGR_TOT_16HH" NUMERIC,
    "LOADPSGR_TOT_17HH" NUMERIC,
    "LOADPSGR_TOT_18HH" NUMERIC,
    "LOADPSGR_TOT_19HH" NUMERIC,
    "LOADPSGR_TOT_20HH" NUMERIC,
    "LOADPSGR_TOT_21HH" NUMERIC,
    "LOADPSGR_TOT_22HH" NUMERIC,
    "LOADPSGR_TOT_23HH" NUMERIC
);

-- Table: seouldata_transportation_62__TPSS_STATION_ROUTE_TURN
CREATE TABLE "aihub_transport"."seouldata_transportation_62__TPSS_STATION_ROUTE_TURN" (
    "CRTR_DT" TEXT,
    "ROUTE_ID" TEXT,
    "STTN_ID" NUMERIC,
    "BUSRUN_CNT" TEXT,
    "BUSRUN_CNT_00HH" TEXT,
    "BUSRUN_CNT_01HH" TEXT,
    "BUSRUN_CNT_02HH" TEXT,
    "BUSRUN_CNT_03HH" TEXT,
    "BUSRUN_CNT_04HH" TEXT,
    "BUSRUN_CNT_05HH" TEXT,
    "BUSRUN_CNT_06HH" TEXT,
    "BUSRUN_CNT_07HH" TEXT,
    "BUSRUN_CNT_08HH" TEXT,
    "BUSRUN_CNT_09HH" TEXT,
    "BUSRUN_CNT_10HH" TEXT,
    "BUSRUN_CNT_11HH" TEXT,
    "BUSRUN_CNT_12HH" TEXT,
    "BUSRUN_CNT_13HH" TEXT,
    "BUSRUN_CNT_14HH" TEXT,
    "BUSRUN_CNT_15HH" TEXT,
    "BUSRUN_CNT_16HH" TEXT,
    "BUSRUN_CNT_17HH" TEXT,
    "BUSRUN_CNT_18HH" TEXT,
    "BUSRUN_CNT_19HH" TEXT,
    "BUSRUN_CNT_20HH" TEXT,
    "BUSRUN_CNT_21HH" TEXT,
    "BUSRUN_CNT_22HH" TEXT,
    "BUSRUN_CNT_23HH" TEXT,
    "STTN_ORD" TEXT
);

-- Table: seouldata_transportation_66__TB_TRAFIC_ENTRC_LFT
CREATE TABLE "aihub_transport"."seouldata_transportation_66__TB_TRAFIC_ENTRC_LFT" (
    "TYPE" TEXT,
    "NODE_WKT" TEXT,
    "NODE_ID" NUMERIC,
    "NODE_CODE" NUMERIC,
    "SGG_CD" NUMERIC,
    "SGG_NM" TEXT,
    "EMD_CD" NUMERIC,
    "EMD_NM" TEXT,
    "SW_NM" TEXT
);

-- Table: seouldata_transportation_677__MASTER_ROUTE_NODE
CREATE TABLE "aihub_transport"."seouldata_transportation_677__MASTER_ROUTE_NODE" (
    "ROUTE_ID" NUMERIC,
    "STTN_ID" NUMERIC,
    "STTN_DSTNC_MTR" NUMERIC,
    "STTN_ORD" TEXT
);

-- Table: seouldata_transportation_67__TPSS_EMD_BUS
CREATE TABLE "aihub_transport"."seouldata_transportation_67__TPSS_EMD_BUS" (
    "CRTR_DT" TEXT,
    "ADMDONG_ID" NUMERIC,
    "BUS_PSGR_CNT" NUMERIC,
    "BUS_PSGR_CNT_00HH" NUMERIC,
    "BUS_PSGR_CNT_01HH" NUMERIC,
    "BUS_PSGR_CNT_02HH" NUMERIC,
    "BUS_PSGR_CNT_03HH" NUMERIC,
    "BUS_PSGR_CNT_04HH" NUMERIC,
    "BUS_PSGR_CNT_05HH" NUMERIC,
    "BUS_PSGR_CNT_06HH" NUMERIC,
    "BUS_PSGR_CNT_07HH" NUMERIC,
    "BUS_PSGR_CNT_08HH" NUMERIC,
    "BUS_PSGR_CNT_09HH" NUMERIC,
    "BUS_PSGR_CNT_10HH" NUMERIC,
    "BUS_PSGR_CNT_11HH" NUMERIC,
    "BUS_PSGR_CNT_12HH" NUMERIC,
    "BUS_PSGR_CNT_13HH" NUMERIC,
    "BUS_PSGR_CNT_14HH" NUMERIC,
    "BUS_PSGR_CNT_15HH" NUMERIC,
    "BUS_PSGR_CNT_16HH" NUMERIC,
    "BUS_PSGR_CNT_17HH" NUMERIC,
    "BUS_PSGR_CNT_18HH" NUMERIC,
    "BUS_PSGR_CNT_19HH" NUMERIC,
    "BUS_PSGR_CNT_20HH" NUMERIC,
    "BUS_PSGR_CNT_21HH" NUMERIC,
    "BUS_PSGR_CNT_22HH" NUMERIC,
    "BUS_PSGR_CNT_23HH" NUMERIC
);

-- Table: seouldata_transportation_681__TBIS_MASTER_ROUTE
CREATE TABLE "aihub_transport"."seouldata_transportation_681__TBIS_MASTER_ROUTE" (
    "ROUTE_ID" NUMERIC,
    "ROUTE_NM" TEXT,
    "ROUTE_TYPE" TEXT,
    "DSTNC" NUMERIC
);

-- Table: seouldata_transportation_682__DISTRICT_EMD
CREATE TABLE "aihub_transport"."seouldata_transportation_682__DISTRICT_EMD" (
    "ADMDONG_ID" NUMERIC,
    "ADMDONG_NM" TEXT,
    "ATDRC_NM" TEXT,
    "SIDO_NM" TEXT
);

-- Table: seouldata_transportation_68__TB_TRAFIC_CRSNG
CREATE TABLE "aihub_transport"."seouldata_transportation_68__TB_TRAFIC_CRSNG" (
    "TYPE" TEXT,
    "NODE_WKT" TEXT,
    "NODE_ID" NUMERIC,
    "NODE_CODE" NUMERIC,
    "LINK_ID" NUMERIC,
    "LINK_CODE" NUMERIC,
    "STRT_NODE_ID" NUMERIC,
    "END_NODE_ID" NUMERIC,
    "LINK_LEN" NUMERIC,
    "SGG_CD" NUMERIC,
    "SGG_NM" TEXT,
    "EMD_NM" TEXT
);

-- Table: seouldata_transportation_699__TRAFFIC_SAFETY_A055_P_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_699__TRAFFIC_SAFETY_A055_P_INFO" (
    "STAT_CDE" NUMERIC,
    "MGRNU" TEXT,
    "DRN" TEXT,
    "LENX" TEXT,
    "A055_KND_CDE" NUMERIC,
    "EVE_CDE" NUMERIC,
    "OD_PE_CDE" NUMERIC,
    "GU_CDE" NUMERIC,
    "NW_PE_CDE" NUMERIC,
    "WORK_CDE" NUMERIC,
    "VIEW_CDE" TEXT,
    "ROD_GBN_CDE" NUMERIC,
    "TFC_BSS_CDE" NUMERIC,
    "SIXID" TEXT,
    "ESB_YMD" TEXT,
    "CAE_YMD" TEXT,
    "XGEO" TEXT,
    "HISID" TEXT,
    "CTK_MGRNU" TEXT,
    "DN_IE_MGRNU" TEXT,
    "FRM_CDE" NUMERIC
);

-- Table: seouldata_transportation_69__TPSS_PASSENGER_CNT
CREATE TABLE "aihub_transport"."seouldata_transportation_69__TPSS_PASSENGER_CNT" (
    "CRTR_DT" TEXT,
    "ADMDONG_ID" NUMERIC,
    "PSGR_CNT" NUMERIC,
    "PSGR_CNT_00HH" NUMERIC,
    "PSGR_CNT_01HH" NUMERIC,
    "PSGR_CNT_02HH" NUMERIC,
    "PSGR_CNT_03HH" NUMERIC,
    "PSGR_CNT_04HH" NUMERIC,
    "PSGR_CNT_05HH" NUMERIC,
    "PSGR_CNT_06HH" NUMERIC,
    "PSGR_CNT_07HH" NUMERIC,
    "PSGR_CNT_08HH" NUMERIC,
    "PSGR_CNT_09HH" NUMERIC,
    "PSGR_CNT_10HH" NUMERIC,
    "PSGR_CNT_11HH" NUMERIC,
    "PSGR_CNT_12HH" NUMERIC,
    "PSGR_CNT_13HH" NUMERIC,
    "PSGR_CNT_14HH" NUMERIC,
    "PSGR_CNT_15HH" NUMERIC,
    "PSGR_CNT_16HH" NUMERIC,
    "PSGR_CNT_17HH" NUMERIC,
    "PSGR_CNT_18HH" NUMERIC,
    "PSGR_CNT_19HH" NUMERIC,
    "PSGR_CNT_20HH" NUMERIC,
    "PSGR_CNT_21HH" NUMERIC,
    "PSGR_CNT_22HH" NUMERIC,
    "PSGR_CNT_23HH" NUMERIC
);

-- Table: seouldata_transportation_702__TRAFFIC_SAFETY_A061_P_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_702__TRAFFIC_SAFETY_A061_P_INFO" (
    "CTR_NAM" TEXT,
    "ONLINE_YMD" TEXT,
    "ESB_YMD" TEXT,
    "MK_CPY" TEXT,
    "STAT_CDE" TEXT,
    "CSS_NUM" TEXT,
    "MGRNU" TEXT,
    "CTR_SYS_CDE" TEXT,
    "CTR_FRM_CDE" TEXT,
    "CTR_PRODUT_CDE" TEXT,
    "CTR_SOE_CDE" TEXT,
    "A061_KND_CDE" TEXT,
    "EVE_CDE" TEXT,
    "RMK" TEXT,
    "CAE_YMD" TEXT,
    "OD_PE_CDE" TEXT,
    "GU_CDE" TEXT,
    "DONG_CDE" TEXT,
    "JIBUN" TEXT,
    "NW_PE_CDE" TEXT,
    "WORK_CDE" NUMERIC,
    "VIEW_CDE" NUMERIC,
    "ROD_GBN_CDE" TEXT,
    "TFC_BSS_CDE" TEXT,
    "SIXID" TEXT,
    "XGEO" TEXT,
    "HISID" TEXT,
    "CTK_MGRNU" TEXT,
    "CTR_MGRNU" TEXT,
    "FRM_CDE" TEXT
);

-- Table: seouldata_transportation_703__TRAFFIC_SAFETY_A074_P_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_703__TRAFFIC_SAFETY_A074_P_INFO" (
    "MGRNU" TEXT,
    "A062_MGRNU" TEXT,
    "DRN_CDE" TEXT,
    "ESB_YMD" TEXT,
    "CAE_YMD" TEXT,
    "XCE" NUMERIC,
    "YCE" NUMERIC,
    "MK_CPY" TEXT,
    "WORK_CDE" NUMERIC,
    "VIEW_CDE" NUMERIC,
    "A074_KND_CDE" TEXT,
    "SIXID" TEXT,
    "STAT_CDE" NUMERIC,
    "CTK_MGRNU" TEXT,
    "RT_IR_MGRNU" TEXT,
    "HISID" TEXT,
    "POS" TEXT,
    "FRM_CDE" NUMERIC
);

-- Table: seouldata_transportation_704__TRAFFIC_SAFETY_A008_P_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_704__TRAFFIC_SAFETY_A008_P_INFO" (
    "CSS_NUM" TEXT,
    "ESB_YMD" TEXT,
    "CSS_NAM" TEXT,
    "A008_KND_CDE" NUMERIC,
    "LK_CS_CDE" TEXT,
    "GU_CDE" NUMERIC,
    "JIBUN" TEXT,
    "OD_PE_CDE" NUMERIC,
    "NW_PE_CDE" NUMERIC,
    "WORK_CDE" NUMERIC,
    "VIEW_CDE" NUMERIC,
    "CUST_NUM" TEXT,
    "CTT_CFN" TEXT,
    "MSE_NUM" TEXT,
    "ROD_GBN_CDE" NUMERIC,
    "TFC_BSS_CDE" NUMERIC,
    "MGRNU" TEXT,
    "XGEO" TEXT,
    "SIXID" TEXT,
    "HISID" TEXT,
    "DONG_CDE" TEXT,
    "FRM_CDE" TEXT,
    "VFLAG" TEXT
);

-- Table: seouldata_transportation_705__TRAFFIC_SAFETY_A054_P_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_705__TRAFFIC_SAFETY_A054_P_INFO" (
    "STAT_CDE" NUMERIC,
    "MGRNU" TEXT,
    "DRN" TEXT,
    "LENX" TEXT,
    "CTT" TEXT,
    "EVE_CDE" NUMERIC,
    "OD_PE_CDE" NUMERIC,
    "GU_CDE" NUMERIC,
    "NW_PE_CDE" NUMERIC,
    "WORK_CDE" NUMERIC,
    "VIEW_CDE" NUMERIC,
    "ROD_GBN_CDE" NUMERIC,
    "TFC_BSS_CDE" NUMERIC,
    "SIXID" TEXT,
    "ESB_YMD" TEXT,
    "CAE_YMD" TEXT,
    "XGEO" TEXT,
    "HISID" TEXT,
    "CTK_MGRNU" TEXT,
    "CR_IE_MGRNU" TEXT,
    "A054_KND_CDE" NUMERIC,
    "FRM_CDE" NUMERIC
);

-- Table: seouldata_transportation_706__TRAFFIC_SAFETY_A058_L_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_706__TRAFFIC_SAFETY_A058_L_INFO" (
    "STAT_CDE" NUMERIC,
    "MGRNU" TEXT,
    "A058_KND_CDE" NUMERIC,
    "EVE_CDE" NUMERIC,
    "OD_PE_CDE" NUMERIC,
    "GU_CDE" NUMERIC,
    "NW_PE_CDE" NUMERIC,
    "WORK_CDE" NUMERIC,
    "VIEW_CDE" NUMERIC,
    "ROD_GBN_CDE" NUMERIC,
    "TFC_BSS_CDE" NUMERIC,
    "SIXID" TEXT,
    "ESB_YMD" TEXT,
    "CAE_YMD" TEXT,
    "XGEO" TEXT,
    "HISID" TEXT,
    "CTK_MGRNU" TEXT,
    "LINE_MGRNU" TEXT,
    "A058_KND2_CDE" NUMERIC,
    "FRM_CDE" NUMERIC,
    "LENX" TEXT
);

-- Table: seouldata_transportation_707__TRAFFIC_SAFETY_A068_P_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_707__TRAFFIC_SAFETY_A068_P_INFO" (
    "STAT_CDE" NUMERIC,
    "MGRNU" TEXT,
    "DRN" TEXT,
    "EVE_CDE" NUMERIC,
    "OD_PE_CDE" NUMERIC,
    "GU_CDE" NUMERIC,
    "NW_PE_CDE" NUMERIC,
    "WORK_CDE" NUMERIC,
    "VIEW_CDE" NUMERIC,
    "ROD_GBN_CDE" NUMERIC,
    "TFC_BSS_CDE" NUMERIC,
    "SIXID" TEXT,
    "ESB_YMD" TEXT,
    "CAE_YMD" TEXT,
    "XGEO" TEXT,
    "HISID" TEXT,
    "CTK_MGRNU" TEXT,
    "CS_NK_MGRNU" TEXT,
    "A068_KND_CDE" NUMERIC,
    "FRM_CDE" NUMERIC
);

-- Table: seouldata_transportation_708__TRAFFIC_SAFETY_A073_P_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_708__TRAFFIC_SAFETY_A073_P_INFO" (
    "MGRNU" TEXT,
    "A062_MGRNU" TEXT,
    "DRN_CDE" TEXT,
    "ESB_YMD" TEXT,
    "CAE_YMD" TEXT,
    "XCE" NUMERIC,
    "YCE" NUMERIC,
    "MK_CPY" TEXT,
    "SL_NUM" TEXT,
    "WORK_CDE" NUMERIC,
    "VIEW_CDE" NUMERIC,
    "A073_KND_CDE" NUMERIC,
    "SIXID" TEXT,
    "STAT_CDE" NUMERIC,
    "CTK_MGRNU" TEXT,
    "SD_MGRNU" TEXT,
    "HISID" TEXT,
    "POS" TEXT,
    "FRM_CDE" TEXT
);

-- Table: seouldata_transportation_709__TRAFFIC_SAFETY_A062_P_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_709__TRAFFIC_SAFETY_A062_P_INFO" (
    "STAT_CDE" NUMERIC,
    "MGRNU" TEXT,
    "A062_KND_CDE" NUMERIC,
    "SPRT_STD_CDE" NUMERIC,
    "EVE_CDE" NUMERIC,
    "SPRT_HOTDIP_CDE" NUMERIC,
    "CSS_CDE" TEXT,
    "ESB_YMD" NUMERIC,
    "CAE_YMD" NUMERIC,
    "OD_PE_CDE" NUMERIC,
    "GU_CDE" NUMERIC,
    "CTRL_YNO_CDE" NUMERIC,
    "DONG_CDE" TEXT,
    "JIBUN" TEXT,
    "RMK" TEXT,
    "NW_PE_CDE" NUMERIC,
    "WORK_CDE" NUMERIC,
    "VIEW_CDE" NUMERIC,
    "SPRT_MET_CDE" NUMERIC,
    "ROB_GBN_CDE" NUMERIC,
    "TFC_BSS_CDE" NUMERIC,
    "XGEO" TEXT,
    "SIXID" TEXT,
    "LINK_ID" NUMERIC,
    "HISID" TEXT,
    "CTK_MGRNU" TEXT,
    "SPRT_MGRNU" TEXT,
    "FRM_CDE" NUMERIC
);

-- Table: seouldata_transportation_711__TRAFFIC_SAFETY_A077_P_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_711__TRAFFIC_SAFETY_A077_P_INFO" (
    "MGRNU" TEXT,
    "A062_MGRNU" TEXT,
    "DRN_CDE" TEXT,
    "ESB_YMD" TEXT,
    "CAE_YMD" TEXT,
    "XCE" NUMERIC,
    "YCE" NUMERIC,
    "MK_CPY" TEXT,
    "WORK_CDE" NUMERIC,
    "VIEW_CDE" NUMERIC,
    "A077_KND_CDE" NUMERIC,
    "SIXID" TEXT,
    "STAT_CDE" TEXT,
    "CTK_MGRNU" TEXT,
    "PO_SI_MGRNU" TEXT,
    "HISID" TEXT,
    "POS" TEXT,
    "FRM_CDE" TEXT
);

-- Table: seouldata_transportation_712__TRAFFIC_SAFETY_A057_P_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_712__TRAFFIC_SAFETY_A057_P_INFO" (
    "MGRNU" TEXT,
    "STAT_CDE" NUMERIC,
    "A057_KND_CDE" NUMERIC,
    "ASN_LENX_CDE" NUMERIC,
    "EVE_CDE" NUMERIC,
    "ASN_DRN" TEXT,
    "SNLP_QUA" TEXT,
    "BSNLP_QUA" TEXT,
    "SNLP_KND_CDE" NUMERIC,
    "BSNLP_KND_CDE" NUMERIC,
    "ESB_YMD" TEXT,
    "CAE_YMD" TEXT,
    "A062_MGRNU" TEXT,
    "SP_RN_CDE" NUMERIC,
    "MK_CPY" TEXT,
    "WORK_CDE" NUMERIC,
    "VIEW_CDE" TEXT,
    "SIXID" TEXT,
    "CTK_MGRNU" TEXT,
    "ASN_MGRNU" TEXT,
    "HISID" TEXT,
    "A062_POS" TEXT,
    "XCE" NUMERIC,
    "YCE" NUMERIC,
    "FRM_CDE" NUMERIC
);

-- Table: seouldata_transportation_71__GET_PARK_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_71__GET_PARK_INFO" (
    "PARKING_NAME" TEXT,
    "ADDR" TEXT,
    "PARKING_CODE" NUMERIC,
    "PARKING_TYPE" TEXT,
    "PARKING_TYPE_NM" TEXT,
    "OPERATION_RULE" NUMERIC,
    "OPERATION_RULE_NM" TEXT,
    "TEL" TEXT,
    "CAPACITY" NUMERIC,
    "PAY_YN" TEXT,
    "PAY_NM" TEXT,
    "NIGHT_FREE_OPEN" TEXT,
    "NIGHT_FREE_OPEN_NM" TEXT,
    "WEEKDAY_BEGIN_TIME" NUMERIC,
    "WEEKDAY_END_TIME" NUMERIC,
    "WEEKEND_BEGIN_TIME" NUMERIC,
    "WEEKEND_END_TIME" TEXT,
    "HOLIDAY_BEGIN_TIME" NUMERIC,
    "HOLIDAY_END_TIME" NUMERIC,
    "SYNC_TIME" TEXT,
    "SATURDAY_PAY_YN" TEXT,
    "SATURDAY_PAY_NM" TEXT,
    "HOLIDAY_PAY_YN" TEXT,
    "HOLIDAY_PAY_NM" TEXT,
    "FULLTIME_MONTHLY" NUMERIC,
    "GRP_PARKNM" NUMERIC,
    "RATES" NUMERIC,
    "TIME_RATE" NUMERIC,
    "ADD_RATES" NUMERIC,
    "ADD_TIME_RATE" NUMERIC,
    "BUS_RATES" NUMERIC,
    "BUS_TIME_RATE" NUMERIC,
    "BUS_ADD_TIME_RATE" NUMERIC,
    "BUS_ADD_RATES" NUMERIC,
    "DAY_MAXIMUM" NUMERIC,
    "LAT" NUMERIC,
    "LNG" NUMERIC
);

-- Table: seouldata_transportation_737__TB_TRAFIC_WLK_NET
CREATE TABLE "aihub_transport"."seouldata_transportation_737__TB_TRAFIC_WLK_NET" (
    "TYPE" TEXT,
    "NODE_WKT" TEXT,
    "NODE_ID" TEXT,
    "NODE_CODE" TEXT,
    "LINK_WKT" TEXT,
    "LINK_ID" TEXT,
    "LINK_CODE" NUMERIC,
    "STRT_NODE_ID" TEXT,
    "END_NODE_ID" TEXT,
    "LINK_LEN" NUMERIC,
    "SGG_CD" NUMERIC,
    "SGG_NM" TEXT,
    "EMD_CD" NUMERIC,
    "EMD_NM" TEXT,
    "TP_HW" TEXT,
    "TP_UW" TEXT,
    "TP_BR" TEXT,
    "TP_TN" TEXT,
    "TP_SW" TEXT,
    "TP_CW" TEXT,
    "TP_PK" TEXT,
    "TP_IN" TEXT
);

-- Table: seouldata_transportation_742__TRAFFIC_MLRD_LINK_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_742__TRAFFIC_MLRD_LINK_INFO" (
    "SERVICE_ID" NUMERIC,
    "LINK_NUM" TEXT,
    "LINK_ID" NUMERIC
);

-- Table: seouldata_transportation_743__CSCY_PUBLIC_VIEW
CREATE TABLE "aihub_transport"."seouldata_transportation_743__CSCY_PUBLIC_VIEW" (
    "CSDY_YYYY" TEXT,
    "CSDY_MM" NUMERIC,
    "CAR_CUSTODY_SIDO" TEXT,
    "CAR_CUSTODY_ATDRC_CODE" NUMERIC,
    "CSDY_COUNT" TEXT
);

-- Table: seouldata_transportation_747__L_O_C_A_L_D_A_T_A_114502
CREATE TABLE "aihub_transport"."seouldata_transportation_747__L_O_C_A_L_D_A_T_A_114502" (
    "OPNSFTEAMCODE" NUMERIC,
    "MGTNO" TEXT,
    "APVPERMYMD" TEXT,
    "APVCANCELYMD" TEXT,
    "TRDSTATEGBN" NUMERIC,
    "TRDSTATENM" TEXT,
    "DTLSTATEGBN" TEXT,
    "DTLSTATENM" TEXT,
    "DCBYMD" TEXT,
    "CLGSTDT" TEXT,
    "CLGENDDT" TEXT,
    "ROPNYMD" TEXT,
    "SITETEL" NUMERIC,
    "SITEAREA" TEXT,
    "SITEPOSTNO" NUMERIC,
    "SITEWHLADDR" TEXT,
    "RDNWHLADDR" TEXT,
    "RDNPOSTNO" NUMERIC,
    "BPLCNM" TEXT,
    "LASTMODTS" NUMERIC,
    "UPDATEGBN" TEXT,
    "UPDATEDT" TEXT,
    "UPTAENM" TEXT,
    "X" TEXT,
    "Y" TEXT,
    "GENWAREDNGNUM" TEXT,
    "GENWAREAREA" TEXT,
    "FRZWAREDNGNUM" TEXT,
    "FRZWAREAREA" TEXT,
    "DEPOPLCAREA" TEXT,
    "EPCNT" TEXT,
    "FACILEQIDTL" TEXT,
    "DEPOPER" TEXT,
    "BUPYNNM" TEXT,
    "UPTAEDEPOWARE" TEXT,
    "UPTAETRAN" TEXT,
    "UPTAESALE" TEXT,
    "UPTAEMAKER" TEXT
);

-- Table: seouldata_transportation_750__CARD_SUBWAY_PAY_FREE
CREATE TABLE "aihub_transport"."seouldata_transportation_750__CARD_SUBWAY_PAY_FREE" (
    "USE_MON" TEXT,
    "LINE_NUM" TEXT,
    "SUB_STA_NM" TEXT,
    "PAY_RIDE_NUM" TEXT,
    "FREE_RIDE_NUM" TEXT,
    "PAY_ALIGHT_NUM" TEXT,
    "FREE_ALIGHT_NUM" TEXT,
    "WORK_DT" TEXT
);

-- Table: seouldata_transportation_794__TG_ACDT19
CREATE TABLE "aihub_transport"."seouldata_transportation_794__TG_ACDT19" (
    "ID" NUMERIC,
    "GEOM" TEXT,
    "SQEUENCE" TEXT,
    "POLICE" TEXT,
    "GU" TEXT,
    "DONG" TEXT,
    "FAC_NAME" TEXT,
    "FAC_TYPE" TEXT,
    "ADDRESS" TEXT,
    "POINT_X" NUMERIC,
    "POINT_Y" NUMERIC
);

-- Table: seouldata_transportation_7__NAMSAN_RECUCE_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_7__NAMSAN_RECUCE_INFO" (
    "RN" NUMERIC,
    "REDUCE_DATE" NUMERIC,
    "REDUCE_LOC" TEXT,
    "REDUCE_ROAD" TEXT,
    "REDUCE_TYPE" TEXT
);

-- Table: seouldata_transportation_811__BIKE_STATION_MASTER
CREATE TABLE "aihub_transport"."seouldata_transportation_811__BIKE_STATION_MASTER" (
    "LENDPLACE_ID" TEXT,
    "STATN_ADDR1" TEXT,
    "STATN_ADDR2" TEXT,
    "STATN_LAT" NUMERIC,
    "STATN_LNT" NUMERIC
);

-- Table: seouldata_transportation_833__CYCLE_FOREIGNER_RENT_DAY_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_833__CYCLE_FOREIGNER_RENT_DAY_INFO" (
    "RENT_DT" TEXT,
    "DAILY_RENT_ID" TEXT,
    "RENT_NM" TEXT,
    "RENT_CNT" TEXT,
    "RTN_CNT" TEXT
);

-- Table: seouldata_transportation_844__CYCLE_FOREIGNER_RENT_MONTH_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_844__CYCLE_FOREIGNER_RENT_MONTH_INFO" (
    "RENT_DT" TEXT,
    "MONTHLY_RENT_ID" TEXT,
    "RENT_NM" TEXT,
    "RENT_CNT" TEXT,
    "RTN_CNT" TEXT
);

-- Table: seouldata_transportation_846__V_GTPA_INSTL_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_846__V_GTPA_INSTL_INFO" (
    "SEQ" TEXT,
    "BHF_ID" TEXT,
    "BHF_NM" TEXT,
    "INSTL_ADRES" TEXT,
    "INSTL_LO" NUMERIC,
    "INSTL_LA" NUMERIC,
    "FCLTS_CD" TEXT,
    "UPDT_DE" TEXT
);

-- Table: seouldata_transportation_853__CYCLE_NEW_MEMBER_RENT_INFO_DAY
CREATE TABLE "aihub_transport"."seouldata_transportation_853__CYCLE_NEW_MEMBER_RENT_INFO_DAY" (
    "RENT_DT" TEXT,
    "MEMBER_CD" TEXT,
    "SEX_CD" TEXT,
    "YEAR_CD" TEXT,
    "MEM_CNT" TEXT
);

-- Table: seouldata_transportation_889__TRAFFIC_SAFETY_A064_P_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_889__TRAFFIC_SAFETY_A064_P_INFO" (
    "MRK_MET_CDE" TEXT,
    "STAT_CDE" TEXT,
    "A064_KND_CDE" TEXT,
    "RMK" TEXT,
    "XCE" NUMERIC,
    "YCE" NUMERIC,
    "ESB_YMD" TEXT,
    "CAE_YMD" TEXT,
    "MGRNU" TEXT,
    "A062_MGRNU" TEXT,
    "DRN_CDE" TEXT,
    "WORK_CDE" NUMERIC,
    "VIEW_CDE" NUMERIC,
    "SIXID" TEXT,
    "HISID" TEXT,
    "CTK_MGRNU" TEXT,
    "MRK_MGRNU" TEXT,
    "MRK_NUM" TEXT,
    "POS" TEXT,
    "FRM_CDE" TEXT
);

-- Table: seouldata_transportation_963__DONG_SIGNAL_INSTL_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_963__DONG_SIGNAL_INSTL_INFO" (
    "DONG_NM" TEXT,
    "DIRECTION" TEXT,
    "SIGNAL1" TEXT,
    "SIGNAL2" TEXT,
    "SIGNAL3" TEXT,
    "ETC" TEXT,
    "TOTAL" TEXT
);

-- Table: seouldata_transportation_964__SIGNAL_INSTL_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_964__SIGNAL_INSTL_INFO" (
    "SIG_NO" TEXT,
    "SIG_TYPE" TEXT,
    "XCODE" NUMERIC,
    "YCODE" NUMERIC,
    "SHORT_IMAGE1" TEXT,
    "SHORT_IMAGE2" TEXT,
    "SHORT_IMAGE3" TEXT,
    "SHORT_IMAGE4" TEXT,
    "SHORT_IMAGE5" TEXT,
    "LONG_IMAGE1" TEXT,
    "LONG_IMAGE2" TEXT,
    "DATA_DATE" TEXT
);

-- Table: seouldata_transportation_965__ROAD_SIGNAL_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_965__ROAD_SIGNAL_INFO" (
    "MANAGE_NM" TEXT,
    "ROAD_TYPE" TEXT,
    "ROAD_NM" TEXT,
    "ROAD_INPUT" TEXT,
    "ROAD_HOLD" TEXT,
    "ROAD_RATIO" TEXT,
    "TRAVEL_INPUT" TEXT,
    "TRAVEL_HOLD" TEXT,
    "TRAVEL_RATIO" TEXT,
    "PRI_INPUT" TEXT,
    "PRI_HOLD" TEXT,
    "PRI_RATIO" TEXT,
    "TOTAL_INPUT" TEXT,
    "TOTAL_HOLD" TEXT,
    "TOTAL_RATIO" TEXT
);

-- Table: seouldata_transportation_966__OPRTLMTT_FCLTS_INFO
CREATE TABLE "aihub_transport"."seouldata_transportation_966__OPRTLMTT_FCLTS_INFO" (
    "MANAGE_NO" TEXT,
    "DIV" TEXT,
    "MGC" TEXT,
    "FCLTY_NM" TEXT,
    "LC" TEXT,
    "START_X" NUMERIC,
    "START_Y" NUMERIC,
    "ARVL_X" NUMERIC,
    "ARVL_Y" NUMERIC,
    "TOT_WT" TEXT,
    "BT_LMTT" NUMERIC,
    "HG_LMTT" TEXT,
    "LT_LMTT" NUMERIC,
    "REAL_HG" TEXT
);
