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