Show tables ? + 2 Feature requests -- PROPERTIES

[Bart Pietercil]

On 19-sep-07, at 16:03, Ruslan Zasukhin wrote:

> On 19/9/07 4:06 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:
>
>>>> 3) May I repeat an earlier FR to have the possibility to include
>>>> comments for all Valentina Objects (Table, Field, Link, Method).  
>>>> I do
>>>> realise that this is overkill for most projects, but I can  
>>>> assure you
>>>> that having this for big projects where multiple people are working
>>>> on a common database, this feature would be very welcomed. I am  
>>>> sure
>>>> PostgreSQL has it and I think this is also true for other major db
>>>> engines
>>>
>>> Instead  of  having  just a comments we are going to implement
>>> more  common thing - "properties". It would be system properties,  
>>> says
>>> properties which are most common for particular object kind  
>>> (Obviously
>>> 'comment' is kind of such property) and UDP (user-defined  
>>> properties).
>>>
>>>
>>
>> Super COOL; this means I can assign status property (finished, in
>> development) and category to tables. Please make it so that we can
>> have popup's to choose from when we 'set' a UDP (enums ?)
>
> Bart,
>
> You can see our draft of this idea here
>
>  http://www.valentina-db.com/dokuwiki/doku.php? 
> id=paradigma:public:en:docume
> ntation:vsql:reference:reference
>
>
> See
>     SET/GET PROPERTIES
>     SHOW PROPERTIES

I read the reference and while I can see this being very useful it is  
not what I meant.
If I understand correctly the UDP's will only be visualised when an  
appropriate query is run.
What I think is needed  for comments is a field in the system tables  
(for all object types) so it can be visualised in the interface of  
VStudio
as a property for that object. I feel the need for this by practicly  
everything I do now in VStudio (probably because the solution is  
becoming very complex)
I want to be able to put a comment next to a diagram, table, links,  
fields, views, triggers, stored procedures,....because when designing  
the solution I know why I take a decision but a few weeks later I  
forget or somebody else is left wondering why a certain object is the  
way it is.
So conclusion would be that UDF's are different from comments



Bart