test
Tables (30)
BT_AZURE
- TENANT_ID — nvarchar(36) — NOT NULL
- ACCOUNT_ID — nvarchar(50) — NOT NULL
- SERVICE_NM — nvarchar(63) — NOT NULL
- DATABASE_NM — nvarchar(50) — NOT NULL
- ADMIN_ID — nvarchar(50) — NOT NULL
- SKU — nvarchar(5)
- SERVICE_STATE — nvarchar(10)
BT_BI_DATASET
- DATASET_NM — nvarchar(100)
- REPORT_ID — nvarchar(36) — NOT NULL
- DATA_SOURCE_NM — nvarchar(100) — NOT NULL
- REFRESH_TIME_YN — datetime2
- REFRESH_FREQ — int
- DATASET_ID — nvarchar(36)
BT_BI_DATASET_COLUMN
- COLUMN_NM — nvarchar(100) — NOT NULL
- TABLE_NM — nvarchar(100) — NOT NULL
- COLUMN_DESC — nvarchar(50)
- DATA_TP — nvarchar(20)
- DATA_SIZE — int
- NULL_YN — nvarchar(1)
- PK_YN — nvarchar(1)
BT_BI_DATASET_TABLE
- TABLE_NM — nvarchar(100) — NOT NULL
- DATASET_NM — nvarchar(100)
- DATA_SOURCE_NM — nvarchar(100)
- TABLE_TP — nvarchar(10)
- TABLE_DESC — nvarchar(50)
- USE_YN — nvarchar(1)
BT_BI_DATA_SOURCE
- DATA_SOURCE_NM — nvarchar(100) — NOT NULL
- DATA_SOURCE_TP — nvarchar(30)
- LINK_URL — nvarchar(100)
- CREDENTIAL — nvarchar(50)
BT_BI_EMBEDD
- TENANT_ID — nvarchar(36) — NOT NULL
- SUB_ID — nvarchar(36)
- SERVICE_NM — nvarchar(63)
- ADMIN_ID — nvarchar(50)
- LOCATION — nvarchar(20)
- SKU — nvarchar(5)
- SERVICE_STATE — nvarchar(10)
BT_BI_EXPOSITION
- BI_EXP_YEAR — datetime2 — NOT NULL
- REPORT_ID — nvarchar(36) — NOT NULL
- BI_TIMES — int — NOT NULL
- PROJECT_NM — nvarchar(100)
- REPORT_NM — nvarchar(100)
- WORKER_TEAM — nvarchar(30)
- OWNER — nvarchar(30)
- BI_EXP_DT — datetime2
- COACH — nvarchar(30)
BT_BI_PORTAL_INFO
- GROUP_ID — nvarchar(36) — NOT NULL
- TENANT_ID — nvarchar(36) — NOT NULL
- ACCOUNT_ID — nvarchar(50) — NOT NULL
- GROUP_NM — nvarchar(100)
- CREATOR — nvarchar(30)
- CREATE_DT — datetime2
- USE_YN — nvarchar(1)
BT_BI_REPORT
- REPORT_ID — nvarchar(36) — NOT NULL
- GROUP_ID — nvarchar(36) — NOT NULL
- REPORT_NM — nvarchar(100)
- REPORT_TP — nvarchar(10)
- CREATOR — nvarchar(30)
- CREATE_DT — datetime2
- UPDATE_DT — datetime2
- USE_YN — nvarchar(1)
- REPORT_URL — nvarchar(112)
BT_BI_REPORT_IMG
- CREATE_DT — datetime2 — NOT NULL
- REPORT_ID — nvarchar(36) — NOT NULL
- PAGE_ID — nvarchar(33) — NOT NULL
- IMAGE — varbinary(max)
BT_BI_REPORT_PAGE
- PAGE_ID — nvarchar(33) — NOT NULL
- REPORT_ID — nvarchar(36) — NOT NULL
- PAGE_NM — nvarchar(100)
- PAGE_SEQ — int
- HIDE_YN — nvarchar(1)
- USE_YN — nvarchar(1)
BT_DL_BLOB
- PATH — nvarchar(200) — NOT NULL
- CONTAINER2 — nvarchar(30)
- FOLDER_NM — nvarchar(30)
- DEPTH — int
- UPPER_FOLDER_NM — nvarchar(30)
- PATH_DESC — nvarchar(50)
- CREATE_DT — datetime2
- UPDATE_DT — datetime2
- EXTENSION — nvarchar(10)
- FILE_COUNT — int
- FILE_SIZE — int
BT_DL_BLOB_FILE
- FILE_NM — nvarchar(30) — NOT NULL
- PATH — nvarchar(100) — NOT NULL
- EXTENSION — nvarchar(10)
- CREATE_DT — datetime2
- UPDATE_DT — datetime2
- CONTENTS_TYPE — nvarchar(20)
- SIZE — int
- PREFIX — nvarchar(10)
BT_DL_INFO
- TENANT_ID — nvarchar(36) — NOT NULL
- SUBSCRIP_ID — nvarchar(36) — NOT NULL
- STORAGE_ACCOUNT — nvarchar(30) — NOT NULL
- CONTAINER — nvarchar(30)
- KIND — nvarchar(50)
BT_DW_COLUMN
- COLUMN_NM — nvarchar(100) — NOT NULL
- TABLE_NM — nvarchar(100) — NOT NULL
- DATA_TP — nvarchar(20) — NOT NULL
- DATA_SIZE — int
- NULL_YN — nvarchar(1)
- COLUMN_DESC — nvarchar(100)
BT_DW_EXTERNAL_TABLE
- EXTERNAL_TABLE_NM — nvarchar(100)
- TABLE_NM — nvarchar(100) — NOT NULL
- BLOB_LOCATION — nvarchar(200)
- FILE_FORMAT — nvarchar(20)
BT_DW_PROCEDURE
- PROCEDURE_NM — nvarchar(50) — NOT NULL
- TABLE_NM — nvarchar(100) — NOT NULL
- EXTERNAL_TABLE_NM — nvarchar(100)
BT_DW_PROCEDURE_LOG
- EXEC_START_DT — datetime2 — NOT NULL
- PROCEDURE_NM — nvarchar(50) — NOT NULL
- EXTERNAL_TABLE_NM — nvarchar(100)
- RUN_RESULT — nvarchar(100)
- TABLE_INSERT_CNT — int
- INSERT_TABLE_NM — nvarchar(100)
- EXEC_TIME — datetime2
- ERROR_MSG — nvarchar(1024)
- TABLE_FINAL_CNT — int
BT_DW_TABLE
- TYPE — nvarchar(10) — NOT NULL
- TABLE_NM — nvarchar(100) — NOT NULL
- TABLE_DESC — nvarchar(100)
- CREATE_DT — datetime2
- TABLE_TP — nvarchar(20)
BT_DW_TABLE_STATISTIC
- TABLE_NM2 — nvarchar(100) — NOT NULL
- TABLE_SIZE — int
- TABLE_NUM — int
BT_MODEL
- MODEL_NM — nvarchar(100) — NOT NULL
- DATABASE_NM — nvarchar(50) — NOT NULL
- OWNER — nvarchar(30) — NOT NULL
- CREATOR — nvarchar(30)
- MANAGER — nvarchar(30)
- CREATE_DT — datetime2
- LAST_CHG_DT — datetime2
- SYNC_DT — datetime2
- GROUP — nvarchar(10)
- MODEL_SIZE — int
- COMPATIBILITY_LEVEL — int
BT_MODEL_COLUMN
- COLUMN_NM — nvarchar(100) — NOT NULL
- TABLE_NM — nvarchar(100) — NOT NULL
- COLUMN_TP — nvarchar(20) — NOT NULL
- DATA_TP — nvarchar(20) — NOT NULL
- SOURCE_COLUMN — nvarchar(100)
- EXPRESSION — nvarchar(500)
BT_MODEL_DATA_SOURCE
- DATA_SOURCE_NM — nvarchar(100) — NOT NULL
- MODEL_NM — nvarchar(100) — NOT NULL
- DATABASE_NM2 — nvarchar(50) — NOT NULL
- PROTOCOL — nvarchar(50)
- PATH — nvarchar(100)
- ACCOUNT — nvarchar(50)
BT_MODEL_EXPRESSION
- EXPRESSION_NM — nvarchar(100)
- MODEL_NM — nvarchar(100) — NOT NULL
- KIND — nvarchar(2000)
- MODEL_EXPRESSION — nvarchar(500)
BT_MODEL_FIREWALL
- RULE_NAME — nvarchar(50) — NOT NULL
- SERVICE_NM — nvarchar(63) — NOT NULL
- FROM_IP — nvarchar(30) — NOT NULL
- TO_IP — nvarchar(30)
- CREATE_DT — datetime2
BT_MODEL_MEASURE
- MEASURE_NM — nvarchar(100) — NOT NULL
- TABLE_NM — nvarchar(100) — NOT NULL
- EXPRESSION — nvarchar(500)
- FORMAT_STRING — nvarchar(20)
BT_MODEL_PROCESS
- PROCESS_TP — nvarchar(30) — NOT NULL
- START_DT — datetime2 — NOT NULL
- MODEL_NM — nvarchar(100) — NOT NULL
- END_DT — datetime2
- STATE — nvarchar(50)
- EXEC_TIME — datetime2
- ERROR_MSG — nvarchar(500)
BT_MODEL_RELATION
- RELATION_NM — nvarchar(50)
- MODEL_NM — nvarchar(100) — NOT NULL
- DATABASE_NM2 — nvarchar(50) — NOT NULL
- FROM_TABLE — nvarchar(100)
- FROM_COLUMN — nvarchar(100)
- TO_TABLE — nvarchar(100)
- TO_COLUMN — nvarchar(100)
- FROM_CARDINALITY — nvarchar(20)
- TO_CARDINALITY — nvarchar(20)
- CROSSFILTER — nvarchar(20)
BT_MODEL_TABLE
- TABLE_NM — nvarchar(100) — NOT NULL
- MODEL_NM — nvarchar(100) — NOT NULL
- DATABASE_NM2 — nvarchar(50) — NOT NULL
- TABLE_TP — nvarchar(10) — NOT NULL
- DATA_SOURCE_NM — nvarchar(100)
- DATA_TABLE_NM — nvarchar(100)
- EXPRESSION — nvarchar(500)
BT_SERVICE_EMBEDD_INFO
- SERVICE_NM — nvarchar(63) — NOT NULL
- MENU_NM — nvarchar(30) — NOT NULL
- REPORT_ID — nvarchar(36) — NOT NULL
- MENU_ROUTE — nvarchar(100)
- URL — nvarchar(100)
- WORKER_NM — nvarchar(30)
- CREATOR — nvarchar(30)
- CREATE_DT — datetime2
- UPDATE_DT — datetime2
- USE_YN — nvarchar(1)
- SITE_URL — nvarchar(100)
- WORKER_TEAM — nvarchar(30)