P1_database

Tables (61)

ACTIVITY(Formdef) (Untitled2)

  • 기본키 (ACTIVITY_ID) — Primary key — NOT NULL — uid? pk? ID?
  • 코드 (code)
  • 주인이름 (owner)
  • 최근 수정일자 (lastUpdate)
  • 최초 생성일자 (createdTime)
  • 설명 (Description)
  • Field (ItemGroupRef)
  • Field (ArchiveLayout)
  • 정규이름 (Field2)
  • 정규코드 (Field3) — 코드와 합쳐야하지 않을까?
  • 상태 (Field4) — 수정 가능여부
  • 커스텀 여부 (Field5)
  • 회사이름 (Field6)
  • OID (Field7) — Activity => formdef
  • 이름 (name)
  • Repeating (Field8) — 반복여부

ASSESMENT (ItemGroupDef)

  • 기본키 (ASSESMENT_ID) — Primary key — NOT NULL
  • 코드 (code) — 변수명
  • 주인이름 (owner)
  • 최근 수정일자 (lastUpdate)
  • 최초 생성일자 (createTime)
  • 표준이름 (Field2)
  • 표준코드 (Field3)
  • 상태 (Field4)
  • 커스텀여부 (Field6)
  • 회사이름 (Field7)
  • Field8 (Description) — ItemGroupDef의 Body
  • Field9 (ItemRef) — ItemGroupDef의 Body
  • Field10 (OID) — ItemGroupDef의 Attribute
  • Field11 (Name) — ItemGroupDef의 Attribute
  • Field12 (Repeating) — ItemGroupDef의 Attribute
  • Field13 (IsReferenceData) — ItemGroupDef의 Attribute
  • Field8 (SASDatasetName) — ItemGroupDef의 Attribute
  • Field9 (Domain) — ItemGroupDef의 Attribute
  • Field10 (Origin) — ItemGroupDef의 Attribute
  • Field11 (Role) — ItemGroupDef의 Attribute
  • Field8 (Purpose) — ItemGroupDef의 Attribute
  • Field9 (Comment) — ItemGroupDef의 Attribute

Alias_activity (Untitled6)

  • activity_id (pk) — Foreign key → ACTIVITY(Formdef).기본키 — NOT NULL — uid? pk? ID?
  • 별칭 대상 OID (Field)
  • Name (Field2)
  • contents (Field3)

Alias_assesment (CopyOfUntitled6)

  • ASSESMENT_ID (pk) — Foreign key → ASSESMENT.기본키 — NOT NULL
  • 별칭 대상 OID (Field)
  • Name (Field2)
  • contents (Field3)

Alias_element (CopyOfUntitled62)

  • ELEMENT_ID — Foreign key → ELEMENT(DEC).기본키 — NOT NULL
  • 별칭 대상 OID (Field)
  • Name (Field2)
  • contents (Field3)

Alias_value (CopyOfUntitled63)

  • value_id (VALUE_ID) — Foreign key → VALUE(CD)(DEC와 n:1 관계 가짐).기본키 — NOT NULL
  • 별칭 대상 OID (Field)
  • Name (Field2)
  • contents (Field3)

CUSTOM_CT_version (커스텀 CT 버전)

  • custom_ct_version_pk (Key) — Primary key — NOT NULL
  • ct_category (Field8)
  • ct_version (버전)

CUSTOM_ControlTerminology (커스텀 CT)

  • custom_ct_pk (Key) — Primary key — NOT NULL
  • custom_ct_version_pk (Key2) — Foreign key → CUSTOM_CT_version.custom_ct_version_pk — NOT NULL
  • code (코드)
  • codelist code (Field2)
  • codelist extensible (Field3)
  • codelist name (Field4)
  • CDISC submission vcalue (Field5)
  • CDISC synonym (Field6)
  • CDISC definition (Field7)
  • NCI preferred term (Field8)

CUSTOM_user_data (custom standard 상태관리 TB)

  • custom_user_data_pk (Key) — Primary key — NOT NULL
  • table_name (Field6)
  • custom_standard_pk (Field5)
  • writer (Field) — 작성자
  • reviewer (Field2) — 리뷰어
  • approvaler (Field3) — 승인자
  • status (Field4) — 상태
  • edit_date (Field7) — 날짜(최종수정일)

