addresses are generally composed of specific information of provinces, cities, autonomous regions and counties. Are they stored separately in four fields?
the nearby subway is one-to-many. How do you store it and check the query?
there are also many pictures, similar to subway stations, how do you store them
what I will do is certainly not a standard answer.
provinces, cities and autonomous regions will be divided into three fields, detailed address of the fourth field. It is easy to check, and the input is easy to control. You can use selective input to avoid user mistakes.
there is a many-to-many relationship between the store and the subway, the subway and the store are stored independently, and the third table stores the relationship.
the picture is complicated, but it should be different from the subway. The possibility that the same picture corresponds to two stores is relatively low, while logo may correspond to multiple stores, but logo will only have one per store, and its frequency will be higher than other images. It should be stored in the store information table.
if logo is removed, the picture is a many-to-one relationship, and the external key of the picture table is associated with the store. The store table itself does not save picture information.
in this way, you can locate the store information directly to logo, and check the table to get other pictures when needed.
nearby subway stations are also checked separately.
I will write two tables, one is that the address and the subway are put together, then make a type distinction, and record their longitude and latitude, and the other table is to store shop pictures, so that you can find out that type is all the subway stations nearby according to the longitude and latitude of the store
.Previous: Using the struts tag to report an error
Next: Before uploading the video, you can let the user trim the photo and then upload it.
description: a regular match is given to the content of an input box, and the matching content is the product activation code. looks like this: "0C31-0B81-BB32-3094-0C31-0B81-BB32-3094 " Code: $( -sharplicenseCode ).keyup(function () { le...
I configured the MIME type of the file with the amr suffix in the apache configuration as application ms-download, Why it is a garbled page when opening a file in amr format using window.open in chrome, while a file in amr format can be successfully dow...
what does the code circled in the following picture mean? ...
adopt a reward of 10 yuan, 1045 Access denied for user root @ localhost (using password:NO) recently, when I was at the front end of my self-study, I came into contact with a little bit of database. This happened when I made a new connection on ...
there is an h5 page embedded in the encapsulated APP. After the function of issuing an order, how can I get the user s id to add the address and place the order ...
each person starts the game with a different Rank (a total of 14 Rank) and selects two people to answer the question pk,. How to design this algorithm? suppose that after I click to start the game, I send my request to enter a game to the server, and ...
A similar question, I want to know how to deal with the number of correct answers. I originally wanted to declare a variable and then decide to add it when the answer is right, but not if it is wrong. But what is printed is always 0 and 1 ....
...
make an answer system, trigger the click event on the answer page (choose the correct answer), and add 1. No mistakes. Now the whole answer is finished. Jump to another page, that is, the answer completion page, how can I get the value of the correct ans...
use Wechat public platform JSSDK to develop Wechat sharing function! Every time I use the company s public platform account, I report a signature error! There is nothing wrong with the account of the public platform developed by myself! I would like to...
involves other people s code problems, so the source code is deleted ...
the background gives me an interface to tell me the parameters to be passed, and how to click Save to save the address information entered by the user to the address list ...
when I click the button to select a region, there will be three addresses of provinces, cities and regions. I got the value through .html, but the parameters required by the background are separated by city and county. What do I do with the data segmen...
if a socket between the client and the server is closed (the tcp connection is closed), the client will not be able to re-establish an identical socket in a short period of time (two minutes according to the book). So my understanding is: join me to conn...
this is the HTML corresponding to this part ...
in the laravel project, when using the blade template, you often use @ section ( style ) on the page. <style type="text css"> < style> @ endsection or @ section ( script ) <script type="text javascript"> &...
the project uses jq+bscroll.js, because there are some pages that need to show chart data, so echart.js, uses a column chart (the data can slide left and right when the data is too long), resulting in problems with the original page sliding 1 if the f...
to write several mobile pages, you need to use the components provided by ant design mobile to develop. How to use this thing, the document doesn t understand much at first and which of the two ways mentioned above should be used, ah, to find a so...
https: www.creams.io , for example, how can you tell what language his background is written in? ...
...