apiMonitering

Tables (4)

Users (Untitled5)

  • userId (id) — NOTNULL — Primary key — NOT NULL
  • nickName (닉네임) — NOTNULL
  • phoneNumber (전화번호) — NOTNULL
  • email (이메일)

apiEndpoint (Untitled)

  • apiEndpointId (id) — NOTNULL — Primary key — NOT NULL
  • userId (idi) — NOTNULL — Foreign key → Users.userId — NOT NULL
  • url (api요청 주소) — NOTNULL
  • authKey (api요청 인증키) — NOTNULL
  • method (post, get 등) — NOTNULL
  • header
  • payload
  • scheduledTime (요청주기) — NOTNULL
  • status (요청 결과값) — NOTNULL

apiReport (Untitled3)

  • apiReportId (id) — NOTNULL — Primary key — NOT NULL
  • apiUrl (대상 api 주소) — NOTNULL
  • averageResponseTime (평균 응답시간) — NOTNULL
  • errorCount (발생 에러 수) — NOTNULL
  • reportStamp (보고서 생성 시간) — NOTNULL
  • apiResponseId (id2) — NOTNULL — Foreign key → apiResponse.apiResponseId — NOT NULL

apiResponse (Untitled2)

  • apiResponseId (id) — NOTNULL — Primary key — NOT NULL
  • request (Field)
  • statusCode (응답 상태 코드) — NOTNULL
  • responseTime (응답 완료 시간) — NOTNULL
  • body (응답 데이터) — NOTNULL
  • errorMessage (에러 메시지)
  • apiRequestId (id2) — NOTNULL — Foreign key → apiEndpoint.apiEndpointId — NOT NULL