diary

Tables (6)

activity_logs (Untitled)

  • log_id (Key) — NOTNULL — Primary key — NOT NULL
  • user_id (key) — NOTNULL
  • activity (Field3)
  • log_time (Field4)

api_logs (Untitled2)

  • log_id (Key) — NOTNULL — Primary key — NOT NULL
  • user_id (Fiel\d) — NOTNULL
  • schedule_id (Field)
  • request_text (Field2)
  • response_text (Field3)
  • request_time (Field4) — TEXT

images (Untitled3)

  • image_id (Key) — NOTNULL — Primary key — NOT NULL
  • user_id (Field) — NOTNULL
  • image_path (Field2)
  • upload_time (Field3)
  • ocr_extracted__text (T)
  • schedule_id (key)
  • Field6

notifications (Untitled4)

  • notification_id (Key) — NOTNULL — Primary key — NOT NULL
  • schedule_id (Field)
  • notification_time (Field2)
  • notification_sent (Field3)
  • Field4

schedules (Untitled5)

  • schedule_id (Key) — NOTNULL — Primary key — NOT NULL
  • user_id (Field) — NOTNULL
  • title (Field2)
  • description (Field3)
  • schedule_date (Field4)
  • notification_time (Field5)
  • created_at (Field6)
  • updated_at (Field7)
  • Field8

users (Untitled6)

  • user_id (Key) — NOTNULL — Primary key — NOT NULL
  • username (Field) — NOTNULL
  • email (Field2) — NOTNULL
  • password_hash (Field3) — NOTNULL
  • created_at (T) — TIMESTAMP