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