ZupStar
Tables (10)
LOCATIONS
- location_index — int — Primary key — NOT NULL
- location_name — varchar(100)
MISSIONS
- mission_index — int — Primary key — NOT NULL
- user_index (user_indx) — int — Foreign key → USERS.user_index — NOT NULL
- mission_title — varchar(40)
- mission_status — tinyint(10)
- mission_start_time — timestamp
- mission_clear_time — timestamp
- mission_carbon_reduction (mission_carbon_redcution) — float
- mission_detected_waste — int
- mission_score — int
- mission_message — text
- mission_timestamp — timestamp
- location_index — int — Foreign key → LOCATIONS.location_index — NOT NULL
SCORES_LOG
- score_log_index — int — Primary key — NOT NULL
- user_index — int — Foreign key → USERS.user_index — NOT NULL
- score_log_added_score — int
- score_log_total_score — int
- score_log_timestamp — timestamp
- score_log_carbon_reduction — float
TEAMS
- team_index — int — Primary key — NOT NULL
- team_name — varchar(100)
- team_profile — varchar(500)
- team_timestamp (team-timestamp) — timestamp
- team_url — varchar(200)
TEAMS_RANK
- team_rank_index — int — Primary key — NOT NULL
- team_index — int — Foreign key → TEAMS.team_index — NOT NULL
- team_rank_total_score — int
- team_rank_total_rank — int
- team_rank_timestamp — timestamp
USERS
- user_index (user_indx) — int — Primary key — NOT NULL
- team_index — int — Foreign key → TEAMS.team_index — NOT NULL
- user_name — varchar(100)
- user_birthday — datetime
- user_profile — varchar(500)
- user_score — int
- user_timestamp — timestamp
- user_mission_count — int
- user_id — vachar(50)
- user_password — varchar(50)
- user_salt — varchar(200)
USERS_AUTH (USRES_AUTH)
- user_index — int — Foreign key → USERS.user_index — NOT NULL
- user_id — varchar(50)
- user_password — varchar(50)
- user_salt — varchar(200)
- user_timestamp — timestamp
USERS_AUTH
- user_index — INT — NOT NULL
- user_id — VARCHAR(50)
- user_password — VARCHAR(50)
- user_salt — VARCHAR(200)
- user_timestamp — TIMESTAMP
USERS_RANK
- user_rank_index — int — Primary key — NOT NULL
- user_index — int — Foreign key → USERS.user_index — NOT NULL
- user_rank_total_score — int
- user_rank_total_rank — int
- user_rank_timestamp — timestamp