API_MANAGEMENT_SERVICE
Tables (16)
TB_API (Untitled)
- API_SQ — int unsigned — Primary key — NOT NULL
- OPEN_API_VERSION
- VERSION
- TITLE
- 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