ㅇㅁㄴㅇㄴㄴㅁㅇㄴ
Tables (19)
boards
- id — CHAR(36) — Primary key — NOT NULL — FK → users.id
- workspace_id — CHAR(36) — Foreign key → workspaces.id — NOT NULL — FK → users.id
- name — VARCHAR(255) — NOT NULL — 뷰포트 줌/팬 상태 (자동저장)
- description — TEXT
- thumbnail_url — TEXT — Soft Delete
- created_by — CHAR(36) — Foreign key → users.id — NOT NULL — UUID PK
- last_edited_by — CHAR(36) — Foreign key → users.id — FK → boards.id
- viewport_state — JSON — 노드 타입 (text/image/image_generator/image_edit/design_report/list/multi_view)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME — 노드 표시 이름
design_layers
- id — CHAR(36) — Primary key — NOT NULL — Redo용 이후 상태 스냅샷
- board_id — CHAR(36) — Foreign key → boards.id — NOT NULL — 보드 내 히스토리 순서
- node_id — CHAR(36) — Foreign key → nodes.id — UUID PK
- 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 — FK → nodes.id
- properties — JSON — NOT NULL — 색상 팔레트 설정
- asset_id — CHAR(36) — Foreign key → generated_assets.id — 소재 프리셋 (fabric/leather/metal 등)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME — 커스터마이징 파라미터
edges
- id — CHAR(36) — Primary key — NOT NULL — 동일 포트 간 중복 연결 방지
- board_id — CHAR(36) — Foreign key → boards.id — NOT NULL — UUID PK
- source_node_id — CHAR(36) — Foreign key → nodes.id — NOT NULL — FK → boards.id
- source_port_id — CHAR(36) — Foreign key → node_ports.id — NOT NULL — FK → users.id
- target_node_id — CHAR(36) — Foreign key → nodes.id — NOT NULL — 실행 모드
- target_port_id — CHAR(36) — NOT NULL — FK → nodes.id (single_node 모드 시)
- created_at — DATETIME — NOT NULL
- deleted_at — DATETIME — UUID PK
- =노드 — 간
edit_histories
- id — CHAR(36) — Primary key — NOT NULL — FK → boards.id
- board_id — CHAR(36) — Foreign key → boards.id — NOT NULL — FK → workflow_runs.id
- user_id — CHAR(36) — NOT NULL — FK → users.id
- action_type — VARCHAR(100) — NOT NULL — Soft Delete
- before_state — JSON — UUID PK
- after_state — JSON — NOT NULL — FK → reports.id
- sequence_num — INT — NOT NULL — 섹션 타입별 콘텐츠 구조
- created_at — DATETIME — NOT NULL
- =편집 — 히스토리
generated_assets
- id — CHAR(36) — Primary key — NOT NULL — FK → nodes.id (연결된 노드)
- node_execution_result_id — CHAR(36) — Foreign key → node_execution_results.id — 0.0 ~ 1.0
- board_id — CHAR(36) — NOT NULL — 위치/크기/변환 등
- asset_type — ENUM('image', 'mask', '3d_model', 'video') — NOT NULL
- storage_path — TEXT — NOT NULL — FK → generated_assets.id
- cdn_url — TEXT
- file_size_bytes — BIGINT
- width — INT
- height — INT
- mime_type — VARCHAR(100) — NOT NULL
- metadata — JSON — Soft Delete
- created_at — DATETIME — NOT NULL
- deleted_at — DATETIME — UUID PK
- =생성된 — 에셋
inpaint_configs
- id — CHAR(36) — Primary key — NOT NULL — UUID PK
- node_id — CHAR(36) — Foreign key → nodes.id — NOT NULL — FK → reports.id
- color_scheme — JSON — 유사 모델명
- material_preset — VARCHAR(100) — AI 유사도 점수 (0.0 ~ 1.0)
- custom_params — JSON — UUID PK
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
node_execution_results
- id — CHAR(36) — Primary key — NOT NULL — S3/GCS 저장 경로
- workflow_run_id — CHAR(36) — Foreign key → workflow_runs.id — NOT NULL — AI 모델명/프롬프트/시드값 등
- node_id — CHAR(36) — Foreign key → nodes.id — NOT NULL — Soft Delete
- status — ENUM('pending', 'running', 'completed', 'failed', 'skipped') — NOT NULL
- execution_order — INT — NOT NULL — PK
- input_snapshot — JSON — FK → users.id
- output_data — JSON — UUID PK
- error_message — TEXT
- started_at — DATETIME
- completed_at — DATETIME
- created_at — DATETIME — NOT NULL
node_ports
- id — CHAR(36) — Primary key — NOT NULL — FK → boards.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 — FK → nodes.id
- data_type — VARCHAR(50) — NOT NULL — FK → node_ports.id
- 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 — 캔버스 Y 좌표
- board_id — CHAR(36) — Foreign key → boards.id — NOT NULL — 노드 타입별 파라미터
- 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
- config — JSON — NOT NULL — 포트 식별 키 (image_in/prompt/image_out 등)
- z_index — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME — 데이터 타입 (image/text/number/mask)
password_reset_tokens
- id — BIGINT — Primary key — NOT NULL — FK → users.id
- user_id — CHAR(36) — Foreign key → users.id — NOT NULL — 액션 유형 (brush_stroke/layer_move/inpaint_apply 등)
- 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 — FK → users.id
- board_id — CHAR(36) — Foreign key → boards.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 — UUID 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) — 비밀번호 해시
- 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 — 실행 순서
- board_id — CHAR(36) — Foreign key → boards.id — NOT NULL — 실행 시점 입력값 스냅샷
- triggered_by — CHAR(36) — Foreign key → users.id — NOT NULL — 출력값 (이미지 URL 포함)
- run_mode — ENUM('single_node', 'partial_chain', 'full_chain') — NOT NULL — UUID PK
- target_node_id — CHAR(36) — Foreign key → nodes.id — FK → node_execution_results.id
- 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 — 역할
- workspace_id — CHAR(36) — Foreign key → workspaces.id — NOT NULL — FK → users.id (초대한 사용자)
- user_id — CHAR(36) — Foreign key → users.id — NOT NULL — 참여 시각
- role — ENUM('owner', 'admin', 'member', 'viewer') — NOT NULL — UUID PK
- invited_by — CHAR(36) — Foreign key → users.id — FK → workspaces.id
- joined_at — DATETIME — 보드 이름
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
workspaces
- id — CHAR(36) — Primary key — NOT NULL — URL용 식별자
- name — VARCHAR(255) — NOT NULL — FK → users.id
- slug — VARCHAR(100) — NOT NULL — Soft Delete
- description — TEXT
- owner_id — CHAR(36) — Foreign key → users.id — NOT NULL — PK
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME — FK → workspaces.id