docsa-new
테이블 (18)
S3 Object 삭제 outbox (s3_delete_outbox)
- id — bigint — 기본 키 — NOT NULL
- max_retry — int — NOT NULL
- retry_count — int — NOT NULL
- created_at — datetime(6) — NOT NULL
- done_at — datetime(6)
- image_id — bigint — 외래 키 → 이미지.id — NOT NULL
- updated_at — datetime(6)
- version — bigint
- object_key — varchar(500) — NOT NULL
- last_error — varchar(2000)
- status — enum('DONE','FAILED','OPEN','PROCESSING') — NOT NULL
domain_event_outbox
- id — bigint — 기본 키 — NOT NULL
- max_retry — int — NOT NULL
- retry_count — int — NOT NULL
- created_at — datetime(6) — NOT NULL
- done_at — datetime(6)
- updated_at — datetime(6)
- version — bigint
- last_error — varchar(2000)
- aggregate_id — varchar(255) — NOT NULL
- aggregate_type — enum('DOC','BRANCH','COMMIT','SAVE','THUMBNAIL') — NOT NULL
- event_type — enum('DOC_CREATED','DOC_TITLE_CHANGED','DOC_ACTIVITY_CHANGED','DOC_THUMBNAIL_CHANGED','DOC_DELETED') — NOT NULL
- payload — json — NOT NULL
- status — enum('DONE','FAILED','OPEN','PROCESSING') — NOT NULL
mongo_outbox_block_ids
- outbox_id — bigint — 외래 키 → 몽고데이터 삭제 outbox.id — NOT NULL
- block_id — varchar(255)
mongo_outbox_commit_ids
- outbox_id — bigint — 외래 키 → 몽고데이터 삭제 outbox.id — NOT NULL
- commit_id — varchar(255)
mongo_outbox_save_ids
- outbox_id — bigint — 외래 키 → 몽고데이터 삭제 outbox.id — NOT NULL
- save_id — varchar(255)
간선 (edges)
- id — bigint — 기본 키 — NOT NULL
- document_id — bigint — 외래 키 → 문서.id — NOT NULL
- next_commit_id — bigint — 외래 키 → 기록.id — NOT NULL
- prev_commit_id — bigint — 외래 키 → 기록.id — NOT NULL
기록 (commits)
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)
- commit_mongo_id — varchar(255)
- description — varchar(255)
- title — varchar(255) — NOT NULL
- branch_id — bigint — 외래 키 → 브랜치.id
기록의문단리스트_mongo (commitBlockSequence)
- id — varchar(255) — 기본 키 — NOT NULL
- blockOrders — json
몽고데이터 삭제 outbox (mongo_delete_outbox)
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)
- trigger_type — enum('COMPENSATE','DELETE') — NOT NULL
- domain_type — enum('BRANCH','COMMIT','DOC','MERGE','SAVE') — NOT NULL
- origin_id — varchar(255) — NOT NULL
- status — enum('DONE','FAILED','OPEN','PROCESSING') — NOT NULL
- retry_count — int — NOT NULL
- max_retry — int — NOT NULL
- done_at — datetime(6)
- last_error — varchar(2000)
- version — bigint
문서 (docs)
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)
- title — varchar(50) — NOT NULL
- user_id — bigint — 외래 키 → 유저.id — NOT NULL
문서목록read_model (doc_list_read_models)
- id — bigint — 기본 키 — NOT NULL
- userId — bigint
- title — varchar(255)
- createdAt — datetime
- updatedAt — datetime
- recentSaveId — bigint
- thumbnailObjectKey — varchar(500)
- thumbnailStatus — varchar(50)
- deleted — boolean
- lastProjectedEventId — bigint
- titleProjectedEventId — bigint
- activityProjectedEventId — bigint
- thumbnailProjectedEventId — bigint
- deletedEventId — bigint
브랜치 (branches)
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)
- name — varchar(100) — NOT NULL
- document_id — bigint — 외래 키 → 문서.id
- from_commit_id — bigint — 외래 키 → 기록.id
- leaf_commit_id — bigint — 외래 키 → 기록.id
- root_commit_id — bigint — 외래 키 → 기록.id
- merge_target_commit_id — bigint — 외래 키 → 기록.id
블록json_mongo (block)
- id — varchar(255) — 기본 키 — NOT NULL
- content — json
썸네일 (doc_thumbnails)
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- current_image_id — bigint — 외래 키 → 이미지.id
- doc_id — bigint — 외래 키 → 문서.id — NOT NULL
- generated_at — datetime(6)
- request_token — bigint — NOT NULL
- requested_at — datetime(6)
- updated_at — datetime(6)
- version — bigint
- last_error — varchar(500)
- signature — varchar(255)
- status — enum('EMPTY','FAILED','PENDING','READY') — NOT NULL
워크스페이스 (saves)
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)
- save_mongo_id — varchar(255) — NOT NULL
- branch_id — bigint — 외래 키 → 브랜치.id — NOT NULL
워크스페이스 본문_mongo (saveContent)
- id — varchar(255) — 기본 키 — NOT NULL
- content — json
유저 (users)
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)
- email — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
이미지 (images)
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)
- user_id — bigint — NOT NULL
- doc_id — bigint — NOT NULL
- original_file_name — varchar(255) — NOT NULL
- purpose — enum('DOC_CONTENT','DOC_THUMBNAIL') — NOT NULL
- object_key — varchar(500) — NOT NULL
- content_type — varchar(255) — NOT NULL
- size — bigint — NOT NULL
- status — enum('ACTIVE','DELETED','DELETING','FAILED','PENDING') — NOT NULL