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