On Thursday, September 26, 2019 at 4:53:15 PM UTC-4, M.FURQAN BiN.AMEEN wrote: > > 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 <fuge...@gmail.com <javascript:>> > 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 rubyonra...@googlegroups.com <javascript:>. >> 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> >> . >> > whats your email
-- 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/0b24a3f1-a1f9-4b23-99c4-bb867259977a%40googlegroups.com.