ZupStar

Tables (10)

LOCAITON_MISSION

    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