Re: [firebird-support] Database design. Simple question!

On Mon, Jul 25, 2016 at 5:51 PM, shg_siste...@yahoo.com.ar [firebird-support] wrote: > > Hello! I have a FB 2.5 database with a tabla "invoices". I need to add a > field in that table which will be null most of the times. Lefts say, that > 90% of the records

Re: [firebird-support] Database design. Simple question!

To have a separate table for a single column is a good idea if the column will be of type BLOB and will be used just sometimes. Greetings. Walter. On Mon, Jul 25, 2016 at 5:51 PM, shg_siste...@yahoo.com.ar [firebird-support] wrote: > > > Hello! I have a

Re: [firebird-support] Database design. Simple question!

Tahnks  Sent from Yahoo Mail. Get the app On Monday, July 25, 2016 11:48 PM, "Aldo Caruso aldo.car...@argencasas.com [firebird-support]" wrote:  My advice is to create that field in the invoices table. You will always have this field at hand

Re: [firebird-support] Database design. Simple question!

My advice is to create that field in the invoices table. You will always have this field at hand without resorting to an outer join with another table that only has two fields ( the invoice ID and this field ) each time you need to inspect it. Aldo El 25/07/16 a las 18:51,

[firebird-support] Database design. Simple question!

Hello! I have a FB 2.5 database with a tabla "invoices". I need to add a field in that table which will be null most of the times. Lefts say, that 90% of the records will have this new field in null. What is your advice? To create a new table with a FK to "invoices" and save the needed