start
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
start [2019/04/08 10:08] – jan | start [2019/04/09 09:21] (current) – jan | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====Welcome to the Metrology Cloud Schema Consensus Finding Wiki==== | ||
+ | === Consensus Process === | ||
+ | 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/ | ||
+ | - ***[[dev: | ||
+ | - ***[[rev: | ||
+ | - ***[[main: | ||
+ | |||
+ | The following data types are allowed: | ||
+ | - INTEGER | ||
+ | - VARCHAR | ||
+ | - FLOAT | ||
+ | - BOOLEAN | ||
+ | - DATE | ||
+ | - TIMESTAMP | ||
+ | |||
+ | Do not use dots in table names. |