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