쿼카이브final

테이블 (26)

app_settings

  • id — INTEGER — 기본 키 — NOT NULL
  • defaultArchiveView — TEXT — NOT NULL
  • deleteGalleryOnScrapDelete — INTEGER — NOT NULL
  • autoRemoveMissingGalleryImage — INTEGER — NOT NULL
  • notificationEnabled — INTEGER — NOT NULL
  • analysisCompleteNotificationEnabled — INTEGER — NOT NULL
  • createdAt — INTEGER — NOT NULL
  • updatedAt — INTEGER — NOT NULL

categories

  • id — INTEGER — 기본 키 — NOT NULL
  • parentId — INTEGER — 외래 키 → categories.id
  • name — TEXT — NOT NULL
  • centroid — BLOB — NOT NULL
  • memberCount — INTEGER — NOT NULL
  • isLeaf — INTEGER — NOT NULL
  • needsSplit — INTEGER — NOT NULL

category_members

  • categoryId — INTEGER — 외래 키 → categories.id — NOT NULL
  • scrapId — INTEGER — 외래 키 → scraps.id — NOT NULL

folders

  • id — INTEGER — 기본 키 — NOT NULL
  • parentFolderId — INTEGER — 외래 키 → folders.id
  • name — TEXT — NOT NULL
  • intentType — TEXT
  • color — TEXT
  • sortOrder — INTEGER — NOT NULL
  • isSystem — INTEGER — NOT NULL
  • createdAt — INTEGER — NOT NULL
  • updatedAt — INTEGER — NOT NULL

image_references

  • id — INTEGER — 기본 키 — NOT NULL
  • scrapId — INTEGER — 외래 키 → scraps.id — NOT NULL
  • mediaStoreUri — TEXT — NOT NULL
  • mediaStoreId — INTEGER
  • bucketId — TEXT
  • bucketName — TEXT
  • displayName — TEXT
  • mimeType — TEXT
  • width — INTEGER
  • height — INTEGER
  • sizeBytes — INTEGER
  • dateTaken — INTEGER
  • dateAdded — INTEGER
  • contentSha256 — TEXT
  • pHash — TEXT
  • sortOrder — INTEGER — NOT NULL
  • isMissing — INTEGER — NOT NULL
  • missingCheckedAt — INTEGER
  • createdAt — INTEGER — NOT NULL

legacy_scrap_reminder_migrations

  • scrapId — INTEGER — 기본 키 — NOT NULL
  • legacyReminderAt — INTEGER — 기본 키 — NOT NULL
  • questId — INTEGER
  • status — TEXT — NOT NULL
  • migratedAt — INTEGER
  • updatedAt — INTEGER — NOT NULL

link_references

  • scrapId — INTEGER — 외래 키 → scraps.id — NOT NULL
  • originalUrl — TEXT — NOT NULL
  • normalizedUrl — TEXT — NOT NULL
  • canonicalUrl — TEXT
  • thumbnailUrl — TEXT
  • faviconUrl — TEXT
  • domain — TEXT — NOT NULL
  • providerType — TEXT — NOT NULL
  • contentType — TEXT — NOT NULL
  • saveStatus — TEXT — NOT NULL
  • metadataFetchedAt — INTEGER

quest_reminders

  • id — INTEGER — 기본 키 — NOT NULL
  • questId — INTEGER — 외래 키 → quests.id — NOT NULL
  • offsetDays — INTEGER — NOT NULL
  • timeMinutes — INTEGER — NOT NULL
  • isEnabled — INTEGER — NOT NULL
  • createdAt — INTEGER — NOT NULL
  • updatedAt — INTEGER — NOT NULL

quest_scraps

  • questId — INTEGER — 외래 키 → quests.id — NOT NULL
  • scrapId — INTEGER — 외래 키 → scraps.id — NOT NULL
  • linkedAt — INTEGER — NOT NULL

quests

  • id — INTEGER — 기본 키 — NOT NULL
  • sourceType — TEXT — NOT NULL
  • generationType — TEXT — NOT NULL
  • scrapType — TEXT
  • questIntent — TEXT
  • status — TEXT — NOT NULL
  • templateCode — TEXT — NOT NULL
  • subjectName — TEXT
  • customTitle — TEXT
  • folderId — INTEGER — 외래 키 → folders.id
  • sourceTargetDate — INTEGER
  • targetDate — INTEGER
  • reminderAt — INTEGER
  • reminderOffsets — TEXT
  • criterionKey — TEXT — NOT NULL
  • isCustomized — INTEGER — NOT NULL
  • createdAt — INTEGER — NOT NULL
  • updatedAt — INTEGER — NOT NULL
  • acceptedAt — INTEGER
  • completedAt — INTEGER
  • customizedAt — INTEGER
  • stoppedAt — INTEGER

