DBTest - schema

MariaDB [DBTEST]> describe Equipment;
+----------------+-----------------------------------------+------+-----+---------+----------------+
| Field          | Type                                    | Null | Key | Default | Extra          |
+----------------+-----------------------------------------+------+-----+---------+----------------+
| id             | int(10) unsigned                        | NO   | PRI | NULL    | auto_increment |
| name           | varchar(100)                            | NO   | UNI | NULL    |                |
| type           | enum('measuring','testing','auxiliary') | NO   |     | NULL    |                |
| comissioned    | date                                    | YES  |     | NULL    |                |
| decomissioned  | date                                    | YES  |     | NULL    |                |
| specs          | text                                    | YES  |     | NULL    |                |
| responsible_id | varchar(100)                            | NO   | MUL | NULL    |                |
+----------------+-----------------------------------------+------+-----+---------+----------------+
7 rows in set (0.001 sec)

MariaDB [DBTEST]> describe EquipmentVerifications;
+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| id            | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| equipment_id  | int(10) unsigned | NO   | MUL | NULL    |                |
| miregister_id | int(10) unsigned | NO   | MUL | NULL    |                |
| ts            | date             | NO   |     | NULL    |                |
| upto          | date             | NO   |     | NULL    |                |
| organization  | varchar(100)     | NO   |     | NULL    |                |
| certificate   | varchar(100)     | NO   | UNI | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+
7 rows in set (0.001 sec)

MariaDB [DBTEST]> describe EquipmentVerifications2;
+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| id            | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| equipment_id  | int(10) unsigned | NO   | MUL | NULL    |                |
| miregister_id | int(10) unsigned | NO   | MUL | NULL    |                |
| ts            | int(11)          | NO   |     | NULL    |                |
| upto          | int(11)          | NO   |     | NULL    |                |
| organization  | varchar(100)     | NO   |     | NULL    |                |
| certificate   | varchar(100)     | NO   | UNI | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+
7 rows in set (0.001 sec)

MariaDB [DBTEST]> describe Equipment_Supplies;
+--------------+------------------+------+-----+---------+----------------+
| Field        | Type             | Null | Key | Default | Extra          |
+--------------+------------------+------+-----+---------+----------------+
| id           | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| equipment_id | int(10) unsigned | NO   | MUL | NULL    |                |
| supply_id    | int(10) unsigned | NO   |     | NULL    |                |
+--------------+------------------+------+-----+---------+----------------+
3 rows in set (0.001 sec)

MariaDB [DBTEST]> describe Supplies;
+-----------------+------------------+------+-----+---------+----------------+
| Field           | Type             | Null | Key | Default | Extra          |
+-----------------+------------------+------+-----+---------+----------------+
| id              | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| name            | varchar(100)     | NO   | MUL | NULL    |                |
| description     | text             | YES  |     | NULL    |                |
| category_id     | varchar(100)     | NO   | MUL | NULL    |                |
| manufacturer_id | int(10) unsigned | YES  | MUL | NULL    |                |
| sn              | varchar(100)     | YES  |     | NULL    |                |
| produced        | date             | YES  |     | NULL    |                |
+-----------------+------------------+------+-----+---------+----------------+
7 rows in set (0.001 sec)

MariaDB [DBTEST]> describe Users;
+-------+--------------+------+-----+---------+-------+
| Field | Type         | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| id    | varchar(100) | NO   | PRI | NULL    |       |
+-------+--------------+------+-----+---------+-------+
1 row in set (0.001 sec)