common_DB
The Laravel parts are currently not in use.
About common DB
CommonDB is our ultimative BigData Database for merging and handling all data we can find.
Syncronisation
common <-> BLUEJECTS
common <-> WDS-APP
Push or Pull
common <-x DENTAL.SHOP
TODO: open syncs
common x-x BLUESAFETY
common x-x DONE.de
common x-x QM-Bausteine
common x-x Mission-Hygiene
common x-x SAFELAB
Naming Convention
Database
10.3.37-MariaDB-0ubuntu0.20.04.1
Tables
| Type | Prefix | Konvention | Example | Description |
|---|---|---|---|---|
bs_ | {prefix}{table} | bs_employees | Deprecated. BS common employee goes to Federated | |
| Admin | admin_ | {prefix}{table} | admin_users | administration common |
| FrontEnd | {table} | users | for our frontend and sessions | |
| LookUp | lu_ | {prefix}{table} | lu_genders | loop-up for genders |
| Joins | _join | {table-1}_{table-2}{prefix} | bs_employees_users_join | n to m |
| Targeter | targeter_ | {prefix}{table} | targeter_valid_list | List from Targeter |
FEDERATED
| Type | Prefix | Konvention | Example | Description |
|---|---|---|---|---|
| BLUESAFETY | bs_ | {prefix}{table} | bs_employees | |
| BLUEJECTS | bj_ | {prefix}{package}_domain_model_{table} | bj_contacts_domain_model_contact | |
| DENTAL.SHOP | ds_ | {prefix}{table} | ds_customer | |
| WDS-APP | wds_ | {prefix}{table} | wds_users | |
| DONE | done_ | {prefix}{table} | done_users | |
| QM-Bausteine | qmds_ | {prefix}{table} | qmds_users | |
| WDS-APP | wds_ | {prefix}{table} | wds_users |
Columns
| DataTypes | Type | Prefix | Konvention | Example | Description |
|---|---|---|---|---|---|
| Date & Time | Date | dtm_ | {prefix}{column} | dtm_insert | |
| Date & Time | DateTime | dtm_ | {prefix}{column} | dtm_time | |
| Date & Time | Timestamp | _at | {created|updated|deleted}{prefix} | updated_at | |
| String | Varchar | str_ | {prefix}{column} | str_name | |
| String | JSON | json_ | {prefix}{column} | json_images | |
| String | Text | str_ | {prefix}{column} | str_description | |
| Binary | Blob | bin_ | {prefix}{column} | bin_files | |
| Binary | Binary | bin_ | {prefix}{column} | bin_ascii | |
| Numeric | Primary Key | id | {prefix} | id | |
| Numeric | Foreign Key | _id | {column}{prefix} | user_id | |
| Numeric | Integer | int_ | {prefix}{column} | int_position | |
| Numeric | Bit | bol_ | {prefix}{column} | bol_active | |
| Numeric | Tinyint | bol_ | {prefix}{column} | bol_inactive | |
| Numeric | Bool | bol_ | {prefix}{column} | bol_true | |
| Real | Float | int_ | {prefix}{column} | int_file_size | |
| Real | Double | int_ | {prefix}{column} | int_molecules | |
| Real | Decimal | dec_ | {prefix}{column} | dec_counter |
Index
| Type | Prefix | Konvention | Example | Description |
|---|---|---|---|---|
| Index | _index | {table}_{column}{prefix} | bs_users_details_idnr_ta_index | only if index is not specified |
| Primary | PRIMARY KEY | {prefix} | PRIMARY KEY | key or id of the table |
| Foreign | _foreign | {table}_{column}{prefix} | bs_users_buildings_user_id_foreign | foreignkey for table users |
| Unique | _unique | {table}_{column*_}{prefix} | bs_users_buildings_lat_long_unique | unique for columns lat & long |
| fulltext | _fulltext | {table}_{column}{prefix} | bs_building_description_fulltext | is a search optimiziation |
| spatial | _spatial | {table}_{column}{prefix} | bs_building_description_spatial | for BTREE ... useful for Geo. |
Procedure / Function
| Type | Prefix | Konvention | Example | Description |
|---|---|---|---|---|
| Procedure | prc_ | {prefix}{name} | prc_update_tables | |
| Function | fnc_ | {prefix}{name} | fnc_add_currency | |
| Event | event_ | {prefix}{type}{name} | event_prc_update_tables | |
| View | view_ | {prefix}{name} | view_show_all |
Server
Environment Variables
To run this project, you will need to add the following environment variables to your .env file
API_KEY
ANOTHER_API_KEY
Color Reference
| Color | Hex |
|---|---|
| Example Color | |
| Example Color | |
| Example Color | |
| Example Color |