123

Tables (7)

RT_Ai_Logs1

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → RT_Users1.id — NOT NULL
  • routine_id — INT — Foreign key → RT_Routines1.id
  • request_type — VARCHAR(30) — NOT NULL
  • prompt — VARCHAR(5000) — NOT NULL
  • response — VARCHAR(5000) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

RT_Categories1

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → RT_Users1.id — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • color_code — VARCHAR(7) — NOT NULL
  • rt_sum — VARCHAR(10) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

RT_Daily_Targets1

  • id — INT — Primary key — NOT NULL
  • routine_id — INT — Foreign key → RT_Routines1.id — NOT NULL
  • target_date — DATE — NOT NULL
  • is_completed — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

RT_Refresh_Tokens1

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → RT_Users1.id — NOT NULL
  • token_value — VARCHAR(5000) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

RT_Routine_Schedules1

  • id — INT — Primary key — NOT NULL
  • routine_id — INT — Foreign key → RT_Routines1.id — NOT NULL
  • cron_expression — VARCHAR(100)
  • start_time — TIME
  • end_time — TIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

RT_Routines1

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → RT_Users1.id — NOT NULL
  • category_id — INT — Foreign key → RT_Categories1.id
  • title — VARCHAR(30) — NOT NULL
  • alarm — TINYINT(1) — NOT NULL
  • state — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

RT_Users1

  • id — INT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255)
  • nickname — VARCHAR(30) — NOT NULL
  • age — INT
  • role — VARCHAR(20)
  • gender — TINYINT
  • provider — VARCHAR(20) — NOT NULL
  • provider_id — VARCHAR(100)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME