공통
테이블 (12)
APP_SETTING
- id — INTEGER — 기본 키 — NOT NULL
- defaultArchiveView — TEXT
- deleteGalleryOnScrapDelete — INTEGER
- autoRemoveMissingGalleryImage — INTEGER
- createdAt — INTEGER
- updatedAt — INTEGER
- notificationEnabled — INTEGER
- analysisCompleteNotificationEnabled — INTEGER
FOLDER
- id — INTEGER — 기본 키 — NOT NULL
- parentFolderId — INTEGER — 외래 키 → FOLDER.id
- name — TEXT
- intentType — TEXT
- color — TEXT
- sortOrder — INTEGER
- isSystem — INTEGER
- createdAt — INTEGER
- updatedAt — INTEGER
IMAGE_REFERENCE
- id — INTEGER — 기본 키 — NOT NULL
- scrapId — INTEGER — 외래 키 → SCRAP.id
- mediaStoreUri — TEXT
- width — INTEGER
- height — INTEGER
- pHash — TEXT
- sortOrder — INTEGER
- createdAt — INTEGER
- content_sha256 — TEXT
SCRAP
- id — INTEGER — 기본 키 — NOT NULL
- scrapType — TEXT
- folderId — INTEGER — 외래 키 → FOLDER.id
- title — TEXT
- bodyText — TEXT
- summary — TEXT
- imageCount — INTEGER
- rewatchEnabled — INTEGER
- createdAt — INTEGER
- updatedAt — INTEGER
- lastViewedAt — INTEGER
- actionIntent — TEXT
- analysisKey — TEXT
SCRAPMON_STATE
- id — INTEGER — 기본 키 — NOT NULL
- level — INTEGER
- stage — TEXT
- experience — INTEGER
- currentAssetKey — TEXT
- updatedAt — INTEGER
SCRAP_ACTION
- id — INTEGER — 기본 키 — NOT NULL
- scrapId — INTEGER — 외래 키 → SCRAP.id — NOT NULL
- actionText — TEXT
- status — TEXT
- reminderAt — INTEGER
SCRAP_APPLY_DETAIL
- id — INTEGER — 기본 키 — NOT NULL
- scrapId — INTEGER — 외래 키 → SCRAP.id
- deadline — INTEGER
- eligibility — TEXT
- requiredDocuments — TEXT
- applicationLink — TEXT
SCRAP_CUSTOM_FIELD
- id — INTEGER — 기본 키 — NOT NULL
- scrapId — INTEGER — 외래 키 → SCRAP.id
- fieldName — TEXT
- fieldValue — TEXT
- sortOrder — INTEGER
- createdAt — INTEGER
- updatedAt — INTEGER
SCRAP_PLACE_DETAIL
- id — INTEGER — 기본 키 — NOT NULL
- scrapId — INTEGER — 외래 키 → SCRAP.id
- placeName — TEXT
- businessName — TEXT
- representativeMenu — TEXT
- placeLink — TEXT
- address — TEXT
SCRAP_PRODUCT_DETAIL
- id — INTEGER — 기본 키 — NOT NULL
- scrapId — INTEGER — 외래 키 → SCRAP.id
- productName — TEXT
- price — TEXT
- brand — TEXT
- shoppingMall — TEXT
- productType — TEXT
SCRAP_TAG
- scrapId — INTEGER — 외래 키 → SCRAP.id — NOT NULL
- tagId — INTEGER — 외래 키 → TAG.id — NOT NULL
- createdAt — INTEGER
TAG
- id — INTEGER — 기본 키 — NOT NULL
- name — TEXT
- createdAt — INTEGER