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