Tmobi GW

Tables (27)

adm_code_m

  • adm_code_nm — varchar(32) — NOT NULL
  • adm_code — integer — NOT NULL
  • lowest_adm_code_nm — varchar(32) — NOT NULL

adm_si_m

  • root_adm_code — integer — NOT NULL
  • adm_code_nm — varchar(32) — NOT NULL
  • adm_code — integer — NOT NULL
  • lowest_adm_code_nm — varchar(32) — NOT NULL

app_m

  • api_key — varchar(64) — NOT NULL
  • oem_code — varchar(16)
  • permission — varchar(16)
  • description — varchar(256) — NOT NULL
  • active — boolean
  • updated — timestamp
  • created — timestamp

cache_m

  • cache_seq — bigint — NOT NULL
  • cache_enabled — boolean — NOT NULL

calendar_m

  • calendar_seq — bigserial
  • cal_type — varchar(16)
  • year — varchar(4)
  • month — varchar(2)
  • result — text
  • updated — timestamp
  • created — timestamp

city_m

  • city_seq — bigserial
  • name — varchar(20) — NOT NULL
  • name_en — varchar(16) — NOT NULL
  • lon — varchar(16) — NOT NULL
  • lat — varchar(32) — NOT NULL
  • city_id — varchar(16) — NOT NULL
  • updated — timestamp
  • created — timestamp

company_m

  • code — varchar(12) — NOT NULL
  • name — varchar(256)
  • company_type — char(2)
  • exchange — varchar(32)
  • updated — timestamp
  • created — timestamp

dust_forecast_m

  • data_time — varchar(10) — Primary key — NOT NULL
  • inform_data — varchar(8) — Primary key — NOT NULL
  • inform_code — varchar(4) — Primary key — NOT NULL
  • inform_cause — varchar(512)
  • inform_grade — text
  • inform_overall — varchar(512)
  • updated — timestamp
  • created — timestamp

dust_m

  • data_time — varchar(12) — Primary key — NOT NULL
  • item_code — varchar(4) — Primary key — NOT NULL
  • inform_grade — text
  • updated — timestamp
  • created — timestamp

error_h

  • error_seq — bigserial
  • type — varchar(32)
  • code — integer
  • msg — text
  • location — varchar(256)
  • code_path — varchar(256)
  • created — timestamp
  • ip_addr — varchar(64)
  • token — varchar(256)
  • app — varchar

exchange_rate_m

  • exchange_rate_seq — bigserial
  • exch_date — varchar(8)
  • cur_unit — varchar(8)
  • value — numeric(8, 2)
  • updown — integer
  • diff_value — numeric(8, 2)
  • diff_rate — numeric(8, 2)
  • ttb — numeric(8, 2)
  • tts — numeric(8, 2)
  • sort — integer
  • updated — timestamp
  • created — timestamp
  • notification_time — timestamp
  • notification_num — bigint

exchange_rate_twelve_m

  • exchange_rate_seq — bigserial
  • exch_date — varchar(8)
  • cur_unit — varchar(8)
  • value — numeric(8, 2)
  • updown — integer
  • diff_value — numeric(8, 2)
  • diff_rate — numeric(8, 2)
  • sort — integer
  • updated — timestamp
  • created — timestamp
  • notification_time — timestamp
  • low — numeric(8, 2)
  • high — numeric(8, 2)
  • open — numeric(8, 2)

gateway_h

  • gateway_seq — bigserial
  • api — varchar(512) — NOT NULL
  • site — varchar(32) — NOT NULL
  • oem_code — varchar(16)
  • vin — varchar(32)
  • api_key — varchar(64)
  • ip_addr — varchar(64) — NOT NULL
  • gw_group — varchar(32) — NOT NULL
  • token — varchar(256)
  • request — jsonb
  • result — text
  • created — timestamp
  • uuid — varchar(128)
  • app — varchar

marketindex_m

  • marketindex_seq — bigserial
  • result — text
  • created — timestamp

news_audio_m

  • news_audio_seq — bigserial
  • code — varchar(64)
  • title — varchar(1024)
  • description — text
  • type — integer
  • media_content — varchar(1024)
  • audio_content — varchar(1024)
  • duration — varchar(32)
  • published_date — timestamp
  • created — timestamp
  • updated — timestamp
  • round — bigint

news_audio_round_m

  • round — bigint — NOT NULL
  • created — timestamp
  • updated — timestamp

news_m

  • news_seq — bigserial
  • code — varchar(64)
  • title — varchar(1024)
  • description — text
  • published_date — timestamp
  • created — timestamp
  • updated — timestamp
  • type — integer
  • link — varchar(1024)
  • media_content — text
  • audio_content — varchar(1024)
  • video_content — varchar(1024)
  • round — bigint

news_round_m (뉴스 회차 테이블)

  • round — bigint — NOT NULL
  • created — timestamp
  • updated — timestamp

oem_m

  • oem_code — varchar(16) — NOT NULL
  • name — varchar(32) — NOT NULL
  • description — varchar(256)
  • active — boolean
  • updated — timestamp
  • created — timestamp

oem_model_permission_m

  • oem_code — VARCHAR(50) — NOT NULL
  • api_name (API 명) — VARCHAR(50) — NOT NULL
  • active — BOOLEAN — NOT NULL
  • deny_body — VARCHAR(1000)
  • description — VARCHAR(500)
  • created — TIMESTAMPTZ

statistics_h

  • statistics_seq — bigserial
  • app_name — varchar(56)
  • uuid — varchar(128)
  • type_code — integer — NOT NULL
  • value — varchar(256)
  • created — timestamp
  • api — varchar(256)
  • ip_addr — varchar(64)

stock_quote_h

  • stock_quote_seq — bigserial
  • code — varchar(12)
  • exchange — varchar(32)
  • created — timestamp

token_h

  • token_seq — bigserial
  • oem_code — varchar(16) — NOT NULL
  • api_key — varchar(64)
  • vin — varchar(32)
  • token — varchar(256)
  • generated — varchar(14)
  • expired — varchar(14)
  • token_h_type — smallint
  • created — timestamp
  • uuid — varchar(128)
  • refresh_token — varchar(256)
  • access_token — varchar(256)

token_m

  • oem_code — varchar(16) — NOT NULL
  • api_key — varchar(64)
  • vin — varchar(32)
  • token — varchar(256)
  • generated — varchar(14)
  • expired — varchar(14)
  • updated — timestamp
  • created — timestamp
  • uuid — varchar(128)
  • refresh_token — varchar(256)
  • access_token — varchar(256)

user_m

  • msrl — bigserial
  • name — varchar(100) — NOT NULL
  • password — varchar(100)
  • provider — varchar(100)
  • uid — varchar(50) — NOT NULL

user_roles

  • user_msrl — bigint — NOT NULL
  • roles — varchar(255)

vehicle_m

  • vehicle_seq — serial
  • vin — varchar(64)
  • model — varchar(64) — NOT NULL
  • created — timestamp