Page MenuHomePhabricator

[Indic-wscontest] Design the database
Closed, ResolvedPublic

Assigned To
Authored By
Jayprakash12345
May 21 2022, 5:04 AM
Referenced Files
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
Tokens
"Barnstar" token, awarded by Jayprakash12345.

Event Timeline

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.

Diagram:

Untitled.png (748×1 px, 57 KB)

Detailed Diagram PDF:

Final set of DDL, DML:

Thank you Rammanoj. Great to collaborate with you :)