CORE_LIMS
Tables (36)
ANALYSIS_INFO_TB
- analysis_info_id — uuid — Primary key — NOT NULL
- analysis_info_contents — varchar(100) — NOT NULL
- analysis_info_registration_dt — timestamp(3) — NOT NULL
- analysis_info_update_dt — timestamp(3)
- code_id_analysis_level — uuid — NOT NULL
- code_id_application — uuid — NOT NULL
- user_id_registrant — uuid — NOT NULL
ANALYSIS_JOB_TB
- analysis_job_id — uuid — Primary key — NOT NULL
- analysis_job_num — varchar(12) — NOT NULL
- analysis_job_run_name — varchar(30) — NOT NULL
- analysis_job_run_excution_dt — timestamp(0) — NOT NULL
- analysis_job_run_completion_dt — timestamp(0)
- analysis_job_progress — varchar(3) — NOT NULL
- analysis_job_database — varchar(20) — NOT NULL
- analysis_job_identity — varchar(20) — NOT NULL
- analysis_job_read_depth — varchar(20) — NOT NULL
- analysis_job_count — int4 — NOT NULL
- analysis_job_input_path — varchar(200) — NOT NULL
- analysis_job_output_path — varchar(200) — NOT NULL
- analysis_job_command — varchar(200)
- analysis_job_log — varchar
- analysis_job_issue — varchar
- analysis_job_status — varchar(10) — NOT NULL
- user_analyzer — uuid — NOT NULL
- analysis_pipeline_id — uuid — NOT NULL
ANALYSIS_LIST_SAMPLE_TB
- analysis_list_sample_id — uuid — Primary key — NOT NULL
- analysis_list_sample_status — varchar(12) — NOT NULL
- analysis_list_sample_is_active — bool — NOT NULL
- analysis_list_sample_registration_dt — timestamp(0) — NOT NULL
- analysis_list_id — uuid — NOT NULL
- sample_id — uuid — NOT NULL
- demutiplexing_detail_id — uuid — NOT NULL
- analysis_job_id — uuid
ANALYSIS_LIST_TB
- analysis_list_id — uuid — Primary key — NOT NULL
- analysis_list_count — int4 — NOT NULL
- analysis_list_status — varchar(12) — NOT NULL
- analysis_list_registration_dt — timestamp(0) — NOT NULL
- order_id — uuid — NOT NULL
- company_id — uuid — NOT NULL
- user_id_analyzer — uuid
ANALYSIS_PIPELINE_TB
- analysis_pipeline_id — uuid — Primary key — NOT NULL
- analysis_pipeline_name — varchar(30) — NOT NULL
- analysis_pipeline_type — varchar(6) — NOT NULL
- analysis_pipeline_server_user_name — varchar(10) — NOT NULL
- analysis_pipeline_server_remote_host — varchar(10) — NOT NULL
- analysis_pipeline_run_file_type — varchar(10) — NOT NULL
- analysis_pipeline_run_script_path — varchar(100) — NOT NULL
- analysis_pipeline_report_data_script_path — varchar(100)
- analysis_pipeline_reporter_script_path — varchar(100)
- analysis_pipeline_param — jsonb — NOT NULL
- analysis_pipeline_output_path — varchar(100) — NOT NULL
- analysis_pipeline_is_active — bool — NOT NULL
- analysis_pipeline_registration_dt — timestamp(3) — NOT NULL
- user_id_registrant — uuid — NOT NULL
ANALYSIS_WORK_SAMPLE_TB
- analysis_work_sample_id — uuid — Primary key — NOT NULL
- analysis_work_sample_name — varchar(20)
- analysis_work_sample_important_microbiome — varchar(200)
- analysis_work_sample_bmi — int4
- sample_id — uuid — NOT NULL
- analysis_list_sample_id — uuid — NOT NULL
- analysis_job_id — uuid
ANALYSIS_WORK_TB
- analysis_work_id — uuid — Primary key — NOT NULL
- analysis_work_run_id — varchar(50) — NOT NULL
- analysis_work_link — varchar(100)
- analysis_work_comment — varchar(200)
- analysis_work_status — varchar(12) — NOT NULL
- analysis_work_registration_dt — timestamp(0) — NOT NULL
- analysis_work_completion_dt — timestamp(0)
- order_id — uuid — NOT NULL
- company_id — uuid — NOT NULL
- user_analyzer — uuid — NOT NULL
CODE_GROUP_TB
- code_group_id — uuid — Primary key — NOT NULL
- code_group_category — varchar(20) — NOT NULL
- code_group_is_active — bool — NOT NULL
- code_group_registration_dt — timestamp(3) — NOT NULL
- code_group_update_dt — timestamp(3) — NOT NULL
- code_group_is_code_ref — bool — NOT NULL
- user_id_registrant — uuid — NOT NULL
CODE_TB
- code_id — uuid — Primary key — NOT NULL
- code_value — varchar(50) — NOT NULL
- code_label — varchar(50) — NOT NULL
- code_is_active — bool — NOT NULL
- code_order — int4 — NOT NULL
- code_registration_dt — timestamp(3) — NOT NULL
- code_update_dt — timestamp(3) — NOT NULL
- code_classification_first — varchar(30)
- code_classification_second — varchar(30)
- code_group_id — uuid — NOT NULL
- user_id_registrant — uuid — NOT NULL
COLUMN_TB
- column_id — uuid — Primary key — NOT NULL
- column_name — varchar(20) — NOT NULL
- column_field — varchar(20) — NOT NULL
- column_classification — varchar(20) — NOT NULL
- column_formatter — varchar(20)
- column_tab — varchar(20)
- column_editor — jsonb
- column_order — int4
- column_width — int4
- column_align — varchar(10)
- column_filter — varchar(100)
- column_filterable — bool — NOT NULL
- column_sortable — bool — NOT NULL
- column_rendereroption — varchar(30)
- column_update_dt — timestamp(3) — NOT NULL
- column_readonly — bool — NOT NULL
- column_required — bool — NOT NULL
- column_range — jsonb
- column_is_active — bool — NOT NULL
- user_id_updator — uuid
- menu_detail_id — uuid — NOT NULL
- code_group_id — uuid
COMPANY_TB
- company_id — uuid — Primary key — NOT NULL
- company_name — varchar(20) — NOT NULL
- company_code — varchar(3) — NOT NULL
- company_division — varchar(20)
- company_supervisor — varchar(20)
- company_customer — varchar(20) — NOT NULL
- company_email_first — varchar(50) — NOT NULL
- company_email_second — varchar(50)
- company_tel_first — varchar(15) — NOT NULL
- company_tel_second — varchar(15)
- company_address — text
- company_comment — text
- company_is_active — bool — NOT NULL
- company_registration_dt — timestamp(3) — NOT NULL
- user_accu_map_id — uuid
- user_id_registrant — uuid — NOT NULL
DEMULTIPLEXING_DETAIL_TB
- demultiplexing_detail_id — uuid — Primary key — NOT NULL
- demultiplexing_detail_project — varchar(255) — NOT NULL
- demultiplexing_detail_sample_name — varchar(12) — NOT NULL
- demultiplexing_detail_barcode_sequence — varchar(17) — NOT NULL
- demultiplexing_detail_read — int4 — NOT NULL
- demultiplexing_detail_lane_pct — numeric(3,2) — NOT NULL
- demultiplexing_detail_perfect_barcode_pct — numeric(3,2) — NOT NULL
- demultiplexing_detail_onemismatch_barcode_pct — numeric(3,2) — NOT NULL
- demultiplexing_detail_pf_clusters_pct — numeric(3,2) — NOT NULL
- demultiplexing_detail_yield — int4 — NOT NULL
- demultiplexing_detail_q30_pct — numeric(2,2) — NOT NULL
- demultiplexing_detail_mean_quality_score — numeric(2,2) — NOT NULL
- demultiplexing_detail_fastq_path — varchar(100) — NOT NULL
- demultiplexing_detail_task_path — varchar(100) — NOT NULL
- demultiplexing_detail_result — varchar(10) — NOT NULL
- demultiplexing_detail_result_qc — bool — NOT NULL
- demultiplexing_detail_confirm_dt — timestamp(3)
- demultiplexing_detail_registration_dt — timestamp(0) — NOT NULL
- demultiplexing_id — uuid — NOT NULL
- order_id — uuid — NOT NULL
- sample_id — uuid — NOT NULL
- company_id — uuid — NOT NULL
- user_id_confirmor — uuid
- code_id_application — uuid — NOT NULL
DEMULTIPLEXING_TB
- demultiplexing_id — uuid — Primary key — NOT NULL
- demultiplexing_run — varchar(30) — NOT NULL
- demultiplexing_run_path — varchar(100) — NOT NULL
- demultiplexing_task — varchar(30) — NOT NULL
- demultiplexing_task_path — varchar(100) — NOT NULL
- demultiplexing_task_status — varchar(10) — NOT NULL
- demultiplexing_task_log_path — varchar(100)
- demultiplexing_task_report_path — varchar(100)
- demultiplexing_task_comment — varchar(200)
- demultiplexing_task_samplesheet_path — varchar(100) — NOT NULL
- demultiplexing_task_command — varchar(400) — NOT NULL
- demultiplexing_task_start_dt — timestamp(3)
- demultiplexing_task_order — int4 — NOT NULL
- demultiplexing_task_end_dt — timestamp(3)
- demultiplexing_sample_cnt — int4 — NOT NULL
- demultiplexing_registration_dt — timestamp(0) — NOT NULL
- sequencing_id — uuid — NOT NULL
- sequencer_id — uuid — NOT NULL
DEPARTMENT_TB
- department_id — uuid — Primary key — NOT NULL
- department_name — varchar(20) — NOT NULL
- department_sort — int4
- department_is_active — bool — NOT NULL
- department_registration_dt — timestamp(0)
- user_id_registrant — uuid — NOT NULL
FILE_TB
- file_id — uuid — Primary key — NOT NULL
- file_ref_id — uuid
- file_path — varchar(100)
- file_original_name — varchar(40)
- file_name — varchar(40)
- file_extension — varchar(10)
- file_classification — varchar(10)
- file_registration_dt — timestamp(0)
- user_id_registrant — uuid — NOT NULL
ILLUMINA_WORK_DETAIL_TB
- illumina_work_detail_id — uuid — Primary key — NOT NULL
- illumina_work_detail_i7_index_id — varchar(6) — NOT NULL
- illumina_work_detail_i7_index_seq — varchar(8) — NOT NULL
- illumina_work_detail_i5_index_id — varchar(6) — NOT NULL
- illumina_work_detail_i5_index_seq — varchar(8) — NOT NULL
- illumina_work_detail_registration_dt — timestamp(3) — NOT NULL
- order_id — uuid — NOT NULL
- company_id — uuid — NOT NULL
- sample_id — uuid — NOT NULL
- miseq_list_id — uuid — NOT NULL
- illumina_work_id — uuid — NOT NULL
ILLUMINA_WORK_TB
- illumina_work_id — uuid — Primary key — NOT NULL
- illumina_work_num — varchar(12) — NOT NULL
- illumina_work_name — varchar(50) — NOT NULL
- illumina_work_nm — numeric(3,2)
- illumina_work_total_read — int4 — NOT NULL
- illumina_work_comment — varchar
- illumina_work_sample_cnt — int4 — NOT NULL
- illumina_work_status — varchar(7) — NOT NULL
- illumina_work_registration_dt — timestamp(3) — NOT NULL
- user_id_registrant — uuid — NOT NULL
- sequencer_id — uuid — NOT NULL
INDEX_SEQ_TB
- index_seq_id — uuid — Primary key — NOT NULL
- index_seq_index_id — varchar(10) — NOT NULL
- index_seq_i7_index_id — varchar(6) — NOT NULL
- index_seq_i7_index_seq — varchar(15) — NOT NULL
- index_seq_i5_index_id — varchar(6) — NOT NULL
- index_seq_i5_index_seq — varchar(15) — NOT NULL
- index_seq_registration_dt — timestamp(3) — NOT NULL
- user_id_registrant — uuid — NOT NULL
LIBRARY_WORKSHEET_SAMPLE_TB
- library_worksheet_sample_id — uuid — Primary key — NOT NULL
- library_worksheet_sample_a260_a280_ratio — numeric(10,2)
- library_worksheet_sample_input_dna — numeric(10,2)
- library_worksheet_sample_volume — numeric(10,2)
- library_worksheet_sample_dw — numeric(10,2)
- library_worksheet_sample_pcr_cycle__1st — numeric(10,2)
- library_worksheet_sample_lib_size_1st — numeric(10,2)
- library_worksheet_sample_pcr_cycle__2nd — numeric(10,2)
- library_worksheet_sample_i7_index_id — varchar(8)
- library_worksheet_sample_i7_index_seq — varchar(12)
- library_worksheet_sample_i5_index_id — varchar(8)
- library_worksheet_sample_i5_index_seq — varchar(12)
- library_worksheet_sample_qubit_conc — numeric(10,2)
- library_worksheet_sample_peak_size — numeric(10,2)
- library_worksheet_sample_nm — numeric(10,2)
- library_worksheet_sample_lib_volume — numeric(10,2)
- library_worksheet_sample_total_lib — numeric(10,2)
- library_worksheet_sample_sample_input — int4
- library_worksheet_sample_lib_concentration_1st — numeric(10,2)
- library_worksheet_sample_lib_concentration_2nd — numeric(10,2)
- library_worksheet_sample_lib_size_2nd — numeric(10,2)
- library_worksheet_sample_nm_1st — numeric(10,2)
- library_worksheet_sample_nm_2nd — numeric(10,2)
- library_worksheet_sample_comment — varchar(20)
- library_worksheet_sample_registration_dt — timestamp(3) — NOT NULL
- library_worksheet_sample_state — bool — NOT NULL
- file_id — uuid
- code_id_qc_result — uuid — NOT NULL
- library_worksheet_id — uuid — NOT NULL
- sample_id — uuid — NOT NULL
- order_id — uuid — NOT NULL
- index_seq_id — uuid — NOT NULL
LIBRARY_WORKSHEET_TB
- library_worksheet_id — uuid — Primary key — NOT NULL
- library_worksheet_num — varchar(10) — NOT NULL
- library_worksheet_name — varchar(25) — NOT NULL
- library_worksheet_sample_cnt — int4 — NOT NULL
- library_worksheet_registration_dt — timestamp(3) — NOT NULL
- library_worksheet_state — bool — NOT NULL
- code_id_sample_type — uuid
- code_id_work_type — uuid
- code_id_prep_kit — uuid
- user_id_registrant — uuid — NOT NULL
LOG_REPLY_TB
- log_reply_id — uuid — Primary key — NOT NULL
- log_reply_content — varchar(255) — NOT NULL
- log_reply_registration_dt — timestamp(0) — NOT NULL
- log_reply_depth — int4 — NOT NULL
- log_reply_sort — int4 — NOT NULL
- log_id — uuid — NOT NULL
- user_id_replier — uuid — NOT NULL
- file_id — uuid — NOT NULL
LOG_TB
- log_id — uuid — Primary key — NOT NULL
- log_num — int4 — NOT NULL
- log_status — varchar(12) — NOT NULL
- log_content — varchar(255) — NOT NULL
- log_urgent — bool — NOT NULL
- log_registration_dt — timestamp(0) — NOT NULL
- log_reply_dt — timestamp(0)
- log_is_completed — bool — NOT NULL
- log_end_dt — timestamp(0)
- user_id_registrant — uuid — NOT NULL
- order_id — uuid — NOT NULL
- department_id_regist — uuid — NOT NULL
- department_id_processing — uuid — NOT NULL
- user_id_confirmor — uuid
- file_id — uuid — NOT NULL
MENU_DETAIL_TB
- menu_detail_id — uuid — Primary key — NOT NULL
- menu_detail_name — varchar(30) — NOT NULL
- menu_detail_sort — int4 — NOT NULL
- menu_detail_route — varchar(30) — NOT NULL
- menu_detail_gbn — varchar(4) — NOT NULL
- menu_detail_update_dt — timestamp(3)
- menu_detail_is_active — bool — NOT NULL
- user_id_updator — uuid
- menu_id — uuid — NOT NULL
MENU_TB
- menu_id — uuid — Primary key — NOT NULL
- menu_name — varchar(30) — NOT NULL
- menu_sort — int4 — NOT NULL
- menu_icon — varchar(30)
- menu_route — varchar(30) — NOT NULL
- menu_gbn — varchar(4) — NOT NULL
- menu_update_dt — timestamp(0)
- menu_registration_dt — timestamp(0) — NOT NULL
- menu_is_active — bool — NOT NULL
- user_id_updator — uuid
MISEQ_LIST_TB
- miseq_list_id — uuid — Primary key — NOT NULL
- miseq_list_i7_index_id — varchar(8) — NOT NULL
- miseq_list_i7_index_seq — varchar(12) — NOT NULL
- miseq_list_i5_index_id — varchar(8) — NOT NULL
- miseq_list_i5_index_seq — varchar(12) — NOT NULL
- miseq_list_work_cnt — int4 — NOT NULL
- miseq_list_registration_dt — timestamp(3) — NOT NULL
- index_seq_id — uuid — NOT NULL
- sample_id — uuid — NOT NULL
- order_id — uuid — NOT NULL
- user_id_registrant — uuid — NOT NULL
ORDER_TB
- order_id — uuid — Primary key — NOT NULL
- order_num — varchar(12) — NOT NULL
- order_name — varchar(25) — NOT NULL
- order_sample_cnt — int4 — NOT NULL
- order_total_price — int4
- order_receive_dt — timestamp(3)
- order_registration_dt — timestamp(3) — NOT NULL
- order_completion_dt — timestamp(3)
- order_tat — timestamp(3)
- order_customer_req — text
- order_sales_req — text
- order_reg_state — bool — NOT NULL
- order_accept_state — bool — NOT NULL
- order_unformed_state — bool — NOT NULL
- order_status — varchar(15) — NOT NULL
- code_id_ordertype — uuid
- code_id_application — uuid
- code_id_species — uuid
- code_id_service — uuid
- code_id_target — uuid
- code_id_specimen — uuid
- code_id_sample_type — uuid
- code_id_output_scale — uuid
- code_id_read_size — uuid
- code_id_library_kit — uuid
- user_id_registrant — uuid — NOT NULL
- user_id_confirmor — uuid
- user_id_sales_rep — uuid
- company_id — uuid — NOT NULL
- analysis_info_id — uuid — NOT NULL
- sequencer_id — uuid
SAMPLE_TB
- sample_id — uuid — Primary key — NOT NULL
- sample_status — varchar(15) — NOT NULL
- sample_output_require — varchar(10)
- sample_receive_dt — timestamp(3)
- sample_smp_completion_dt — timestamp(3)
- sample_lib_completion_dt — timestamp(3)
- sample_demulti_completion_dt — timestamp(3)
- sample_analysis_completion_dt — timestamp(3)
- sample_comment — varchar(20)
- sample_i7_index_seq — varchar(12)
- sample_i5_index_seq — varchar(12)
- sample_smp_list_status — varchar(10) — NOT NULL
- sample_smp_sheet_cnt — int4
- sample_smp_prep_cnt — int4
- sample_smp_qc_cnt — int4
- sample_lib_list_status — varchar(10) — NOT NULL
- sample_lib_sheet_cnt — int4
- sample_lib_prep_cnt — int4
- sample_lib_qc_cnt — int4
- sample_registration_dt — timestamp(3) — NOT NULL
- order_id — uuid — NOT NULL
SAMPLE_WORKSHEET_SAMPLE_TB
- sample_worksheet_sample_id — uuid — Primary key — NOT NULL
- sample_worksheet_sample_conc — numeric(10,2)
- sample_worksheet_sample_volume — numeric(10,2)
- sample_worksheet_sample_a260_a280_ratio — numeric(10,2)
- sample_worksheet_sample_a260_a230_ratio — numeric(10,2)
- sample_worksheet_sample_total_dna — numeric(10,2)
- sample_worksheet_sample_qubit_conc — numeric(10,2)
- sample_worksheet_sample_input_dna_quantity — numeric(10,2)
- sample_worksheet_sample_total_amount_nd — numeric(10,2)
- sample_worksheet_sample_total_amount_q — numeric(10,2)
- sample_worksheet_sample_bioaz_conc — numeric(10,2)
- sample_worksheet_sample_rrna_ratio_28s_16s — numeric(10,2)
- sample_worksheet_sample_dv_200 — numeric(10,2)
- sample_worksheet_sample_rin — numeric(10,2)
- sample_worksheet_sample_comment — varchar(20)
- sample_worksheet_sample_registration_dt — timestamp(3) — NOT NULL
- sample_worksheet_sample_state — bool — NOT NULL
- sample_id — uuid — NOT NULL
- order_id — uuid — NOT NULL
- sample_worksheet_id — uuid — NOT NULL
- code_id_qc_result — uuid
- file_id — uuid
SAMPLE_WORKSHEET_TB
- sample_worksheet_id — uuid — Primary key — NOT NULL
- sample_worksheet_num — varchar(10) — NOT NULL
- sample_worksheet_name — varchar(25) — NOT NULL
- sample_worksheet_sample_cnt — int4 — NOT NULL
- sample_worksheet_registration_dt — timestamp(3) — NOT NULL
- sample_worksheet_state — bool — NOT NULL
- code_id_sample_type — uuid
- code_id_work_type — uuid
- code_id_prep_kit — uuid
- user_id_registrant — uuid — NOT NULL
SEQENCER_TB
- sequencer_id — uuid — Primary key — NOT NULL
- sequencer_inst_name — varchar(20) — NOT NULL
- sequencer_inst_id — varchar(10) — NOT NULL
- sequencer_platform — varchar(20)
- sequencer_type — varchar(10) — NOT NULL
- sequencer_lanes — int4 — NOT NULL
- sequencer_path — varchar(50) — NOT NULL
- sequencer_is_active — bool — NOT NULL
- sequencer_running_status — bool — NOT NULL
- sequencer_registration_dt — timestamp(3) — NOT NULL
- user_id_registrant — uuid — NOT NULL
SEQEUNCING_DETAIL_TB
- sequencing_detail_id — uuid — Primary key — NOT NULL
- sequencing_detail_lane — int4 — NOT NULL
- sequencing_detail_registration_dt — timestamp(3) — NOT NULL
- order_id — uuid — NOT NULL
- company_id — uuid — NOT NULL
- sample_id — uuid — NOT NULL
- illumina_work_id — uuid — NOT NULL
- illumina_work_detail_id — uuid — NOT NULL
- sequencing_id — uuid — NOT NULL
SEQUENCING_TB
- sequencing_id — uuid — Primary key — NOT NULL
- sequencing_plate — varchar(12) — NOT NULL
- sequencing_plate_name — varchar(50) — NOT NULL
- sequencing_read_type — varchar(10) — NOT NULL
- sequencing_read_cycle — int4 — NOT NULL
- sequencing_index_type — varchar(10) — NOT NULL
- sequencing_index_cycle — int4 — NOT NULL
- sequencing_sample_cnt — int4 — NOT NULL
- sequencing_run — varchar(30)
- sequencing_run_recipe — varchar(11) — NOT NULL
- sequencing_run_path — varchar(100)
- sequencing_run_status — varchar(10) — NOT NULL
- sequencing_kill — bool — NOT NULL
- sequencing_start_dt — timestamp(0)
- sequencing_update_dt — timestamp(3)
- sequencing_end_dt — timestamp(0)
- sequencing_completed_dt — timestamp(0)
- sequencing_confirm — bool — NOT NULL
- sequencing_confirm_dt — timestamp(0)
- sequencing_comment — varchar
- sequencing_registration_dt — timestamp(0) — NOT NULL
- sequencer_id — uuid — NOT NULL
- user_id_registrant — uuid — NOT NULL
- user_id_confirmor — uuid
USER_ACCUMAP_TB
- user_accu_map_id — uuid — Primary key — NOT NULL
- user_accu_map_level — int4 — NOT NULL
- user_accu_map_account — varchar(20) — NOT NULL
- user_accu_map_name — varchar(20) — NOT NULL
- user_accu_map_email — varchar(50)
- user_accu_map_password — varchar(60) — NOT NULL
- user_accu_map_is_active — bool — NOT NULL
- user_accu_map_registration_dt — timestamp(0) — NOT NULL
- company_id — uuid — NOT NULL
- user_id_registrant — uuid — NOT NULL
USER_TB
- user_id — uuid — Primary key — NOT NULL
- user_level — int4 — NOT NULL
- user_account — varchar(20) — NOT NULL
- user_name — varchar(20) — NOT NULL
- user_email — varchar(50)
- user_password — varchar(60) — NOT NULL
- user_is_active — bool — NOT NULL
- user_registration_dt — timestamp(3) — NOT NULL
- department_id — uuid
- user_id_registrant — uuid
YIELDCHECK_TB
- yield_check_id — uuid — Primary key — NOT NULL
- yield_check_fastq_path — varchar(100) — NOT NULL
- yield_check_read_stack — int4 — NOT NULL
- yield_check_registration_dt — timestamp(0) — NOT NULL
- yield_check_output_require — int4 — NOT NULL
- yield_check_read — int4 — NOT NULL
- yield_check_read_gap — int4 — NOT NULL
- yield_check_result — varchar(10) — NOT NULL
- yield_check_result_confirm — bool
- yield_check_confirm_dt — timestamp(0)
- demultiplexing_id — uuid — NOT NULL
- demultiplexing_detail_id — uuid — NOT NULL
- order_id — uuid — NOT NULL
- sample_id — uuid — NOT NULL
- sequencer_id — uuid — NOT NULL
- user_id_confirmor — uuid
_prisma_migrations
- id — varchar(36) — Primary key — NOT NULL
- checksum — varchar(64) — NOT NULL
- finished_at — timestamptz
- migration_name — varchar(255) — NOT NULL
- logs — text
- rolled_back_at — timestamptz
- started_at — timestamptz — NOT NULL
- applied_steps_count — int4 — NOT NULL