Hyperdata

Tables (21)

DATAOBJECT_DOWNLOAD_INFO (Untitled9)

  • DATAOBJECT_ID (Key) — Primary key — NOT NULL
  • FILE_TOKEN (Field)
  • USER_ID (Field2)

DATASOURCE_INFO (Untitled18)

  • ID (Key) — Primary key — NOT NULL
  • TYPE (Field)

DATASOURCE_OZONE_JSON_FILE_INFO (Untitled20)

  • DATASOURCE_ID (Key) — Foreign key → DATASOURCE_INFO.ID
  • FILEPATH (Field)
  • VOLUME_NAME (Field2)
  • BUCKET_NAME (Field3)
  • IP (Field4)
  • PORT (Field5)

DATASOURCE_PROP (Untitled19)

  • DATASOURCE_ID (Key) — Foreign key → DATASOURCE_INFO.ID — NOT NULL
  • SUB_TYPE (Field)
  • CONNECT_TYPE (Field2)
  • IP (Field3)
  • PORT (Field4)
  • SID (Field5)
  • PATH (Field6)
  • FILE_DELIMITER (Field7)
  • LINE_DELIMITER (Field8)
  • ESCAPE (Field9)
  • IGNORE_LINES (Field10)
  • XML_NAMESPACE (Field11)
  • UUID (Field12)
  • CONNECT_ID (Field13)
  • ORGANIZATION_INFO (Field14)
  • SCOPE_REGEX (Field15)
  • SCOPE_DATE_START (Field16)
  • SCOPE_DATA_END (Field17)
  • FILE_SIZE (Field18)

DATASOURCE_SQL_EDITOR_CONNECT_USERS (Untitled11)

  • USER_ID (Field)

LOOKUP_OBJECT_STATUS (Untitled2)

  • STATUS (Key) — Primary key — NOT NULL
  • NAME (Field)

LOOKUP_OBJECT_TYPE (Untitled)

  • OBJ_TYPE (Key) — Primary key — NOT NULL
  • NAME (Field)

META_BUSINESSRULE_INFO (Untitled8)

  • ID (Key) — Primary key — NOT NULL
  • Field

META_COLUMN_INFO (Untitled5)

  • ID (Key2) — Foreign key → META_NODE_INFO.ID — NOT NULL
  • LOGICAL_NAME (Field) — NOT NULL
  • PHYSICAL_NAME (Field2)
  • SEMANTIC_TYPE (Field3)
  • PHYSICAL_TYPE (Field4)
  • ORIGINAL_TYPE (Field5)
  • COLUMN_TYPE (Field6)
  • DESCRIPTION (Field7)

META_DATAOBJECT_INFO (Untitled3)

  • ID (Key) — Primary key — NOT NULL — META_NODE_INFO 테이블의 Table ID
  • PHYSICAL_NAME (Field) — NOT NULL — DataObject의 소스테이블 물리명
  • DATAOBJECT_TYPE (Field2) — NOT NULL — DB 데이터소스 or #Default DataSource일 경우 : "Table" File 데이터소스일 경우: "File" SQL 데이터소스일 경우: "SQL"
  • DATAJOB_RUN_HISTORY_ID (Field3) — DATAJOB - Save Output DataObject 수행 시에 필요시 관련 value 삽입할 수 있는 column. 현재 상태에서는 사용되지 않는 것으로 확인됨.
  • SQL (Field4) — SQL DO의 경우 DO 생성 SQL 구문
  • IS_ANALYSIS (Field5) — NOT NULL — DataObject Analysis 결과 상태 카테고리 변수 초기: 0 / 분석중: 1 / 분석완료: 2 / 분석없음: 3 / 분석실패: 4
  • OBJECT_ID (Key2) — Foreign key → OBJECT_INFO.ID — NOT NULL
  • SCOPE_REGEX (Field6)
  • SCOPE_DATA_START (Field7)
  • SCOPE_DATA_END (Field8)

