I have a complete project as like in ruby on rail with same tables name you can contact with me further on my email
Best Regards: MUHAMMAD FURQAN On Fri, Sep 27, 2019, 1:16 AM fugee ohu <fugee...@gmail.com> wrote: > > > On Monday, September 16, 2019 at 4:31:29 PM UTC-4, Ariel Juodziukynas > wrote: >> >> Personally, I would do this: >> >> auctions table >> (with the basic shared information of all auctions and an "auction type")) >> >> properties table >> property_name (like network, carrier, publisher, etc) >> auction_type (like cellphone, book, etc) >> >> auctions_properties >> auction_id >> property_id >> value >> >> That way you can have any number of auction types with any number of >> specific properties with just 3 tables. >> >> Note that the "value" column would be some string variation (VARCHAR, >> CHAR, TEXT, etc) depending on your needs, maybe you want to redesign it a >> little if you want to store different types. Like if you want to store an >> integer (and retrieve an integer) you'll have to save the original type and >> reparse it (you could use serialization but that requires a TEXT column and >> maybe you can't use that many space) >> >> El lun., 16 sept. 2019 a las 17:19, fugee ohu (<fuge...@gmail.com>) >> escribió: >> >>> I was looking at some auction projects that use a single listings table >>> for all auctions but I know on auction sites the form will be different for >>> different types of items like if you're selling a cell phone there'll be a >>> form field for network, carrier, whatever and if you're selling a book >>> there'll be form fields for publisher, year of publication, so they would >>> have separate tables I assume for books, cell phones, etc? Then how would >>> they treat them all as one? >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Ruby on Rails: Talk" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to rubyonra...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/rubyonrails-talk/512f8b73-e3a4-4e74-95e7-4281e7b54821%40googlegroups.com >>> <https://groups.google.com/d/msgid/rubyonrails-talk/512f8b73-e3a4-4e74-95e7-4281e7b54821%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> > Could I give the join table different value fields for different data > types llike text_value, date_value, string_value, ... > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to rubyonrails-talk+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rubyonrails-talk/02ff8e61-7024-4b21-a8b0-680507d8cb69%40googlegroups.com > <https://groups.google.com/d/msgid/rubyonrails-talk/02ff8e61-7024-4b21-a8b0-680507d8cb69%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAMWiOBt-A5qQ7hX4yDyQemWTNx%3DcW05WzHJF5bTbBYA%2BYzntZg%40mail.gmail.com.