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