Re: [Gnumed-devel] Questions re database schema - naming

[Horst Herb]

On Thu, 2 Sep 2004 12:51, J Busser wrote:
> n the table "address" we have the pk_audit field
> NOT NULL  DEFAULT nextval('public.audit_fields_pk_audit_seq'::text)
>
> In the table audit_fields I cannot find audit_fields_pk_audit_seq.
>  From where does it come?
> Likewise audit_trail_pk_audit_seq'
>
> Are these missing from the table definitions?

"audit_fields_pk_audit_seq" is a "generator", ccording to Postgresql's default 
naming conventions for a column "pk_audit" within a table "audit_fields".
The generator is automatically generated for any comlun of te type 
"SERIAL" (serial is not really a data type, it is a macro for a long integer 
with unique key constraint and default value produced by generator and 
implemented via trigger)

Horst