test

Tables (10)

tb_wl_class_context_node

  • context_id — varchar — NOT NULL
  • class_level — integer — NOT NULL
  • class_code — varchar — NOT NULL
  • node_title — varchar
  • node_id — integer — NOT NULL
  • res_depth — integer — json

tb_wl_class_context_node_log

  • idx — serial
  • trans_type — varchar
  • context_id_prev — varchar
  • context_id — varchar
  • class_level_prev — integer
  • class_level — integer
  • class_code_prev — varchar
  • class_code — varchar
  • node_title_prev — varchar
  • node_title — varchar
  • node_id_prev — integer
  • node_id — integer
  • res_depth_prev — integer
  • res_depth — integer
  • reg_dtime — timestamp
  • reg_user — varchar

tb_wl_class_filter_type

  • context_id — varchar — Primary key — NOT NULL
  • filter_id — varchar — Primary key — NOT NULL
  • filter_type — varchar — Primary key — NOT NULL
  • selection_type — varchar — NOT NULL

tb_wl_class_filter_type_log

  • idx — serial
  • trans_type — varchar
  • context_id_prev — varchar
  • context_id — varchar
  • filter_id_prev — varchar
  • filter_id — varchar
  • filter_type_prev — varchar
  • filter_type — varchar
  • selection_type_prev — varchar
  • selection_type — varchar
  • reg_dtime — timestamp
  • reg_user — varchar

tb_wl_class_filter_value

  • filter_id — varchar — Primary key — NOT NULL
  • filter_target — varchar — Primary key — NOT NULL
  • welaaa_value — varchar — Primary key — NOT NULL
  • replace_value — varchar

tb_wl_class_filter_value_log

  • idx — serial
  • trans_type — varchar
  • filter_id_prev — varchar
  • filter_id — varchar
  • filter_target_prev — varchar
  • filter_target — varchar
  • welaaa_value_prev — varchar
  • welaaa_value — varchar
  • replace_value_prev — varchar
  • replace_value — varchar
  • reg_dtime — timestamp
  • reg_user — varchar

tb_wl_class_node_path

  • ancestor_id — integer — Primary key — NOT NULL
  • descendant_id — integer — Primary key — NOT NULL
  • depth_num — integer — NOT NULL

tb_wl_class_node_path_log

  • idx — serial
  • trans_type — varchar
  • ancestor_id_prev — integer
  • ancestor_id — integer
  • descendant_id_prev — integer
  • descendant_id — integer
  • depth_num_prev — integer
  • depth_num — integer
  • reg_dtime — timestamp
  • reg_user — varchar

tb_wl_class_param_path

  • context_id — varchar — Primary key — NOT NULL
  • class_param — varchar — Primary key — NOT NULL
  • resource_path — varchar
  • replace_filter — varchar

tb_wl_class_param_path_log

  • idx — serial
  • trans_type — varchar
  • context_id_prev — varchar
  • context_id — varchar
  • class_param_prev — varchar
  • class_param — varchar
  • resource_path_prev — varchar
  • resource_path — varchar
  • replace_filter_prev — varchar
  • replace_filter — varchar
  • reg_dtime — timestamp
  • reg_user — varchar