review_quests

  • id — INTEGER — 기본 키 — NOT NULL
  • folderId — INTEGER — 외래 키 → folders.id
  • tagId — INTEGER — 외래 키 → tags.id
  • questType — TEXT — NOT NULL
  • status — TEXT — NOT NULL
  • unreadCount — INTEGER — NOT NULL
  • createdAt — INTEGER — NOT NULL
  • reminderAt — INTEGER — NOT NULL

scrap_actions

  • id — INTEGER — 기본 키 — NOT NULL
  • scrapId — INTEGER — 외래 키 → scraps.id — NOT NULL
  • actionText — TEXT
  • status — TEXT — NOT NULL
  • reminderAt — INTEGER

scrap_apply_details

  • id — INTEGER — 기본 키 — NOT NULL
  • scrapId — INTEGER — 외래 키 → scraps.id — NOT NULL
  • applicationName — TEXT
  • organization — TEXT
  • applicationField — TEXT
  • deadline — INTEGER
  • eligibility — TEXT
  • requiredDocuments — TEXT
  • applicationLink — TEXT

scrap_code_details

  • id — INTEGER — 기본 키 — NOT NULL
  • scrapId — INTEGER — 외래 키 → scraps.id — NOT NULL
  • codeType — TEXT
  • productName — TEXT
  • usagePlace — TEXT
  • date — INTEGER

scrap_embeddings

  • scrapId — INTEGER — 외래 키 → scraps.id — NOT NULL
  • vector — BLOB — NOT NULL
  • modelVersion — TEXT — NOT NULL
  • updatedAt — INTEGER — NOT NULL

scrap_fts

  • scrapId — INTEGER — 외래 키 → scraps.id — NOT NULL
  • tags — TEXT — NOT NULL

scrap_general_details

  • id — INTEGER — 기본 키 — NOT NULL
  • scrapId — INTEGER — 외래 키 → scraps.id — NOT NULL
  • date — INTEGER
  • source — TEXT
  • link — TEXT

scrap_place_details

  • id — INTEGER — 기본 키 — NOT NULL
  • scrapId — INTEGER — 외래 키 → scraps.id — NOT NULL
  • placeType — TEXT
  • address — TEXT
  • placeName — TEXT
  • businessName — TEXT
  • representativeMenu — TEXT
  • placeLink — TEXT

scrap_private_details

  • id — INTEGER — 기본 키 — NOT NULL
  • scrapId — INTEGER — 외래 키 → scraps.id — NOT NULL
  • infoType — TEXT
  • site — TEXT

scrap_product_details

  • id — INTEGER — 기본 키 — NOT NULL
  • scrapId — INTEGER — 외래 키 → scraps.id — NOT NULL
  • productType — TEXT
  • productName — TEXT
  • price — TEXT
  • brand — TEXT
  • shoppingMall — TEXT

scrap_reading_details

  • id — INTEGER — 기본 키 — NOT NULL
  • scrapId — INTEGER — 외래 키 → scraps.id — NOT NULL
  • topic — TEXT
  • studyField — TEXT
  • source — TEXT

scrap_schedule_details

  • id — INTEGER — 기본 키 — NOT NULL
  • scrapId — INTEGER — 외래 키 → scraps.id — NOT NULL
  • scheduleName — TEXT
  • scheduleDate — INTEGER
  • scheduleTime — TEXT
  • place — TEXT

scrap_tags

  • scrapId — INTEGER — 외래 키 → scraps.id — NOT NULL
  • tagId — INTEGER — 외래 키 → tags.id — NOT NULL
  • createdAt — INTEGER — NOT NULL

scrapmon_states

  • id — INTEGER — 기본 키 — NOT NULL
  • level — INTEGER — NOT NULL
  • stage — TEXT — NOT NULL
  • experience — INTEGER — NOT NULL
  • currentAssetKey — TEXT
  • updatedAt — INTEGER — NOT NULL

scraps

  • id — INTEGER — 기본 키 — NOT NULL
  • sourceType — TEXT — NOT NULL
  • scrapType — TEXT — NOT NULL
  • folderId — INTEGER — 외래 키 → folders.id
  • actionIntent — TEXT
  • title — TEXT — NOT NULL
  • bodyText — TEXT — NOT NULL
  • summary — TEXT — NOT NULL
  • memo — TEXT — NOT NULL
  • isFavorite — INTEGER — NOT NULL
  • imageCount — INTEGER — NOT NULL
  • rewatchEnabled — INTEGER — NOT NULL
  • analysisStatus — TEXT — NOT NULL
  • analysisKey — TEXT
  • analysisCompletedAt — INTEGER
  • analysisViewedAt — INTEGER
  • createdAt — INTEGER — NOT NULL
  • updatedAt — INTEGER — NOT NULL
  • lastViewedAt — INTEGER

tags

  • id — INTEGER — 기본 키 — NOT NULL
  • name — TEXT — NOT NULL
  • createdAt — INTEGER — NOT NULL