Home

Databases

JStore uses relational database, which have 3 tables: apps, devs, apps_screenshots.

Table apps

Have 15 rows.

• id: have unique number of app, which uses for accessing via web. Takes the value of number a type INT
• app_name: application name. Takes the value of text a type TEXT
• dev_name: developer's name. Takes the value of text a type TEXT
• votes: count of pros for app (In the future we set votes_plus and votes_minus). Takes the value of number a type INT
• icon: URL of a picture. Takes the value of text a type VARCHAR
• banner: URL of a advert banner. Takes the value of text a type VARCHAR