KeepIt
Tables (3)
articles
- id — BIGINT
- public_id — UUID — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- url — VARCHAR(2048) — NOT NULL
- title — VARCHAR(500) — NOT NULL
- description — VARCHAR(1000)
- thumbnail_url — VARCHAR(2048)
- domain — VARCHAR(255) — NOT NULL
- category — VARCHAR(100)
- is_read — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
refresh_tokens
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- jti — VARCHAR(255) — NOT NULL
- family_id — VARCHAR(255) — NOT NULL
- issued_at — TIMESTAMPTZ — NOT NULL
- expires_at — TIMESTAMPTZ — NOT NULL
- revoked — BOOLEAN — NOT NULL
users
- id — BIGINT
- public_id — UUID — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_user_id — VARCHAR(255) — NOT NULL
- display_name — VARCHAR(255)
- avatar_url — VARCHAR(2048)
- created_at — TIMESTAMPTZ — NOT NULL