Hackpads are smart collaborative documents. .

Andy Shu

648 days ago
Unfiled. Edited by Chun Yin Vincent Lau , Andy Shu , Hung Fai Tang , Elaine Chan 648 days ago
Features
 
  • there are quite a few tracking apps but most of their technology are proprietary 
 
 
 
 
Chun L HK hiking info
 
 
 
Elaine C Calories calculation:
Metabolic Equivalent Task (MET) (1 kcal/kg/hour) for hiking: 5-7
Allow 1 hour for every 5 kilometres (3.1 mi) forward, plus 1 hour for every 600 metres (2,000 ft) of ascent.
 
 
 
 
 
 
Hung T  Schema 
  • create table Event (
  •   id                  int               auto_increment,
  •   name                varchar(256)      not null, 
  •   start_time          datetime          not null,
  •   end_time            datetime          not null,
  •   description         text              default '',
  •  
  •   is_deleted          bool              default 0,
  •  
  •   primary key(id)
  • );
  •  
  •  
  • create table User (
  •   id                int               auto_increment,
  •   username          varchar(256)      not null,
  •   password_salt     varchar(64)       not null,
  •   password_hash     varchar(256)      not null,
  •  
  •   join_time         datetime          not null,
  •   verified          bool              not null, 
  •  
  •   -- total_distance for all events
  •   total_distance    double            auto_increment,
  •  
  •   is_deleted        bool              default 0,
  •  
  •   primary key(id)
  • );
  •  
  • create table Event_User (
  •   id                int              auto_increment,
  •   event_id          int              not null,
  •   user_id           int              not null,
  •  
  •   -- total_distance for this event this user
  •   total_distance    double           default 0,  
  •  
  •  
  •   primary key(id),
  •   index(event_id),
  •   index(user_id)
  • );
  •  
  • create table Achievement (
  •   id                int              auto_increment,
  •   name              varchar(256)     not null,
  •  
  •   primary key(id)
  • );
  •  
  • create table Achievement_User (
  •   id               int              auto_increment,
  •   user_id          int              not_null,
  •   achievement_id   int              not_null,
  •  
  •   primary key(id)
  • );
  •  
Web API
 
Andy S How to Get 100k Users
A. Demographic backgrounds
A1. People who has smart phones in Hong Kong
  • Smartphone penetration: 87%;
  • 90%+ in population aged 15-39;
  • 70% in population aged 40-49;
  • 50% in population aged 50-54.
A2. People who exercise regularly
  • 80% of HK people exercised in the past 3 months;
  • 20% didn't exercise in the past 3 months, the main reason being having no time;
  • 20% exercised more than 3 times a week.
A3. Hikers
  • 14,644 people joined "Hong Kong Hiking Meetup"
  •  2,010 people joined "HiKE HK"
...

Contact Support



Please check out our How-to Guide and FAQ first to see if your question is already answered! :)

If you have a feature request, please add it to this pad. Thanks!


Log in / Sign up