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