diary service
Tables (7)
bookmarks
- id — SERIAL
- user_id — INTEGER — NOT NULL
- quote_id — INTEGER — NOT NULL
diaries
- id — SERIAL
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- user_id — INTEGER — NOT NULL
questions
- id — SERIAL
- question_text — TEXT — NOT NULL
quotes
- id — SERIAL
- content — TEXT — NOT NULL
- author — VARCHAR(100)
token_blacklist
- id — SERIAL
- token — VARCHAR(500) — NOT NULL
- user_id — INTEGER — NOT NULL
- expired_at — TIMESTAMPTZ — NOT NULL
user_questions
- id — SERIAL
- user_id — INTEGER — NOT NULL
- question_id — INTEGER — NOT NULL
- seen — BOOLEAN — NOT NULL
- seen_at — TIMESTAMPTZ — NOT NULL
users
- id — SERIAL
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL