checkmate
Tables (8)
chart_type (차트 유형)
- id — BIGSERIAL
- name — VARCHAR(50) — NOT NULL
dashboard (대시보드)
- dashboard_id (id) — BIGSERIAL — Primary key
- member_id — BIGINT — NOT NULL
- display_order — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
dashboard_metric_card
- position — INT — NOT NULL
- size_x — INT — NOT NULL
- size_y — INT — NOT NULL
- dashboard_id (id) — BIGSERIAL — Foreign key → dashboard.dashboard_id
- metric_card (metrinc_card) — BIGSERIAL — Foreign key → metric_card.metric_card_id
exposure_element (노출요소)
- exposure_element_id (id) — BIGSERIAL — Primary key
- name — VARCHAR(50) — NOT NULL
metric_card (지표카드)
- metric_card_id (id) — BIGSERIAL — Primary key
- name — VARCHAR(100) — NOT NULL
- metric_detail_id — BIGINT — NOT NULL
- period — period_type — NOT NULL
- compare_period — period_type
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
metric_card_exposure_element
- metric_card_id (id) — BIGSERIAL — Foreign key → metric_card.metric_card_id
- exposure_element_id (id2) — BIGSERIAL — Foreign key → exposure_element.exposure_element_id
metric_category (지표 카테고리)
- metric_category_id (id) — BIGSERIAL
- name — VARCHAR(100) — NOT NULL
metric_detail
- metric_detali_id (상세지표) — BIGSERIAL — Primary key
- name — VARCHAR(100) — NOT NULL
- chart_type_id — BIGINT — NOT NULL
- calc_type — metric_calc_type — NOT NULL
- compare_basis — VARCHAR(50)
- default_period — period_type — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP