ngrinder-erd

Tables (9)

MTTFB

  • id — int8 — Primary key — NOT NULL
  • id (result_id) — int8 — Foreign key → result.id — NOT NULL
  • (started_at) — int4
  • Field (mttfb) — float
  • Field (finished_at) — bigint

STATUS

  • id — int8 — Primary key — NOT NULL
  • id (result_id) — int8 — Foreign key → result.id — NOT NULL
  • (http_status_code) — int
  • Field (count) — int
  • Field (message) — string

TEST_ERROR_LOG

  • id — int8 — Primary key — NOT NULL
  • (message) — string
  • Field (created_at) — timestamp — NOT NULL

TEST_TEMPLATE

  • id — int8 — Primary key — NOT NULL
  • 유저id (user_group_id) — string — Foreign key → USER_GROUP.그룹id — NOT NULL
  • url — string — NOT NULL
  • method — string — NOT NULL
  • json (body) — jsonb
  • vuser — int4 — NOT NULL
  • max_request (requests) — int4
  • max_duration (duration) — int8
  • Field (created_at) — timestamp — NOT NULL
  • Field (updtaed_at) — timestamp — NOT NULL
  • name — varchar
  • description — varchar

TPS

  • id — int8 — Primary key — NOT NULL
  • id (result_id) — int8 — Foreign key → result.id — NOT NULL
  • (started_at) — int4
  • Field (transaction) — int4
  • Field (finished_at) — bigint

USER

  • 유저id (id) — string — Primary key — NOT NULL
  • 유저pw (pw) — string — NOT NULL
  • 권한 (role) — string — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL
  • Field (slack_webhook_url) — string
  • Field (slack_notification) — boolean — NOT NULL
  • 유저이메일 (email) — string
  • Field (email_notification) — boolean — NOT NULL

USER_GROUP

  • 그룹id (id) — string — Primary key — NOT NULL
  • 유저pw (group_name) — string — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL

USER_GROUP_JOIN

  • jointableid (id) — int8 — Primary key — NOT NULL
  • 유저id (user_id) — string — Foreign key → USER.유저id — NOT NULL
  • 그룹id (group_id) — string — Foreign key → USER_GROUP.그룹id — NOT NULL
  • Field (role) — string — NOT NULL

result (RESULT)

  • id — int8 — Primary key — NOT NULL
  • id (test_template_id) — int8 — Foreign key → TEST_TEMPLATE.id
  • 유저id (user_group_id) — int8 — Foreign key → USER_GROUP.그룹id — NOT NULL
  • (total_request) — int4
  • Field (total_error) — int4
  • Field (total_success) — int4
  • Field (tps_avg) — bigint
  • Field (mttfb_avg) — bigint
  • Field (started_at) — timestamp — NOT NULL
  • Field (finished_at) — timestamp — NOT NULL