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