대시보드

테이블 (8)

dashboard_link (링크 url)

  • id (Key) — 기본 키 — NOT NULL
  • widget_id (Key2) — 외래 키 → dashboard_project_widget.id — NOT NULL
  • id (Key22) — 외래 키 → dashboard_project_widget.widget_id — NOT NULL
  • project_id (Field)
  • name (Field2)
  • url (Field3)

dashboard_milestorn_event (마일스톤 이벤트)

  • id (Key) — 기본 키 — NOT NULL
  • widget_id (Key2) — 외래 키 → dashboard_project_widget.id — NOT NULL
  • id (Key22) — 외래 키 → dashboard_project_widget.widget_id — NOT NULL
  • project_id (Field3)
  • title (Field)
  • date (Field2)

dashboard_project_cctv (Untitled3)

  • id (Key) — 외래 키 → dashboard_project_widget.id — NOT NULL
  • widget_id (Key2) — 외래 키 → dashboard_project_widget.widget_id — NOT NULL
  • project_id (Field)
  • url (Field2)
  • name (Field3)
  • index (Field4)

dashboard_project_material (Untitled2)

  • Key — 기본 키 — NOT NULL
  • id (Key2) — 외래 키 → dashboard_project_widget.id — NOT NULL
  • widget_id (Key22) — 외래 키 → dashboard_project_widget.widget_id — NOT NULL
  • material (Field)
  • unit (Field2)
  • project_id (Field3)

dashboard_project_widget (프로젝트대시보드위젯)

  • id (Key) — 기본 키 — NOT NULL
  • widget_id (Key2) — 외래 키 → dashboard_widget.id — NOT NULL
  • widget_type (위젯 타입)
  • project_id (Field2)
  • name (위젯이름)
  • origin_view_name (Field7)
  • description (설명)
  • view_name (화면표시)
  • milestone_type (마일스톤 타입)
  • milestone_start_date (마일스톤 일정)
  • milestone_end_date (Field4)
  • tool_type (장비타입)
  • x (Field)
  • y (Field3)
  • w (Field6)
  • h (Field5)

dashboard_project_work_category (CopyOfUntitled2)

  • Key — 기본 키 — NOT NULL
  • id (Key2) — 외래 키 → dashboard_project_widget.id — NOT NULL
  • widget_id (Key22) — 외래 키 → dashboard_project_widget.widget_id — NOT NULL
  • project_id (Field3)
  • name (Field)
  • group_category (Field2)
  • gubun (Field4)

dashboard_widget (대시보드 위젯)

  • id (Key) — 기본 키 — NOT NULL
  • name (위젯이름) — string
  • description (설명)
  • view_name (화면표시)
  • widget_type (Field5)
  • x (Field)
  • y (Field2)
  • w (Field3)
  • h (Field4)

document_setting (Untitled)

  • randing_page (Field)