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개 테이블