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