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