쿼카이브
테이블 (24)
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 — 외래 키 — 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
- contentSha256 — TEXT
- pHash — TEXT
- sortOrder — INTEGER — NOT NULL
- isMissing — INTEGER — NOT NULL
- missingCheckedAt — INTEGER
- createdAt — INTEGER — NOT NULL
link_references
- scrapId — INTEGER — 외래 키 — 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_scraps
- questId — INTEGER — 외래 키 → quests.id — NOT NULL
- scrapId — INTEGER — 외래 키 — NOT NULL
- linkedAt — INTEGER — NOT NULL
quests
- id — INTEGER — 기본 키 — NOT NULL
- sourceType — TEXT — NOT NULL
- generationType — TEXT — NOT NULL
- scrapType — TEXT
- status — TEXT — NOT NULL
- templateCode — TEXT — NOT NULL
- subjectName — TEXT
- customTitle — TEXT
- folderId — INTEGER — 외래 키
- sourceTargetDate — INTEGER
- targetDate — INTEGER
- reminderAt — INTEGER
- criterionKey — TEXT — NOT NULL
- isCustomized — INTEGER — NOT NULL
- createdAt — INTEGER — NOT NULL
- updatedAt — INTEGER — NOT NULL
- acceptedAt — INTEGER
- completedAt — INTEGER
- customizedAt — INTEGER
review_quests
- id — INTEGER — 기본 키 — NOT NULL
- folderId — INTEGER — 외래 키
- tagId — INTEGER — 외래 키
- 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 — 외래 키 — NOT NULL
- actionText — TEXT
- status — TEXT — NOT NULL
- reminderAt — INTEGER
scrap_apply_details
- id — INTEGER — 기본 키 — NOT NULL
- scrapId — INTEGER — 외래 키 — 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 — 외래 키 — 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 — 외래 키 — NOT NULL
- tags — TEXT — NOT NULL
scrap_general_details
- id — INTEGER — 기본 키 — NOT NULL
- scrapId — INTEGER — 외래 키 — NOT NULL
- date — INTEGER
- source — TEXT
- link — TEXT
scrap_place_details
- id — INTEGER — 기본 키 — NOT NULL
- scrapId — INTEGER — 외래 키 — NOT NULL
- placeType — TEXT
- address — TEXT
- placeName — TEXT
- businessName — TEXT
- representativeMenu — TEXT
- placeLink — TEXT
scrap_private_details
- id — INTEGER — 기본 키 — NOT NULL
- scrapId — INTEGER — 외래 키 — NOT NULL
- infoType — TEXT
- site — TEXT
scrap_product_details
- id — INTEGER — 기본 키 — NOT NULL
- scrapId — INTEGER — 외래 키 — NOT NULL
- productType — TEXT
- productName — TEXT
- price — TEXT
- brand — TEXT
- shoppingMall — TEXT
scrap_reading_details
- id — INTEGER — 기본 키 — NOT NULL
- scrapId — INTEGER — 외래 키 — NOT NULL
- topic — TEXT
- studyField — TEXT
- source — TEXT
scrap_schedule_details
- id — INTEGER — 기본 키 — NOT NULL
- scrapId — INTEGER — 외래 키 — NOT NULL
- scheduleName — TEXT
- scheduleDate — INTEGER
- scheduleTime — TEXT
- place — TEXT
scrap_tags
- scrapId — INTEGER — 외래 키 — NOT NULL
- tagId — INTEGER — 외래 키 — 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
- CREATE — TABLE