TPS_META2

테이블 (7)

Copy Of Copy Of Untitled (feature_aggregation)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • id, auto increment key (source_id) — bigint — 외래 키 → input table 관리.id, auto increment key — NOT NULL
  • Field (group_name) — varchar(10)
  • Field (name) — varchar(255)
  • Field (data_type) — varchar(10)
  • Field (special_values) — text
  • Field (min) — varchar(20)
  • Field (max) — varchar(20)
  • Field (calculation) — varchar(20)
  • Field3 (is_money) — boolean
  • Field (description) — text
  • Field2 (tec) — text
  • Field (worker) — varchar(20)
  • Field (reg_ts) — timestamp
  • Field (upd_ts) — timestamp

Copy Of Untitled (feature_period)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • id, auto increment key (source_id) — bigint — 외래 키 → input table 관리.id, auto increment key — NOT NULL
  • Field (duration) — int
  • Field (period_type) — varchar(50)
  • Field (name) — varchar(255)
  • Field (column_name) — varchar(60)
  • Field (logic) — varchar(255)
  • Field (description) — text
  • Field (etc) — text
  • Field (worker) — varchar(20)
  • Field (reg_ts) — timestamp
  • Field (upd_ts) — timestamp

Copy Of Untitled2 (feature_filter)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • id, auto increment key (source_id) — bigint — 외래 키 → input table 관리.id, auto increment key — NOT NULL
  • Field (name) — varchar(100)
  • Field (column_name) — varchar(60)
  • Field (logic) — varchar(255)
  • Field (description) — text
  • Field (etc) — text
  • Field (worker) — varchar(20)
  • Field (reg_ts) — timestamp
  • Field (upd_ts) — timestamp

Copy Of input table 관리 (feature_definition)

  • id, auto increment key (id) — bigint — 기본 키 — NOT NULL
  • Key (category_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Key (period_id) — bigint — 외래 키 → Copy Of Untitled.Key — NOT NULL
  • Key (aggregation_id) — bigint — 외래 키 → Copy Of Copy Of Untitled.Key — NOT NULL
  • Field (tps_id) — varchar(12)
  • input_table_name (seq) — char(3) — [primary key, note: '입력 테이블명, card_trx_prep']
  • Field3 (version) — char(1) — NOT NULL
  • Field5 (status) — varchar(10)
  • Field6 (description) — text
  • Field (etc) — text
  • Field (reg_ts) — timestamp
  • Field (upd_ts) — timestamp

Untitled (feature_category)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • id, auto increment key (source_id) — bigint — 외래 키 → input table 관리.id, auto increment key — NOT NULL
  • Field (code) — varchar(5)
  • Field (name) — varchar(100)
  • Field (source) — varchar(60)
  • Field (info_area) — varchar(60)
  • Field (output_table_name) — varchar(255)
  • Field (description) — text
  • Field (etc) — text
  • Field (worker) — varchar(20)
  • Field (reg_ts) — timestamp
  • Field (upd_ts) — timestamp

Untitled (feature_filter_def)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • id, auto increment key (filter_id) — bigint — 외래 키 → Copy Of input table 관리.id, auto increment key — NOT NULL
  • Key (defnition_id) — bigint — 외래 키 → Copy Of Untitled2.Key — NOT NULL
  • Field (reg_ts) — timestamp
  • Field (upd_ts) — timestamp

input table 관리 (data_source)

  • id, auto increment key (id) — bigint — 기본 키 — NOT NULL
  • input_table_name — varchar(100) — [primary key, note: '입력 테이블명, card_trx_prep']
  • Field (flag) — boolean
  • Field3 (description) — text — NOT NULL
  • Field4 (etc) — text — NOT NULL
  • Field5 (reg_ts) — timestamp
  • Field6 (upd_ts) — timestamp