MarsWork
Tables (9)
bookmarks
- id — SERIAL
- user_id — INT
- name — VARCHAR(50) — NOT NULL
- url — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
deadlines
- id — SERIAL
- user_id — INT
- title — VARCHAR(100) — NOT NULL
- deadline_date — TIMESTAMP
- is_notified — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
folder_bookmarks
- folder_id — INT
- bookmark_id — INT
folders
- id — SERIAL
- user_id — INT
- name — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
quotes
- id — SERIAL
- theme — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- author — VARCHAR(50)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
schedules
- id — SERIAL
- user_id — INT
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- schedule_date — DATE
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
settings
- id — SERIAL
- user_id — INT
- theme — VARCHAR(50)
- location — VARCHAR(100)
- timezone — VARCHAR(50)
- background_image_url — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
todos
- id — SERIAL
- user_id — INT
- task — VARCHAR(255) — NOT NULL
- is_completed — BOOLEAN
- due_date — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
users
- id — INT — Primary key — NOT NULL
- name — VARCHAR — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- password — VARCHAR