Opened 2 years ago

Last modified 19 months ago

#997 assigned задача

Формат таблиц в БД — at Version 1

Reported by: san Owned by: san
Priority: blocker Component: БД изделий АДС
Keywords: Cc:

Description (last modified by 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

Change History (1)

comment:1 by san, 2 years ago

Description: modified (diff)
Note: See TracTickets for help on using tickets.