Формат таблиц в БД

[san]

Здесь описан формат таблиц в БД, при необходимости изменить формат - пишем в этот тикет.
`
MariaDB [adcproducts]> SHOW columns from products;
+------------+-------------------------------------------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------------------------------------------------------------------+------+-----+---------+----------------+
| UID | int(32) | NO | PRI | NULL | auto_increment |
| type | varchar(100) | YES | | NULL | |
| name | varchar(100) | YES | | NULL | |
| perfomance | varchar(100) | YES | | NULL | |
| serial | varchar(100) | NO | UNI | NULL | |
| date | date | YES | | NULL | |
| owner | varchar(100) | YES | | NULL | |
| location | enum('stock','shipped','develop','isolator','nelikvid','repair','work') | YES | | NULL | |
| testing | enum('ok','fail','notest') | YES | | notest | |
| otk | enum('ok','fail','nocheck') | YES | | NULL | |
| mismatch | enum('yes','no') | YES | | no | |
| repair | varchar(100) | YES | | NULL | |
| comment | text | YES | | NULL | |
+------------+-------------------------------------------------------------------------+------+-----+---------+----------------+
13 rows in set (0.002 sec)

MariaDB [adcproducts]> SHOW columns from history;
+--------------+---------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+---------------------------------------------------------------+------+-----+---------+-------+
| UID | int(32) | YES | | NULL | |
| worker | varchar(100) | YES | | NULL | |
| date | datetime | YES | | NULL | |
| type_write | enum('record','otk','mismatch','testing','repair','shipping') | YES | | NULL | |
| order_from | varchar(100) | YES | | NULL | |
| whom_order | varchar(100) | YES | | NULL | |
| location | enum('stock','shipped','develop','isolator','nelikvid','repair','work') | YES | | NULL | |
| number_order | varchar(100) | YES | | NULL | |
| status | enum('ok','fail') | YES | | NULL | |
| comment | text | YES | | NULL | |
| protocol | varchar(100) | YES | | NULL | |
+--------------+---------------------------------------------------------------+------+-----+---------+-------+
10 rows in set (0.002 sec)

MariaDB [adcproducts]> SHOW columns from users;
+----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| user | varchar(100) | YES | UNI | NULL | |
| worker | varchar(100) | YES | | NULL | |
| password | varchar(100) | YES | | NULL | |
| root | varchar(100) | YES | | NULL | |
+----------+--------------+------+-----+---------+-------+
4 rows in set (0.001 sec)

MariaDB [adcproducts]> SHOW columns from list_of_products;
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| name | varchar(100) | YES | | NULL | |
| type | varchar(100) | YES | | NULL | |
+-------+--------------+------+-----+---------+-------+
2 rows in set (0.004 sec)

MariaDB [adcproducts]> SHOW columns from orders;
+-------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------------+------+-----+---------+-------+
| UID | int(32) | YES | UNI | NULL | |
| composition | text | YES | | NULL | |
| recipient | varchar(100) | YES | | NULL | |
| shipped | enum('yes','no') | YES | | NULL | |
| comment | text | YES | | NULL | |
+-------------+------------------+------+-----+---------+-------+
5 rows in set (0.003 sec)

`
Права: accept,mismatch,otk,refand,repair,shipment,testing