DataElenemt (DE)

  • DE_ID (Key) — Primary key — NOT NULL
  • DEC에 대한ID (ELEMENT_ID) — Foreign key → ELEMENT(DEC).기본키 — NOT NULL
  • DEC (Field)
  • DEC using this DE (Field2)
  • standard Type (Field3)
  • standard (Field4)
  • variable (Field5)
  • version (Field6)
  • vd (Field7)
  • DEC using this vd (Field8)

ELEMENT(DEC) (concept Map에서 Element, ODM에서 ItemDef)

  • 기본키 (ELEMENT_ID) — Primary key — NOT NULL
  • 코드 (code)
  • 이름 (name)
  • 주인이름 (owner)
  • 최근 수정일자 (lastUpdate)
  • 최초 생성일자 (createTime)
  • 버전 (Field)
  • 도메인 (Field2)
  • 설명 (Field3)
  • 상태 (Field4)
  • CD conceptual (Field5)
  • dataelement (Field6)
  • 커스텀여부 (Field7)
  • 회사이름 (Field8)
  • description — itemDef의 Body
  • question — ItemDef의 body
  • externalQuestion — itemDef의 Body
  • measurement UnitRef (measurementUnitRef) — itemDef의 Body
  • RangeCheck — itemDef의 Body
  • CodeListRef — itemDef의 Body
  • Role Deprecated (RoleDeprecated) — itemDef의 Body
  • Alias — itemDef의 Body alias, 테이블 따로 빠짐
  • OID — Attribute
  • Name — Attribute
  • DataType — Attribute
  • Length — Attribute
  • SignificantDigits — Attribute
  • SASFieldName — Attribute
  • SDSBarName — Attribute
  • Origin — Attribute
  • Comment — Attribute

Form Ref (Untitled)

  • Field (FormOID) — Attribute
  • Field2 (OrderNumber)
  • Field3 (Mandatory)
  • Field4 (CollectionExceptionConditionOID)

Item Ref (CopyOfCopyOfUntitled)

  • Field (ItemOID) — Attribute
  • Field2 (OrderNumber)
  • Field3 (Mandatory)
  • Field (KeySequence) — MDR에서는 못함 필요 없음
  • Field2 (MethodOID) — 계산식의 OID
  • Field3 (InputaionMethodOID)
  • Field4 (Role)
  • Field (RoleCodeListOID)
  • Field4 (CollectionExceptionConditionOID)

ItemGroup Ref (CopyOfUntitled)

  • Field (ItemGroupOID) — Attribute
  • Field2 (OrderNumber)
  • Field3 (Mandatory)
  • Field4 (CollectionExceptionConditionOID)

Reviews (Untitled3)

  • review_pk (Key) — Primary key — NOT NULL
  • custom_user_data_pk (Key2) — Foreign key → CUSTOM_user_data.custom_user_data_pk — NOT NULL
  • review_text (Field)
  • created_at (Field5)

SDTM_dataset_value (SDTM datasets value TB)

  • sdtm_datasets_value_pk (Key) — Primary key — NOT NULL
  • sdtm_datasets_pk (Key2) — Foreign key → SDTM_datasets.sdtm_datasets_pk — NOT NULL
  • class_pk (Key22) — Foreign key → SDTM_datasets.class_pk — NOT NULL
  • sdtm_version_pk (Key222) — Foreign key → SDTM_datasets.sdtm_version_pk — NOT NULL
  • value_ordinal (Field)
  • value_name (Field2)
  • label (Field3)
  • datatype (Field4)
  • role (Field5)
  • qulifiies_variable (Field6)
  • described_value_domain (Field7)
  • notes (Field8)
  • usage_restictions (Field9)
  • definition (Field10)
  • variable_c-code (Field11)
  • examples (Field12)

SDTM_datasets (SDTM dataset TB)

  • sdtm_datasets_pk (Key) — Primary key — NOT NULL
  • class_pk (Key2) — Foreign key → standard_SDTM_class.class_pk — NOT NULL
  • sdtm_version_pk (Key22) — Foreign key → standard_SDTM_class.sdtm_version_pk — NOT NULL
  • datasets_name (Field)
  • datasets_fullname (Field2)
  • description (Field3)

STANDARD_CT_version (스탠다드 CT 버전)

  • standard_ct_version_pk (Key) — Primary key — NOT NULL
  • ct_catagory (Field2) — package 이름
  • ct_version (Field) — 날짜

STANDARD_ControlTerminology (스탠다드 CT)

  • standard_ct_pk (Key) — Primary key — NOT NULL
  • standard_ct_version_pk (Key2) — Foreign key → STANDARD_CT_version.standard_ct_version_pk — NOT NULL
  • code (코드)
  • codelist code (Field2)
  • extensible (Field3)
  • name (Field4)
  • submission value (Field5)
  • synonyms (Field6)
  • definition (Field7)
  • NCI_preferred_term (Field8)

Template_assasement (템플릿의 assessment, 질문을 관리하기 위한 테이블)

  • Key — Primary key — NOT NULL
  • DEC (Field)
  • valluelevelmetadata (Field2)
  • Question (Field3) — assasement이기 때문에 question은 삭제될 수 있다.
  • enable (Field4)
  • collect (Field5)
  • datatype (Field6)
  • value (Field7)
  • Field8

TreePath_ACTIVITY (Untitled4)

  • 기본키 (Key2) — Primary key — NOT NULL
  • activity자신 (ACTIVITY_ID) — Foreign key → ACTIVITY(Formdef).기본키 — NOT NULL — uid? pk? ID?
  • assesment자식 (ASSESMENT_ID) — Foreign key → ASSESMENT.기본키 — NOT NULL

TreePath_ASSESMENT (CopyOfUntitled4)

  • 기본키 (pk) — Primary key — NOT NULL
  • assesment 자신 (ASSESMENT_ID) — Foreign key → ASSESMENT.기본키 — NOT NULL
  • element 자식 (ELEMENT_ID) — Foreign key → ELEMENT(DEC).기본키 — NOT NULL

TreePath_DEC (CopyOfCopyOfUntitled4)

  • 기본키 (pk) — Primary key — NOT NULL
  • DEC 자신 (ELEMENT_ID) — Foreign key → ELEMENT(DEC).기본키 — NOT NULL
  • CD 자식 (VALUE_ID) — Foreign key → VALUE(CD)(DEC와 n:1 관계 가짐).기본키 — NOT NULL

TreePath_TA (CopyOfUntitled42)

  • 기본키 (pk) — Primary key — NOT NULL
  • 치료영역 키 (자신) (TA_ID) — Foreign key → 치료영역.치료영역 키 — NOT NULL
  • 액티비티키(자신) (ACTIVITY_ID) — Foreign key → ACTIVITY(Formdef).기본키 — NOT NULL — uid? pk? ID?

TreePath_alias (CopyOfCopyOfCopyOfCopyOfUntitled42)

  • 기본키 (Key) — Primary key — NOT NULL
  • 부모 (Field)
  • 자식(assesment) (Field2)

VALUE(CD)(DEC와 n:1 관계 가짐) (CodeList)

  • 기본키 (VALUE_ID) — Primary key — NOT NULL
  • 코드 (code) — 사용 여부 결정 요망
  • 이름 (name)
  • 주인이름 (owner) — 소유주 계정
  • 최근 수정일자 (lastUpdate)
  • 최초 생성일자 (createTime)
  • 커스텀여부 (Field)
  • 회사이름 (Field2)
  • DEC_pk (Field3) — DEC 식별자 나중에 외래키로
  • DEC using CD (Field4) — 사이에 treepath 포함해서 보여주기
  • version (Field5) — 수정버전
  • Description (Field6) — 설명
  • Values (Field7) — 나올수 있는 VD 리스트
  • state (Field8) — 승인상태
  • DataType (Field9)
  • DisplayFormat (Field10)
  • Maximum Length (Field11)
  • 최소길이 (Field12)
  • high value (Field13) — 최댓값
  • Low value (Field14) — 최솟값
  • value (Field15) — 실제 입력받을 값.
  • Domain (Field16)
  • Type (Field17)
  • Value Domain (Field18)
  • CDs using this VD (Field19)

Value Domain (VD)

  • VD_ID (Key) — Primary key — NOT NULL
  • 기본키 (VALUE_ID) — Foreign key → VALUE(CD)(DEC와 n:1 관계 가짐).기본키 — NOT NULL
  • DE_ID (Key2) — Foreign key → DataElenemt.DE_ID — NOT NULL
  • DEC에 대한ID (ELEMENT_ID) — Foreign key → DataElenemt.DEC에 대한ID — NOT NULL
  • PV (Field) — 입력 가능한 값
  • PVs using this VD (Field2)
  • Dict Type (Field3)
  • Dictionaly (Field4)
  • Codelist name (Field5)
  • Codelist Code (Field6)
  • value (Field7)
  • code (Field8)
  • version (Field9)
  • DE (Field10)
  • des using this vd (Field11)

cdashIG_scenarios (시나리오tb)

  • senarios_pk (Key3) — Primary key — NOT NULL
  • domain_pk (Key) — Foreign key → standard_cdashIG_domain.domain_pk — NOT NULL
  • class_pk (Key2) — Foreign key → standard_cdashIG_domain.class_pk — NOT NULL
  • cdashig_version_pk (Key22) — Foreign key → standard_cdashIG_domain.cdashig_version_pk — NOT NULL
  • scenarios_name (Field2)
  • scenarios_ordinal (Field3)

config_log (Untitled5)

  • 대상 유저uid (Field)
  • odm OID (Field2)
  • 수정시간 (Field3)
  • 수정내용 (Field4)
  • 기존내용 (Field5)
  • 기존내용 작성시간 (Field6)
  • 수정대상 코드 (Field7)

custom SDTM_datasets (custom SDTM dataset TB)

  • sdtm_datasets_pk (Key) — Primary key — NOT NULL
  • class_pk (Key2) — Foreign key → custom_SDTM_class.class_pk — NOT NULL
  • sdtm_title_pk (Key22) — Foreign key → custom_SDTM_class.sdtm_title_pk — NOT NULL
  • datasets_name (Field)
  • datasets_fullname (Field2)
  • dataset_description (Field3)

custom_SDTMIG_value (custom SDTMIG 항목2)

  • value_pk (Key) — Primary key — NOT NULL
  • dataset_pk (Key3) — Foreign key → standard_SDTMIG_datasets.dataset_pk — NOT NULL
  • class_pk (Key2) — Foreign key → standard_SDTMIG_datasets.class_pk — NOT NULL
  • sdtmig_version_pk (Key22) — Foreign key → standard_SDTMIG_datasets.sdtmig_version_pk — NOT NULL
  • value_ordinal (Field)
  • value_name (Field2)
  • label (Field3)
  • value_description (Field4)
  • datatype (Field5)
  • role (Field6)
  • core (Field7)
  • codelist (Field8)
  • described_value_domain (Field9)
  • implements (Field10)
  • value_list (Field11)

custom_SDTM_class (customSDTMMODEL 클래스)

  • class_pk (Key) — Primary key — NOT NULL
  • sdtm_title_pk (Key2) — Foreign key → custom_SDTM_title.sdtm_title_pk — NOT NULL
  • class_name (Field)
  • class_description (Field2)

custom_SDTM_dataset_value (custom datasets value TB)

  • sdtm_datasets_value_pk (Key) — Primary key — NOT NULL
  • sdtm_datasets_pk (Key2) — Foreign key → custom SDTM_datasets.sdtm_datasets_pk — NOT NULL
  • class_pk (Key22) — Foreign key → custom SDTM_datasets.class_pk — NOT NULL
  • sdtm_title_pk (Key222) — Foreign key → custom SDTM_datasets.sdtm_title_pk — NOT NULL
  • value_ordinal (Field)
  • value_name (Field2)
  • label (Field3)
  • datatype (Field4)
  • role (Field5)
  • qulifiies_variable (Field6)
  • described_value_domain (Field7)
  • notes (Field8)
  • usage_restictions (Field9)
  • definition (Field10)
  • variable_c-code (Field11)
  • examples (Field12)

custom_SDTM_title (custom SDTMMODEL 타이틀)

  • sdtm_title_pk (Key) — Primary key — NOT NULL
  • title (제목)
  • implement_by (Field3)

custom_SDTM_value (custom SDTMIG 항목)

  • value id (Key) — Primary key — NOT NULL
  • class_pk (Key2) — Foreign key → custom_SDTM_class.class_pk — NOT NULL
  • sdtm_title_pk (Key22) — Foreign key → custom_SDTM_class.sdtm_title_pk — NOT NULL
  • value_ordinal (Field)
  • value_name (Field2)
  • label (Field3)
  • datatype (Field4)
  • role (Field5)
  • qualifies_variables (Field6)
  • described_value_domain (Field7)
  • notes (Field8)
  • usage_restictions (Field9)
  • definition (Field10)
  • variable_c-code (Field11)
  • examples (Field12)

custom_cdashIG_value (custom CDASHIG 항목)

  • value_pk (Key) — Primary key — NOT NULL
  • domain_pk (Key2) — Foreign key → standard_cdashIG_domain.domain_pk — NOT NULL
  • class_pk (Key22) — Foreign key → standard_cdashIG_domain.class_pk — NOT NULL
  • version_pk (Key222) — Foreign key → standard_cdashIG_domain.cdashig_version_pk — NOT NULL
  • value_ordinal (Field)
  • value_name (Field2)
  • label (Field3)
  • definition (Field4)
  • question_text (Field5)
  • prompt (Field6)
  • data_type (Field7)
  • core (Field8)
  • completion_instructions (Field9)
  • implementation_notes (Field10)
  • mapping_instructions (Field11)
  • mapping_targets (Field12)
  • code_list (Field13)
  • implements (Field14)

custom_cdashModel_domain (custom cdashmodel domain tb)

  • domain_pk (Key) — Primary key — NOT NULL
  • custom_cdashModel_title_pk (Key2) — Foreign key → custom_cdashModel_title.custom_cdashModel_title_pk — NOT NULL
  • domain_name (Field) — domain 약어
  • domain_fullname (Field4)
  • domain_ordinal (Field2) — 정렬 순서
  • domain_description (Field3)

custom_cdashModel_title (CopyOfCDASHModel 버전)

  • custom_cdashModel_title_pk (Key) — Primary key — NOT NULL
  • title (제목) — 버전이지만 이름으로 관리함 ex) _신풍 _씨엔알
  • implemented_by (Field3)

custom_cdashModel_value (CopyOfCDASHModel 항목)

  • value_pk (Key) — Primary key — NOT NULL
  • domain_pk (Key2) — Foreign key → custom_cdashModel_domain.domain_pk — NOT NULL
  • custom_cdashModel_title_pk (Key22) — Foreign key → custom_cdashModel_domain.custom_cdashModel_title_pk — NOT NULL
  • value_ordinal (Field11)
  • value_name (Field) — 항목이름
  • label (Field2)
  • definition (Field3)
  • question_text (Field4)
  • prompt (Field5)
  • data_type (Field6)
  • implementation_notes (Field7)
  • mapping_instructions (Field8)
  • mapping_targets (Field9)
  • code_list (Field10)

element 언어 (CopyOfCopyOfUntitled11)

  • id (Key) — Primary key — NOT NULL
  • ELEMENT_ID (pk) — Foreign key → ELEMENT(DEC).기본키 — NOT NULL
  • 언어 (Field)
  • 이름 (Field2)
  • 설명 (Field3)
  • 질문 (Field4)

standard_SDTMIG_class (SDTMIG 클래스)

  • class_pk (Key) — Primary key — NOT NULL
  • sdtmig_version_pk (Key2) — Foreign key → standard_SDTMIG_version.sdtmig_version_pk — NOT NULL
  • class_name (Field)
  • class_description (Field2)

standard_SDTMIG_datasets (SDTMIG 데이터셋)

  • dataset_pk (Key3) — Primary key — NOT NULL
  • class_pk (Key) — Foreign key → standard_SDTMIG_class.class_pk — NOT NULL
  • sdtmig_version_pk (Key2) — Foreign key → standard_SDTMIG_class.sdtmig_version_pk — NOT NULL
  • dataset_fullname (Field)
  • dataset_name (Field2)
  • structure (Field3)
  • dataset_description (Field4)

standard_SDTMIG_value (SDTMIG 항목)

  • value_pk (Key) — Primary key — NOT NULL
  • dataset_pk (Key3) — Foreign key → standard_SDTMIG_datasets.dataset_pk — NOT NULL
  • class_pk (Key2) — Foreign key → standard_SDTMIG_datasets.class_pk — NOT NULL
  • sdtmig_version_pk (Key22) — Foreign key → standard_SDTMIG_datasets.sdtmig_version_pk — NOT NULL
  • value_ordinal (Field)
  • value_name (Field2)
  • label (Field3)
  • value_description (Field4)
  • datatype (Field5)
  • role (Field6)
  • core (Field7)
  • codelist (Field8)
  • described_value_domain (Field9)
  • implements (Field10)
  • value_list (Field11)

standard_SDTMIG_version (SDTMIG 버전)

  • sdtmig_version_pk (Key) — Primary key — NOT NULL
  • version (버전)
  • status (Field)
  • effective_data (Field2)
  • implement_by (Field3)

standard_SDTM_class (SDTMMODEL 클래스)

  • class_pk (Key) — Primary key — NOT NULL
  • sdtm_version_pk (Key2) — Foreign key → standard_SDTM_version.sdtm_version_pk — NOT NULL
  • class_name (Field)
  • class_description (Field2)

standard_SDTM_value (CopyOfSDTMIG 항목)

  • value id (Key) — Primary key — NOT NULL
  • class_pk (Key2) — Foreign key → standard_SDTM_class.class_pk — NOT NULL
  • sdtm_version_pk (Key22) — Foreign key → standard_SDTM_class.sdtm_version_pk — NOT NULL
  • value_ordinal (Field)
  • value_name (Field2)
  • label (Field3)
  • datatype (Field4)
  • role (Field5)
  • qualifies_variables (Field6)
  • described_value_domain (Field7)
  • notes (Field8)
  • usage_restictions (Field9)
  • definition (Field10)
  • variable_c-code (Field11)
  • examples (Field12)

standard_SDTM_version (SDTMMODEL 버전)

  • sdtm_version_pk (Key) — Primary key — NOT NULL
  • version (버전)
  • status (Field)
  • effective_date (Field2)
  • implement_by (Field3)

standard_cdashIG_class (CDASHIG 클래스)

  • class_pk (Key) — Primary key — NOT NULL
  • cdashig_version_pk (Key2) — Foreign key → standard_cdashIG_version.cdashig_version_pk — NOT NULL
  • class_name (버전) — class 이름
  • class_description (Field)
  • class_ordinal (Field2)

standard_cdashIG_domain (CDASHIG 도메인)

  • domain_pk (Key) — Primary key — NOT NULL
  • class_pk (Key2) — Foreign key → standard_cdashIG_class.class_pk — NOT NULL
  • cdashig_version_pk (Key22) — Foreign key → standard_cdashIG_class.cdashig_version_pk — NOT NULL
  • domain_name (Field) — 도메인 이름 약어
  • domain_ordinal (정렬번호)
  • domain_description (도메인 설명)
  • domain_fullname (Field2) — 도메인 풀네임

standard_cdashIG_value (CDASHIG 항목)

  • value_pk (Key) — Primary key — NOT NULL
  • domain_pk (Key2) — Foreign key → standard_cdashIG_domain.domain_pk — NOT NULL
  • class_pk (Key22) — Foreign key → standard_cdashIG_domain.class_pk — NOT NULL
  • version_pk (Key222) — Foreign key → standard_cdashIG_domain.cdashig_version_pk — NOT NULL
  • value_ordinal (Field)
  • value_name (Field2)
  • label (Field3)
  • definition (Field4)
  • question_text (Field5)
  • prompt (Field6)
  • data_type (Field7)
  • core (Field8)
  • completion_instructions (Field9)
  • implementation_notes (Field10)
  • mapping_instructions (Field11)
  • mapping_targets (Field12)
  • code_list (Field13)
  • implements (Field14)

standard_cdashIG_version (CDASHIG 버전)

  • cdashig_version_pk (Key) — Primary key — NOT NULL
  • version (버전)
  • status (Field)
  • effective_date (Field2)
  • implements (Field3)

standard_cdashModel_class (CDASHModel 클래스)

  • class_pk (Key) — Primary key — NOT NULL
  • cdashModel_version_pk (Key2) — Foreign key → standard_cdashModel_version.cdashModel_version_pk — NOT NULL
  • class_name (Field) — class 이름
  • class_ordinal (Field2) — 정렬 순서
  • class_description (Field3) — class 설명

standard_cdashModel_value (CDASHModel 항목)

  • value_pk (Key) — Primary key — NOT NULL
  • class_pk (Key2) — Foreign key → standard_cdashModel_class.class_pk — NOT NULL
  • cdashModel_version_pk (Key22) — Foreign key → standard_cdashModel_class.cdashModel_version_pk — NOT NULL
  • value_ordinal (Field11)
  • value_name (Field) — 항목이름
  • label (Field2)
  • definition (Field3)
  • question_text (Field4)
  • prompt (Field5)
  • data_type (Field6)
  • implementation_notes (Field7)
  • mapping_instructions (Field8)
  • mapping_targets (Field9)
  • code_list (Field10)

standard_cdashModel_version (CDASHModel 버전)

  • cdashModel_version_pk (Key) — Primary key — NOT NULL
  • version (버전) — 버전
  • status (Field) — 상태
  • effective_date (Field2)
  • implemented_by (Field3)

template vlaue (템플릿의 벨류들)

  • Key — Primary key — NOT NULL
  • CodeListItem Body (Field) — Decode, Alias
  • Codelist Body (Field2) — Description, CodelistItem, EnumeratedItem, ExternalCodeList, Alias
  • CodelistAttribute (Field3) — OID, name, DataType, SASFormatName
  • CodeListItem Attrivute (Field4) — CodeValue, Rank, OrderNumber
  • Field5
  • Field6
  • Field7

template_value (Untitled15)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5

value 언어 (CopyOfUntitled112)

  • id (VALUE_ID) — Primary key — NOT NULL
  • value_id (pk) — Foreign key → VALUE(CD)(DEC와 n:1 관계 가짐).기본키 — NOT NULL
  • 언어 (Field)
  • 이름 (Field2)
  • 설명 (Field3)

액티비티 언어 (Untitled11)

  • id (Key) — Primary key — NOT NULL
  • activity_id (pk) — Foreign key → ACTIVITY(Formdef).기본키 — NOT NULL — uid? pk? ID?
  • 언어 (Field)
  • 이름 (Field2)
  • 설명 (Field3)

어세스먼트 언어 (CopyOfUntitled11)

  • id (Key) — Primary key — NOT NULL
  • ASSESMENT_ID (pk) — Foreign key → ASSESMENT.기본키 — NOT NULL
  • 언어 (Field)
  • 이름 (Field2)
  • 설명 (Field3)

치료영역 (Untitled7)

  • 치료영역 키 (TA_ID) — Primary key — NOT NULL
  • TA이름 (Field)
  • 버전 (Field2)
  • effective date (Field3) — 효력발생일
  • status (Field4) — 완료, 수정중
  • 주인(만든애) (Field5)
  • 커스텀 여부 (Field6)
  • 회사이름 (Field7)

템플릿의 주인과 버전을 관리하기위한 테이블 (collection_template_identifier)

  • Key — Primary key — NOT NULL
  • Name (Field)
  • owner (Field2)
  • activity (Field3)
  • effective date (Field5)
  • status (Field6)
  • version (Field10)