Currently, we are storing data in raw JSON file. This needs to shift on database.
Raw JSON structure:
Jayprakash12345 | |
May 21 2022, 5:04 AM |
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 |
F35160007: dumpMariaDB (2).sql | |
May 21 2022, 8:45 AM |
F35160008: Untitled.pdf | |
May 21 2022, 8:45 AM |
F35159710: dumpMariaDB.sql | |
May 21 2022, 7:29 AM |
Currently, we are storing data in raw JSON file. This needs to shift on database.
Raw JSON structure:
*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