ㅇㅁㄴㅇㄴㄴㅁㅇㄴ

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