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