id summary reporter owner description type status priority component resolution keywords cc 997 Информация по проекту БД изделий АДС san san "**Формат серийных номеров изделий:** A12345 - латинская заглавная буква и 5 цифр\\ 12345 - 5 цифр\\ Б1234 - русская заглавная Б и 4 цифры\\ Р123456 - русская заглавная Р[эр] и 6 цифр\\ **Формат таблиц в БД:** {{{ 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 | | | 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 | | nocheck | | | mismatch | enum('yes','no') | YES | | no | | | repair | varchar(100) | No | | no | | | comment | text | YES | | NULL | | +----------+-------------------------------------------------------------------------+------+-----+---------+----------------+ 12 rows in set (0.001 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','transform') | 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 | int(11) | YES | | NULL | | | status | enum('ok','fail') | YES | | NULL | | | comment | text | YES | | NULL | | | N | int(11) | NO | PRI | NULL | auto_increment | +--------------+---------------------------------------------------------------------------+------+-----+---------+----------------+ 12 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 | +--------+--------------+------+-----+---------+----------------+ | uid | int(32) | NO | PRI | NULL | auto_increment | | name | varchar(100) | YES | UNI | NULL | | | type | varchar(100) | YES | | NULL | | | parent | int(32) | YES | | NULL | | +--------+--------------+------+-----+---------+----------------+ 4 rows in set (0.001 sec) MariaDB [adcproducts]> Show columns from `orders`; +-------------+---------------------------------------------------------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------------------------------------------------------+------+-----+---------------------+-------+ | UID | int(32) | YES | UNI | NULL | | | datetime | datetime | NO | | current_timestamp() | | | deadline | date | YES | | NULL | | | status | enum('created','accept','completed','verify','otk','shipped') | YES | | NULL | | | composition | text | YES | | NULL | | | recipient | varchar(200) | YES | | NULL | | | comment | text | YES | | NULL | | +-------------+---------------------------------------------------------------+------+-----+---------------------+-------+ 7 rows in set (0.001 sec) MariaDB [adcproducts]> Show columns from `order-items`; +------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+---------+-------+ | order_id | int(32) | NO | MUL | NULL | | | serial | varchar(100) | YES | MUL | NULL | | | type | varchar(100) | NO | | NULL | | | name | varchar(100) | NO | | NULL | | | parent | varchar(100) | YES | | NULL | | | record_checkmark | tinyint(1) | NO | | 0 | | +------------------+--------------+------+-----+---------+-------+ 6 rows in set (0.001 sec) }}} **Права пользователей:**\\ accept - добавление изделий в базу\\ mismatch - добавление несоответствий\\ repair - устранение несоответствий\\ refand - приём плат в возврат или в ремонт от заказчика\\ testing -проверка плат\\ otk - ОТК\\ shipment - отгрузка \\ transform - преобразование изделия в другое изделие\\ createorder - создание и редактирование заказа\\" задача assigned blocker БД изделий АДС