Nocky ERD

Tables (12)

Api Info (api)

  • Key (id) — Primary key — NOT NULL
  • endpoint_id — Foreign key → Endpoint.Key — NOT NULL
  • 경로 (path)
  • 생성일시 (created)
  • 설명 (description)
  • 통신프로토콜 (protocol)
  • 포트번호 (port)
  • 쿼리스트링 (query)
  • 메소드 (method)
  • 체크주기 (cycle)
  • 알람여부 (isAlarm)

Api Param Info (api_param)

  • Key (id) — Primary key — NOT NULL
  • 생성일시 (created)
  • 구분(header/body) (type)
  • key
  • value
  • 설명 (description)
  • api_id — Foreign key → Api Info.Key — NOT NULL

Api history (api_hist)

  • Key (id) — Primary key — NOT NULL
  • 생성일시 (created)
  • 상태코드 (status_code)
  • 상태메시지 (status_message)
  • 응답속도 (response_time)
  • 에러여부 (isError)

Endpoint (endpoint)

  • Key (id) — Primary key — NOT NULL
  • 주소 (address)
  • 생성일시 (created)
  • service_id — Foreign key → Service.Key — NOT NULL

Notification Contact (notification_contact)

  • Key (id) — Primary key — NOT NULL
  • 구분(email/sms) (type)
  • 주소or번호 (address)

Notification Group (notification_group)

  • Key (id) — Primary key — NOT NULL
  • 이름 (name)
  • 생성일시 (created)
  • 설명 (description)
  • Key (user_id) — Foreign key → User.Key — NOT NULL

Notification History (notification_hist)

  • Key (api_hist_id) — Foreign key → Api history.Key — NOT NULL
  • Key (notification_contact_id) — Foreign key → Notification Contact.Key — NOT NULL
  • 생성일시 (created)
  • 실패여부 (isFailed)

Project (project)

  • Key (id) — Primary key — NOT NULL
  • 이름 (name)
  • 생성일시 (created)
  • user_id — Foreign key → User.Key — NOT NULL

Service (service)

  • Key (id) — Primary key — NOT NULL
  • 이름 (name)
  • 생성일시 (created)
  • 설명 (description)
  • project_id — Foreign key → Project.Key — NOT NULL

User (user)

  • Key (id) — Primary key — NOT NULL
  • 이름 (name)
  • 이메일 (email)
  • 비밀번호 (password)

[Rela] Notification Group - Service (notification_group_service)

  • Key (notification_group_id) — Foreign key → Notification Group.Key — NOT NULL
  • Key (service_id) — Foreign key → Service.Key — NOT NULL

[Rela] Notification Group Contact (notification_group_contact)

  • Key (notification_group_id) — Foreign key → Notification Group.Key — NOT NULL
  • Key (notification_contact_id) — Foreign key → Notification Contact.Key — NOT NULL