랩스스튜디오

테이블 (7)

breakpoints (브레이크포인트)

  • id — UUID
  • code — VARCHAR(10) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • min_width — SMALLINT — NOT NULL
  • cols — SMALLINT — NOT NULL
  • sort_order — SMALLINT
  • created_at — TIMESTAMPTZ — NOT NULL

outbox_events

  • id — UUID
  • aggregate_type — VARCHAR(100) — NOT NULL
  • aggregate_id — VARCHAR(100) — NOT NULL
  • event_type — VARCHAR(100) — NOT NULL
  • payload — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • processed_at — TIMESTAMPTZ

tenant_brandings (테넌트 별 브랜딩 정보)

  • tenant_id — VARCHAR(50)
  • logo_light_url — VARCHAR(500)
  • logo_dark_url — VARCHAR(500)
  • favicon_url — VARCHAR(500)
  • primary_color — VARCHAR(20)
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — VARCHAR(100)

tenant_dashboard_publications (발행 히스토리)

  • id — UUID
  • tenant_id — VARCHAR(50) — NOT NULL
  • logo_light_url — VARCHAR(500)
  • logo_dark_url — VARCHAR(500)
  • favicon_url — VARCHAR(500)
  • primary_color — VARCHAR(20)
  • layout_snapshot — JSONB — NOT NULL
  • widget_snapshot — JSONB — NOT NULL
  • description — VARCHAR(500)
  • published_at — TIMESTAMPTZ — NOT NULL
  • published_by — VARCHAR(100)
  • restored_from — UUID

tenant_draft_layouts (위젯별 브레이크포인트별 좌표)

  • id — UUID
  • tenant_id — VARCHAR(50) — NOT NULL
  • widget_id — UUID — NOT NULL
  • breakpoint_code — VARCHAR(10) — NOT NULL
  • x — SMALLINT — NOT NULL
  • y — SMALLINT — NOT NULL
  • w — SMALLINT — NOT NULL
  • h — SMALLINT — NOT NULL
  • min_w — SMALLINT
  • min_h — SMALLINT
  • max_w — SMALLINT
  • max_h — SMALLINT
  • is_static — BOOLEAN
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

tenant_draft_widgets (위젯 인스턴스)

  • id — UUID
  • tenant_id — VARCHAR(50) — NOT NULL
  • widget_key — VARCHAR(100) — NOT NULL
  • widget_type_code — VARCHAR(50) — NOT NULL
  • title — VARCHAR(200)
  • config — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

widget_types (위젯 타입)

  • id — UUID
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • component_name — VARCHAR(100) — NOT NULL
  • default_w — SMALLINT — NOT NULL
  • default_h — SMALLINT — NOT NULL
  • min_w — SMALLINT — NOT NULL
  • min_h — SMALLINT — NOT NULL
  • max_w — SMALLINT — NOT NULL
  • max_h — SMALLINT — NOT NULL
  • metadata — JSONB
  • sort_order — SMALLINT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