poc
Tables (19)
boards
- id — CHAR(36) — Primary key — NOT NULL — FK → boards.id (복제 출처)
- workspace_id — CHAR(36) — Foreign key → workspaces.id — NOT NULL — FK → users.id
- name — VARCHAR(255) — NOT NULL — FK → users.id
- description — TEXT
- thumbnail_url — TEXT — 뷰포트 줌/팬 상태
- created_by — CHAR(36) — Foreign key → users.id — NOT NULL — FK → boards.id
- last_edited_by — CHAR(36) — Foreign key → users.id — FK → users.id
- viewport_state — JSON — UUID PK
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME — FK → boards.id
design_layers
- id — CHAR(36) — Primary key — NOT NULL — UUID PK
- board_id — CHAR(36) — Foreign key → boards.id — NOT NULL — FK → nodes.id
- node_id — CHAR(36) — Foreign key → nodes.id — 색상 팔레트 설정
- name — VARCHAR(255) — NOT NULL
- layer_type — ENUM('image', 'mask', 'brush', 'group') — NOT NULL
- z_index — INT — NOT NULL
- is_visible — TINYINT(1) — NOT NULL
- is_locked — TINYINT(1) — NOT NULL
- opacity — FLOAT — NOT NULL — 소재 프리셋 (fabric/leather/metal 등)
- properties — JSON — NOT NULL — 커스터마이징 파라미터
- asset_id — CHAR(36) — Foreign key → generated_assets.id — UUID PK
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME — FK → boards.id
edges
- id — CHAR(36) — Primary key — NOT NULL — FK → boards.id
- board_id — CHAR(36) — Foreign key → boards.id — NOT NULL — FK → users.id
- source_node_id — CHAR(36) — Foreign key → nodes.id — NOT NULL — 실행 모드
- source_port_id — CHAR(36) — Foreign key → node_ports.id — NOT NULL — FK → nodes.id (single_node 모드 시)
- target_node_id — CHAR(36) — Foreign key → nodes.id — NOT NULL — UUID PK
- target_port_id — CHAR(36) — NOT NULL — FK → workflow_runs.id
- created_at — DATETIME — NOT NULL
- deleted_at — DATETIME — FK → nodes.id
edit_histories
- id — CHAR(36) — Primary key — NOT NULL — FK → users.id
- board_id — CHAR(36) — Foreign key → boards.id — NOT NULL — Soft Delete
- user_id — CHAR(36) — NOT NULL — UUID PK
- action_type — VARCHAR(100) — NOT NULL — FK → reports.id
- before_state — JSON — 섹션 타입별 콘텐츠 구조
- after_state — JSON — NOT NULL — FK → generated_assets.id
- sequence_num — INT — NOT NULL — UUID PK
- created_at — DATETIME — NOT NULL
generated_assets
- id — CHAR(36) — Primary key — NOT NULL — 위치/크기/변환 등
- node_execution_result_id — CHAR(36) — Foreign key → node_execution_results.id — FK → generated_assets.id
- board_id — CHAR(36) — NOT NULL — Soft Delete
- asset_type — ENUM('image', 'mask', '3d_model', 'video') — NOT NULL
- storage_path — TEXT — NOT NULL — UUID PK
- cdn_url — TEXT
- file_size_bytes — BIGINT
- width — INT
- height — INT
- mime_type — VARCHAR(100) — NOT NULL
- metadata — JSON — FK → boards.id
- created_at — DATETIME — NOT NULL
- deleted_at — DATETIME — FK → users.id
inpaint_configs
- id — CHAR(36) — Primary key — NOT NULL — 유사 모델명
- node_id — CHAR(36) — Foreign key → nodes.id — NOT NULL — AI 유사도 점수 (0.0 ~ 1.0)
- color_scheme — JSON — UUID PK
- material_preset — VARCHAR(100) — FK → reports.id
- custom_params — JSON — FK → users.id
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
node_execution_results
- id — CHAR(36) — Primary key — NOT NULL — Soft Delete
- workflow_run_id — CHAR(36) — Foreign key → workflow_runs.id — NOT NULL — PK
- node_id — CHAR(36) — Foreign key → nodes.id — NOT NULL — FK → users.id
- status — ENUM('pending', 'running', 'completed', 'failed', 'skipped') — NOT NULL
- execution_order — INT — NOT NULL — UUID PK
- input_snapshot — JSON — FK → boards.id
- output_data — JSON — FK → nodes.id (연결된 노드)
- error_message — TEXT
- started_at — DATETIME
- completed_at — DATETIME
- created_at — DATETIME — NOT NULL
node_ports
- id — CHAR(36) — Primary key — NOT NULL — FK → node_ports.id
- node_id — CHAR(36) — Foreign key → nodes.id — NOT NULL — FK → nodes.id
- port_type — ENUM('input', 'output') — NOT NULL — FK → node_ports.id
- port_key — VARCHAR(100) — NOT NULL — Soft Delete
- data_type — VARCHAR(50) — NOT NULL — 동일 포트 간 중복 연결 방지
- label — VARCHAR(100)
- is_required — TINYINT(1) — NOT NULL
- position_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
nodes
- id — CHAR(36) — Primary key — NOT NULL — 노드 타입별 파라미터
- board_id — CHAR(36) — Foreign key → boards.id — NOT NULL — 색상/아이콘 등 UI 커스터마이징
- node_type — VARCHAR(100) — NOT NULL — Soft Delete
- label — VARCHAR(255) — UUID PK
- position_x — FLOAT — NOT NULL — FK → nodes.id
- position_y — FLOAT — NOT NULL — 포트 방향
- width — FLOAT — NOT NULL
- height — FLOAT — NOT NULL
- is_collapsed — TINYINT(1) — NOT NULL — 포트 식별 키 (image_in/prompt/image_out 등)
- config — JSON — NOT NULL — 데이터 타입 (image/text/number/mask)
- ui_state — JSON — UUID PK
- z_index — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME — FK → boards.id
password_reset_tokens
- id — BIGINT — Primary key — NOT NULL — Undo용 이전 상태 스냅샷
- user_id — CHAR(36) — Foreign key → users.id — NOT NULL — Redo용 이후 상태 스냅샷
- token_hash — VARCHAR(255) — NOT NULL
- expires_at — DATETIME — NOT NULL
- used_at — DATETIME
- created_at — DATETIME — NOT NULL
report_exports
- id — CHAR(36) — Primary key — NOT NULL
- pptx) — NOT — NOT NULL
- status — ENUM('queued', 'processing', 'completed', 'failed') — NOT NULL
- storage_path — TEXT
- cdn_url — TEXT
- file_size_bytes — BIGINT
- error_message — TEXT
- created_at — DATETIME — NOT NULL
- completed_at — DATETIME
report_sections
- id — CHAR(36) — Primary key — NOT NULL
- custom) — NOT — NOT NULL
- title — VARCHAR(255)
- content — JSON — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
reports
- id — CHAR(36) — NOT NULL
- node_id — CHAR(36) — Foreign key → nodes.id — NOT NULL — 노드 타입별 파라미터
- description — TEXT
- status — ENUM('draft', 'generating', 'ready', 'failed') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
similar_model_references
- id — CHAR(36) — Primary key — NOT NULL
- thumbnail_url — TEXT
- similarity_score — FLOAT
- display_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
user_sessions
- id — CHAR(36) — Primary key — NOT NULL — FK → users.id
- user_id — CHAR(36) — Foreign key → users.id — NOT NULL — 세션 토큰 해시
- token_hash — VARCHAR(255) — NOT NULL — 접속 IP
- ip_address — VARCHAR(45) — 브라우저 정보
- user_agent — TEXT — 만료 시각
- expires_at — DATETIME — NOT NULL — PK
- created_at — DATETIME — NOT NULL
users
- id — CHAR(36) — Primary key — NOT NULL — UUID PK
- email — VARCHAR(255) — NOT NULL — 로그인 이메일
- password_hash — VARCHAR(255) — 소셜 로그인 시 NULL
- name — VARCHAR(100) — NOT NULL — 사용자 이름
- avatar_url — TEXT — 프로필 이미지 URL
- email_verified — TINYINT(1) — NOT NULL — 이메일 인증 여부
- is_active — TINYINT(1) — NOT NULL — 계정 활성 여부
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME — Soft Delete
workflow_runs
- id — CHAR(36) — Primary key — NOT NULL — 출력값 (이미지 URL 포함)
- board_id — CHAR(36) — Foreign key → boards.id — NOT NULL — UUID PK
- triggered_by — CHAR(36) — Foreign key → users.id — NOT NULL — FK → node_execution_results.id
- run_mode — ENUM('single_node', 'partial_chain', 'full_chain') — NOT NULL — FK → boards.id
- target_node_id — CHAR(36) — Foreign key → nodes.id — S3/GCS 저장 경로
- status — ENUM('queued', 'running', 'completed', 'failed', 'cancelled') — NOT NULL
- started_at — DATETIME
- completed_at — DATETIME
- error_message — TEXT
- created_at — DATETIME — NOT NULL
workspace_members
- id — BIGINT — Primary key — NOT NULL — FK → users.id (초대한 사용자)
- workspace_id — CHAR(36) — Foreign key → workspaces.id — NOT NULL — 참여 시각
- user_id — CHAR(36) — Foreign key → users.id — NOT NULL — UUID PK
- role — ENUM('owner', 'admin', 'member', 'viewer') — NOT NULL — FK → workspaces.id
- invited_by — CHAR(36) — Foreign key → users.id — 보드 이름
- joined_at — DATETIME — 썸네일 이미지 URL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
workspaces
- id — CHAR(36) — Primary key — NOT NULL — FK → users.id
- name — VARCHAR(255) — NOT NULL — 플랜 등급
- description — TEXT
- owner_id — CHAR(36) — Foreign key → users.id — NOT NULL — Soft Delete
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME — FK → users.id