Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MariaDB [productsdb]> desc products;
- +---------------------------------+---------------+------+-----+---------+----------------+
- | Field | Type | Null | Key | Default | Extra |
- +---------------------------------+---------------+------+-----+---------+----------------+
- | id | bigint(20) | NO | PRI | NULL | auto_increment |
- | name | varchar(255) | YES | MUL | NULL | |
- | category_id | int(11) | YES | | NULL | |
- | part_number | varchar(255) | YES | MUL | NULL | |
- | manufacturer | varchar(255) | YES | MUL | NULL | |
- | supplier | varchar(255) | YES | | NULL | |
- | is_rohs_compliant | tinyint(1) | YES | | NULL | |
- | unit_price | decimal(16,5) | YES | | NULL | |
- | unit | varchar(255) | YES | | NULL | |
- | created_by | int(11) | YES | | NULL | |
- | updated_by | int(11) | YES | | NULL | |
- | is_active | tinyint(1) | YES | | 0 | |
- | created_at | datetime(6) | NO | | NULL | |
- | updated_at | datetime(6) | NO | | NULL | |
- | manufacturer_product_name | varchar(255) | YES | | NULL | |
- | manufacturer_std_lead_time | int(11) | YES | | NULL | |
- | manufacturer_std_lead_time_unit | varchar(255) | YES | | NULL | |
- | description | text | YES | | NULL | |
- | min_qty | int(11) | YES | | 1 | |
- | popularity | int(11) | YES | | 0 | |
- | requires_quote | tinyint(1) | YES | | 0 | |
- | ctyea_part_number | varchar(128) | YES | MUL | NULL | |
- | ref | varchar(128) | YES | | NULL | |
- | current_stock | int(11) | YES | | 0 | |
- | main_category_id | int(11) | YES | MUL | NULL | |
- | sub_category_id | int(11) | YES | MUL | NULL | |
- | attr_1 | varchar(128) | YES | | NULL | |
- | attr_2 | varchar(128) | YES | | NULL | |
- | attr_3 | varchar(128) | YES | | NULL | |
- | attr_4 | varchar(128) | YES | | NULL | |
- | attr_5 | varchar(128) | YES | | NULL | |
- | attr_6 | varchar(128) | YES | | NULL | |
- | attr_7 | varchar(128) | YES | | NULL | |
- | attr_8 | varchar(128) | YES | | NULL | |
- | attr_9 | varchar(128) | YES | | NULL | |
- | attr_10 | varchar(128) | YES | | NULL | |
- | attr_11 | varchar(128) | YES | | NULL | |
- | attr_12 | varchar(128) | YES | | NULL | |
- | attr_13 | varchar(128) | YES | | NULL | |
- | attr_14 | varchar(128) | YES | | NULL | |
- | attr_15 | varchar(128) | YES | | NULL | |
- .
- .
- .
- .
- | attr_121 | tinytext | YES | | NULL | |
- | attr_122 | tinytext | YES | | NULL | |
- | attr_123 | tinytext | YES | | NULL | |
- | attr_124 | tinytext | YES | | NULL | |
- | attr_125 | tinytext | YES | | NULL | |
- | attr_126 | tinytext | YES | | NULL | |
- | attr_127 | tinytext | YES | | NULL | |
- | attr_128 | tinytext | YES | | NULL | |
- +---------------------------------+---------------+------+-----+---------+----------------+
- 154 rows in set (0.002 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement