dbins_cstdb

테이블 (7)

App 연결관리 (DS_APP_GROUP_CPS)

  • GROUP_ID (Key) — 외래 키 → 앱 그룹.GROUP_ID — NOT NULL
  • DS_App_NO (Key2) — 외래 키 → 앱.DS_App_NO — NOT NULL
  • REG_USER_NO (Field)
  • REG_DTTM (Field2)
  • ALT_USER_NO (Field3)
  • ALT_DTTM (Field4)

DBMS 서비스 (DS_DBMS_SVC)

  • DS_DBMS_SVC_NO (Key) — 기본 키 — NOT NULL
  • DS_DB_TYPE_NO (Key2) — 외래 키 → DB타입.DS_DB_TYPE_NO — NOT NULL
  • DS_DB_NET_TYPE_NO (Field6)
  • DS_SVC (Field7)
  • DS_PROJECT_NO (Field8)
  • DS_HOST_NM (Field9)
  • DS_SERVER_NM (Field10)
  • DS_SVC_IP (Field11)
  • DS_SVC_PORT (Field12)
  • DS_SID (Field13)
  • DS_SVC_NM (Field14)
  • DS_PRI_MGMT_USER_NO (Field15)
  • DS_SUB_MGMT_USER_NO (Field16)
  • DS_DBSAFER_YN (Field17)
  • REG_USER_NO (Field)
  • REG_DTTM (Field2)
  • ALT_USER_NO (Field3)
  • ALT_DTTM (Field4)

DB접근권한 (DS_DB_ACS_AUTH)

  • DS_IDX (Key) — 기본 키 — NOT NULL
  • DS_DBMS_SVC_NO (Key2) — 외래 키 → DBMS 서비스.DS_DBMS_SVC_NO — NOT NULL
  • GROUP_ID (Key3) — 외래 키 → 앱 그룹.GROUP_ID — NOT NULL
  • DS_REQUEST_ID (Field5)
  • DS_USER_ID (Field6)
  • USER_NO (Field7)
  • DS_USER_IP (Field8)
  • DS_START (Field10)
  • DS_END (Field11)
  • NETWORK (Field12)
  • REG_USER_NO (Field)
  • REG_DTTM (Field2)
  • ALT_USER_NO (Field3)
  • ALT_DTTM (Field4)

DB접근권한 통제 (DS_DB_ACS_AUTH_CONST)

  • DS_ACS_AUTH_CONST_IDX (Key) — 기본 키 — NOT NULL
  • DS_DBMS_SVC_NO (Key2) — 외래 키 → DBMS 서비스.DS_DBMS_SVC_NO — NOT NULL
  • DS_REQUEST_ID (Field5)
  • USER_NO (Field7)
  • DS_PROJECT_NO (Field6)
  • EXPORT_ALLOW_YN (Field8)
  • IMPORT_ALLOW_YN (Field9)
  • CLPBRD_ALLOW_YN (Field10)
  • EXPORT_START_DTTM (Field11)
  • EXPORT_END_DTTM (Field12)
  • IMPORT_START_DTTM (Field13)
  • IMPORT_END_DTTM (Field14)
  • CLPBRD_START_DTTM (Field15)
  • CLPBRD_END_DTTM (Field16)
  • REG_USER_NO (Field)
  • REG_DTTM (Field2)
  • ALT_USER_NO (Field3)
  • ALT_DTTM (Field4)

DB타입 (DS_DB_TYPE)

  • DS_DB_TYPE_NO (Key) — 기본 키 — NOT NULL
  • DS_DB_TYPE (Field)
  • REG_USER_NO (Field3)
  • REG_DTTM (Field4)
  • ALT_USER_NO (Field5)
  • ALT_DTTM (Field6)

앱 (DS_APP)

  • DS_App_NO (Key) — 기본 키 — NOT NULL
  • DS_APP (Field)
  • REG_USER_NO (Field2)
  • REG_DTTM (Field3)
  • ALT_USER_NO (Field4)
  • ALT_DTTM (Field5)

앱 그룹 (DS_APP_GROUP)

  • GROUP_ID (Key) — 기본 키 — NOT NULL
  • GROUP_NM (Field)
  • HIRNK_GROUP_ID (Field2)
  • REG_USER_NO (Field3)
  • REG_DTTM (Field4)
  • ALT_USER_NO (Field5)
  • ALT_DTTM (Field6)