alli

Tables (4)

Subscription (subscriptions)

  • id — BIGINT — Primary key — NOT NULL
  • isActive (is_active) — BOOLEAN
  • createdAt (created_at) — TIMESTAMP
  • updatedAt (updated_at) — TIMESTAMP
  • lastNotified (last_notified) — TIMESTAMP
  • site_id (sisite_id) — BIGINT — Foreign key → site.id — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL

notice (notices)

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • url — VARCHAR(255)
  • externalId (external_id) — VARCHAR(255)
  • publisedAt (published_at) — TIMESTAMP
  • updatedAt (updated_at) — TIMESTAMP
  • isNew (is_new) — BOOLEAN
  • site_id — BIGINT — Foreign key → site.id — NOT NULL

site (sites)

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100)
  • url — VARCHAR(255)
  • selector — TEXT
  • titleSelector (title_selector) — TEXT
  • linkSelector (link_selector) — TEXT
  • category — VARCHAR(255)
  • enabled — BOOLEAN
  • lastCrawled (last_crawled) — TIMESTAMP
  • createdAt (created_at) — TIMESTAMP
  • updatedAt (updated_at) — TIMESTAMP

user (users)

  • id — BIGINT — Primary key — NOT NULL
  • fcmToken (fcm_token) — VARCHAR(255)
  • deviceId (device_id) — VARCHAR(255)