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 )
Здесь описан формат таблиц в БД, при необходимости изменить формат - пишем в этот тикет.
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
Note:
See TracTickets
for help on using tickets.