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