poc2

Tables (18)

boards

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → workspaces.id — NOT NULL — FK
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • thumbnail_url — TEXT
  • created_by — UUID — Foreign key → users.id — NOT NULL — FK
  • last_edited_by — UUID — Foreign key → users.id — FK
  • viewport_state — JSONB — 뷰포트
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP — Soft

design_layers

  • id — UUID — Primary key — NOT NULL
  • board_id — UUID — Foreign key → boards.id — NOT NULL — FK
  • node_id — UUID — Foreign key → nodes.id — FK
  • name — VARCHAR(255) — NOT NULL
  • layer_type — design_layer_type — NOT NULL
  • z_index — INTEGER — NOT NULL
  • is_visible — BOOLEAN — NOT NULL
  • is_locked — BOOLEAN — NOT NULL
  • opacity — REAL — NOT NULL — 0.0
  • properties — JSONB — NOT NULL — 위치/크기/변환
  • asset_id — UUID — Foreign key → generated_assets.id — FK
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP — Soft

edges

  • id — UUID — Primary key — NOT NULL
  • board_id — UUID — Foreign key → boards.id — NOT NULL — FK
  • source_node_id — UUID — Foreign key → nodes.id — NOT NULL — FK
  • source_port_id — UUID — Foreign key → node_ports.id — NOT NULL — FK
  • target_node_id — UUID — Foreign key → nodes.id — NOT NULL — FK
  • target_port_id — UUID — Foreign key → node_ports.id — NOT NULL — FK
  • created_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP — Soft

generated_assets

  • id — UUID — Primary key — NOT NULL
  • node_execution_result_id — UUID — Foreign key → node_execution_results.id — FK
  • board_id — UUID — Foreign key → boards.id — NOT NULL — FK
  • asset_type — generated_asset_type — NOT NULL
  • storage_path — TEXT — NOT NULL — S3/GCS
  • cdn_url — TEXT
  • file_size_bytes — BIGINT
  • width — INTEGER
  • height — INTEGER
  • mime_type — VARCHAR(100) — NOT NULL
  • metadata — JSONB — AI
  • created_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP — Soft

inpaint_configs

  • id — UUID — Primary key — NOT NULL
  • node_id — UUID — Foreign key → nodes.id — NOT NULL — FK
  • color_scheme — JSONB — 색상
  • material_preset — VARCHAR(100)
  • custom_params — JSONB — 커스터마이징
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

node_execution_results

  • id — UUID — Primary key — NOT NULL
  • workflow_run_id — UUID — Foreign key → workflow_runs.id — NOT NULL — FK
  • node_id — UUID — Foreign key → nodes.id — NOT NULL — FK
  • status — node_exec_status — NOT NULL
  • execution_order — INTEGER — NOT NULL
  • input_snapshot — JSONB — 실행
  • output_data — JSONB — 출력값
  • error_message — TEXT
  • started_at — TIMESTAMP
  • completed_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

node_ports

  • id — UUID — Primary key — NOT NULL
  • node_id — UUID — Foreign key → nodes.id — NOT NULL — FK
  • port_type — node_port_direction — NOT NULL — 포트
  • port_key — VARCHAR(100) — NOT NULL — 포트
  • data_type — VARCHAR(50) — NOT NULL — 데이터
  • label — VARCHAR(100)
  • is_required — BOOLEAN — NOT NULL
  • position_order — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

nodes

  • id — UUID — Primary key — NOT NULL
  • board_id — UUID — Foreign key → boards.id — NOT NULL — FK
  • node_type — VARCHAR(100) — NOT NULL — 노드 종류. text / image / image_generator / image_edit / design_report / list / multi_view
  • label — VARCHAR(255)
  • position_x — REAL — NOT NULL
  • position_y — REAL — NOT NULL
  • width — REAL — NOT NULL
  • height — REAL — NOT NULL
  • config — JSONB — NOT NULL — 노드 타입별 파라미터. 타입마다 구조가 달라 JSON으로 관리
  • z_index — INTEGER — NOT NULL — 캔버스에서 노드 간 겹침 순서
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP — Soft

password_reset_tokens

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • token_hash — VARCHAR(255) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL — 만료
  • used_at — TIMESTAMP — 사용
  • created_at — TIMESTAMP — NOT NULL

report_exports

  • id — UUID — Primary key — NOT NULL
  • report_id — UUID — Foreign key → reports.id — NOT NULL — FK
  • exported_by — UUID — Foreign key → users.id — NOT NULL — FK
  • export_format — report_export_format — NOT NULL
  • status — report_export_status — NOT NULL
  • storage_path — TEXT
  • cdn_url — TEXT
  • file_size_bytes — BIGINT
  • error_message — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • completed_at — TIMESTAMP

report_sections

  • id — UUID — Primary key — NOT NULL
  • report_id — UUID — Foreign key → reports.id — NOT NULL — FK
  • section_type — report_section_type — NOT NULL
  • title — VARCHAR(255)
  • content — JSONB — NOT NULL — 섹션
  • asset_id — UUID — Foreign key → generated_assets.id — FK
  • display_order — INTEGER — NOT NULL — 표시
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

reports

  • id — UUID — Primary key — NOT NULL
  • board_id — UUID — Foreign key → boards.id — NOT NULL — FK
  • created_by — UUID — Foreign key → users.id — NOT NULL — FK
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • status — report_status — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP — Soft

similar_model_references

  • id — UUID — Primary key — NOT NULL
  • report_id — UUID — Foreign key → reports.id — NOT NULL — FK
  • name — VARCHAR(255) — NOT NULL
  • source_url — TEXT
  • thumbnail_url — TEXT
  • similarity_score — REAL — AI
  • metadata — JSONB
  • display_order — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

user_sessions

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL — FK
  • token_hash — VARCHAR(255) — NOT NULL — 세션
  • ip_address — VARCHAR(45) — 접속
  • user_agent — TEXT — 브라우저
  • expires_at — TIMESTAMP — NOT NULL — 만료
  • created_at — TIMESTAMP — NOT NULL

users

  • id — UUID — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL — 로그인
  • password_hash — VARCHAR(255) — 비밀번호
  • name — VARCHAR(100) — NOT NULL
  • avatar_url — TEXT
  • email_verified — BOOLEAN — NOT NULL — 이메일
  • is_active — BOOLEAN — NOT NULL — 계정
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP — Soft

workflow_runs

  • id — UUID — Primary key — NOT NULL
  • board_id — UUID — Foreign key → boards.id — NOT NULL — FK
  • triggered_by — UUID — Foreign key → users.id — NOT NULL — FK
  • run_mode — workflow_run_mode — NOT NULL
  • target_node_id — UUID — Foreign key → nodes.id — FK
  • status — workflow_run_status — NOT NULL
  • started_at — TIMESTAMP
  • completed_at — TIMESTAMP
  • error_message — TEXT
  • created_at — TIMESTAMP — NOT NULL

workspace_members

  • id — BIGSERIAL — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL — FK
  • role — workspace_role — NOT NULL — 역할
  • invited_by — UUID — Foreign key → users.id — FK
  • joined_at — TIMESTAMP — 참여
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

workspaces

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL — 워크스페이스
  • description — TEXT
  • owner_id — UUID — Foreign key → users.id — NOT NULL — FK
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP — Soft