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