META_EDGE_INFO (Untitled6)

  • SRC_NODE (Key) — Foreign key → META_NODE_INFO.ID — NOT NULL
  • DST_NODE (Key2) — Foreign key → META_NODE_INFO.ID — NOT NULL
  • EDGE_TYPE (Field) — NOT NULL
  • BR_ID (Key3) — Foreign key → META_BUSINESSRULE_INFO.ID — NOT NULL

META_NODE_INFO (Untitled4)

  • ID (Key) — Primary key — NOT NULL — DataObject의 Table과 Column에 새로이 부여한 ID
  • PROJECT_ID (Field) — NOT NULL
  • NODE_TYPE (Field2) — NOT NULL

META_TAG_INFO (Untitled7)

  • ID (Key) — Primary key — NOT NULL
  • TAG (Field) — NOT NULL
  • NODE_ID (Key2) — Foreign key → META_NODE_INFO.ID — NOT NULL

OBJECT_INFO

  • ID (Key) — Primary key — NOT NULL
  • PARENT_ID (Field) — 해당 OBJECT가 생성된 OBJECT ID - Project의 경우 Project ID(자기자신) - Data Source의 경우 Project ID - Data Object의 경우 Data Source ID
  • NAME (Field2)
  • CREATED_ON (Field3) — NOT NULL
  • LAST_EDITED (Field4) — NOT NULL
  • DESCRIPTION (Field5)
  • STATUS (Field6)
  • AUTHOR (Field7)
  • OWNER_ID (Field8)
  • OBJ_TYPE (Key2) — Foreign key → LOOKUP_OBJECT_TYPE.OBJ_TYPE — NOT NULL — OBJECT 타입 (LOOKUP_OBJECT_TYPE) 0: Project, 1: Data Job, 2: Service Job, 3: Data source, 4: Data Object 5. Virtual model…
  • STATUS (Key3) — Foreign key → LOOKUP_OBJECT_STATUS.STATUS — NOT NULL

OBJECT_REFERENCE (Untitled10)

  • OBJ_ID (Key) — Foreign key → OBJECT_INFO.ID — NOT NULL
  • REF_ID (Key2) — Foreign key → OBJECT_INFO.ID — NOT NULL
  • SHARE_TIME (Field) — NOT NULL — DO가 Project로 공유된 날짜
  • SHARE_VALID_PERIOD (Field2) — DO가 Project에서 공유가 만료되는 날짜
  • SHARE_APPROVAL_STATUS (Field3) — DO 공유 상태( 0: 신규요청 미승인, 1: 승인, 2: 갱신요청 미승인)

PROJECT_INFO (Untitled15)

  • ID (Key) — Primary key — NOT NULL

SM_GROUP (Untitled13)

  • ID (Key) — Primary key — NOT NULL
  • NAME (Field)
  • GROUP_TYPE (Field2)
  • DESCRIPTION (Field3)
  • CREATED_ON (Field4)
  • LAST_EDITED (Field5)

SM_GROUP_PERMISSION (Untitled17)

  • ID (Key) — Primary key — NOT NULL
  • NAME (Field)
  • DESCRIPTION (Field2)

SM_PROJECT_GROUP_AUTH (Untitled16)

  • PROJECT_ID (Key) — Foreign key → PROJECT_INFO.ID — NOT NULL
  • GROUP_ID (Key2) — Foreign key → SM_GROUP.ID — NOT NULL
  • GROUP_PERMISSION_ID (Key3) — Foreign key → SM_GROUP_PERMISSION.ID — NOT NULL

SM_USER (Untitled12)

  • UUID (Key) — Primary key — NOT NULL
  • ID (Field)
  • GROUP_ID (Field2)
  • RECENT_PROJECT (Field3)
  • TOKEN (Field4)
  • REFRESH_TOKEN (Field5)
  • LAST_TIME (Field6)

SM_USER_GROUP (Untitled14)

  • USER_UUID (Key) — Foreign key → SM_USER.UUID — NOT NULL
  • GROUP_ID (Key2) — Foreign key → SM_GROUP.ID — NOT NULL