IntraFlow

Tables (15)

app_meta

  • key — TEXT — Primary key — NOT NULL — Local 앱 메타 키
  • value — TEXT — schema_version/current_user_id/current_device_id 등

assignment_progress

  • assignment_id — TEXT — Primary key — Foreign key → assignments.id — NOT NULL — PK + FK, Assignment당 최대 1개 진행 상태
  • user_id — TEXT — Foreign key → users.id — NOT NULL — 진행 데이터 소유자
  • device_id — TEXT — Foreign key → devices.id — 마지막 수정 장치
  • schedule_start — TEXT — 담당자 업무 일정 시작 YYYY-MM-DD
  • schedule_end — TEXT — 담당자 업무 일정 종료 YYYY-MM-DD
  • completed_quantity — REAL — NOT NULL — 완료량 >= 0
  • note — TEXT — 공개 업무 특이사항
  • revision — INTEGER — NOT NULL — 사용자 snapshot 내 revision
  • updated_at — TEXT — NOT NULL — UTC ISO-8601

assignments

  • id — TEXT — Primary key — NOT NULL — UUIDv4
  • work_item_id — TEXT — Foreign key → work_items.id — NOT NULL — assignments.work_item_id → work_items.id
  • user_id — TEXT — Foreign key → users.id — NOT NULL — assignments.user_id → users.id
  • allocated_quantity — REAL — NOT NULL — 사용자 할당량 >= 0
  • status — TEXT — NOT NULL — ACTIVE/CANCELLED
  • is_deleted — INTEGER — NOT NULL — 0/1
  • created_at — TEXT — NOT NULL — UTC ISO-8601
  • updated_at — TEXT — NOT NULL — UTC ISO-8601

calendar_events

  • id — TEXT — Primary key — NOT NULL — UUIDv4
  • user_id — TEXT — Foreign key → users.id — NOT NULL — 일정 소유자
  • title — TEXT — NOT NULL — 일정 제목
  • event_type — TEXT — NOT NULL — MEETING/ABSENCE/OTHER
  • start_at — TEXT — NOT NULL — UTC ISO-8601
  • end_at — TEXT — UTC ISO-8601
  • visibility — TEXT — NOT NULL — PRIVATE/TEAM
  • memo — TEXT — 간단 메모
  • revision — INTEGER — NOT NULL — 일정 revision
  • is_deleted — INTEGER — NOT NULL — 0/1 tombstone
  • created_at — TEXT — NOT NULL — UTC ISO-8601
  • updated_at — TEXT — NOT NULL — UTC ISO-8601

devices

  • id — TEXT — Primary key — NOT NULL — UUIDv4
  • user_id — TEXT — Foreign key → users.id — NOT NULL — devices.user_id → users.id
  • device_name — TEXT — 설치 PC 이름
  • is_current — INTEGER — NOT NULL — 0/1
  • created_at — TEXT — NOT NULL — UTC ISO-8601
  • last_seen_at — TEXT — UTC ISO-8601

parts

  • id — TEXT — Primary key — NOT NULL — UUIDv4
  • project_id — TEXT — Foreign key → projects.id — NOT NULL — parts.project_id → projects.id
  • name — TEXT — NOT NULL — Part 이름
  • weight — REAL — NOT NULL — 0 < weight <= 1
  • planned_start — TEXT — YYYY-MM-DD
  • planned_end — TEXT — YYYY-MM-DD
  • sort_order — INTEGER — NOT NULL — 표시 순서
  • is_deleted — INTEGER — NOT NULL — 0/1 tombstone
  • created_at — TEXT — NOT NULL — UTC ISO-8601
  • updated_at — TEXT — NOT NULL — UTC ISO-8601

personal_notes

  • id — TEXT — Primary key — NOT NULL — UUIDv4, Local only
  • user_id — TEXT — Foreign key → users.id — NOT NULL — Local 전용 메모 소유자
  • title — TEXT — NOT NULL — 메모 제목
  • content — TEXT — 메모 본문
  • is_pinned — INTEGER — NOT NULL — 0/1
  • created_at — TEXT — NOT NULL — UTC ISO-8601
  • updated_at — TEXT — NOT NULL — UTC ISO-8601
  • is_deleted — INTEGER — NOT NULL — 0/1

