Runabit
Tables (3)
promise
- promise_id — BIGINT
- user_id — BIGINT — NOT NULL
- promise_time — DATETIME — NOT NULL
- goal_distance — DECIMAL(5,2) — NOT NULL
- alarm_offset — INT
- status — ENUM('SCHEDULED', 'COMPLETED')
- created_at — DATETIME
- updated_at — DATETIME
run
- run_id — BIGINT
- promise_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- run_date — DATETIME
- total_time_seconds — INT — NOT NULL
- total_distance — DECIMAL(5,2) — NOT NULL
- pace — DECIMAL(5,2)
- calorie — INT — NOT NULL
- achieve_percent — DECIMAL(5,2) — NOT NULL
- achieve_30 — BOOLEAN
- achieve_60 — BOOLEAN
- achieve_100 — BOOLEAN
- created_at — DATETIME
users
- user_id — BIGINT
- nickname — VARCHAR(50) — NOT NULL
- level — INT
- carrot_count — INT
- created_at — DATETIME
- updated_at — DATETIME