Re: [gnome-db] GUI - External Reference

On 3 September 2010 06:17, Daniel Espinosa <[email protected]> wrote:
> When used an external reference, may a reference to an ID is taken, but on
> GdaBrowser the ID is taken not any other more easy to remember file.
> For the Sales example, when you try to add a new order the customer field
> combobox shows the customer's ID, but may be is better to show its name and
> may be more data.
> When customizing a table, may is usefull to add a table's "Descriptor"
> helper. This could help to create a custom description of the table by using
> one field or a combination of them in order to create a String
> representation of the table.
> For example, if a customer table have the following fields:
> id serial PRIMARY KEY
> name string
> email string
> code string
> created date
> The table's descriptor could be created by using the following:
> 1) Take the customer's name
> 2) Take the customer's name and code
> 3) Take the customer's e-mail and name
> When more than one field is used a string concatenation of each field's
> string representation must be used.
>

For now, if there is a UNIQUE constraint (other than the Primary key
one), then the fields composing the unique constraint are taken to
create the "table's descriptor".

I have in mind to let one change this by adding some extra properties
in the preferences tab of the table's properties in the schema browser
perspective.

Regards,

Vivien