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