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