Advertisement
ajithkgshk

Products table schema

Jul 23rd, 2023 (edited)
172
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.89 KB | None | 0 0
  1. MariaDB [productsdb]> desc products;
  2. +---------------------------------+---------------+------+-----+---------+----------------+
  3. | Field | Type | Null | Key | Default | Extra |
  4. +---------------------------------+---------------+------+-----+---------+----------------+
  5. | id | bigint(20) | NO | PRI | NULL | auto_increment |
  6. | name | varchar(255) | YES | MUL | NULL | |
  7. | category_id | int(11) | YES | | NULL | |
  8. | part_number | varchar(255) | YES | MUL | NULL | |
  9. | manufacturer | varchar(255) | YES | MUL | NULL | |
  10. | supplier | varchar(255) | YES | | NULL | |
  11. | is_rohs_compliant | tinyint(1) | YES | | NULL | |
  12. | unit_price | decimal(16,5) | YES | | NULL | |
  13. | unit | varchar(255) | YES | | NULL | |
  14. | created_by | int(11) | YES | | NULL | |
  15. | updated_by | int(11) | YES | | NULL | |
  16. | is_active | tinyint(1) | YES | | 0 | |
  17. | created_at | datetime(6) | NO | | NULL | |
  18. | updated_at | datetime(6) | NO | | NULL | |
  19. | manufacturer_product_name | varchar(255) | YES | | NULL | |
  20. | manufacturer_std_lead_time | int(11) | YES | | NULL | |
  21. | manufacturer_std_lead_time_unit | varchar(255) | YES | | NULL | |
  22. | description | text | YES | | NULL | |
  23. | min_qty | int(11) | YES | | 1 | |
  24. | popularity | int(11) | YES | | 0 | |
  25. | requires_quote | tinyint(1) | YES | | 0 | |
  26. | ctyea_part_number | varchar(128) | YES | MUL | NULL | |
  27. | ref | varchar(128) | YES | | NULL | |
  28. | current_stock | int(11) | YES | | 0 | |
  29. | main_category_id | int(11) | YES | MUL | NULL | |
  30. | sub_category_id | int(11) | YES | MUL | NULL | |
  31. | attr_1 | varchar(128) | YES | | NULL | |
  32. | attr_2 | varchar(128) | YES | | NULL | |
  33. | attr_3 | varchar(128) | YES | | NULL | |
  34. | attr_4 | varchar(128) | YES | | NULL | |
  35. | attr_5 | varchar(128) | YES | | NULL | |
  36. | attr_6 | varchar(128) | YES | | NULL | |
  37. | attr_7 | varchar(128) | YES | | NULL | |
  38. | attr_8 | varchar(128) | YES | | NULL | |
  39. | attr_9 | varchar(128) | YES | | NULL | |
  40. | attr_10 | varchar(128) | YES | | NULL | |
  41. | attr_11 | varchar(128) | YES | | NULL | |
  42. | attr_12 | varchar(128) | YES | | NULL | |
  43. | attr_13 | varchar(128) | YES | | NULL | |
  44. | attr_14 | varchar(128) | YES | | NULL | |
  45. | attr_15 | varchar(128) | YES | | NULL | |
  46. .
  47. .
  48. .
  49. .
  50. | attr_121 | tinytext | YES | | NULL | |
  51. | attr_122 | tinytext | YES | | NULL | |
  52. | attr_123 | tinytext | YES | | NULL | |
  53. | attr_124 | tinytext | YES | | NULL | |
  54. | attr_125 | tinytext | YES | | NULL | |
  55. | attr_126 | tinytext | YES | | NULL | |
  56. | attr_127 | tinytext | YES | | NULL | |
  57. | attr_128 | tinytext | YES | | NULL | |
  58. +---------------------------------+---------------+------+-----+---------+----------------+
  59. 154 rows in set (0.002 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement