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