RareBird(20211116기준)

테이블 (126)

account

  • id — int(11) — 기본 키 — NOT NULL — auto_increament 번호( unique값)
  • email — varchar(256) — NOT NULL — 이메일 주소(입력아이디)
  • password — varchar(256) — NOT NULL — 비밀번호
  • first_name — varchar(256) — NOT NULL — 이름
  • last_name — varchar(256) — NOT NULL — 성
  • institution — varchar(256) — NOT NULL — 연구기관명
  • degree — varchar(64) — 학위입력
  • country — varchar(2) — NOT NULL — country.code
  • timezone — varchar(255) — NOT NULL — 가입한 유저 기준 시간선
  • phone — varchar(32) — 핸드폰번호
  • address — varchar(256) — 주소
  • city — varchar(256) — 시
  • state — varchar(256) — 도,특별시
  • post_code — varchar(256) — 우편번호
  • iam_a — varchar(16) — 사용x컬럼
  • general_mailing_emails — int(1) — NOT NULL — 메일 송신 서비스 사용여부 0:사용, 1:거부
  • outcome_update_emails — int(1) — NOT NULL — 데이터 갱신에 대한 서비스 사용여부 0:사용, 1:거부
  • user_type — int(11) — NOT NULL — 유저타입 가입화면에서 status해당 1:Patient/Family | 2:Researcher |3:Doctor(사용x) 4:Clinical researcher code_mst테이블 참조
  • agreements — int(1) — NOT NULL — 모르겠음
  • agreements_privacy — int(1) — NOT NULL — Privacy policy 동의 여부 1:동의 0:거부
  • agreements_terms — int(1) — NOT NULL — Terms of use 동의 여부 1:동의 0:거부
  • active — int(1) — NOT NULL — 활성화 여부 0 :비활성 1:활성
  • status — enum('REGISTERED', 'ACTIVATED', 'INACTIVATED') — NOT NULL — 상태 ATIVATED:활성화 REGISTERED 가입상태
  • medical_license — varchar(16) — 의사 라이센스 입력
  • activation_key — varchar(256) — NOT NULL — 이메일별 활성화 키 (소스상에서 urlencode 로 생성)
  • activation_until — datetime — NOT NULL — 활성화 만료일 해당 날짜까지 활성화 인증을해야함 안하면 생성x
  • created_at — datetime — NOT NULL — 생성일자
  • updated_at — timestamp — NOT NULL — 갱신일자
  • created_by — varchar(256) — NOT NULL — 생성자
  • updated_by — varchar(256) — NOT NULL — 갱신한 사람
  • by_admin_id — varchar(256) — NOT NULL — 관리자 id

account_role

  • role_id — int(10) — 기본 키 — NOT NULL — role_mst에 있는 role_id
  • account_id — int(10) — 기본 키 — NOT NULL — 계정 ID
  • del_yn — varchar(1) — NOT NULL — 삭제여부
  • created_at — timestamp — NOT NULL — 생성일자
  • created_by — int(10) — 생성한 계정 id(account테이블참조)
  • updated_at — timestamp — NOT NULL — 갱신일자
  • updated_by — int(10) — 데이터 변경한 계정 id(account테이블참조)

