Advertisement
Guest User

Untitled

a guest
Oct 30th, 2014
143
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. barcodes
  2. barcode_id primary key auto increment
  3. account_id integer not null; reference to accounts.account_id
  4. barcode varchar(255) not null
  5.  
  6. unique barcode + accound_id
  7. don't repeat barcode for that account
  8.  
  9. parts
  10. part_id primary key auto increment
  11. part_name varchar 1024 not null
  12. account_id integer not null; reference
  13. notes varchar 1024 null
  14.  
  15. unique part_name + account_id
  16. don't repeat part name for that account
  17.  
  18. part_barcodes
  19. part_id reference to parts.part_id
  20. account_id reference to accounts.account_id
  21. barcode_id reference to barcodes.barcode_id
  22.  
  23. part_id + account_id unique
  24. don't repeat part for that account; only one barcode per part
  25.  
  26. product_barcodes
  27. catalogid
  28. barcode_id
  29. account_id
  30. quantity
  31. notes
  32. option_set_id_1 NULL
  33. option_id_1 NULL
  34. ...
  35.  
  36. catalogid + account_id + option_set_id_1 + option_id_1 + ... unique
  37. don't repeat product for that account; only one barcode per product
  38.  
  39. product_components
  40. account_id
  41. type
  42. catalogid
  43. child_component_id
  44. quantity
  45. option_set_id_1 NULL
  46. option_id_1 NULL
  47. ...
  48.  
  49. account_id type catalogid child_component_id unique
  50. don't repeat components for that product
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement