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)