Mysql database design issue -

Mysql database design issue -

I know I'm doing this wrong, so I'm hoping someone can help me here. It's a bit complicated, so I'll try to explain it as much as I can.

I have a table of products with an ID and title. A product can have multiple certificates and there may be several products in the certificate. So far, these are my tables:

Products
certificate
product_x_certificate

The problem here is that I should be able to present products together. So suppose I have these products:

Towels
Club
hats - balls

On a certificate, I present towels with clubs, another evidence In the letter, I present towels with hats, and on the other, I offer cap with balls, to make it even more complicated, customers have the option for each certificate. Therefore, there can be multiple offerings in a certificate, for example, customers have an option between balls and cap or towels and clubs on certificate A.

I tried to create a table named product_x_product and field A_ID, B_ID, certificate, but I am running in all types

thanks

I think you need most of the tables you need. * You can have multiple certificate IDs and multiple product IDs, in the product_x_Certificate *, which means that you can set up one like this:

  Product_x_Certificate table certificate id - Product ID 45 4 45 7 46 8 46 9 47 10    In this way you have one or several products per certificate that satisfies your first requirement. For the same certificate with many groups of products - why not just create a new Certificate ID? Then if you need to create them conceptually group then you can create certificate group and certificate_xartprograph group table like:  
  certificate group table certificategroupIID name1 items hitting certificate_x_CertificateGroup table certificate group id Certificate ID 1 461 47    Is this help?








02:22

















Get link





Facebook





X





Pinterest





Email





Other Apps




Comments





Post a Comment







Popular Posts




google chrome extension - Reason for Uncaught Error: Attempting to use
a disconnected port object -



    While retrieving the request from the content script, I get this error in the background page. Does anyone know that this error What can be the reason?   Full stack trace:    Unwanted error: Attempt to use Chrome / Renderer Extension Binding Disconnected Port Objects: 147 Chrome.port Post Message Chrome / Renderer Extension Binings: 147 ChromeHird.port DicePatchOnConnect.Connect Event Chrome / Renderer Extension Binings: 89IExtension.fu SendResponse.state background.js: 1573db.readTransaction.tx.executeSql.paramStr background.js: 1038    This only happens when Reloading extension is not being helpful for a few hours - it is not that after restarting the Chrome browser it will be a solution that becomes normal for a few hours, content script may continue to send requests for background No response can be sent from the background. Is there any way that I can catch this unwanted error and reset the listener?   I am using chrome.extension.onRequest.addListener for my communication. Bef...






visual studio 2010 - How to reinstall MVC 2 tools for VS2010? -



    I uninstalled ASP.Net MVC 2 device for Visual Studio 2010. How can I restore it? MVC2 downloads seem to include only the VS2008 device.   Whatever I said, says that MVC 2 has been included in VS2010, but the installation of an improvement did not fix it, and MVC 2 is not listed. Add VS2010 / Select a component in the Remove screen.      You will get your VS2010ToolsMVC2.msi VS2010 DVD under WCU \ ASPNETMVC - hopefully it will do!    






Git Bash script to check whether repo has any commits? -



    I have a script on which I need to work differently if there is one, which is one or more , Commits. What is the best way to do this?   Something like this will appear in the proxy code.    #! / Bin / bash if [[`git log_count`] ==" 0 "]]; Then there is no commodity for this repo. # What goods ... and echo are "one or more committed!" # What are the other things?    Any ideas?      you can    git rev-parse -verify HEAD    (after :)     This is a pipeline command, and its behavior vs. "  git diff " There is very little possibility to change   I find it more pronounced  rev-parse -verify  means "is this a valid object name?"    This is your  show-ref .  You ask "Is there anything in this safe / head in the safe?"  I ask, "what current  head  exists?"   In practice, both of these are fair tests, because once you have a branch, so to achieve the  HEAD , some mock values will indicate manually lack of editing It is very diffic...








Powered by Blogger