MySQL One Column, two Foreign Key options -

-

I have a database set up, it has two tables, with a event containing a Event_ID and Places with Venue_ID . These two tables have slightly different structures (events date and venue_name are not places) I have details of both events and places, which share the same structure. Can there be a description table, which can either refer to a event_id or space_id , or is it better to keep it separate? Or is there a third option?

places + developments do not have many details (referencing comments)

I'm not sure what your institutions are trying to do, but I (a native English speaker), a "phenomenon" is very different from a "site". An "event" is something that happens at a particular point in time and place. "Participants" can sign up for an "event" A "venue" is a special place. These are very different bodies.

There is a connection between them. As Alvaro points out in his comment, there is not a suitable feature for venue_name event . venue_id is a suitable attribute, creating a link between the table.

The answer to your question is that you can put the details in a table, but generally it is usually (in most cases) to include the details of different entities in a table, generally, You add a description column to the table, where you want that attribute.

There are some situations where such a table can be desirable if you are creating a multilingual database application and description can be shown to some users, you can translate You may want to store all such stars in the same table.

Comments

Post a Comment

Popular posts from this blog

Pygame memory leak with transform.flip -

-
Today I came across an interesting issue which, by writing a small side scroller, instead of a sprite sheet, I was planning to use because I lacked a good "packer" for making phantom sheets (and honestly with patience and passion as it is only a test project). Anyway, I showed the animation running on the right of 8 PNG (with transparency). I considered it a good idea to prepare the flipped images to run on the left in the consultant, and the frame is not framed when the game is running (Flip actually consumes a lot of CPU like I Was measured). > To get access to the loop, I get the memory leak self.move_l = [# 8 PNG images with transparency to the right] For the self in IMG. Move_l: self.move_r.append (pygame.transform.flip (img, true, false) error traceback: traceback (most recent Call final): The file "D: \ Python 34 \ _Projects \ efg \ efg.py", in line 196, in the & lt; module & gt; main = master program ((1024, 680)) "D: \ Python ...
Read more

python - Writing Greek in matplotlib labels, titles -

-
Image
I'm trying to write some text for labels, shape titles etc. with my plots, but no benefit till now Has not happened . I do not want to print specific characters (I know how to use special characters), I want to write the entire text in Greek (maybe Unicode and text ' ?). , suggesting that I would like to mention that for some reason I can not get matplotlib to cooperate with Tex (using IPython notebook from Anaconda in Ubuntu 14.10) so that there really is an option Will not be the first. I tried loading the Arial font and it loads successfully but again I get square blocks instead of characters. I import matplotlib.font_manager FM PROP = FM Font Properties (fname = '/ usr / share / fonts / truetype / msttcorefonts / Arial.ttf') And then to display the string I u'Î? ? I ?? Î¿Ï ?? ÎμÎ »second ?? μΠ± i ?? I ± i ?? I ?? Used ο किया? ? Î¿Î¼Î¿Î¯Ï ?? I ?? I · I ?? ' . Ariel is considered to be fully presented to Greek and I have used it many times ...
Read more

cmake set_source_files_properties not working properly -

-
I have a project in which. C is a group of files which need to be compiled as C files, but I need it to be compiled as C ++ code. I tried the solution I found, but did not work as expected. Instead of making filename.c only, it is compiled as C ++, it compiles all the files in my project as C ++ code. Without that call, all the files have been compiled as C. I also tried: set_source_files_properties ($ {FILES_SRC} property languages ​​C) set_source_files_properties (filename.c property languages ​​CFX) Where FILES_SRC variable keeps all my source files. I am CMK 2.8.12 and Visual Studio 11 ARM Generator. Any ideas how can I fix this? I finished compiling the library using C compiler and added a C ++ code to a different library For which I created a C interface so it can be told from my C library.
Read more