api-g

Tables (11)

API (CopyOfUntitled)

  • SEQ (Key) — Primary key — NOT NULL
  • METHOD (Field)
  • PATH (Field3)
  • AUTHENTICATION_TYPE (Field4)
  • ID (Key2) — Foreign key → INTERFACE.ID — NOT NULL

API_KEY

  • ID (Key) — Primary key — NOT NULL
  • USER_ID (Key2) — Foreign key → user.ID — NOT NULL
  • INFO (Field)

HEADER

  • SEQ (Key) — Primary key — NOT NULL
  • NAME (Field2)
  • TYPE (Field)
  • DESCRIPTION (Field3)
  • API_SEQ (Key2) — Foreign key → API.SEQ — NOT NULL

HTTP

  • ID (Key) — Primary key — NOT NULL
  • USER_ID (Key2) — Foreign key → user.ID — NOT NULL
  • INFO (Field)

INTERFACE

  • ID (Key) — Primary key — NOT NULL
  • TYPE (Field2)

OAUTH2

  • ID (Key) — Primary key — NOT NULL
  • USER_ID (Key2) — Foreign key → user.ID — NOT NULL
  • INFO (Field)

QUERY

  • SEQ (Key) — Primary key — NOT NULL
  • NAME (Field2)
  • TYPE (Field)
  • DESCRIPTION (Field3)
  • API_SEQ (Key2) — Foreign key → API.SEQ — NOT NULL

REQUEST_BODY

  • SEQ (Key) — Primary key — NOT NULL
  • SCHEMA (Key3) — Foreign key → SCHEMA.NAME — NOT NULL
  • CONTENTS_TYPE (Field2)
  • API_SEQ (Key2) — Foreign key → API.SEQ — NOT NULL

RESPONSE_BODY

  • SEQ (Key) — Primary key — NOT NULL
  • SECHEMA (Key3) — Foreign key → SCHEMA.NAME — NOT NULL
  • NAME (Field2)
  • TYPE (Field)
  • DESCRIPTION (Field3)
  • API_SEQ (Key2) — Foreign key → API.SEQ — NOT NULL

SCHEMA

  • NAME (Key) — Primary key — NOT NULL
  • DATA (Field2)
  • DESCRIPTION (Field3)

user (Untitled)

  • ID (Key) — Primary key — NOT NULL
  • PASSWORD (Field2)
  • PARTNER_ID (Field)
  • AUTH (Field3)