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)