gxd
Tables (145)
clinical_trial_asso_drug
- TRIAL_ID — varchar(30) — Primary key — NOT NULL
- OKB_DRUG_ID — varchar(20) — Primary key — NOT NULL
- CREATE_DT — datetime
- CREATE_USER — varchar(100)
- LAST_UPDATE_DT — datetime
- LAST_UPDATE_USER — varchar(100)
clinical_trial_info
- TRIAL_ID — varchar(30) — Primary key — NOT NULL
- SEQ — int(11) — Primary key — NOT NULL
- RELATE_SOLUTION — varchar(15)
- CANCER_TYPE — varchar(50)
- COLLECT_DATE — date
- TRIAL_START_DT — date
- TRIAL_END_DT — date
- STUDY — text
- DISEASE_SETTING — varchar(100)
- ORGAN — varchar(50)
- CANCER — varchar(200)
- BIOMARKER — text
- LEVEL — varchar(15)
- GENE — varchar(200)
- MOLECULAR_ALTER — varchar(400)
- NEGATIVE — varchar(200)
- EXCLUSION — text
- ASSO_DRUG — text
- PHASE — varchar(15)
- COUNTRY — varchar(25)
- ENROL_STATUS — varchar(40)
- SEX — varchar(5)
- STUDY_POPULATION — int(10)
- PRIM_OUTCOME — text
- ADD_INFO — text
- CREATE_DT — datetime
- CREATE_USER — varchar(100)
- LAST_UPDATE_DT — datetime
- LAST_UPDATE_USER — varchar(100)
- INTERVENTION — text
clinical_trial_intervention
- TRIAL_ID — varchar(30) — Primary key — NOT NULL
- INTERVENTION — varchar(200)
- INTERVENTION_TYP — varchar(50)
- CREATE_DT — datetime
- CREATE_USER — varchar(100)
- LAST_UPDATE_DT — datetime
- LAST_UPDATE_USER — varchar(100)
clinical_trial_target
- TRIAL_ID — varchar(30) — Primary key — NOT NULL
- GENE_NM — varchar(50) — Primary key — NOT NULL
- MOLECULAR_ALTERATION — varchar(200) — Primary key — NOT NULL
- LEVEL — varchar(20) — Primary key — NOT NULL
- CONN_TYP — varchar(3)
- ATTR1 — varchar(50)
- ATTR2 — varchar(50)
- ATTR3 — varchar(50)
- CREATE_DT — datetime
- CREATE_USER — varchar(100)
- LAST_UPDATE_DT — datetime
- LAST_UPDATE_USER — varchar(100)
- 비고 — varchar(1024)
cm_clinical_trial_mst
- CLINICAL_TRIAL_ID — bigint(20) — Primary key — NOT NULL — Clinical Trial ID
- CLINICAL_TRIAL_NAME — varchar(100) — NOT NULL — Clinical Trial Name
- OLD_CLINICAL_TRIAL_ID — varchar(100) — Clinical Trial ID(old)
- USE_YN — char(1) — NOT NULL — Use YN
- CREATE_DATE — datetime — Create Date
- CREATE_USER — varchar(100) — Create User ID
- UPDATE_DATE — datetime — Update Date
- UPDATE_USER — varchar(100) — Update User ID
cm_date_mst
- DATE — date — Primary key — NOT NULL
- DAY — char(8)
- WEEK_START — char(10)
- WEEK_END — char(10)
- WEEK_MONTH — char(12)
- WORKING_DT — tinyint(1)
cm_lookup
- GROUP_ID — varchar(30) — Primary key — NOT NULL — 코드그룹 ID
- COM_ID — varchar(20) — Primary key — NOT NULL — 코드 ID
- GROUP_NAME — varchar(100) — 코드그룹명
- COM_NAME — varchar(100) — 코드명
- SORT_ORDER — int(11) — 정렬순서
- DESCRIPTION — varchar(1000) — 상세설명
- USE_YN — char(1) — 사용여부
- ATTR1 — varchar(255) — 속성1
- ATTR2 — varchar(255) — 속성2
- ATTR3 — varchar(255) — 속성3
- ATTR4 — varchar(255) — 속성4
- ATTR5 — varchar(255) — 속성5
- ATTR6 — varchar(255) — 속성6
- ATTR7 — varchar(255) — 속성7
- ATTR8 — varchar(255) — 속성8
- ATTR9 — varchar(255) — 속성9
- ATTR10 — varchar(255) — 속성10
- ATTR11 — varchar(255) — 속성11
- ATTR12 — varchar(255) — 속성12
- ATTR13 — varchar(255) — 속성13
- ATTR14 — varchar(255) — 속성14
- ATTR15 — varchar(255) — 속성15
- ATTR16 — varchar(255) — 속성16
- ATTR17 — varchar(255) — 속성17
- ATTR18 — varchar(255) — 속성18
- ATTR19 — varchar(255) — 속성19
- ATTR20 — varchar(255) — 속성20
- ATTR21 — varchar(255) — 속성21
- ATTR22 — varchar(255) — 속성22
- ATTR23 — varchar(255) — 속성23
- ATTR24 — varchar(255) — 속성24
- ATTR25 — varchar(255) — 속성25
- ATTR26 — varchar(255) — 속성26
- ATTR27 — varchar(255) — 속성27
- ATTR28 — varchar(255) — 속성28
- ATTR29 — varchar(255) — 속성29
- ATTR30 — varchar(255) — 속성30
- ATTR31 — varchar(255)
- ATTR32 — varchar(255)
- ATTR33 — varchar(255)
- ATTR34 — varchar(255)
- ATTR35 — varchar(255)
- ATTR36 — varchar(255)
- ATTR37 — varchar(255)
- ATTR38 — varchar(255)
- ATTR39 — varchar(255)
- ATTR40 — varchar(255)
- ATTR41 — varchar(255)
- ATTR42 — varchar(255)
- ATTR43 — varchar(255)
- ATTR44 — varchar(255)
- ATTR45 — varchar(255)
- ATTR46 — varchar(255)
- ATTR47 — varchar(255)
- ATTR48 — varchar(255)
- ATTR49 — varchar(255)
- ATTR50 — varchar(255)
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- … +1
cm_lookup_bk_20250217
- GROUP_ID — varchar(30) — Primary key — NOT NULL — 코드그룹 ID
- COM_ID — varchar(20) — Primary key — NOT NULL — 코드 ID
- GROUP_NAME — varchar(100) — 코드그룹명
- COM_NAME — varchar(100) — 코드명
- SORT_ORDER — int(11) — 정렬순서
- DESCRIPTION — varchar(1000) — 상세설명
- USE_YN — char(1) — 사용여부
- ATTR1 — varchar(255) — 속성1
- ATTR2 — varchar(255) — 속성2
- ATTR3 — varchar(255) — 속성3
- ATTR4 — varchar(255) — 속성4
- ATTR5 — varchar(255) — 속성5
- ATTR6 — varchar(255) — 속성6
- ATTR7 — varchar(255) — 속성7
- ATTR8 — varchar(255) — 속성8
- ATTR9 — varchar(255) — 속성9
- ATTR10 — varchar(255) — 속성10
- ATTR11 — varchar(255) — 속성11
- ATTR12 — varchar(255) — 속성12
- ATTR13 — varchar(255) — 속성13
- ATTR14 — varchar(255) — 속성14
- ATTR15 — varchar(255) — 속성15
- ATTR16 — varchar(255) — 속성16
- ATTR17 — varchar(255) — 속성17
- ATTR18 — varchar(255) — 속성18
- ATTR19 — varchar(255) — 속성19
- ATTR20 — varchar(255) — 속성20
- ATTR21 — varchar(255) — 속성21
- ATTR22 — varchar(255) — 속성22
- ATTR23 — varchar(255) — 속성23
- ATTR24 — varchar(255) — 속성24
- ATTR25 — varchar(255) — 속성25
- ATTR26 — varchar(255) — 속성26
- ATTR27 — varchar(255) — 속성27
- ATTR28 — varchar(255) — 속성28
- ATTR29 — varchar(255) — 속성29
- ATTR30 — varchar(255) — 속성30
- ATTR31 — varchar(255)
- ATTR32 — varchar(255)
- ATTR33 — varchar(255)
- ATTR34 — varchar(255)
- ATTR35 — varchar(255)
- ATTR36 — varchar(255)
- ATTR37 — varchar(255)
- ATTR38 — varchar(255)
- ATTR39 — varchar(255)
- ATTR40 — varchar(255)
- ATTR41 — varchar(255)
- ATTR42 — varchar(255)
- ATTR43 — varchar(255)
- ATTR44 — varchar(255)
- ATTR45 — varchar(255)
- ATTR46 — varchar(255)
- ATTR47 — varchar(255)
- ATTR48 — varchar(255)
- ATTR49 — varchar(255)
- ATTR50 — varchar(255)
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- … +1
cm_mail_hist
- SEQ — int(11) — Primary key — NOT NULL
- CON — varchar(500)
- SAMPLE_ID — varchar(50)
- IDX — int(10)
- ORG_ID — varchar(20)
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
cm_menu_mst
- MENU_ID — varchar(20) — Primary key — NOT NULL — 메뉴 ID
- MENU_NAME — varchar(50) — 메뉴명
- MENU_LOCALE — varchar(50) — locale value
- P_MENU_ID — varchar(20) — 상위 메뉴 ID
- SYSTEM_ID — varchar(20) — 시스템 ID
- SORT_ORDER — int(11) — 정렬순서
- USE_YN — char(1) — 사용여부
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
cm_p_menu_mst
- P_MENU_ID — varchar(20) — Primary key — NOT NULL — 상위 메뉴 ID
- P_MENU_NAME — varchar(50) — 상위 메뉴 명
- P_MENU_LOCALE — varchar(50) — locale value
- MENU_TYPE — char(1) — Menu 타입, Side Menu/Main Menu
- SYSTEM_ID — varchar(20) — 시스템 ID
- SORT_ORDER — int(11) — 정렬순서
- USE_YN — char(1) — 사용여부
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
cm_pi_company_clinical_trial_map
- CLINICAL_TRIAL_ID — bigint(20) — Primary key — NOT NULL
- PI_COMP_ID — bigint(20) — Primary key — NOT NULL
- CREATE_DATE — datetime — Create Date
- CREATE_USER — varchar(100) — Create User ID
- UPDATE_DATE — datetime — Update Date
- UPDATE_USER — varchar(100) — Update User ID
cm_pi_company_mst
- PI_COMP_ID — bigint(20) — Primary key — NOT NULL — PI Company ID
- PI_COMP_NAME — varchar(100) — NOT NULL — PI Company Name
- OLD_PI_COMP_ID — varchar(100) — PI Company ID(old)
- USE_YN — char(1) — NOT NULL — Use YN
- CREATE_DATE — datetime — Create Date
- CREATE_USER — varchar(100) — Create User ID
- UPDATE_DATE — datetime — Update Date
- UPDATE_USER — varchar(100) — Update User ID
cm_pi_dept_mst
- PI_DEPT_ID — bigint(20) — Primary key — NOT NULL — PI Department ID
- PI_DEPT_NAME — varchar(100) — NOT NULL — PI Department Name
- OLD_PI_DEPT_ID — varchar(100) — PI Department ID(old)
- USE_YN — char(1) — NOT NULL — Use YN
- CREATE_DATE — datetime — Create Date
- CREATE_USER — varchar(100) — Create User ID
- UPDATE_DATE — datetime — Update Date
- UPDATE_USER — varchar(100) — Update User ID
cm_pi_group_mst
- PI_COMP — varchar(100) — Primary key — NOT NULL — PI Company ID
- EMAIL — varchar(100) — Primary key — NOT NULL — 그룹이메일
- USE_YN — varchar(1) — NOT NULL
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
cm_pi_group_mst_bk_20250217
- EMAIL — varchar(100) — NOT NULL — 그룹이메일
- USE_YN — varchar(1) — NOT NULL
- PI_COMP — varchar(100) — NOT NULL
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
cm_pi_group_mst_bk_origin_20250217
- EMAIL — varchar(100) — NOT NULL — 그룹이메일
- USE_YN — varchar(1) — NOT NULL
- PI_COMP — varchar(100) — NOT NULL
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
cm_pi_mst
- USER_ID — varchar(100) — Primary key — NOT NULL — 사용자 ID
- USER_PW — varchar(65) — 사용자 Password
- USER_NAME — varchar(30) — 사용자 이름
- USER_ROLE_ID — varchar(20) — 권한 ID
- DEPT_ID — bigint(20) — Department ID
- PHONE — varchar(20) — 전화번호
- company_id — bigint(20) — PI Company ID
- SECTION_ID — bigint(20) — Clinical Trial ID
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
cm_pi_mst_bk_20250217
- USER_ID — varchar(100) — Primary key — NOT NULL — 사용자 ID
- USER_PW — varchar(65) — 사용자 Password
- USER_NAME — varchar(30) — 사용자 이름
- USER_ROLE_ID — varchar(20) — 권한 ID
- DEPT_ID — varchar(20) — 부서 ID
- PHONE — varchar(20) — 전화번호
- COMPANY_ID — varchar(20) — 회사 ID
- SECTION_ID — varchar(30)
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
cm_pi_mst_bk_20250512
- USER_ID — varchar(100) — Primary key — NOT NULL — 사용자 ID
- USER_PW — varchar(65) — 사용자 Password
- USER_NAME — varchar(30) — 사용자 이름
- USER_ROLE_ID — varchar(20) — 권한 ID
- DEPT_ID — bigint(20) — Department ID
- PHONE — varchar(20) — 전화번호
- company_id — bigint(20) — PI Company ID
- SECTION_ID — bigint(20) — Clinical Trial ID
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
cm_pi_mst_bk_20250611_gxd_so
- USER_ID — varchar(100) — Primary key — NOT NULL — 사용자 ID
- USER_PW — varchar(65) — 사용자 Password
- USER_NAME — varchar(30) — 사용자 이름
- USER_ROLE_ID — varchar(20) — 권한 ID
- DEPT_ID — bigint(20) — Department ID
- PHONE — varchar(20) — 전화번호
- company_id — bigint(20) — PI Company ID
- SECTION_ID — bigint(20) — Clinical Trial ID
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
cm_pi_role_mst
- USER_ROLE_ID — varchar(20) — Primary key — NOT NULL — User Role ID
- USER_ROLE_NAME — varchar(50) — User Role 이름
- SYSTEM_ID — varchar(20) — 시스템 ID
- SORT_ORDER — int(11) — 정렬순서
- USE_YN — char(1) — 사용여부
- USER_ROLE_ACC — varchar(7) — Role 유형
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
cm_program_mst
- PROGRAM_ID — varchar(20) — Primary key — NOT NULL — 프로그램 ID
- PROGRAM_NAME — varchar(100) — 프로그램명
- MENU_ID — varchar(20) — 메뉴 ID
- SYSTEM_ID — varchar(20) — 시스템 ID
- FILE_PATH — varchar(255) — 파일경로
- PROGRAM_URI — varchar(255) — 프로그램 URI
- PROGRAM_TYPE — char(2) — main/popup/tab 등 구분
- USE_YN — char(1) — 사용여부
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
cm_system_mst
- SYSTEM_ID — varchar(20) — Primary key — NOT NULL — 시스템 ID
- SYSTEM_NAME — varchar(100) — 시스템 명
- SYSTEM_SHORT_NAME — varchar(20) — 시스템 약어
- SORT_ORDER — int(11) — 정렬순서
- USE_YN — char(1) — 사용여부
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
cm_user_mst
- USER_ID — varchar(100) — Primary key — NOT NULL — 사용자 ID
- USER_PW — varchar(65) — 사용자 Password
- USER_NAME — varchar(30) — 사용자 이름
- USER_ROLE_ID — varchar(20) — 권한 ID
- EMAIL — varchar(100) — E-mail
- EMP_NO — varchar(20) — 사번
- DEPT_ID — varchar(20) — 부서 ID
- DEPT_POS_NAME — varchar(50) — 직급
- PHONE — varchar(20) — 전화번호
- COMPANY_ID — varchar(20) — 회사 ID
- USE_YN — char(1) — 사용여부
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
- USER_IP — varchar(20) — 사용자 IP
- ORG_ID — varchar(30)
- PW_UPDATE_DATE — datetime
- LOGIN_FAIL_COUNT — int(11)
cm_user_role_auth
- USER_ROLE_ID — varchar(20) — Primary key — NOT NULL — 사용자 역할 ID
- PROGRAM_ID — varchar(100) — Primary key — NOT NULL — 프로그램 ID
- AUTH_ID — varchar(20) — Primary key — NOT NULL — 권한 ID
- SORT_ORDER — int(11) — 정렬순서
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
cm_user_role_mst
- USER_ROLE_ID — varchar(20) — Primary key — NOT NULL — User Role ID
- USER_ROLE_NAME — varchar(50) — User Role 이름
- SYSTEM_ID — varchar(20) — 시스템 ID
- SORT_ORDER — int(11) — 정렬순서
- USE_YN — char(1) — 사용여부
- USER_ROLE_ACC — varchar(7) — Role 유형
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
cs_cancertype_summary
- CALC_DATE — date — Primary key — NOT NULL
- CANCER_TYPE — varchar(50) — Primary key — NOT NULL
- SITE_NAME — varchar(50) — Primary key — NOT NULL
- SAMPLE_CNT — int(11)
- REG_DTM — datetime
- REGR_ID — varchar(50)
cs_civic_annotation
- CIVIC_RO_LINE — int(11)
- GENE — varchar(15)
- ENTREZ_ID — varchar(300)
- VARIANT — varchar(300)
- DISEASE — varchar(300)
- DO_ID — varchar(300)
- DRUGS — varchar(300)
- EVIDENCE_TYPE — varchar(300)
- EVIDENCE_DIRECTION — varchar(300)
- EVIDENCE_LEVEL — varchar(300)
- CLINICAL_SIGNIFICANCE — varchar(300)
- EVIDENCE_STATEMENT — varchar(2000)
- PUBMED_ID — varchar(300)
- CITATION — varchar(300)
- RATING — varchar(300)
- EVIDENCE_STATUS — varchar(300)
- VIDENCE_ID — varchar(300)
- VARIANT_ID — varchar(300)
- GENE_ID — varchar(300)
- CHROMOSOME — varchar(300)
- CIVIC_START — varchar(300)
- CIVIC_STOP — varchar(300)
- REFERENCE_BASES — varchar(300)
- REPRESENTATIVE_TRANSCRIPT — varchar(300)
- CHROMOSOME2 — varchar(300)
- START2 — varchar(300)
- STOP2 — varchar(300)
- REPRESENTATIVE_TRANSCRIPT2 — varchar(300)
- ENSEMBL_VERSION — varchar(300)
- REFERENCE_BUILD — varchar(300)
- VARIANT_SUMMARY — varchar(1000)
- VARIANT_ORIGIN — varchar(1000)
- EVIDENCE_CIVIC_URL — varchar(300)
- VARIANT_CIVIC_URL — varchar(300)
- GENE_CIVIC_URL — varchar(300)
- VARIANT_ID2 — varchar(300)
- ID2 — varchar(300)
- PUBMED_LINK — varchar(300)
- VARIANT_TYPE — varchar(300)
- EVIDENCE_LEVEL_DESC — varchar(300)
- EXON — varchar(300)
- DRUG_DIRECTION — varchar(300)
- DIRECTION — varchar(300)
- LAST_UPDATE_DATE — datetime
- LAST_UPDATED_BY — int(11)
- CREATION_DATE — datetime
- CREATED_BY — int(11)
cs_panel_summary
- CALC_DATE — date — Primary key — NOT NULL
- PANEL_VER_ID — varchar(15) — Primary key — NOT NULL
- SITE_NAME — varchar(50) — Primary key — NOT NULL
- SAMPLE_CNT — int(11)
- REG_DTM — datetime
- REGR_ID — varchar(50)
cs_sample_info_old
- SI_ID — decimal(11,0)
- SAMPLE_NO — varchar(50)
- SPECIMEN — varchar(50)
- SGI_ID — varchar(50) — NOT NULL
- TUMOR_PERCENT — varchar(45)
- REQUESTED — varchar(200)
- SEQ_DATE — datetime
- REPORT_DATE — datetime
- DX — varchar(150)
- DX_CODE — varchar(10)
- DX_CURATED — varchar(100)
- REQUESTED_CODE — varchar(20)
- CURATED — varchar(45)
- CS_COMMENT — varchar(1200)
- COMMENT_SGI — varchar(1200)
- COMMENT_DATE — datetime
- COMMENT_DATE_SGI — datetime
- COMMENT_SGI_BY — varchar(50)
- COMMENT_BY — varchar(50)
- REQUESTED_IN_REPORT — varchar(100)
- RECEIVED_DATE — datetime
- PREP_DATE — datetime
- QC_DONE_DATE — datetime
- LIB_DATE — datetime
- DATE_DB_UPDATE — datetime
- UPDATED_BY — varchar(45)
- NO_EXP — varchar(45)
- NO_EXP_DESC — varchar(255)
- DO_SEQ — varchar(45)
- RECEIVED_CHECK — varchar(45)
- REMARK — varchar(200)
- DNA_GRADE — varchar(45)
- DX_ORGAN — varchar(255)
- PCODE — varchar(45)
- RNA_SEQ — varchar(45)
- REPORT_DATE_FIRST — datetime
- REPORT_DATE_LAST — datetime
- REPORT_DATE_LAST_SNV — datetime
- REPORT_DATE_LAST_INDEL — datetime
- REPORT_DATE_LAST_CNV — datetime
- REPORT_DATE_LAST_SV — datetime
- BAM_STARTED — datetime
- BAM_FINISHED — datetime
- SNV_STARTED — datetime
- SNV_FINISHED — datetime
- INDEL_STARTED — datetime
- INDEL_FINISHED — datetime
- CNV_STARTED — datetime
- CNV_FINISHED — datetime
- SV_STARTED — datetime
- SV_FINISHED — datetime
- REPORT_STARTED — datetime
- REPORT_FINISHED — datetime
- MODULE_VER — varchar(45)
- CS_VER_IN_RUN_BAM — varchar(45)
- CS_VER_IN_RUN_SNV — varchar(45)
- CS_VER_IN_RUN_INDEL — varchar(45)
- CS_VER_IN_RUN_CNV — varchar(45)
- CS_VER_IN_RUN_SV — varchar(45)
- CS_VER_IN_RUN_REPORT — varchar(45)
- … +22
cs_samples_qc
- SGI_ID — varchar(50) — NOT NULL
- BATCH_NAME — varchar(300)
- BATCH_DATE — datetime
- BED_VER — varchar(135)
- FASTQ_PRODUCTION_PATH — varchar(765)
- FASTQ_READS_RAW — varchar(90)
- FASTQ_TOTAL_BASES — varchar(90)
- FASTQ_READ_LENGTH — varchar(90)
- FASTQ_FILE_SIZE — varchar(90)
- GC — varchar(135)
- Q30 — varchar(135)
- PCT_TARGET_BASES_100X — double
- PCT_ONBAIT — double — HS_NGS-Raw data 중 목표 지점과 일치율, HS_ARR-Call rate
- PCT_UNIQUELY_ALIGNED_READS — double
- MEAN_TARGET_COVERAGE — double
- UNIQUELY_ALIGNED_COUNT — varchar(90)
- ON_TARGET_BASES — varchar(90)
- PICARD_HSMETRICS — varchar(1200)
- PICARD_HSMETRICS_FILE — varchar(765)
- READS_COUNT_BEFORE_DUP — varchar(90)
- READS_COUNT_AFTER_DUP — varchar(90)
- READS_COUNT_RECAL_BAM — varchar(90)
- COVERAGE_RECAL_BAM — varchar(90)
- SAMPLE_TYPE — varchar(135)
- SAMPLES_QC_NOTE — varchar(1200)
- SAMPLE_NAME_HISTORY — varchar(1200)
- BED_FILE — varchar(765)
- SAMPLE_DESC — varchar(300)
- SAMPLE_PROJECT — varchar(300)
- LAST_UPDATE — datetime
- FIRST_UPDATE — datetime
- PICARD_METRICS_DATA — varchar(1200)
- SAMPLE_INDEX — varchar(60)
- BARCODE — varchar(1200)
- BARCODE_INFO — varchar(1200)
- DX_CODE — varchar(30)
- SEQ_DONE_DATE — datetime
- CALLING_QC_SNV — varchar(60)
- CREATED_BY — int(11)
- LAST_UPDATE_DATE — datetime
- LAST_UPDATED_BY — int(11)
- CREATION_DATE — datetime
- PCT_ONBAIT_BK — varchar(135)
- PCT_UNIQUELY_ALIGNED_READS_BK — varchar(135)
- MEAN_TARGET_COVERAGE_BK — varchar(135)
- PCT_TARGET_BASES_100X_BK — double
- PR_SCORE — varchar(30)
- UNIFORMITY_RATE — varchar(30)
- DUP_RATE — double
- INPUT_AMOUNT — varchar(10)
- CELL_LINE — varchar(100)
- DESCRIPTION — varchar(1000)
- TUMOR_PURITY — varchar(100)
- GENDER_MF — varchar(10)
- ANAL_COMP_YN — varchar(1)
- LRR_5 — double — HealthSCAN array chip data의 Log R Ratio의 5% 범위값
- LRR_95 — double — HealthSCAN array chip data의 Log R Ratio의 95% 범위값
- BAF — double — HealthSCAN array chip data의 BAF 적정값 비율
ct_intervention
- TRIAL_ID — varchar(20) — Primary key — NOT NULL
- INTERVENTION_ITEM_NO — int(10) — Primary key — NOT NULL
- INTERVENTION_TYPE — varchar(200)
- INTERVENTION_NAME — varchar(200)
- DESC — mediumtext
- ARMGROUP_LABEL — mediumtext
ct_outcome
- TRIAL_ID — varchar(20) — Primary key — NOT NULL
- OUTCOME_ITEM_NO — int(10) — Primary key — NOT NULL
- OUTCOME_TYPE — varchar(20)
- MEASURE — mediumtext
- TIME_FRAME — mediumtext
- DESC — mediumtext
email_confirm
- email — varchar(255) — Primary key — NOT NULL — 이메일주소
- auth_code — varchar(100) — NOT NULL — 인증 코드
- expire_at — timestamp — NOT NULL — 만료 일시
- created_at — timestamp — 생성일시
- created_by — varchar(100) — 생성자 id
- updated_at — timestamp — 수정일시
- updated_by — varchar(100) — 수정자 id
gc_alter_cnv
- SEQ — int(11) — Primary key — NOT NULL — SEQ
- SAMPLE_ID — varchar(30) — 샘플 아이디
- IDX — int(11) — 인덱스
- CONFIRM_YN — varchar(1) — confirm 여부
- TIER — varchar(10) — Pipeline에서 생성된 티어
- DISPLAY_TIER — varchar(10) — Display 티어(수정한)
- OKB_ADJUSTED_LEVEL — varchar(10) — OncoKB 적용 레벨
- SYMBOL — varchar(10) — Gene 명(Symbol 값)
- CHROM — varchar(10) — Chrom
- COPY_STATUS — varchar(15) — Amp. or Del.
- COPY_NO — varchar(20) — copy number
- VARIANT_ID — varchar(100) — gc_okb_var_drug_mapping 테이블 OncoKB Variant ID
- OKB_ONCOGENICITY — varchar(20) — OncoKB Oncogenicity
- OKB_DRUG_ID — varchar(30) — OncoKB Drug ID
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_alter_cnv_confirm_hist
- SEQ — int(10) — Primary key — NOT NULL — SEQ
- CONFIRM_SEQ — int(10) — Primary key — NOT NULL — gc_sample_confirm_hist.seq
- IDX — int(11) — NOT NULL
- SAMPLE_ID — varchar(30) — 샘플 아이디
- CONFIRM_YN — varchar(1) — confirm 여부 (Y/N)
- TIER — varchar(10) — Pipeline에서 생성된 티어
- DISPLAY_TIER — varchar(10) — Display 티어(수정한)
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_alter_express
- SAMPLE_ID — varchar(30) — 샘플 아이디
- IDX — int(11) — NOT NULL — 인덱스
- GENE — varchar(40) — NOT NULL — Gene명
- TPM — float — NOT NULL — TPM
- LOG_TPM — float — NOT NULL — LOG TPM
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_alter_mrd
- SEQ — int(10) — Primary key — NOT NULL — SEQ
- SAMPLE_ID — varchar(30) — 샘플 아이디
- IDX — int(11) — NOT NULL
- SEQ_NAME — varchar(30) — NOT NULL — 시퀀스 명
- GENE_TARGET — varchar(10) — 유전체 타겟
- TARGET_READ_COUNT — int(11) — Target Read Count
- MRD_RESULT — varchar(20) — MRD 결과
- CLONAL_FREQ_TYPE — int(10) — Cloncal Frequency Type(0,1,2,3,4....)
- CLONAL_FREQ — float — Cloncal Frequency 값
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(50) — 생성자
- LAST_UPDATE_DATE — datetime — 갱신일
- LAST_UPDATE_USER — varchar(50) — 갱신자
gc_alter_msi
- SEQ — int(11) — Primary key — NOT NULL
- SAMPLE_ID — varchar(30) — NOT NULL — 샘플 아이디
- IDX — int(11)
- TIER — varchar(5)
- DISPLAY_TIER — varchar(5)
- OKB_ADJUSTED_LEVEL — varchar(10) — OncoKB 적용 레벨
- STATUS — varchar(10) — MSS or MSI-H
- MSI — varchar(10)
- VARIANT_ID — varchar(100) — gc_okb_var_drug_mapping 테이블 OncoKB Variant ID
- OKB_ONCOGENICITY — varchar(20) — OncoKB Oncogenicity
- OKB_DRUG_ID — varchar(30) — OncoKB Drug ID
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_alter_plot
- SAMPLE_ID — varchar(30) — Primary key — NOT NULL — 검체 Sample ID
- IDX — int(11) — Primary key — NOT NULL — 인덱스
- VARIANT_GROUP_ID — varchar(20) — Primary key — NOT NULL — 분석 타입
- CHART_FILE_PATH — varchar(255) — PLOT 이미지 저장 경로
- CHART_URL_PATH — varchar(2000) — 오즈레포트를 위한 이미지 저장 경로
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_alter_sample_snv_confirm_hist
- SEQ — int(10) — Primary key — NOT NULL — SEQ
- CONFIRM_SEQ — int(10) — Primary key — NOT NULL — gc_sample_confirm_hist.seq
- IDX — int(11) — NOT NULL
- SAMPLE_ID — varchar(30) — 샘플 아이디
- CONFIRM_YN — varchar(1) — confirm 여부 (Y/N)
- TIER — varchar(10) — Pipeline에서 생성된 티어
- DISPLAY_TIER — varchar(10) — Display 티어(수정한)
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_alter_snv
- SEQ — int(10) — Primary key — NOT NULL — SEQ
- SAMPLE_ID — varchar(30) — 샘플 아이디
- IDX — int(11) — NOT NULL
- CONFIRM_YN — varchar(1) — confirm 여부 (Y/N)
- TIER — varchar(10) — Pipeline에서 생성된 티어
- DISPLAY_TIER — varchar(10) — Display 티어(수정한)
- OKB_ADJUSTED_LEVEL — varchar(10) — OncoKB 적용 레벨
- VAF — float — Variant Allele Frequency
- SYMBOL — varchar(10) — Gene 명(Symbol 값)
- HGVSC — varchar(200) — human genome variation society cDNA change
- HGVSP — varchar(200) — human genome variation society protein change
- EXON_NO — int(10) — exon number
- CLV_CLIN_SIG — varchar(60)
- VARIANT_ID — varchar(100) — gc_okb_var_drug_mapping 테이블 OncoKB Variant ID
- OKB_ONCOGENICITY — varchar(20) — OncoKB Oncogenicity
- OKB_DRUG_ID — varchar(30) — OncoKB Drug ID
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 갱신일
- LAST_UPDATE_USER — varchar(100) — 갱신자
gc_alter_snv_af_mapping
- VEP_ANN_SEQ — int(11) — Primary key — NOT NULL
- AF_ID — varchar(25) — Primary key — NOT NULL — AF_ID
- VAR_ID — mediumtext — NOT NULL — VAR_ID
- AF — double — AF 값
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_alter_snv_confirm_hist
- SEQ — int(10) — Primary key — NOT NULL — SEQ
- CONFIRM_SEQ — int(10) — Primary key — NOT NULL — gc_sample_confirm_hist.seq
- IDX — int(11) — NOT NULL
- SAMPLE_ID — varchar(30) — 샘플 아이디
- CONFIRM_YN — varchar(1) — confirm 여부 (Y/N)
- TIER — varchar(10) — Pipeline에서 생성된 티어
- DISPLAY_TIER — varchar(10) — Display 티어(수정한)
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_alter_snv_temp
- SEQ — int(10) — Primary key — NOT NULL — SEQ
- SAMPLE_ID — varchar(30) — 샘플 아이디
- IDX — int(11) — NOT NULL
- CONFIRM_YN — varchar(1) — confirm 여부 (Y/N)
- TIER — varchar(10) — Pipeline에서 생성된 티어
- DISPLAY_TIER — varchar(10) — Display 티어(수정한)
- OKB_ADJUSTED_LEVEL — varchar(10) — OncoKB 적용 레벨
- VAF — float — Variant Allele Frequency
- SYMBOL — varchar(10) — Gene 명(Symbol 값)
- HGVSC — varchar(200) — human genome variation society cDNA change
- HGVSP — varchar(200) — human genome variation society protein change
- EXON_NO — int(10) — exon number
- CLV_CLIN_SIG — varchar(60)
- VARIANT_ID — varchar(100) — gc_okb_var_drug_mapping 테이블 OncoKB Variant ID
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 갱신일
- LAST_UPDATE_USER — varchar(100) — 갱신자
gc_alter_splice
- SEQ — int(11) — Primary key — NOT NULL — SEQ
- SAMPLE_ID — varchar(30) — 샘플 아이디
- IDX — int(11) — NOT NULL — 인덱스
- CONFIRM_YN — char(1) — confirm 여부
- TIER — varchar(10) — Pipeline에서 생성된 티어
- DISPLAY_TIER — varchar(10) — Display 티어(수정한)
- OKB_ADJUSTED_LEVEL — varchar(10) — OncoKB 적용 레벨
- GENE — varchar(40) — Gene 명(Symbol 값)
- DETECTION — char(1) — Detection
- OKB_ONCOGENICITY — varchar(20) — OncoKB Oncogenicity
- OKB_MUTATION_EFFECT — varchar(30) — OncoKB Mutational Effect
- OKB_DRUG_ID — varchar(30) — OncoKB Drug ID
- OKB_DRUGS — varchar(255) — OncoKB Drug Names
- CLV_CLIN_SIG — varchar(60)
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_alter_sv
- SEQ — int(11) — Primary key — NOT NULL — SEQ
- IDX — int(11) — NOT NULL — 인덱스
- SAMPLE_ID — varchar(30) — 샘플 아이디
- CONFIRM_YN — char(1) — confirm 여부
- TIER — varchar(10) — Pipeline에서 생성된 티어
- DISPLAY_TIER — varchar(10) — Display 티어(수정한)
- GENE_A — varchar(40) — Gene 명(Symbol 값)
- GENE_A_ORI — char(1) — 유전자 발현 방향
- READ_A — int(11)
- READ_A_CNT — int(11)
- READ_A_COVER — int(11)
- READ_A_POS — varchar(50)
- CHR_A — varchar(10) — 염색체
- BREAKPOINT_A — varchar(10) — 변이 발생 위치
- GENE_B — varchar(40) — Gene 명(Symbol 값)
- GENE_B_ORI — char(1) — 유전자 발현 방향
- READ_B — int(11)
- READ_B_CNT — int(11)
- READ_B_COVER — int(11)
- READ_B_POS — varchar(50)
- CHR_B — varchar(10) — 염색체
- BREAKPOINT_B — varchar(10) — 변이 발생 위치
- TOTAL_DISCORDANT_READ_CNT — int(11)
- CHR_POS — varchar(255) — 변이가 발생한 두 염색체의 위치정보 (콤마구분자)
- DIRECTION — varchar(50) — fusion이 발생한 유전자 방향
- KNOWN — varchar(10)
- IS_REAL_FUSION — varchar(500)
- TOTAL_SPLIT_READ_CNT — int(11)
- VAR_TYPE — varchar(20)
- EVENT — varchar(50)
- FRAME — varchar(20)
- IGV_IMAGE — varchar(500) — 사용 안 함
- GENE_A_IGV_IMAGE — varchar(500) — 사용 안 함
- GENE_B_IGV_IMAGE — varchar(500) — 사용 안 함
- PLOT_IMAGE — varchar(500) — fusion plot image path
- OKB_VARIANT_ID — varchar(100) — SV final에서 Variant key와 조인하는 key 컬럼 값.
- OKB_ENTREZ_ID — int(10) — 사용 안 할 예정
- OKB_ISOFORM — varchar(20) — 사용 안 할 예정
- OKB_REF_SEQ — varchar(20) — 사용 안 할 예정
- OKB_HUGO_SYMBOL — varchar(20) — 사용 안 할 예정
- OKB_ALTERATION — varchar(150) — 사용 안 할 예정
- OKB_PROTEIN_CHANGE — varchar(150) — 사용 안 할 예정
- OKB_ONCOGENICITY — varchar(150) — 사용 안 할 예정
- OKB_MUTATION_EFFECT — varchar(150) — 사용 안 할 예정
- OKB_PMIDS_MUT_EFFECT — varchar(255) — 사용 안 할 예정
- OKB_ABSTRACTS_MUT_EFFECT — varchar(255) — 사용 안 할 예정
- OKB_DRUG_ID — varchar(20) — 사용 안 할 예정
- OKB_DRUGS — varchar(255) — 사용 안 할 예정
- OKB_SENSITIVITY — varchar(30) — 사용 안 할 예정
- OKB_CANCER_TYPE_ID — varchar(20) — 사용 안 할 예정
- OKB_CANCER_TYPE — varchar(255) — 사용 안 할 예정
- OKB_LEVEL — varchar(10) — 사용 안 할 예정
- OKB_PMIDS_DRUG — varchar(255) — 사용 안 할 예정
- OKB_ABSTRACTS_DRUG — varchar(255) — 사용 안 할 예정
- CLV_CLIN_SIG — varchar(60)
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
- CALL — char(1) — LS 분석결과 WBC 여부 판단용
- … +4
gc_alter_sv_confirm_hist
- SEQ — int(10) — Primary key — NOT NULL — SEQ
- CONFIRM_SEQ — int(10) — Primary key — NOT NULL — gc_sample_confirm_hist.seq
- IDX — int(11) — NOT NULL
- SAMPLE_ID — varchar(30) — 샘플 아이디
- CONFIRM_YN — varchar(1) — confirm 여부 (Y/N)
- TIER — varchar(10) — Pipeline에서 생성된 티어
- DISPLAY_TIER — varchar(10) — Display 티어(수정한)
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_alter_tmb
- SEQ — int(11) — Primary key — NOT NULL
- SAMPLE_ID — varchar(30) — NOT NULL
- IDX — int(11)
- TIER — varchar(5)
- DISPLAY_TIER — varchar(5)
- OKB_ADJUSTED_LEVEL — varchar(10) — OncoKB 적용 레벨
- STATUS — varchar(10) — TMB-H or TMB-L
- TMB — varchar(10)
- VARIANT_ID — varchar(100) — 삭제예정. filtered 된 variant정보는 변이테이블에 추가
- OKB_ONCOGENICITY — varchar(20) — OncoKB Oncogenicity
- OKB_DRUG_ID — varchar(30) — OncoKB Drug ID
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_anal_capa
- CLI_CD — varchar(15) — Primary key — NOT NULL
- CLI_NM — varchar(50)
- ANAL_CAPA — int(10)
gc_anal_log
- SAMPLE_ID — varchar(50) — Primary key — NOT NULL
- TID — datetime — Primary key — NOT NULL — time id (생성시간)
- MODULE_CD — varchar(50) — Primary key — NOT NULL — pipeline module code
- MODULE_STATUS_CD — varchar(50) — Primary key — NOT NULL — status code (start, errror, complete)
- ERR_MSG — text — error message
- IDX — int(11)
gc_auth_mst
- AUTH_ID — varchar(20)
- AUTH_NAME — varchar(20)
- SYSTEM_ID — varchar(20)
- SORT_ORDER — int(11)
- USE_YN — char(1)
- CREATE_DATE — datetime
- CREATE_USER — varchar(100)
- LAST_UPDATE_DATE — datetime
- LAST_UPDATE_USER — varchar(100)
gc_cnv_frequency
- SYMBOL — varchar(30) — Primary key — NOT NULL — 유전자
- DIAGNOSIS_ID — varchar(255) — Primary key — NOT NULL — oncoKB Cancer ID
- TAG — varchar(30) — Primary key — NOT NULL
- COPY_STATUS — varchar(15) — Primary key — NOT NULL — COPY NUMBER VARIANT 상태 (AMP/DEL)
- DETECT_CASE_CNT — int(11) — 발견된 케이스 수
- TOTAL_CASE_CNT — int(11) — 총 케이스 수
- CREATE_DATE — date — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_cnv_frequency_hist
- CREATE_DATE — date — Primary key — NOT NULL — 생성일
- SYMBOL — varchar(30) — Primary key — NOT NULL — 유전자
- DIAGNOSIS_ID — varchar(255) — Primary key — NOT NULL — oncoKB Cancer ID
- COPY_STATUS — varchar(15) — Primary key — NOT NULL — COPY NUMBER VARIANT 상태 (AMP/DEL)
- TAG — varchar(30) — Primary key — NOT NULL
- DETECT_CASE_CNT — int(11) — 발견된 케이스 수
- TOTAL_CASE_CNT — int(11) — 총 케이스 수
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_diagnosis_mst
- DIAGNOSIS_ID — varchar(20) — Primary key — NOT NULL — BD 진단 ID
- DIAGNOSIS_NAME — varchar(500) — BD 진단명
- ICD10_2016 — varchar(20)
- BD_ICD10 — varchar(20)
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_diagnosis_okb_mst
- DIAGNOSIS_OKB_ID — varchar(20) — Primary key — NOT NULL — geninub ID
- DIAGNOSIS_OKB_NAME — varchar(500) — OKB 진단명
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_drug_mst
- DRUG_ID — varchar(20) — Primary key — NOT NULL — Drug ID
- INGREDIENT — varchar(100) — Ingredient
- DRUG_NAME — varchar(255) — 이름
- MANUFACTURER — varchar(255) — Manufacturer
- SELLER — varchar(255) — Seller
- EFFICACY — mediumtext — Efficacy_classification
- TARGET — varchar(255) — Target
- FDA — mediumtext — FDA Labeled indication
- NOTE — mediumtext — Note
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_dx_okb_ct_mapping
- DIAGNOSIS_ID — varchar(20) — Primary key — NOT NULL — BD 진단 ID
- CANCER_TYPE_ID — varchar(255) — Primary key — NOT NULL — OKB CANCER TYPE ID
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_eval_lvl_to_tier
- EVAL_LEVEL — varchar(10) — Primary key — NOT NULL
- TIER — varchar(10) — Primary key — NOT NULL
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_frequency_mst
- SEQ — int(11) — Primary key — NOT NULL — ID(순번)
- SYMBOL — varchar(10) — 유전자
- AA — varchar(30) — 이름
- DIAGNOSIS_ID — varchar(20) — Manufacturer
- FREQUENCY — varchar(10) — Seller
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_gene_mst
- SYMBOL — varchar(20) — Primary key — NOT NULL
- CHROM — varchar(20)
- HG19_START — varchar(20)
- HG19_END — varchar(20)
- ENSEMBL_SYMBOL — varchar(20)
- ENSEMBL_ID — varchar(30)
- ENTREZ_ACCESSION — varchar(20)
- ENTREZ_ID — varchar(20)
- HUGO_SYMBOL — varchar(20)
- HUGO_ID — varchar(20)
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_history_log
- SAMPLE_ID — varchar(50) — Primary key — NOT NULL — 샘플 아이디
- IDX — int(10) — Primary key — NOT NULL — 인덱스
- DIAGNOSIS_ID — varchar(20) — OncoKB ID
- DIAGNOSIS_NAME — varchar(100) — OncoKB 진단명
- RECEIPT_DIAGNOSIS — varchar(200) — 환자 진단명
- ANAL_STATUS — varchar(10) — progress step (cm_lookup.group_id = 'ST001')
- SAVE_YN — char(1) — confirm여부
- REPORT_CREATE_YN — char(1) — report 생성 여부
- REPORT_DATE — datetime — report 생성 날짜
- COMM — text — 재분석 사유
- REPORT_COMM — text — report 생성자가 report에 남기고 싶은 코멘트
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
- SEND_YN — varchar(1) — NOT NULL
- REPORT_URL — varchar(255) — 레포트경로
- REPORT_CREATE_DATE — datetime — 레포트 생성 일시
gc_index_mst
- INDEX_ID — varchar(10) — Primary key — NOT NULL — Index ID
- LIBRARY_KIT — varchar(20) — Primary key — NOT NULL — Library Kit
- INDEX_SEQUENCE — varchar(20) — Index Sequence
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_log_detail
- SEQ — int(11) — Primary key — NOT NULL
- SAMPLE_ID — varchar(30) — Sample ID
- CLASS_1 — varchar(50) — 로그분류1
- CLASS_2 — varchar(50) — 로그분류2
- VALUE — varchar(1000) — 로그 값
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_msi_frequency
- DIAGNOSIS_ID — varchar(255) — Primary key — NOT NULL — oncoKB Cancer ID
- TAG — varchar(20) — Primary key — NOT NULL
- DETECT_CASE_CNT — int(11) — 발견된 케이스 수
- TOTAL_CASE_CNT — int(11) — 총 케이스 수
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_okb_cancer_type_mst
- CANCER_TYPE_ID — varchar(20) — Primary key — NOT NULL — CANCER TYPE ID
- CANCER_TYPE — varchar(255) — Level-associated cancer type
- ALL_TUMORS_YN — char(1) — ALL TUMORS 여부
- ALL_SOLID_TUMORS_YN — char(1) — ALL SOLID TUMORS 여부
- CNS_CANCER_YN — char(1) — CNS CANCER 여부
- CREATE_DATE — datetime — created date
- CREATE_USER — varchar(100) — created user name
- LAST_UPDATE_DATE — datetime — modified date
- LAST_UPDATE_USER — varchar(100) — modified user name
- LAST_LEAF_YN — varchar(1) — LAST_LEAF_YN
gc_okb_drug_mst
- OKB_DRUG_ID — varchar(30) — Primary key — NOT NULL — drug code
- OKB_DRUG_NAME — varchar(2000) — drug names
- CANCER_TYPE_ID — varchar(20) — okb id
- CANCER_TYPE — varchar(255) — cancer name
- LEVEL — varchar(5) — leve
- FDA_LEVEL — varchar(20) — fda leve
- PMIDS_DRUG — varchar(2000) — pmids
- ABSTRACTS_DRUG — varchar(2000) — abstract drug
- SENSITIVITY — varchar(30) — sensitivity
gc_okb_pmid_apa
- OKB_PMID — varchar(15) — Primary key — NOT NULL — PMID
- APA — text — PMID Description
gc_okb_var_drug_mapping
- VARIANT_ID — varchar(200) — Primary key — NOT NULL — VARIANT_ID
- OKB_DRUG_ID — varchar(20) — Primary key — NOT NULL — OKB_DRUG_ID
- DEL_YN — varchar(1) — DEL_YN
- OKB_SENSITIVITY — varchar(100) — OKB_SENSITIVITY
- DEL_DT — date — DEL_DT
- CREATE_DT — datetime — CREATE_DT
- CREATE_USER — varchar(100) — CREATE_USER
- LAST_UPDATE_DT — datetime — LAST_UPDATE_DT
- LAST_UPDATE_USER — varchar(100) — LAST_UPDATE_USER
- CREATE_DATE — datetime — CREATE_DATE
- LAST_UPDATE_DATE — datetime — LAST_UPDATE_DATE
gc_okb_variant
- VARIANT_ID — varchar(100) — Primary key — NOT NULL — Variant 키
- VARIANT_GROUP_ID — varchar(20)
- VARIANT_SUB_GROUP_ID — varchar(20)
- ISOFORM — varchar(50)
- REF_SEQ_ORI — varchar(50)
- REF_SEQ — varchar(50)
- ENTREZ_ID — varchar(20)
- HUGO_SYMBOL — varchar(20)
- ALTERATION — varchar(150)
- PROTEIN_CHANGE — varchar(150)
- ONCOGENICITY — varchar(150)
- MUTATION_EFFECT — varchar(150)
- PMIDS_MUT_EFFECT — varchar(255)
- ABSTRACTS_MUT_EFFECT — varchar(255)
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_panel_gene_mst
- PANEL_CODE — varchar(20) — Primary key — NOT NULL — Panel Code
- PANEL_VERSION — varchar(10) — Primary key — NOT NULL — Version 정보
- SYMBOL — varchar(20) — Primary key — NOT NULL
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_panel_mst
- PANEL_VER_ID — varchar(20) — Primary key — NOT NULL — Panel ID
- PANEL_DESIGN_NO — varchar(50) — Panel Degign Number
- MANUFACTURER_ID — varchar(20) — 제조사 Code
- PANEL_NM — varchar(100)
- PANEL_ID — varchar(20) — Panel Code
- PANEL_VERSION — varchar(10) — Version 정보
- USE_YN — varchar(1)
- DATA_OUTPUT — float
- PANEL_TARGET — int(11)
- PANEL_TARGET_SIZE — int(11) — 패널 타겟 영역 (bp)
- PANEL_PROBE_NO — int(11) — 패널 프로브 개수
- PANEL_PROBE_SIZE — int(11) — 패널 프로브 영역 (bp)
- PANEL_REF_GENOME — varchar(20) — 패널디자인에 사용된 reference genome version
- PANEL_MANUFACTURER — varchar(30) — 패널 제조사
- PANEL_DESIGNED_BY — varchar(20) — 패널 디자인 주체
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_process_log
- SEQ — int(11) — Primary key — NOT NULL
- SAMPLE_ID — varchar(30) — Sample ID
- CLASS_1 — varchar(50) — 로그분류1
- CLASS_2 — varchar(50) — 로그분류2
- VALUE — varchar(1000) — 로그 값
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_project
- SAMPLE_ID — varchar(30) — Primary key — NOT NULL — 샘플 아이디
- PATIENT_NO — varchar(50) — Primary key — NOT NULL — 환자번호
- ACCEPT_DATE — date — 접수일
- PATIENT_NAME — varchar(255) — 환자명
- GENDER — char(1) — 성별
- AGE — varchar(20) — 나이
- SAMPLING_DATE — datetime — 검체체취일
- PI_ID — varchar(20)
- PI_NAME — varchar(100) — principal investigator name
- REF_PATH_NO — varchar(50) — 병리번호
- BLOCK_NO — varchar(10)
- PATH_DIAGNOSIS_DATE — datetime — 진단일
- OCCURRED_ORGAN — mediumtext — 발병 기관
- PATH_DIAGNOSIS_ID — varchar(20) — 환자 진단명 id
- SLCE_SZ — varchar(100)
- PURITY — varchar(100)
- EXTG_OCUR_CNCR_YN — char(1)
- AOM_MTHD_CNTE — varchar(100)
- TYPE_EXTRACTED — varchar(100) — DNA or RNA
- FIXED_STATE — mediumtext — FFPE or Fresh Tissue
- NGS_PANEL_NAME — mediumtext
- ETC_CNTE — varchar(100)
- EXAM_CODE — varchar(20)
- EXAM_ORG_CENTER — varchar(100) — 분석의뢰기관명
- EXAM_ORG_CENTER_CODE — varchar(20) — 분석의뢰기관명 (코드값)
- RCPR_SYM — varchar(20)
- ACCEPT_NO — varchar(10)
- MYUNGILRYUN — varchar(50)
- BIRTH_DATE — varchar(50) — 생일
- REF_PATH_NO_ACCEPT_DATE — date
- NGS_ORDER_DATE — datetime
- PBSO_DEPT_CODE — varchar(20)
- PATH_NO — varchar(50) — SPECIMEN ID
- PATH_NAME — varchar(100) — SPECIMEN NAME
- REQ_STAFF_NO — varchar(50) — 접수자코드
- REQ_STAFF_NAME — mediumtext — 접수자명
- SPCM_TP_CODE — mediumtext
- AGREE_YN — char(1) — 동의여부
- NGS_RECEIVE_DATE — datetime
- SPECIMEN_MADE_DATE — datetime — 검체 채취 일
- NGS_COMPLETE_DATE — datetime — NGS sequencing 완료일
- NGS_RESULT_DATE — datetime — NGS 분석 완료일
- NGS_FINAL_INPUT_DATE — datetime
- NGS_INTERPRET_DATE — datetime
- ORD_INSPECT_STAFF_NAME — varchar(50) — 검사자명
- PTHL_TSS_SZ_CODE — varchar(2)
- SPECIMEN_REGION — mediumtext — 검체명
- DIAGNOSIS_ID — varchar(20) — OncoKB ID
- DIAGNOSIS_NAME — mediumtext — OncoKB 진단명
- RECEIPT_DIAGNOSIS — mediumtext — 환자 진단명
- TUMOR_FRACTION — mediumtext
- DIAGNOSIS_ETC — mediumtext
- SKNS_CTG_CODE — varchar(20)
- SKNS_CTG_NAME — mediumtext
- PANEL_VER_ID — varchar(20) — GENINUS panel id (코드값)
- STAGE_CANCER — varchar(5)
- SURGERY_ORGAN — mediumtext
- PRJ_TYPE — varchar(5) — 서비스 종류 (코드값)
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- … +15
gc_project_sample_map
- SAMPLE_ID — varchar(30) — Primary key — NOT NULL
- PATIENT_NO — varchar(30)
- SAMPLE_TYPE — varchar(20)
- Sample_Tag — varchar(30) — PROJECT NAME or DIR NAME in local
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- PATH_R1 — varchar(200)
- PATH_R2 — varchar(200)
- PATH_IDX — varchar(200)
- PATH_BAM — varchar(200)
- PATH_CLOUD — varchar(200) — BAM file location in AWS cloud
- REF_PATH_NO — varchar(200)
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
gc_qc_bi
- SAMPLE_ID — varchar(50) — Primary key — NOT NULL — 샘플 아이디
- IDX — int(10) — Primary key — NOT NULL — 인덱스
- FASTQ_TOTAL_READ — int(10) — FASTQ Total read
- FASTQ_GC_CONTENTS — varchar(10) — FASTQ GC contents
- FASTQ_Q30 — varchar(10) — FASTQ Q30
- FASTQ_OVERALL — varchar(10) — FASTQ Overall quality
- FASTQ_TOTAL_READ_R1 — int(10) — R1: FASTQ Total read
- FASTQ_GC_CONTENTS_R1 — varchar(10) — R1: FASTQ GC contents
- FASTQ_OVERALL_R1 — varchar(10) — R1: FASTQ Overall quality
- FASTQ_Q30_R1 — varchar(10) — R1: FASTQ Q30
- FASTQ_TOTAL_READ_R2 — int(10) — R2: FASTQ Overall quality
- FASTQ_GC_CONTENTS_R2 — varchar(10) — R2: FASTQ GC contents
- FASTQ_OVERALL_R2 — varchar(10) — R2: FASTQ Overall quality
- FASTQ_Q30_R2 — varchar(10) — R2: FASTQ Q30
- BAM_MEAN_DEPTH — varchar(10) — BAM Mean depth
- BAM_MEAN_DEPTH_TARGET — varchar(10)
- BAM_CAPTURE_EFFICIENCY — varchar(100) — on target > 100x rate
- BAM_ON_TARGET_RATE — varchar(10) — BAM capture efficiency
- BAM_DUP_RATE — varchar(10) — BAM Dup rate
- BAM_PR_SCORE — varchar(10) — BAM PR score
- BAM_UNIFORM — varchar(10) — BAM Uniformity
- BAM_TUMOR_VOL — varchar(10) — BAM Tumor Vol
- BAM_OVERALL_QUALITY — varchar(10) — BAM Overall quality
- BAM_GENDER_ESTIMATED — varchar(10) — BAM Gender estimated
- ANAL_PF_QC — varchar(5) — BI QC fail 여부 (FAIL/null)
- ANAL_PF_COMM — varchar(100) — BI QC fail 사유
- CREATE_DATE — datetime — 생성일
- LAST_UPDATE_DATE — datetime — 갱신일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_USER — varchar(100) — 갱신자
- MEDIAN_EXON_COVERAGE — varchar(100) — median exon coverage
- PCT_TARGET_04X_MEAN — varchar(100) — Pct target 0.4x mean
- ALIGN_RATE — varchar(10)
- UNIQUE_READ — varchar(10)
- UNIQUE_MEAN_DEPTH — varchar(10)
- BAM_MEAN_INSERT_SIZE — varchar(10)
- BAM_CHIMERIC_READS — varchar(10) — % of chimeric reads per total number of mapped unique reads
- COEF — varchar(10)
- BAM_MAPPED_READS_PERCENT — varchar(10)
- BAM_UNIQUE_MAPPED_READS_PERCENT — varchar(10)
- BAM_UNMAPPED_READS_PERCENT — varchar(10)
- BAM_CHIMERIC_READS_PERCENT — varchar(10)
- BAM_DUPLICATE_READS_PERCENT — varchar(10)
- DEPTH_OF_COVERAGE — varchar(10)
- VCF_DBSNP — varchar(10)
- VCF_NONSYN_SYN — varchar(10)
- VCF_TI_TV — varchar(10)
- BAM_COVERAGE_100X — varchar(10)
- BAM_MULTIMAPPED_READS_PERCENT — varchar(10)
gc_qc_bi_ewes
- SAMPLE_ID — varchar(50) — Primary key — NOT NULL — 샘플 아이디
- IDX — int(10) — Primary key — NOT NULL — 인덱스
- FASTQ_TOTAL_READ_BEFORE — int(10) — Before: FASTQ Total read
- FASTQ_GC_CONTENTS_BEFORE — varchar(10) — Before: FASTQ GC contents
- FASTQ_OVERALL_BEFORE — varchar(10) — Before: FASTQ Overall quality
- FASTQ_Q30_BEFORE — varchar(10) — Before: FASTQ Q30
- FASTQ_TOTAL_READ_AFTER — int(10) — After: FASTQ Overall quality
- FASTQ_GC_CONTENTS_AFTER — varchar(10) — After: FASTQ GC contents
- FASTQ_OVERALL_AFTER — varchar(10) — After: FASTQ Overall quality
- FASTQ_Q30_AFTER — varchar(10) — After: FASTQ Q30
- BAM_TARGET_MEAN_DEPTH — varchar(10) — BAM Target Mean depth
- BAM_TARGET_CAPTURE_EFFICIENCY — varchar(100) — BAM Target on target > 100x rate
- BAM_TARGET_ON_TARGET_RATE — varchar(10) — BAM Target capture efficiency
- BAM_TARGET_DUP_RATE — varchar(10) — BAM Target Dup rate
- BAM_TARGET_PR_SCORE — varchar(10) — BAM Target PR score
- BAM_TARGET_UNIFORM — varchar(30) — BAM Target Uniformity
- BAM_TARGET_TUMOR_VOL — varchar(10) — BAM Target Tumor Vol
- BAM_TARGET_OVERALL_QUALITY — varchar(10) — BAM Target Overall quality
- BAM_TARGET_GENDER_ESTIMATED — varchar(10) — BAM Target Gender estimated
- VCF_TARGET_DBSNP — varchar(10) — VCF TARGET DBSNP
- VCF_TARGET_NONSYN_SYN — varchar(10) — VCF TARGET NONSYN_SYN
- VCF_TARGET_TI_TV — varchar(10) — VCF TARGET TI_TV
- BAM_EXOME_MEAN_DEPTH — varchar(10) — BAM ExomeMean depth
- BAM_EXOME_CAPTURE_EFFICIENCY — varchar(100) — BAM Exome on target > 100x rate
- BAM_EXOME_ON_TARGET_RATE — varchar(10) — BAM Exome capture efficiency
- BAM_EXOME_DUP_RATE — varchar(10) — BAM Exome Dup rate
- BAM_EXOME_PR_SCORE — varchar(10) — BAM Exome PR score
- BAM_EXOME_UNIFORM — varchar(30) — BAM Exome Uniformity
- BAM_EXOME_TUMOR_VOL — varchar(10) — BAM ExomeTumor Vol
- BAM_EXOME_OVERALL_QUALITY — varchar(10) — BAM ExomeOverall quality
- BAM_EXOME_GENDER_ESTIMATED — varchar(10) — BAM Exome Gender estimated
- VCF_EXOME_DBSNP — varchar(10) — VCF EXOME DBSNP
- VCF_EXOME_NONSYN_SYN — varchar(10) — VCF EXOME NONSYN_SYN
- VCF_EXOME_TI_TV — varchar(10) — VCF EXOME TI_TV
- ANAL_PF_QC — varchar(5) — BI QC fail 여부 (FAIL/null)
- ANAL_PF_COMM — varchar(100) — BI QC fail 사유
- CREATE_DATE — datetime — 생성일
- LAST_UPDATE_DATE — datetime — 갱신일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_USER — varchar(100) — 갱신자
- DEPTH_OF_COVERAGE — varchar(10)
gc_qc_next
- SEQ — int(11) — Primary key — NOT NULL — 순번
- DIR_NAME — varchar(50) — 배치 런 결과 디렉토리명
- FC_ID — varchar(50) — Flow Cell ID
- CVRT_STATUS — varchar(50) — status of converting bcl to fastq
- ANAL_COMPLETE — varchar(100) — 배치 샘플 전체 분석완료 여부
- RTA_CONFIG_DATE — datetime — RTA Configuration 생성일
- RUN_COMPLETE_DATE — datetime — RunCompletionStatus 생성일
- BASECELL — char(1) — Basecell 생성여부
- SAMPLE_CREATE_DATE — datetime — Sample Sheet 생성일
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
- PRJ_TYP — varchar(10) — NOT NULL — 서비스 종류 (코드값)
gc_qc_sample
- SAMPLE_ID — varchar(30) — Primary key — NOT NULL
- TECAN_REG_DATE — datetime — Tecan 등록일
- TECAN_FILE_NAME — varchar(50) — Tecan 파일명
- DNA_UV_CONC — float — Tecan UV Conc
- DNA_NANODROP_260_230 — float — Tecan 260/230
- DNA_NANODROP_260_280 — float — Tecan 260/280
- DNA_QUBIT_CONC — float — Quantus Qubit Conc.(ng/ul)
- LIB_INPUT_AMT — float — DNA, RNA input amount(ng)
- DNA_MEDIAN_SIZE — float — Tapestation Median Size(bp)
- DNA_GRADE — varchar(30) — Grade
- TAPE_REG_DATE — datetime — Tapestation등록일
- AVG_LIB_SIZE — int(10) — Tapestation Average Library Size(bp)
- QUANTUS_REG_DATE — datetime — Quantus등록일
- PRE_QUBIT_CONC — float — Pre-PCR후 Qubit Conc.(ng/ul)
- POST_QUBIT_CONC — float — Post PCR후 Qubit Conc.(ng/ul)
- INDEX_REG_DATE — datetime — Index 등록일
- RIN_RESULT — float — RNA integrity number
- DV200 — float — 단위(%), represents the percentage of RNA fragments that are > 200 nucleotides in size.
- INDEX_ID — varchar(10) — Index wall id
- INDEX_SEQUENCE — varchar(8) — Index sequence
- INDEX1_ID — varchar(15)
- INDEX2_ID — varchar(15)
- INDEX1_SEQUENCE — varchar(15) — i7 index
- INDEX2_SEQUENCE — varchar(15) — i5 index
- FC_REG_DATE — datetime — Flow Cell ID 등록일
- FC_ID — varchar(50) — Flow Cell ID
- SEQ_EQUIP — varchar(100) — sequnecing equipment
- STATUS — char(1) — 상태
- SAVE_YN — char(1) — Save 클릭여부
- REPORT_CREATE_YN — char(1) — 레포트 생성여부
- REPORT_DATE — datetime — 리포트 날짜
- FASTQ_TOTAL_READ — int(10) — FASTQ Total read
- FASTQ_GC_CONTENTS — varchar(10) — FASTQ GC contents
- FASTQ_Q30 — varchar(10) — FASTQ Q30
- FASTQ_OVERALL — varchar(10) — FASTQ Overall quality
- FASTQ_TOTAL_READ_R1 — int(10) — FASTQ Total read
- FASTQ_GC_CONTENTS_R1 — varchar(10) — FASTQ GC contents
- FASTQ_Q30_R1 — varchar(10) — FASTQ Q30
- FASTQ_OVERALL_R1 — varchar(10) — FASTQ Overall quality
- FASTQ_TOTAL_READ_R2 — int(10) — FASTQ Total read
- FASTQ_GC_CONTENTS_R2 — varchar(10) — FASTQ GC contents
- FASTQ_Q30_R2 — varchar(10) — FASTQ Q30
- FASTQ_OVERALL_R2 — varchar(10) — FASTQ Overall quality
- BAM_MEAN_DEPTH — varchar(10) — BAM Mean depth
- BAM_CAPTURE_EFFICIENCY — varchar(10) — PCT_SELECTED_BASES
- BAM_ON_TARGET_RATE — varchar(10)
- BAM_DUP_RATE — varchar(10) — BAM Dup rate
- BAM_PR_SCORE — varchar(10) — BAM PR score
- BAM_UNIFORM — varchar(10) — BAM Uniformity
- BAM_TUMOR_VOL — varchar(10) — BAM Tumor Vol
- BAM_OVERALL_QUALITY — varchar(10) — BAM Overall quality
- BAM_GENDER_ESTIMATED — varchar(10) — BAM Gender estimated
- COEF — varchar(100)
- CREATE_DATE — datetime — 생성일
- CREATE_USER — varchar(100) — 생성자
- LAST_UPDATE_DATE — datetime — 마지막 갱신일자
- LAST_UPDATE_USER — varchar(100) — 마지막 갱신자
- ANAL_STATUS — varchar(5)
- SAMPLE_PF_QC — varchar(5)
- SAMPLE_PF_COMM — varchar(100)
- … +4
and 65 more tables