[Indic-wscontest] Design the database
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Jayprakash12345
	May 21 2022, 5:04 AM

Description

Currently, we are storing data in raw JSON file. This needs to shift on database.

Raw JSON structure:

All contests: https://gerrit.wikimedia.org/r/plugins/gitiles/labs/tools/indic-wscontest/+/refs/heads/master/contest_data/contests.json
Particular contest: https://gerrit.wikimedia.org/r/plugins/gitiles/labs/tools/indic-wscontest/+/refs/heads/master/contest_data/stats/1.json

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

*Initial Design:*

Contests:

cid - name - createdby - createdon - status - start_date - end_date - ln - p_point - v_point

Contest Admin:

cid - admins

Contest Index:

cid - index

Indexe Pages:

idbp - idb - pages - code

Contest Books:

cid - idbp - validator - proofreader - validate_time - proofread_time

Unlisted User:

cid - username

Attaching enhanced version of the sql file.

dumpMariaDB (2).sql2 KBDownload

Diagram:

Detailed Diagram PDF:

Untitled.pdf126 KBDownload

Final set of DDL, DML:

DDL.sql2 KBDownload

DML Insert.sql3 KBDownload

DML Search.sql846 BDownload

Thank you Rammanoj. Great to collaborate with you :)

Jayprakash12345 rescinded a token.

Jayprakash12345 awarded a token.

	F35160367: DML Insert.sql
	May 21 2022, 11:35 AM

	F35160366: DML Search.sql
	May 21 2022, 11:35 AM

	F35160368: DDL.sql
	May 21 2022, 11:35 AM

	F35160017: Untitled.png
	May 21 2022, 8:47 AM