amberroad
Tables (10)
tb_ds_dataset
- dataset_id — varchar(50) — Primary key — NOT NULL
- dataset_name — varchar(255)
- description — varchar(255)
- use_yn — varchar(1)
- create_dtm — datetime
- update_dtm — datetime
- extraction_type — varchar(30)
- dataset_type — varchar(30)
- retention_unit_count — integer
- temp_id — UUID
- server_id — varchar(10) — NOT NULL
tb_ds_dataset_history
- hist_dtm — timestamp — Primary key — NOT NULL
- dataset_id — varchar(50) — Foreign key → tb_ds_dataset.dataset_id — NOT NULL
- dataset_name — varchar(100)
- description — varchar(100)
- dataset_type — enum("APPEND", "UPSERT', "REFRESH")
tb_ds_dataset_layout
- id — bigint — Primary key — NOT NULL
- layout_type — enum("MAIN", "ORIGIN")
- col_rename — varchar
- col_name — varchar
- col_seq — integer
- data_retype — enum("date","cat","num","func")
- data_type — enum("date","cat","num","func")
- col_desc — varchar
- create_dtm — timestamp
- update_dtm — timestamp
- dataset_id — varchar(50) — NOT NULL
tb_ds_dataset_layout_history
- id — bigint — Primary key — NOT NULL
- layout_type — enum("MAIN", "ORIGIN")
- col_rename — varchar
- col_name — varchar
- data_retype — enum("date","cat","num","func")
- data_type — enum("date","cat","num","func")
- col_desc — varchar
- col_seq — integer
- hist_dtm — timestamp
- dataset_layout_id — bigint — NOT NULL
tb_ds_job_unit
- id — long — Primary key — NOT NULL
- input_param — json
- dataset_id — varchar(50) — NOT NULL
tb_ds_wf
- sequence — int — Primary key — NOT NULL
- dataset_id — varchar(50) — Foreign key → tb_ds_dataset.dataset_id — NOT NULL
- ds_comp_id — varchar(10) — NOT NULL
- ds_comp_property — json
- ds_comp_result — json
- status — varchar(50)
- error_msg — varchar(100)
- create_dtm — datetime
- update_dtm — datetime
tb_ds_wf_comp
- ds_comp_id — varchar(10) — Primary key — NOT NULL
- ds_comp_name_kr — varchar(20)
- ds_comp_order — int
- ds_comp_desc — varchar(100)
- input_param — json
- use_yn — varchar(1)
- display_yn — varchar(1)
- create_dtm — datetime
- update_dtm — datetime
tb_sys_schedule
- job_id — varchar(50) — Primary key — NOT NULL
- job_type — varchar(10) — Primary key — NOT NULL
- job_name_kr — varchar(255)
- job_params — json
- sche_cycle — varchar(1)
- sche_secs — varchar(4)
- sche_mins — varchar(2)
- sche_hours — varchar(2)
- sche_days — varchar(2)
- sche_mon — varchar(2)
- sche_dow — varchar(10)
- sche_weekday — varchar(3)
- extr_secs — varchar(2)
- extr_mins — varchar(2)
- extr_hours — varchar(2)
- extr_days — varchar(2)
- extr_weeks — varchar(1)
- use_yn — varchar(1)
- create_dtm — datetime
- update_dtm — datetime
- dataset_id — varchar(50) — NOT NULL
tb_sys_schedule_log
- start_dtm — datetime — Primary key — NOT NULL
- job_id — varchar(50) — Foreign key → tb_sys_schedule.job_id — NOT NULL
- job_log_seq — long — Foreign key → tb_ds_job_unit.id — NOT NULL
- job_status — varchar(1)
- job_result — varchar(1)
- param — json
- error_msg — varchar(255)
- error_point — varchar(100)
- end_dtm — datetime
tb_sys_server
- server_id — varchar(10) — Primary key — NOT NULL
- server_name — varchar(50)
- server_desc — varchar(50)
- id — varchar(50)
- password — varchar(255)
- port — int
- ip — varchar(15)
- server_type — varchar(20)
- create_dtm — datetime
- update_dtm — datetime
- use_yn — varchar(1)
- param — json