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