ids

Tables (6)

data_join_file_info

  • data_join_file_info_id — serial4 — Primary key — NOT NULL
  • data_join_work_id — int4 — Foreign key → data_join_work.data_join_work_id — NOT NULL
  • agency_id — int4
  • upload_file_path — varchar(256)
  • upload_file_size — varchar(100)
  • upload_file_time — timestamp
  • status — varchar(2)
  • privacy_check_status — varchar(2)
  • remove_file_path — varchar(256)
  • remove_count — int4
  • column_count — int4
  • seq_column_idx — int4
  • sort_order — int4
  • file_del_yn — varchar(2)
  • mail_send_yn — varchar(2)
  • mail_send_time — timestamp
  • encryption_send_time — timestamp
  • upload_rate — text
  • file_send_confirm_1 — varchar(2)
  • file_send_confirm_2 — varchar(2)
  • exception_log — text
  • file_send_manager — varchar(50)
  • split_file — varchar(50)

data_join_file_sample

  • sample_id — serial4 — Primary key — NOT NULL
  • data_join_work_id — int4 — Foreign key → data_join_work.data_join_work_id — NOT NULL
  • agency_id — int4
  • sample_type — varchar(2)
  • sample — jsonb
  • column_name — text

data_join_parent

  • data_join_parent_id — serial4 — Primary key — NOT NULL
  • parent_name — varchat(32)

data_join_relation

  • data_join_relation_id — serial4 — Primary key — NOT NULL
  • data_join_work_id — int4 — Foreign key → data_join_work.data_join_work_id — NOT NULL
  • agency_id — int4
  • agency_manager_id — int4
  • login_id — varchar(100)
  • login_pw — varchar(100)
  • encrypt_pw — varchar(100)
  • status — varchar(2)
  • insert_date — timestamp
  • deid_data_supply_yn — varchar(2)
  • join_result_use_yn — varchar(2)
  • split_file_yn — varchar(50)
  • split_file — varchar(50)

data_join_work

  • data_join_work_id — serial4 — Primary key — NOT NULL
  • work_name — text
  • receipt_time — timestamp
  • work_finish_time — timestamp
  • work_manager_id — varchar(50)
  • work_step — varchar(2)
  • work_status — varchar(2)
  • join_file_path — varchar(256)
  • dnld_cntl_yn — varchar(2)
  • dnld_vlid_date — varchar(8)
  • dnld_limit_count — int4
  • dnld_count — int4
  • join_file_size — varchar(100)
  • join_column_count — int4
  • work_stop_reason — varchar(500)
  • work_rate — varchar(100)
  • key_file_path — varchar(256)
  • key_file_size — varchar(100)
  • encryption_key — varchar(500)
  • prev_join_rate — varchar(100)
  • compl_join_rate — varchar(100)
  • time_series_join — varchar(2)
  • result_file_delete — varchar(2)
  • work_type — varchar(1)
  • join_type — varchar(1)
  • repeat_join_status — varchar(1)
  • work_start_time — timestamp
  • total_row_count — int4
  • read_row_count — int4
  • read_start_time — timestamp
  • read_end_time — timestamp
  • destroy_time — timestamp
  • work_delete_yn — varchar(2)
  • deid_work_id — int4
  • parent_data_join_work_id — int4
  • use_flag_key — varchar(1)
  • data_join_parent_id — serial4 — Foreign key → data_join_parent.data_join_parent_id — NOT NULL

data_sample

  • sample_id — serial4 — Primary key — NOT NULL
  • sample — json
  • collect_data_id — int4
  • data_join_work_id — serial4 — Foreign key → data_join_work.data_join_work_id — NOT NULL