공통

테이블 (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