Voting online Monitoring System development notes

Platform

Use (Python2.7)

+ (SQLite) +

(Ngix+flask)

Database

SQLite Four Sheets

0, basic collection Information set table Base_info

Table Entries:

Serial base_table_id

Voting activity name Activity_title

Event start time activity_start_time

Activity end time activity_end_time

Event rules & Prizes activity_rule

Organizer Activity_company

Acquisition activity start time activity_collect_start_time

Estimated end time activity_collect_end_time

Active total days ==> initialize ==> total number of days N

1. Data acquisition Activity status record table

5 minutes to collect 1 strips, about 12*24*30 strips

Collect_info

Table Entries:

Serial collect_table_id

Acquisition serial number collect_data_id

Acquisition Time Collect_data_time

Acquisition Status Collect_data_status

Collection activity Total Acquisition quantity Collect_data_amount

Activity nth day collect_data_nowday

2 . Participants ' information sheet

Contestant_info

Table Entries:

Serial contestant_table_id

Entry Number contestant_id

Name Contestant_name

Current Rank Contestant_rank

Assuming that the first time after the initial acquisition initialization, after each acquisition of the total number of people compared with the item, the number of people to update the table.

3. Voting data Sheet for contestants

DataSet

2+n Table Entries:

Serial dataset_table_id

Entry Number dataset_id

L1---LN datalist_1 to datalist_n

1th Day voting list[10,20,30 ...], 5 minutes add an array of 12*24=288 elements.

2nd day 288 an array of elements ...

3rd day ...

Nth Day.

Voting online Monitoring System development notes