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