API_MANAGEMENT_SERVICE

Tables (16)

TB_API (Untitled)

  • API_SQ — int unsigned — Primary key — NOT NULL
  • OPEN_API_VERSION
  • VERSION
  • TITLE
  • EMAIL
  • ORIGIN_DATA
  • VALID_STATUS
  • REGIST_DT
  • UPDATE_DT

TB_API_DEFINITION (Untitled9)

  • API_DEFINITION_SQ — Primary key — NOT NULL
  • API_SQ — Foreign key → TB_API.API_SQ — NOT NULL
  • NAME
  • DEFINITION_CD
  • VALID_STATUS
  • REGIST_DT
  • UPDATE_DT

TB_API_DEFINITION_COMP (Untitled12)

  • END_DT — Primary key — NOT NULL
  • API_DEFINITION_SQ — Foreign key → TB_API_DEFINITION.API_DEFINITION_SQ — NOT NULL
  • API_SQ — Foreign key → TB_API_DEFINITION.API_SQ — NOT NULL
  • DESCRIPTION
  • EXAMPLE
  • REGIST_DT
  • UPDATE_DT

TB_API_DEFINITION_OBJ (Untitled15)

  • API_DEFINITION_OBJ_SQ — Primary key — NOT NULL
  • DEFINITION_OBJ_BASE_SORT_SQ — Primary key — NOT NULL
  • API_DEFINITION_SQ — Foreign key → TB_API_DEFINITION.API_DEFINITION_SQ — NOT NULL
  • API_SQ — Foreign key → TB_API_DEFINITION.API_SQ — NOT NULL
  • VALID_STATUS
  • REGIST_DT
  • UPDATE_DT

TB_API_DEFINITION_OBJ_COMP (Untitled14)

  • API_DEFINITION_OBJ_COMP_SQ — Primary key — NOT NULL
  • END_DT — Primary key — NOT NULL
  • API_DEFINITION_OBJ_SQ — Foreign key → TB_API_DEFINITION_OBJ.API_DEFINITION_OBJ_SQ — NOT NULL
  • DEFINITION_OBJ_BASE_SORT_SQ — Foreign key → TB_API_DEFINITION_OBJ.DEFINITION_OBJ_BASE_SORT_SQ — NOT NULL
  • API_DEFINITION_SQ — Foreign key → TB_API_DEFINITION_OBJ.API_DEFINITION_SQ — NOT NULL
  • API_SQ — Foreign key → TB_API_DEFINITION_OBJ.API_SQ — NOT NULL
  • TYPE_CD
  • NAME
  • DESCRIPTION
  • EXAMPLE
  • REGIST_DT
  • UPDATE_DT

TB_API_PATH (Untitled3)

  • API_PATH_SQ — Primary key — NOT NULL
  • API_SQ — Foreign key → TB_API.API_SQ — NOT NULL
  • URL
  • CALL_SERVICE_URL
  • CALL_DB
  • METHOD_CD
  • TAGS
  • SUMMARY
  • DESCRIPTION
  • OPERATIONID
  • REQUEST_CD
  • VALID_STATUS
  • REGIST_DT
  • UPDATE_DT

TB_API_REQUEST_BODY (Untitled5)

  • API_REQ_BODY_SQ — Primary key — NOT NULL
  • END_DT — Primary key — NOT NULL
  • API_PATH_SQ — Foreign key → TB_API_PATH.API_PATH_SQ — NOT NULL
  • API_SQ — Foreign key → TB_API_PATH.API_SQ — NOT NULL
  • REQUIRED
  • CONTENT_TYPE
  • REF_NM
  • REGIST_DT
  • UPDATE_DT

TB_API_REQUEST_PARAM (Untitled4)

  • API_REQ_PARAM_SQ — Primary key — NOT NULL
  • END_DT — Primary key — NOT NULL
  • API_PATH_SQ — Foreign key → TB_API_PATH.API_PATH_SQ — NOT NULL
  • API_SQ — Foreign key → TB_API_PATH.API_SQ — NOT NULL
  • NAME
  • IN
  • SCHEMA_CD
  • SCHEMA_TYPE
  • SCHEMA__REF
  • REQUIRED
  • DESCRIPTION
  • REGIST_DT
  • UPDATE_DT

TB_API_RESPONSE (Untitled6)

  • API_RES_SQ (API_RESPONSE_SQ) — Primary key — NOT NULL
  • API_PATH_SQ — Foreign key → TB_API_PATH.API_PATH_SQ — NOT NULL
  • API_SQ — Foreign key → TB_API_PATH.API_SQ — NOT NULL
  • STATUS_CD
  • DESCRIPTION
  • CONTENT_TYPE
  • SCHEMA_TYPE
  • VALID_STATUS
  • REGIST_DT
  • UPDATE_DT

TB_API_RES_PROPERTY_COMP (Untitled8)

  • END_DT — Primary key — NOT NULL
  • API_RES_REQUIRE_SQ — Foreign key → TB_API_RES_REQUIRE.API_RES_REQUIRE_SQ — NOT NULL
  • API_RES_SQ — Foreign key → TB_API_RES_REQUIRE.API_RES_SQ — NOT NULL
  • API_PATH_SQ — Foreign key → TB_API_RES_REQUIRE.API_PATH_SQ — NOT NULL
  • API_SQ — Foreign key → TB_API_RES_REQUIRE.API_SQ — NOT NULL
  • DESCRIPTION
  • EXAMPLE
  • REGIST_DT
  • UPDATE_DT

TB_API_RES_PROPERTY_OBJ (Untitled11)

  • API_RES_PROPERTY_OBJ_SQ — Primary key — NOT NULL
  • PROPERTY_OBJ_BASE_SORT_SQ — Primary key — NOT NULL
  • API_RES_REQUIRE_SQ — Foreign key → TB_API_RES_REQUIRE.API_RES_REQUIRE_SQ — NOT NULL
  • API_RES_SQ — Foreign key → TB_API_RES_REQUIRE.API_RES_SQ — NOT NULL
  • API_PATH_SQ — Foreign key → TB_API_RES_REQUIRE.API_PATH_SQ — NOT NULL
  • API_SQ — Foreign key → TB_API_RES_REQUIRE.API_SQ — NOT NULL
  • VALID_STATUS
  • REGIST_DT
  • UPDATE_DT

TB_API_RES_PROPERTY_OBJ_COMP (Untitled13)

  • API_RES_PROPERTY_OBJ__COMP_SQ — Primary key — NOT NULL
  • END_DT — Primary key — NOT NULL
  • API_RES_PROPERTY_OBJ_SQ — Foreign key → TB_API_RES_PROPERTY_OBJ.API_RES_PROPERTY_OBJ_SQ — NOT NULL
  • PROPERTY_OBJ_BASE_SORT_SQ — Foreign key → TB_API_RES_PROPERTY_OBJ.PROPERTY_OBJ_BASE_SORT_SQ — NOT NULL
  • API_RES_REQUIRE_SQ — Foreign key → TB_API_RES_PROPERTY_OBJ.API_RES_REQUIRE_SQ — NOT NULL
  • API_RES_SQ — Foreign key → TB_API_RES_PROPERTY_OBJ.API_RES_SQ — NOT NULL
  • API_PATH_SQ — Foreign key → TB_API_RES_PROPERTY_OBJ.API_PATH_SQ — NOT NULL
  • API_SQ — Foreign key → TB_API_RES_PROPERTY_OBJ.API_SQ — NOT NULL
  • NAME
  • DESCRIPTION
  • EXAMPLE
  • REGIST_DT
  • UPDATE_DT

TB_API_RES_PROPERTY_REF (Untitled10)

  • END_DT — Primary key — NOT NULL
  • API_RES_REQUIRE_SQ — Foreign key → TB_API_RES_REQUIRE.API_RES_REQUIRE_SQ — NOT NULL
  • API_RES_SQ — Foreign key → TB_API_RES_REQUIRE.API_RES_SQ — NOT NULL
  • API_PATH_SQ — Foreign key → TB_API_RES_REQUIRE.API_PATH_SQ — NOT NULL
  • API_SQ — Foreign key → TB_API_RES_REQUIRE.API_SQ — NOT NULL
  • REF_NM
  • REGIST_DT
  • UPDATE_DT

TB_API_RES_REQUIRE (Untitled7)

  • API_RES_REQUIRE_SQ — Primary key — NOT NULL
  • API_RES_SQ — Foreign key → TB_API_RESPONSE.API_RES_SQ — NOT NULL
  • API_PATH_SQ — Foreign key → TB_API_RESPONSE.API_PATH_SQ — NOT NULL
  • API_SQ — Foreign key → TB_API_RESPONSE.API_SQ — NOT NULL
  • PROPERTY_CD
  • NAME
  • VALID_STATUS
  • REGIST_DT
  • UPDATE_DT

TB_API_SERVER (Untitled2)

  • API_SERVER_SQ — Primary key — NOT NULL
  • END_DT — Primary key — NOT NULL
  • API_SQ — Foreign key → TB_API.API_SQ — NOT NULL
  • URL
  • DESCRIPTION
  • REGIST_DT
  • UPDATE_DT

TB_API_TAG (Untitled20)

  • API_TAG_SQ — Primary key — NOT NULL
  • END_DT — Primary key — NOT NULL
  • API_SQ — Foreign key → TB_API.API_SQ — NOT NULL
  • NAME
  • DESCRIPTION
  • REGIST_DT
  • UPDATE_DT