API Gateway

Tables (14)

API Client (api_client)

  • Auth Type (auth_type) — varchar(20) — Primary key — NOT NULL
  • Client ID (client_id) — varchar(20) — Primary key — NOT NULL
  • User ID (user_id) — varchar(100) — Foreign key → API USer.User ID — NOT NULL
  • Last Modified (last_modified) — datetime
  • Properties (props) — TEXT

API Deployment (api_deployment)

  • Deploy Path (deploy_path) — Primary key — NOT NULL
  • 경로 (gateway_path) — varchar(100) — Foreign key → API Gateway Service.경로 — NOT NULL
  • 인스턴스ID (instance_id) — varchar(36) — Foreign key → API Gateway Service.인스턴스ID — NOT NULL
  • Land-Scape (landscape) — varchar(30)
  • Endpoint ID (endpoint_id) — varchar(36) — Foreign key → Endpoint.Endpoint ID — NOT NULL
  • SIgnature Hash (signature_hash) — varchar(500)
  • Configuration (configuration) — MEDIUMTEXT
  • Version (api_version_id) — varchar(36) — Foreign key → API Package Version.Version — NOT NULL
  • 패키지 ID (package_id) — varchar(36) — Foreign key → API Package Version.패키지 ID — NOT NULL

API Gateway Service (api_gateway_service)

  • 경로 (path) — varchar(100) — Primary key — NOT NULL
  • 인스턴스ID (instance_id) — varchar(36) — Foreign key → Gateway Instance.인스턴스ID — NOT NULL
  • Service Owner (service_owner) — varchar(100) — Foreign key → API Owner.사용자ID — NOT NULL

API Guide (api_guide)

  • Title (title) — varchar(50) — Primary key — NOT NULL
  • 패키지 ID (package_id) — varchar(36) — Foreign key → API Package.패키지 ID — NOT NULL
  • 컨텐츠 (content) — MEDIUMTEXT

API Owner (user)

  • 사용자ID (user_id) — varchar(100) — Primary key — NOT NULL

API Package (api_package)

  • 패키지 ID (package_id) — varchar(36) — Primary key — NOT NULL
  • 패키지 명 (package_name) — varchar(100)
  • 설명 (description) — vatchar(200)
  • Develope Enpoint (dev_endpoint_id) — varchar(36) — Foreign key → Endpoint.Endpoint ID — NOT NULL
  • 사용자ID (user_id) — varchar(100) — Foreign key → API Owner.사용자ID — NOT NULL
  • 디자인 방식 (design_model) — varchar(30)
  • 구독 방식 (subscription_model) — varchar(20)
  • 사용자별 기본 사용량 (user_default_rate_limit) — INT

API Package Version (api_package_version)

  • Version (api_version_id) — varchar(36) — Primary key — NOT NULL
  • 패키지 ID (package_id) — varchar(36) — Foreign key → API Package.패키지 ID — NOT NULL
  • Version Name (version_name) — varchar(20)
  • OpenAPI Spec (open_api_spec) — MEDIUMTEXT

API Permission (api_permission)

  • User ID (user_id) — varchar(100) — Foreign key → API USer.User ID — NOT NULL
  • 패키지 ID (package_id) — varchar(36) — Foreign key → API Package.패키지 ID — NOT NULL
  • Rate Limit (rate_limit) — INT

API USer (api_user)

  • User ID (user_id) — varchar(100) — Primary key — NOT NULL
  • password — varchar(100)
  • Email (email) — varchar(100)

Allowed Auth (allowed_auth)

  • Auth Type (auth_type) — varchar(20) — Primary key — NOT NULL
  • 패키지 ID (package_id) — varchar(36) — Foreign key → API Package.패키지 ID — NOT NULL
  • Properties (properties) — TEXT

Channel (channel)

  • Endpoint Channel ID (channel_id) — varchar(30) — Primary key — NOT NULL
  • Endpoint ID (endpoint_id) — varchar(36) — Foreign key → Endpoint.Endpoint ID — NOT NULL
  • Target Path (path) — varchar(100) — NOT NULL

Channel Binding (channel_binding)

  • Path (path) — varchar(100) — Primary key — NOT NULL
  • Method (method) — varchar(10) — Primary key — NOT NULL
  • Version (api_version_id) — varchar(36) — Foreign key → API Package Version.Version — NOT NULL
  • 패키지 ID (package_id) — varchar(36) — Foreign key → API Package Version.패키지 ID — NOT NULL
  • Rate Limit (rate_limit) — INT
  • Endpoint Channel ID (channel_id) — varchar(30) — Foreign key → Channel.Endpoint Channel ID — NOT NULL

Endpoint (endpoint)

  • Endpoint ID (endpoint_id) — varchar(36) — Primary key — NOT NULL
  • Type (type) — varchar(10)
  • Target (target) — varchar(100)
  • 경로 (path) — varchar(100) — Foreign key → API Gateway Service.경로 — NOT NULL
  • 인스턴스ID (instance_id) — varchar(36) — Foreign key → API Gateway Service.인스턴스ID — NOT NULL

Gateway Instance (api_gateway_instance)

  • 인스턴스ID (instance_id) — varchar(36) — Primary key — NOT NULL
  • Connection Info (connection_info) — varchar(100)