admin_account

  • id — int(11) — 기본 키 — NOT NULL
  • email — varchar(256) — NOT NULL
  • password — varchar(256) — NOT NULL
  • first_name — varchar(256) — NOT NULL
  • last_name — varchar(256) — NOT NULL
  • active — int(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

assembly_mst

  • id — int(11) — 기본 키 — NOT NULL — 고유 unique값
  • chr — varchar(20) — NOT NULL — Chromosome(염색체 번호)
  • length — int(11) — NOT NULL — Chromosome lengths(염색체 길이)
  • version — enum('GRCh37', 'GRCh38') — NOT NULL — 표준게놈 버전
  • sort — int(11) — NOT NULL — 모름

code_mst

  • id — int(11) — 기본 키 — NOT NULL
  • div_1 — varchar(64) — NOT NULL — key to select
  • div_2 — varchar(64) — key to select
  • div_3 — varchar(64) — key to select
  • div_4 — varchar(64) — key to select
  • div_5 — varchar(64) — key to select
  • value — int(11) — html tag value
  • sort — int(11) — html tag value
  • active — int(1) — NOT NULL — 1:active, 0:unactive
  • lang_key — varchar(128) — html text to show
  • text — varchar(128) — html text to show
  • comment — text

comm_code_mst

  • comm_code_type — varchar(32) — 기본 키 — NOT NULL — 어디에 사용하는건지 code 대분류 값 E-O:환자나이 해당하는 선택지부분
  • comm_code — varchar(32) — 기본 키 — NOT NULL
  • comm_code_nm — varchar(128) — NOT NULL
  • comm_code_desc — text
  • ord_no — int(10)
  • del_yn — varchar(1) — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — int(10) — NOT NULL
  • updated_at — timestamp — NOT NULL
  • updated_by — int(10)

community_board

  • id — int(11) — 기본 키 — NOT NULL
  • subject — varchar(255) — NOT NULL
  • content — text
  • hit — int(10) — NOT NULL
  • active — int(1) — NOT NULL
  • admin_id — int(11) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

community_comment

  • id — int(11) — 기본 키 — NOT NULL
  • community_board_id — varchar(255) — NOT NULL
  • content — text
  • active — int(1) — NOT NULL
  • admin_id — int(11) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL
  • id (id2) — int(11) — 외래 키 → community_board.id — NOT NULL

country

  • id — int(10) — 기본 키 — NOT NULL
  • code — char(2) — NOT NULL — 코드(2자)
  • alpha_3 — char(3) — NOT NULL — 코드(3자)
  • numeric — char(3) — NOT NULL — 국가 넘버
  • name — varchar(64) — 국가명
  • official_name — varchar(128) — 국가명(정식명칭이 있는경우)
  • display_order — int(10)
  • description — varchar(255) — 국가명(영어)

dataset_dul

  • dataset_type — varchar(1) — 기본 키 — NOT NULL — eCRF:E, MME:M, Functional study: F
  • dataset_id — int(11) — 기본 키 — NOT NULL — ecrfid가 될수도 있고 mme id가 될수도 있음
  • duo_id — varchar(11) — 기본 키 — NOT NULL — duo id
  • modifier — varchar(45) — 상세값
  • del_yn — varchar(1) — NOT NULL — 삭제여부
  • created_at — datetime — NOT NULL — 생성일자
  • updated_at — timestamp — NOT NULL — 수정일자
  • created_by — varchar(256) — NOT NULL — 생성자
  • updated_by — varchar(256) — NOT NULL — 수정자

dataset_perm

  • dataset_type — varchar(64) — 기본 키 — NOT NULL — E: eCRF, M: MME, F: Functional study
  • dataset_id — int(10) — 기본 키 — NOT NULL
  • role_id — int(10) — 기본 키 — NOT NULL
  • account_id — int(10) — 기본 키 — NOT NULL
  • perm — varchar(4)
  • del_yn — varchar(1) — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — int(10)
  • updated_at — timestamp — NOT NULL
  • updated_by — int(10)

duo_addinfo

  • category_id — int(11) — 기본 키 — NOT NULL — 카테고리 ID
  • duo_code — varchar(50) — 기본 키 — NOT NULL — DUO 코드
  • no — int(11) — 기본 키 — NOT NULL — 순번
  • category_type — varchar(50) — NOT NULL — category_type
  • text — varchar(200) — 입력값
  • param1 — varchar(200) — 비고1
  • param2 — varchar(200) — 비고2
  • param3 — varchar(200) — 비고3
  • created_at — datetime
  • updated_at — timestamp
  • created_by — int(11)
  • updated_by — int(11)

duo_category_tag

  • category_id — int(11) — NOT NULL — 각 카테고리별 ID
  • category_type — varchar(50) — NOT NULL — ecrf, mme, gv, fr
  • duo_code — varchar(50) — NOT NULL
  • tag_id — int(11) — NOT NULL
  • category_id (category_id2) — int(11) — 외래 키 → duo_main.category_id — NOT NULL — 각 카테고리별 ID

duo_main

  • category_id — int(11) — 기본 키 — NOT NULL — 각 카테고리별 ID
  • category_type — varchar(50) — 기본 키 — NOT NULL — ecrf, mme, gv, fr
  • duo_code — varchar(50) — 기본 키 — NOT NULL
  • text — varchar(200) — 입력값
  • use_yn — varchar(2) — 사용여부
  • share_limit_sd — date — 데이터 공유시작일
  • share_limit_ed — date — 데이터 공유마감일
  • share_user_tbkey — varchar(50) — 데이터 공유 유저 테이블 key값
  • created_at — datetime
  • updated_at — timestamp
  • created_by — int(11)
  • updated_by — int(11)
  • mme_id — int(11) — 외래 키 — NOT NULL
  • fr_id — int(11) — 외래 키 — NOT NULL — 유니크 ID
  • gv_id — int(11) — 외래 키 — NOT NULL — dd
  • id (id2) — int(11) — 외래 키 → ecrf.id — NOT NULL — ecrf아이디 사실상 db상에서 가장 unique한 단위

duo_mst

  • id — varchar(11)
  • shorthand — varchar(16)
  • label — varchar(128)
  • description — text

duo_shared_users

  • category_id — int(11) — 기본 키 — NOT NULL — 각 공유 카테고리별 ID
  • category_type — varchar(50) — 기본 키 — NOT NULL — ecrf, mme, gv, fr
  • shared_id — int(11) — 기본 키 — NOT NULL — 공유받은 유저 ID
  • from_id — int(11) — NOT NULL — 공유자 유저 ID
  • share_limit_sd — date — 데이터 공유시작일
  • share_limit_ed — date — 데이터 공유마감일
  • created_at — date
  • updated_at — timestamp
  • created_by — int(11)
  • updated_by — int(11)
  • category_id (category_id2) — int(11) — 외래 키 → duo_main.category_id — NOT NULL — 각 카테고리별 ID
  • category_type (category_type2) — varchar(50) — 외래 키 → duo_main.category_type — NOT NULL — ecrf, mme, gv, fr
  • duo_code — varchar(50) — 외래 키 → duo_main.duo_code — NOT NULL

duo_tag

  • tag_id — int(11) — 기본 키 — NOT NULL — 태그 ID
  • tag_name — varchar(50) — 태그명

ecrf

  • id — int(11) — 기본 키 — NOT NULL — ecrf아이디 사실상 db상에서 가장 unique한 단위
  • usr_id — int(11) — NOT NULL — 데이터 소유자
  • rarebird_id — int(11) — NOT NULL — 레어버드 아이디
  • enc_ecrf_id — int(11) — NOT NULL
  • ecrf_name — varchar(128)
  • ecrf_description — text — NOT NULL
  • active — int(1) — NOT NULL — (맴버에게 공개여부)0: inactive, 1: active
  • add_to_match — int(1) — NOT NULL — (매치박스에 등록 여부)0: inactive, 1: active
  • account_id — int(11)
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — int(11) — NOT NULL
  • updated_by — int(11) — NOT NULL
  • id (id2) — int(11) — 외래 키 — NOT NULL — Category ID
  • cat_type — varchar(10) — 외래 키 — NOT NULL — Category Type (ecrf, gv, fr, mme)

ecrf_basic_info

  • ecrf_id — int(11) — 기본 키 — NOT NULL — ecrf_id
  • study_number — varchar(128) — 기관검체번호
  • referral_hospital — varchar(128) — 진료병원기관
  • referred_date — date — 진료일자
  • sex — int(1) — 1:male, 2:female
  • birthday — date — 생일
  • age — int(11) — 나이
  • genetic_test_result — varchar(16) — 유전검사 결과 'Normal', 'Abnormal'
  • Not_done, — `description` — 상세
  • submission_comment — text
  • read_only — varchar(2) — NOT NULL — 읽기전용여부
  • created_at — datetime — NOT NULL — 생성일자
  • updated_at — timestamp — NOT NULL — 갱신일자
  • created_by — varchar(256) — NOT NULL — 생성자
  • updated_by — varchar(256) — NOT NULL — 수정자
  • id (id2) — int(11) — 외래 키 → ecrf.id — NOT NULL — ecrf아이디 사실상 db상에서 가장 unique한 단위

ecrf_duo

  • ecrf_id — int(11)
  • duo_id — varchar(11)
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_fam_hist

  • ecrf_id — int(10) — 기본 키 — NOT NULL
  • ecrf_file_id — int(10) — NOT NULL
  • affected_member — varchar(255)
  • family_symptom_desc — text
  • created_at — timestamp — NOT NULL
  • created_by — int(10)
  • updated_at — timestamp — NOT NULL
  • updated_by — int(10)
  • id (id2) — int(11) — 외래 키 → ecrf.id — NOT NULL — ecrf아이디 사실상 db상에서 가장 unique한 단위

ecrf_family_history

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_id — int(11) — NOT NULL — ecrfid
  • pedigree_file_path — varchar(256)
  • pedigree_file_size — int(11)
  • e02_01 — varchar(1)
  • e02_01_01 — varchar(64)
  • e02_01_01_09_others — varchar(256)
  • e03_01_textarea — text
  • e04_01_textarea — text
  • e03_01_01 — varchar(256)
  • e03_01_02 — varchar(256)
  • e04_01_01 — varchar(256)
  • e04_01_02 — varchar(256)
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_family_history_20200928

  • id — int(11) — NOT NULL
  • ecrf_id — int(11) — NOT NULL
  • pedigree_file_path — varchar(256)
  • pedigree_file_size — int(11)
  • e02_01 — varchar(1)
  • e02_01_01 — varchar(64)
  • e02_01_01_09_others — varchar(256)
  • e03_01_textarea — text
  • e04_01_textarea — text
  • e03_01_01 — varchar(256)
  • e03_01_02 — varchar(256)
  • e04_01_01 — varchar(256)
  • e04_01_02 — varchar(256)
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_family_history_20201008

  • id — int(11) — NOT NULL
  • ecrf_id — int(11) — NOT NULL
  • pedigree_file_path — varchar(256)
  • pedigree_file_size — int(11)
  • e02_01 — varchar(1)
  • e02_01_01 — varchar(64)
  • e02_01_01_09_others — varchar(256)
  • e03_01_textarea — text
  • e04_01_textarea — text
  • e03_01_01 — varchar(256)
  • e03_01_02 — varchar(256)
  • e04_01_01 — varchar(256)
  • e04_01_02 — varchar(256)
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_func_study

  • id — int(10) — 기본 키 — NOT NULL
  • ecrf_id — int(10)
  • t1_name — varchar(64) — NOT NULL — 테스트종류
  • t1_result — varchar(12) — NOT NULL — 사용x
  • t2_name — varchar(64) — 테스트 상세 종'류
  • t2_result — varchar(12) — 사용x
  • t2_date — date — 진단일자
  • t2_desc — mediumtext — 진단 결과
  • del_yn — varchar(1) — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — int(10) — NOT NULL
  • updated_at — timestamp — NOT NULL
  • updated_by — int(10)
  • id (id2) — int(11) — 외래 키 → ecrf.id — NOT NULL — ecrf아이디 사실상 db상에서 가장 unique한 단위

ecrf_functional_studies

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_id — int(11) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_functional_studies_01

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_functional_studies_id — int(11) — 외래 키 → ecrf_functional_studies.id — NOT NULL
  • m01 — varchar(32)
  • m01_01 — varchar(32)
  • m01_01_01_details — text
  • m01_01_02_details — text
  • m01_01_03_details — text
  • m01_01_04_details — text
  • m01_01_05_details — text
  • active — int(1)
  • m01_date_dummy — varchar(32)
  • m01_01_text_dummy — text
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_functional_studies_02

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_functional_studies_id — int(11) — 외래 키 → ecrf_functional_studies.id — NOT NULL
  • m02 — varchar(32)
  • m02_01 — varchar(32)
  • m02_01_01_details — text
  • m02_01_02_details — text
  • m02_01_03_details — text
  • m02_01_04_details — text
  • m02_01_05_details — text
  • active — int(1)
  • m02_date_dummy — varchar(32)
  • m02_01_text_dummy — text
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_functional_studies_03

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_functional_studies_id — int(11) — 외래 키 → ecrf_functional_studies.id — NOT NULL
  • m03 — varchar(32)
  • m03_01 — varchar(32)
  • m03_01_01_details — text
  • m03_01_02_details — text
  • m03_01_03_details — text
  • m03_01_04_details — text
  • active — int(1)
  • m03_date_dummy — varchar(32)
  • m03_01_text_dummy — text
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_functional_studies_04

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_functional_studies_id — int(11) — 외래 키 → ecrf_functional_studies.id — NOT NULL
  • m04 — varchar(32)
  • m04_01 — varchar(32)
  • m04_01_01_details — text
  • m04_01_02_details — text
  • m04_01_03_details — text
  • m04_01_04_details — text
  • m04_01_05_details — text
  • active — int(1)
  • m04_date_dummy — varchar(32)
  • m04_01_text_dummy — text
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_functional_studies_05

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_functional_studies_id — int(11) — 외래 키 → ecrf_functional_studies.id — NOT NULL
  • m05 — varchar(32)
  • m05_01 — varchar(32)
  • m05_01_01_details — text
  • m05_01_02_details — text
  • m05_01_03_details — text
  • m05_01_04_details — text
  • active — int(1)
  • m05_date_dummy — varchar(32)
  • m05_01_text_dummy — text
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_functional_studies_06

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_functional_studies_id — int(11) — 외래 키 → ecrf_functional_studies.id — NOT NULL
  • m06 — varchar(32)
  • m06_date — varchar(32)
  • m06_01 — varchar(32)
  • m06_01_01_details — varchar(256)
  • m06_01_02_details — varchar(256)
  • active — int(1)
  • m06_01_text_dummy — text
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_functional_studies_07

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_functional_studies_id — int(11) — 외래 키 → ecrf_functional_studies.id — NOT NULL
  • m07 — varchar(32)
  • m07_01 — varchar(32)
  • m07_01_01_details — text
  • m07_01_02_details — text
  • m07_01_03_details — text
  • m07_01_04_details — text
  • m07_01_05_details — text
  • m07_01_06_details — text
  • active — int(1)
  • m07_date_dummy — varchar(32)
  • m07_01_text_dummy — text
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_gene_test

  • id — int(10) — 기본 키 — NOT NULL
  • ecrf_id — int(10)
  • t1_name — varchar(64) — NOT NULL
  • t1_result — varchar(12) — NOT NULL
  • t2_name — varchar(64)
  • t2_result — varchar(12)
  • t2_date — date
  • t2_desc — text
  • del_yn — varchar(1) — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — int(10) — NOT NULL
  • updated_at — timestamp — NOT NULL
  • updated_by — int(10)

ecrf_genetic_test

  • ecrf_id — int(11) — 기본 키 — NOT NULL
  • n01 — varchar(32) — 염색체분석 결과 (Chromosomal analysis)
  • n01_text — text — 염색체분석 결과 상세
  • n02 — varchar(32) — 염색체마이크로어레이 분석결과 (Chromosome microarray)
  • n02_text — text — 염색체마이크로어레이 분석결과 상세
  • n03 — varchar(32) — 단일세포시퀀싱 결과?(Single gene study)
  • n03_text — text — 단일세포시퀀싱 결과? 상세
  • n04 — varchar(32) — 타겟 패널 시퀀싱 결과? (Target gene panel)
  • n04_text — text — 타겟 패널 시퀀싱 결과? 상세
  • n05 — varchar(32) — Whole exome sequencing 결과
  • n05_text — text — Whole exome sequencing 결과 상세
  • n06 — varchar(32) — 미토콘드리아 분석 결과(Mitochondrial genome assay)
  • n06_text — text — 미토콘드리아 분석 상세
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL
  • id (id2) — int(11) — 외래 키 → ecrf.id — NOT NULL — ecrf아이디 사실상 db상에서 가장 unique한 단위

ecrf_genetic_test_20200913

  • id — int(11) — NOT NULL
  • ecrf_id — int(11) — NOT NULL
  • n00 — varchar(32)
  • n01 — varchar(32)
  • n01_text — text
  • n02 — varchar(32)
  • n02_text — text
  • n03 — varchar(32)
  • n03_text — text
  • n04 — varchar(32)
  • n04_text — text
  • n05 — varchar(32)
  • n05_text — text
  • n06 — varchar(32)
  • n06_text — text
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_genetic_test_old

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_id — int(11)

ecrf_imaging_01

  • id — int(11) — 기본 키 — NOT NULL
  • l01 — varchar(32)
  • l01_01 — varchar(32)
  • l01_01_01_details — text
  • l01_01_02_details — text
  • l01_01_03_details — text
  • l01_01_04_details — text
  • l01_01_05_details — text
  • l01_01_06_details — text
  • l01_date_dummy — varchar(32)
  • l01_01_text_dummy — text
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_imaging_02

  • id — int(11) — 기본 키 — NOT NULL
  • l02 — varchar(32)
  • l02_01 — varchar(32)
  • l02_01_01_details — text
  • l02_01_02_details — text
  • l02_01_03_details — text
  • l02_01_04_details — text
  • l02_date_dummy — varchar(32)
  • l02_01_text_dummy — text
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_img

  • id — int(10) — 기본 키 — NOT NULL
  • ecrf_id — int(10)
  • t1_name — varchar(64) — NOT NULL — 테스트 종류
  • t1_result — varchar(12) — NOT NULL
  • t2_name — varchar(64) — 테스트 상세종류
  • t2_result — varchar(12) — 결과(정상비정상)
  • t2_date — date — 진단일자
  • t2_desc — mediumtext — 진단상세
  • del_yn — varchar(1) — NOT NULL — 삭제여부
  • created_at — timestamp — NOT NULL — 생성일자
  • created_by — int(10) — NOT NULL — 생성자
  • updated_at — timestamp — NOT NULL — 갱신일자
  • updated_by — int(10) — 수정자
  • id (id2) — int(11) — 외래 키 → ecrf.id — NOT NULL — ecrf아이디 사실상 db상에서 가장 unique한 단위

ecrf_lab_test

  • id — int(10) — 기본 키 — NOT NULL
  • ecrf_id — int(10)
  • t1_name — varchar(64) — NOT NULL — 테스트ㅡ 종류(test category)
  • t1_result — varchar(12) — NOT NULL — 사용x
  • t2_name — varchar(64) — 증상
  • t2_result — varchar(12) — 사용x
  • t2_date — date — 진단일자
  • t2_desc — mediumtext — 상세
  • del_yn — varchar(1) — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — int(10) — NOT NULL
  • updated_at — timestamp — NOT NULL
  • updated_by — int(10)
  • id (id2) — int(11) — 외래 키 → ecrf.id — NOT NULL — ecrf아이디 사실상 db상에서 가장 unique한 단위

ecrf_laboratory_tests

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_id — int(11) — NOT NULL
  • h00 — varchar(32)
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_laboratory_tests_01

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_laboratory_tests_id — int(11) — 외래 키 → ecrf_laboratory_tests.id — NOT NULL
  • h01 — varchar(32)
  • h01_date — date
  • h01_01 — varchar(32)
  • h01_01_text_01 — text
  • h01_01_text_02 — text
  • h01_01_text_03 — text
  • h01_01_text_04 — text
  • active — int(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_laboratory_tests_02

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_laboratory_tests_id — int(11) — 외래 키 → ecrf_laboratory_tests.id — NOT NULL
  • h02 — varchar(32)
  • h02_date — date
  • h02_01 — varchar(32)
  • h02_01_text_01 — text
  • h02_01_text_02 — text
  • h02_01_text_03 — text
  • h02_01_text_04 — text
  • h02_01_text_05 — text
  • h02_01_text_06 — text
  • active — int(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_laboratory_tests_03

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_laboratory_tests_id — int(11) — 외래 키 → ecrf_laboratory_tests.id — NOT NULL
  • h03 — varchar(32)
  • h03_date — date
  • h03_01 — varchar(32)
  • h03_01_text_01 — text
  • h03_01_text_02 — text
  • active — int(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_laboratory_tests_04

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_laboratory_tests_id — int(11) — NOT NULL
  • h04 — varchar(32)
  • h04_date — date
  • h04_01_text — text
  • active — int(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_laboratory_tests_05

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_laboratory_tests_id — int(11) — NOT NULL
  • h05 — varchar(32)
  • h05_date — date
  • h05_01 — varchar(32)
  • h05_01_text_01 — text
  • h05_01_text_02 — text
  • h05_01_text_03 — text
  • h05_01_text_04 — text
  • active — int(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_laboratory_tests_06

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_laboratory_tests_id — int(11) — NOT NULL
  • h06 — varchar(32)
  • h06_date — date
  • h06_01 — varchar(32)
  • h06_01_text_01 — varchar(256)
  • h06_01_text_02 — varchar(256)
  • h06_01_text_03 — varchar(256)
  • h06_01_text_04 — varchar(256)
  • h06_01_text_05 — varchar(256)
  • h06_01_text_06 — varchar(256)
  • h06_01_text_07 — varchar(256)
  • h06_01_text_08 — varchar(256)
  • h06_01_text_09 — varchar(256)
  • h06_01_text_10 — varchar(256)
  • h06_01_text_11 — varchar(256)
  • h06_01_text_12 — varchar(256)
  • h06_01_text_13 — varchar(256)
  • active — int(1) — NOT NULL
  • h06_01_12_details_01_dummy — varchar(256)
  • h06_01_12_details_02_dummy — varchar(256)
  • h06_01_12_details_03_dummy — varchar(256)
  • h06_01_13_details_01_dummy — varchar(256)
  • h06_01_13_details_02_dummy — varchar(256)
  • h06_01_13_details_03_dummy — varchar(256)
  • h06_01_text_dummy — text
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_laboratory_tests_07

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_laboratory_tests_id — int(11) — NOT NULL
  • h07 — varchar(32)
  • h07_date — date
  • h07_01_text — text
  • active — int(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_laboratory_tests_08

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_laboratory_tests_id — int(11) — NOT NULL
  • h08 — varchar(32)
  • h08_01 — varchar(32)
  • h08_date — date
  • h08_01_text_01 — text
  • h08_01_text_02 — text
  • h08_01_text_03 — text
  • active — int(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_laboratory_tests_08_dummy

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_laboratory_tests_id — int(11) — NOT NULL
  • h08 — varchar(32)
  • h08_date — date
  • h08_01_text — text
  • active — int(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_laboratory_tests_09

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_laboratory_tests_id — int(11) — NOT NULL
  • h09 — varchar(32)
  • h09_date — date
  • h09_01_text — text
  • active — int(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_laboratory_tests_10

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_laboratory_tests_id — int(11) — NOT NULL
  • h10 — varchar(32)
  • h10_01_text — text
  • active — int(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_measure

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_id — int(10) — NOT NULL — ecrf_id
  • measure_date — date — NOT NULL — 측정날짜
  • height — decimal(5, 2) — 신장
  • weight — decimal(5, 2) — 무게
  • hc — decimal(5, 2) — head circumference 머리둘레
  • del_yn — varchar(1) — NOT NULL
  • created_at — datetime
  • updated_at — timestamp — NOT NULL
  • created_by — int(10)
  • updated_by — int(10)
  • id (id2) — int(11) — 외래 키 → ecrf.id — NOT NULL — ecrf아이디 사실상 db상에서 가장 unique한 단위

ecrf_medical_history

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_id — int(11) — 기본 키 — NOT NULL
  • board_uid — varchar(50) — 기본 키 — NOT NULL — 입력순서
  • medical_type — varchar(128) — Other, Vaccination, Development, Medication, Allergies, Surgeries
  • medical_type_dtl — varchar(128) — 작성한 병명
  • medical_status — varchar(128) — 발병 상태(Ongoing:진행중,Resolve:완치) 혹은 약명 등 각 type별로 다름
  • medical_onset_y — varchar(50) — 발병년도
  • medical_onset_m — varchar(50) — 발생시기
  • past_date — date — 과거 일자
  • medical_desc — mediumtext — Remark
  • del_yn — varchar(1) — NOT NULL
  • created_at — datetime
  • updated_at — timestamp — NOT NULL
  • created_by — int(11)
  • updated_by — int(11)
  • id (id2) — int(11) — 외래 키 → ecrf.id — NOT NULL — ecrf아이디 사실상 db상에서 가장 unique한 단위

ecrf_neuroexam

  • id — int(10) — 기본 키 — NOT NULL
  • ecrf_id — int(10)
  • t1_name — varchar(64) — NOT NULL — 테스트명
  • t1_result — varchar(12) — NOT NULL — 현재 사용x
  • t2_name — varchar(64) — 현재 사용x
  • t2_result — varchar(12) — 현재 사용x
  • t2_date — date — 진단 날짜
  • t2_desc — mediumtext — 증상 상세
  • del_yn — varchar(1) — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — int(10) — NOT NULL
  • updated_at — timestamp — NOT NULL
  • updated_by — int(10)
  • id (id2) — int(11) — 외래 키 → ecrf.id — NOT NULL — ecrf아이디 사실상 db상에서 가장 unique한 단위

ecrf_neurological_examination

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_id — int(11) — NOT NULL
  • g00 — varchar(32)
  • g01 — varchar(32)
  • g01_abnormal_details — varchar(256)
  • g02 — varchar(32)
  • g02_abnormal_details — varchar(256)
  • g03 — varchar(32)
  • g03_abnormal_details — varchar(256)
  • g04 — varchar(32)
  • g04_abnormal_details — varchar(256)
  • g05 — varchar(32)
  • g05_abnormal_details — varchar(256)
  • g06 — varchar(32)
  • g06_abnormal_details — varchar(256)
  • g07 — varchar(32)
  • g07_abnormal_details — varchar(256)
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_past_medical_history

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_id — int(11) — NOT NULL
  • d01_01_01 — varchar(64)
  • d01_01_01_01 — varchar(256)
  • d01_01_02 — varchar(64)
  • d01_01_02_01 — varchar(256)
  • d02_01 — varchar(64)
  • d02_02_reason — varchar(256)
  • d03_01 — varchar(64)
  • d03_01_02_delayed — varchar(256)
  • d03_01_03_arrested — varchar(256)
  • d04_textarea — text
  • d05_01_01 — text
  • d06_01_01 — varchar(256)
  • d07_01_01 — varchar(256)
  • d08_01_01 — varchar(256)
  • d09_01_01 — text
  • d01_01_01_01_onset_dummy — varchar(256)
  • d01_01_02_01_onset_dummy — varchar(256)
  • d05_01_01_check_dummy — varchar(64)
  • d07_01_01_details_dummy — varchar(256)
  • d08_01_01_details_dummy — varchar(256)
  • d09_01_01_details_dummy — text
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_past_medical_history_bak

  • id — int(11) — NOT NULL
  • ecrf_id — int(11) — NOT NULL
  • d01_01_01 — varchar(64)
  • d01_01_01_01 — varchar(256)
  • d01_01_02 — varchar(64)
  • d01_01_02_01 — varchar(256)
  • d02_01 — varchar(64)
  • d02_02_reason — varchar(256)
  • d03_01 — varchar(64)
  • d03_01_02_delayed — varchar(256)
  • d03_01_03_arrested — varchar(256)
  • d04_textarea — text
  • d05_01_01 — varchar(256)
  • d06_01_01 — varchar(256)
  • d07_01_01 — varchar(256)
  • d08_01_01 — varchar(256)
  • d09_01_01 — varchar(256)
  • d01_01_01_01_onset_dummy — varchar(256)
  • d01_01_02_01_onset_dummy — varchar(256)
  • d05_01_01_check_dummy — varchar(64)
  • d07_01_01_details_dummy — varchar(256)
  • d08_01_01_details_dummy — varchar(256)
  • d09_01_01_details_dummy — varchar(256)
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL
  • d01_01_01_01_02_dummy — varchar(256)
  • d01_01_01_01_02_onset_dummy — varchar(256)
  • d01_01_01_01_03_dummy — varchar(256)
  • d01_01_01_01_03_onset_dummy — varchar(256)
  • d01_01_02_01_02_dummy — varchar(256)
  • d01_01_02_01_02_onset_dummy — varchar(256)
  • d01_01_02_01_03_dummy — varchar(256)
  • d01_01_02_01_03_onset_dummy — varchar(256)
  • d05_01_02_dummy — varchar(256)
  • d05_01_02_check_dummy — varchar(64)
  • d05_01_03_dummy — varchar(256)
  • d06_01_02_dummy — varchar(256)
  • d06_01_03_dummy — varchar(256)
  • d05_01_03_check_dummy — varchar(64)
  • d07_01_02_dummy — varchar(256)
  • d07_01_02_details_dummy — varchar(256)
  • d07_01_03_dummy — varchar(256)
  • d07_01_03_details_dummy — varchar(256)
  • d08_01_02_dummy — varchar(256)
  • d08_01_02_details_dummy — varchar(256)
  • d08_01_03_dummy — varchar(256)
  • d08_01_03_details_dummy — varchar(256)
  • d09_01_02_dummy — varchar(256)
  • d09_01_02_details_dummy — varchar(256)
  • d09_01_03_dummy — varchar(256)
  • d09_01_03_details_dummy — varchar(256)

ecrf_pathology

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_id — int(11) — NOT NULL
  • k00 — varchar(32)
  • k01_01 — varchar(32)
  • k01_01_05_details — varchar(256)
  • k01_01_06_details — varchar(256)
  • k02_01 — varchar(32)
  • k02_01_text_01 — text
  • k02_01_text_02 — text
  • k02_01_text_03 — text
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_patient

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_id — int(11) — NOT NULL
  • study_number — varchar(128)
  • referral_hospital — varchar(128)
  • referred_date — date
  • name_of_patient — varchar(128)
  • sex — int(1) — 1:male, 2:female
  • birthday — date
  • age — int(11)
  • height — text
  • weight — text
  • description — text
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_perinatal_history

  • id — int(10) — 기본 키 — NOT NULL
  • ecrf_id — int(10)
  • t1_name — varchar(64) — NOT NULL — 분만기 시절 구분(During the pregnancy,Parity of mother,Manner of birth,Gestational age,Postnatal medical history)
  • t1_result — varchar(12)
  • t2_name — varchar(64) — 상세선택
  • t2_result — varchar(12) — 상세 선택지 결과(사용x)
  • t2_date — date — 사용x
  • t2_desc — mediumtext — 결과 상세
  • del_yn — varchar(1) — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — int(10) — NOT NULL
  • updated_at — timestamp — NOT NULL
  • updated_by — int(10)
  • id (id2) — int(11) — 외래 키 → ecrf.id — NOT NULL — ecrf아이디 사실상 db상에서 가장 unique한 단위

ecrf_perinatal_history_20200916

  • id — int(11) — NOT NULL
  • ecrf_id — int(11) — NOT NULL
  • b01_01 — varchar(32)
  • b01_01_04_details — varchar(256)
  • b01_01_05_details — varchar(256)
  • b01_01_06_details — varchar(256)
  • b02_01 — varchar(32)
  • b02_02 — varchar(32)
  • b02_02_week — varchar(32)
  • b02_02_days — varchar(32)
  • b02_06 — varchar(32)
  • b03_01 — varchar(32)
  • b03_01_06_others — varchar(256)
  • b04_01_weeks — varchar(32)
  • b04_01_days — varchar(32)
  • b05_01_kg — varchar(32)
  • b05_02 — varchar(32)
  • b06_01_cm — varchar(32)
  • b06_02 — varchar(32)
  • b07_01_cm — varchar(32)
  • b07_02 — varchar(32)
  • b08_01 — varchar(32)
  • b08_01_13_details — varchar(256)
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL
  • b01_01_05_details_backup — varchar(256)
  • b01_01_06_details_backup — varchar(256)
  • b01_01_07_details_backup — varchar(256)
  • b02_01_times_dummy — varchar(32)
  • b02_01_delivery_dummy — varchar(32)
  • b02_01_01_times_dummy — varchar(32)
  • b02_01_01_weeks_dummy — varchar(32)
  • b02_01_01_days_dummy — varchar(32)
  • b02_02_01_times_dummy — varchar(32)
  • b08_01_01_01_dummy — varchar(32)
  • b08_01_01_04_others_dummy — varchar(256)
  • b08_01_05_01_dummy — varchar(32)
  • b08_01_01_dummy — varchar(32)
  • b08_01_07_others_dummy — varchar(256)

ecrf_perinatal_history_bak

  • id — int(11) — NOT NULL
  • ecrf_id — int(11) — NOT NULL
  • b01_01 — varchar(32)
  • b01_01_04_details — varchar(256)
  • b01_01_05_details — varchar(256)
  • b01_01_06_details — varchar(256)
  • b02_01 — varchar(32)
  • b02_02 — varchar(32)
  • b02_02_week — varchar(32)
  • b02_02_days — varchar(32)
  • b02_06 — varchar(32)
  • b03_01 — varchar(32)
  • b03_01_06_others — varchar(256)
  • b04_01_weeks — varchar(32)
  • b04_01_days — varchar(32)
  • b05_01_kg — varchar(32)
  • b05_02 — varchar(32)
  • b06_01_cm — varchar(32)
  • b06_02 — varchar(32)
  • b07_01_cm — varchar(32)
  • b07_02 — varchar(32)
  • b08_01 — varchar(32)
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL
  • b01_01_05_details_backup — varchar(256)
  • b01_01_06_details_backup — varchar(256)
  • b01_01_07_details_backup — varchar(256)
  • b02_01_times_dummy — varchar(32)
  • b02_01_delivery_dummy — varchar(32)
  • b02_01_01_times_dummy — varchar(32)
  • b02_01_01_weeks_dummy — varchar(32)
  • b02_01_01_days_dummy — varchar(32)
  • b02_02_01_times_dummy — varchar(32)
  • b08_01_01_01_dummy — varchar(32)
  • b08_01_01_04_others_dummy — varchar(256)
  • b08_01_05_01_dummy — varchar(32)
  • b08_01_01_dummy — varchar(32)
  • b08_01_07_others_dummy — varchar(256)

ecrf_phyexam

  • id — int(10) — 기본 키 — NOT NULL
  • ecrf_id — int(10)
  • t1_name — varchar(64) — NOT NULL — 테스트 명
  • t1_result — varchar(12) — NOT NULL — 현재 사용x
  • t2_name — varchar(64) — 현재 사용x
  • t2_result — varchar(12) — 테스트 결과(abnomal:비정상/normal:정상)
  • t2_date — date — 진단일자
  • t2_desc — mediumtext — description 상세
  • del_yn — varchar(1) — NOT NULL
  • created_at — timestamp — NOT NULL — 생성일자
  • created_by — int(10) — NOT NULL — 생성자
  • updated_at — timestamp — NOT NULL
  • updated_by — int(10)
  • id (id2) — int(11) — 외래 키 → ecrf.id — NOT NULL — ecrf아이디 사실상 db상에서 가장 unique한 단위

ecrf_physical_examination

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_id — int(11) — NOT NULL
  • f00 — varchar(32)
  • f01 — varchar(32)
  • f01_abnormal_details — varchar(256)
  • f01_abnormal_image — varchar(256)
  • f01_abnormal_image_size — varchar(32)
  • f02 — varchar(32)
  • f02_abnormal_details — varchar(256)
  • f02_abnormal_image — varchar(256)
  • f02_abnormal_image_size — varchar(32)
  • f03 — varchar(32)
  • f03_abnormal_details — varchar(256)
  • f03_abnormal_image — varchar(256)
  • f03_abnormal_image_size — varchar(32)
  • f04 — varchar(32)
  • f04_abnormal_details — varchar(256)
  • f04_abnormal_image — varchar(256)
  • f04_abnormal_image_size — varchar(32)
  • f05 — varchar(32)
  • f05_abnormal_details — varchar(256)
  • f05_abnormal_image — varchar(256)
  • f05_abnormal_image_size — varchar(32)
  • f06 — varchar(32)
  • f06_abnormal_details — varchar(256)
  • f06_abnormal_image — varchar(256)
  • f06_abnormal_image_size — varchar(256)
  • f07 — varchar(32)
  • f07_abnormal_details — varchar(256)
  • f07_abnormal_image — varchar(256)
  • f07_abnormal_image_size — varchar(256)
  • f08 — varchar(32)
  • f08_abnormal_details — varchar(256)
  • f08_abnormal_image — varchar(256)
  • f08_abnormal_image_size — varchar(256)
  • f09 — varchar(32)
  • f09_abnormal_details — varchar(256)
  • f09_abnormal_image — varchar(256)
  • f09_abnormal_image_size — varchar(256)
  • f10 — varchar(32)
  • f10_abnormal_details — varchar(256)
  • f10_abnormal_image — varchar(256)
  • f10_abnormal_image_size — varchar(256)
  • f11 — varchar(32)
  • f11_abnormal_details — varchar(256)
  • f11_abnormal_image — varchar(256)
  • f11_abnormal_image_size — varchar(32)
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_present_iillness_bak

  • id — int(11) — NOT NULL
  • ecrf_id — int(11) — NOT NULL
  • c01_01 — varchar(64)
  • c01_01_01_age_years — varchar(64)
  • c01_01_01_age_months — varchar(64)
  • c01_01_01 — varchar(64)
  • c01_01_02 — varchar(64)
  • c01_01_03 — varchar(64)
  • c01_01_04 — varchar(64)
  • c01_01_04_01 — varchar(64)
  • c01_01_04_02 — varchar(64)
  • c01_01_04_03 — varchar(64)
  • c01_01_04_04_others — text
  • c01_01_04_05_description — text
  • c01_01_04_06_aggravating — text
  • c01_01_04_05_duration — varchar(64)
  • c01_01_04_06_details — varchar(256)
  • c01_01_04_10_frequency — varchar(64)
  • c01_01_04_10_duration — varchar(64)
  • c01_01_05_yes_no — varchar(64)
  • c01_01_05_01_details — varchar(256)
  • c02_01_textarea — text
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_present_illness

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_id — int(11) — NOT NULL
  • c01_01 — varchar(64)
  • inspected_date — varchar(10)
  • c01_01_01_age_years — varchar(64)
  • c01_01_01_age_months — varchar(64)
  • c01_01_01 — varchar(64)
  • c01_01_02 — varchar(64)
  • c01_01_03 — varchar(64)
  • c01_01_04 — varchar(64)
  • c01_01_04_01 — varchar(64)
  • c01_01_04_02 — varchar(64)
  • c01_01_04_03 — varchar(64)
  • c01_01_04_04_others — text
  • c01_01_04_05_description — text
  • c01_01_04_06_aggravating — text
  • c01_01_04_02_details — text
  • c01_01_04_03_details — text
  • c01_01_04_04_details — text
  • c01_01_04_05_details — text
  • c01_01_05_yes_no — varchar(64)
  • c01_01_05_01_details — varchar(256)
  • c02_01_textarea — text
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_reference

  • ecrf_id — int(11) — 기본 키 — NOT NULL — ecrf 유니크 ID
  • ref_type — varchar(10) — 기본 키 — NOT NULL — 참조 타입 (MME, GV : Genetic Variant, FR : Function Research)
  • ref_id — varchar(50) — 기본 키 — NOT NULL — 참조 유니크 ID
  • use_YN — char(1) — NOT NULL
  • created_by — varchar(50)
  • created_at — datetime
  • updated_by — varchar(50)
  • updated_at — datetime
  • gv_id — int(11) — 외래 키 — NOT NULL — dd
  • id (id2) — int(11) — 외래 키 → ecrf.id — NOT NULL — ecrf아이디 사실상 db상에서 가장 unique한 단위

ecrf_repository

  • ecrf_file_id — int(11) — 기본 키 — NOT NULL
  • ecrf_id — int(11) — NOT NULL
  • q_type — varchar(32) — NOT NULL — fam, phyeam
  • q_no — varchar(32) — NOT NULL — f01
  • file_name — varchar(255) — NOT NULL
  • orig_file_name — varchar(255) — NOT NULL
  • file_path — varchar(4096) — including file name
  • file_size — varchar(32) — kB
  • description — varchar(255) — details
  • use_yn — varchar(1) — NOT NULL
  • del_yn — varchar(1) — NOT NULL — Y / N
  • created_at — datetime — NOT NULL
  • updated_at — timestamp
  • created_by — int(11) — NOT NULL
  • updated_by — int(11)
  • id (id2) — int(10) — 외래 키 → ecrf_phyexam.id — NOT NULL
  • ecrf_id (ecrf_id2) — int(10) — 외래 키 → ecrf_fam_hist.ecrf_id — NOT NULL
  • id (id3) — int(10) — 외래 키 → ecrf_img.id — NOT NULL
  • gv_id — int(11) — 외래 키 — NOT NULL — Genetic Variant ID 유니크
  • cmt_no — int(10) — 외래 키 — NOT NULL — 코멘트 번호
  • fr_id — int(11) — 외래 키 — NOT NULL — Function Research 유니크 ID
  • cmt_no (cmt_no2) — int(10) — 외래 키 — NOT NULL — 코멘트 번호

ecrf_tests_for_other_samples_01_dummy

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_tests_for_other_samples_id — int(11) — NOT NULL
  • j01 — varchar(32)
  • j01_01 — varchar(32)
  • j01_date — varchar(32)
  • j01_01_text_01 — text
  • j01_01_text_02 — text
  • j01_01_text_03 — text
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_tests_for_other_samples_02_dummy

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_tests_for_other_samples_id — int(11) — NOT NULL
  • j02 — varchar(32)
  • j02_date — varchar(32)
  • j02_01_text — text
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_tests_for_other_samples_dummy

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_id — int(11) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_tests_for_other_samples_emp

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_id — int(11)

ecrf_urinalysis

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_id — int(11) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_urinalysis_01

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_urinalysis_id — int(11) — 외래 키 → ecrf_urinalysis.id — NOT NULL
  • i01 — varchar(32)
  • i01_date — varchar(32)
  • i01_01_text — text
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

ecrf_urinalysis_02

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_urinalysis_id — int(11) — 외래 키 → ecrf_urinalysis.id — NOT NULL
  • i02 — varchar(32)
  • i02_date — varchar(32)
  • i02_01_text — text
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

enc_ecrf

  • id — int(11) — 기본 키 — NOT NULL
  • ecrf_key — varchar(128) — NOT NULL
  • ecrf_iv — varchar(128) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL

family_details

  • id — int(11) — 기본 키 — NOT NULL
  • family_history_id — int(11) — NOT NULL
  • family_id — varchar(256)
  • family_relation — varchar(64)
  • sex — enum('0','1','2','9')
  • affected — varchar(16)
  • deceased — varchar(1)
  • age_of_death — varchar(16)
  • active — int(1)
  • created_at — datetime — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — varchar(256) — NOT NULL
  • updated_by — varchar(256) — NOT NULL

family_relation_mst

  • id — int(11) — 기본 키 — NOT NULL
  • value — int(11)
  • lang_key — varchar(64)
  • sort — int(11)
  • active — int(1)

외 46개 테이블