test

Tables (14)

xm_dashboard

  • dashboard_id — bigserial — Primary key — NOT NULL
  • deleted — bool — NOT NULL
  • created_by — int8
  • created_date — timestamp
  • modified_by — int8
  • modified_date — timestamp
  • dashboard_name — varchar(255)
  • preset — bool
  • user_id — int8
  • start_screen — bool
  • value — text
  • description — varchar(1000)
  • image — text
  • share — bool
  • share_users — text — 미사용
  • featured_report — bool
  • custom_report — bool
  • extends_edit — bool — NOT NULL
  • extends_delete — bool — NOT NULL
  • extends_share — bool — NOT NULL
  • icon_id — varchar
  • alias — varchar

xm_dashboard_global_filter

  • global_filter_id — bigserial — Primary key — NOT NULL
  • dashboard_id — int8
  • alias — varchar(255)
  • category — varchar(255)
  • target_paths — text
  • deleted — bool
  • created_by — int8
  • created_date — timestamp
  • modified_by — int8
  • modified_date — timestamp
  • type — varchar(50)
  • is_target — bool
  • is_single — bool

xm_dashboard_group

  • dashboard_group_id — bigserial — Primary key — NOT NULL
  • deleted — bool — NOT NULL
  • created_by — int8
  • created_date — timestamp
  • modified_by — int8
  • modified_date — timestamp
  • dashboard_group_name — varchar(255)
  • user_id — int8

xm_dashboard_group_mapping

  • dashboard_group_mapping_id — bigserial — Primary key — NOT NULL
  • user_id — int8 — NOT NULL
  • dashboard_id — int8 — NOT NULL — 대시보드
  • dashboard_group_id — int8 — NOT NULL — 대시보드
  • created_by — int8 — NOT NULL — 생성
  • created_date — timestamp — NOT NULL — 생성일
  • modified_by — int8 — NOT NULL — 수정
  • modified_date — timestamp — NOT NULL — 수정일
  • deleted — bool — NOT NULL — 삭제

xm_dashboard_share_mapping

  • dashboard_share_id — bigserial — Primary key — NOT NULL
  • deleted — bool — NOT NULL
  • created_by — int8
  • created_date — timestamp
  • modified_by — int8
  • modified_date — timestamp
  • dashboard_id — int8
  • user_id — int8
  • extends_edit — bool — NOT NULL — 미사용
  • extends_share — bool — NOT NULL — 미사용
  • share — bool — NOT NULL — 보기

xm_dashboard_user_filter

  • user_filter_id — bigserial — Primary key — NOT NULL
  • global_filter_id — int8
  • name — varchar(255)
  • target_paths — text
  • deleted — bool
  • created_by — int8
  • created_date — timestamp
  • modified_by — int8
  • modified_date — timestamp
  • user_id — int8

xm_dashboard_widget_mapping

  • widget_mapping_id — bigserial — Primary key — NOT NULL
  • deleted — bool — NOT NULL
  • created_by — int8
  • created_date — timestamp
  • modified_by — int8
  • modified_date — timestamp
  • dashboard_id — int8 — 대시보드

xm_default_widget

  • default_widget_id — varchar(255) — Primary key — NOT NULL
  • disable — bool — NOT NULL
  • created_date — timestamp
  • data_id — varchar(255)
  • alias — varchar(255)
  • value — text
  • category — varchar(255)
  • data_type — varchar(255)
  • series_type — varchar(255)

xm_user_dashboard_gnb_mapping

  • gnb_mapping_id — bigserial — Primary key — NOT NULL
  • user_id — int8
  • dashboard_id — int8
  • gnb_alias — text
  • deleted — bool — NOT NULL
  • created_by — int8
  • created_date — timestamp
  • modified_by — int8
  • modified_date — timestamp
  • analysis_gnb_alias — text
  • extra_gnb_alias — text

xm_user_favorite_dashboard

  • user_favorite_id — bigserial — Primary key — NOT NULL
  • deleted — bool — NOT NULL
  • created_by — int8
  • created_date — timestamp
  • modified_by — int8
  • modified_date — timestamp
  • dashboard_id — int8
  • user_id — int8
  • hash_code — varchar(255)

xm_user_option_dashboard

  • user_option_id — bigserial — Primary key — NOT NULL
  • deleted — bool — NOT NULL
  • created_by — int8
  • created_date — timestamp
  • modified_by — int8
  • modified_date — timestamp
  • dashboard_id — int8
  • user_id — int8
  • type — varchar(255)

xm_widget_value

  • widget_value_id — bigserial — Primary key — NOT NULL
  • deleted — bool — NOT NULL
  • created_by — int8
  • created_date — timestamp
  • modified_by — int8
  • modified_date — timestamp
  • height — int4
  • value — text
  • widget_type — varchar(255)
  • width — int4
  • x — int4
  • y — int4
  • widget_mapping_id — int8 — 매핑테이블
  • owner — bool
  • period — varchar(255)
  • chart_type — varchar(255)
  • display_style — varchar(255)
  • color_theme — varchar(255)
  • widget_color — varchar(255)
  • title_option — varchar(255)
  • chart_option — text
  • extra_id — varchar(255)
  • sync_type — varchar(50)
  • hidden_extra_id — varchar(255)
  • widget_uuid — varchar(255) — NOT NULL — 위젯의
  • filter_option — text
  • parent_uuid — varchar — 부모의

xm_widget_value_extra_target

  • extra_target_id — bigserial — Primary key — NOT NULL
  • deleted — bool — NOT NULL
  • created_by — int8
  • created_date — timestamp
  • modified_by — int8
  • modified_date — timestamp
  • custom_id — varchar(255)
  • target — text
  • widget_value_id — int8

xm_widget_value_target

  • xm_widget_value_target_id — bigserial — Primary key — NOT NULL
  • deleted — bool — NOT NULL
  • created_by — int8
  • created_date — timestamp
  • modified_by — int8
  • modified_date — timestamp
  • data_id — varchar(255) — 지표아이디
  • widget_value_id — int8 — 위젯
  • target_paths — text
  • aggregation — varchar(255)
  • alias — varchar(255)
  • platform — varchar(255)
  • value — text
  • category — varchar(255)
  • data_type — varchar(255)
  • series_type — varchar(255)
  • default — bool
  • global_filter_ids — text
  • group — varchar — 미사용
  • markers — text