At any time, you can add, remove or modify tables in the Dev section of the wiki. Every participant can add personal comments to each table, so discussions can be held regarding the content of each table.
The wiki will watch any changes and once a certain threshold of changed content is exceeded, a syntax verification process is initiated. The program will verify if all current tables have a correct syntax (e.g. valid column names, correct data types, …) and the stated foreign key / primary key references are valid. Should there be any errors, a manual check is performed to correct those errors.
Once all tables are in a valid state, a new consensus round is started and the tables are copied into the In Review area. Here, you can review all tables (but no longer modify) and give your consent or rejection to the proposed schema. If more than half of all participants have given their consent, the tables are accepted and copied to the main area. Should more than half of all participants reject the current proposal, the consensus round will be closed and no further actions will be taken, leaving the main area as it is.
The main area will, thus, always contain the data schema as it was last accepted by most participants.
There are three areas/stages:
The following data types are allowed:
Do not use dots in table names.