progress_history

  • id — TEXT — Primary key — NOT NULL — UUIDv4
  • assignment_id — TEXT — Foreign key → assignments.id — NOT NULL — 진행 이력 대상 Assignment
  • user_id — TEXT — Foreign key → users.id — NOT NULL — 이력 소유자
  • device_id — TEXT — Foreign key → devices.id — 변경 장치
  • previous_quantity — REAL — NOT NULL — 변경 전 완료량
  • delta_quantity — REAL — NOT NULL — 증감량
  • current_quantity — REAL — NOT NULL — 변경 후 완료량 >= 0
  • note — TEXT — 변경 당시 특이사항
  • created_at — TEXT — NOT NULL — UTC ISO-8601

project_editors

  • project_id — TEXT — Primary key — Foreign key → projects.id — NOT NULL — 복합 PK, Project FK
  • user_id — TEXT — Primary key — Foreign key → users.id — NOT NULL — 복합 PK, User FK

projects

  • id — TEXT — Primary key — NOT NULL — UUIDv4
  • updated_by — TEXT — Foreign key → users.id — 마지막 수정 사용자
  • name — TEXT — NOT NULL — 프로젝트명
  • description — TEXT — 설명
  • planned_start — TEXT — YYYY-MM-DD
  • planned_end — TEXT — YYYY-MM-DD
  • status — TEXT — NOT NULL — 프로젝트 상태
  • revision — INTEGER — NOT NULL — project.json revision
  • is_deleted — INTEGER — NOT NULL — 0/1 tombstone
  • created_at — TEXT — NOT NULL — UTC ISO-8601
  • updated_at — TEXT — NOT NULL — UTC ISO-8601

sync_outbox

  • id — TEXT — Primary key — NOT NULL — UUIDv4
  • target_type — TEXT — NOT NULL — USER_PUBLIC 등
  • target_id — TEXT — NOT NULL — Snapshot 대상 ID
  • created_at — TEXT — NOT NULL — UTC ISO-8601
  • retry_count — INTEGER — NOT NULL — 재시도 횟수
  • next_retry_at — TEXT — UTC ISO-8601
  • last_error — TEXT — 최근 오류

sync_state

  • source_type — TEXT — Primary key — NOT NULL — SYSTEM/USERS/PROJECT/USER_PUBLIC
  • source_id — TEXT — Primary key — NOT NULL — 동기화 원본 식별자
  • remote_revision — INTEGER — NOT NULL — 마지막 반영 revision
  • last_sync_at — TEXT — UTC ISO-8601
  • last_hash — TEXT — 선택적 Snapshot hash

units

  • id — TEXT — Primary key — NOT NULL — UUIDv4
  • code — TEXT — NOT NULL — 단위 코드, UNIQUE
  • display_name — TEXT — NOT NULL — 표시명
  • is_active — INTEGER — NOT NULL — 0/1
  • sort_order — INTEGER — NOT NULL — 표시 순서

users

  • id — TEXT — Primary key — NOT NULL — UUIDv4
  • user_code — TEXT — NOT NULL — 로그인/식별용 사용자 코드, UNIQUE
  • display_name — TEXT — NOT NULL — 화면 표시 이름
  • department — TEXT — 부서
  • is_system_admin — INTEGER — NOT NULL — 0/1, 시스템 설정 권한
  • is_active — INTEGER — NOT NULL — 0/1
  • created_at — TEXT — NOT NULL — UTC ISO-8601
  • updated_at — TEXT — NOT NULL — UTC ISO-8601
  • revision — INTEGER — NOT NULL — 공유 사용자 정보 revision

work_items

  • id — TEXT — Primary key — NOT NULL — UUIDv4
  • part_id — TEXT — Foreign key → parts.id — NOT NULL — work_items.part_id → parts.id
  • unit_id — TEXT — Foreign key → units.id — NOT NULL — work_items.unit_id → units.id
  • name — TEXT — NOT NULL — 업무명
  • total_quantity — REAL — NOT NULL — 총 업무량 >= 0
  • weight — REAL — NOT NULL — 0 < weight <= 1
  • planned_start — TEXT — YYYY-MM-DD
  • planned_end — TEXT — YYYY-MM-DD
  • sort_order — INTEGER — NOT NULL — 표시 순서
  • is_deleted — INTEGER — NOT NULL — 0/1 tombstone
  • created_at — TEXT — NOT NULL — UTC ISO-8601
  • updated_at — TEXT — NOT NULL — UTC ISO-8601