[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: Horst Herb
Subject: Re: [Gnumed-devel] Questions re database schema - naming
Date: Thu, 2 Sep 2004 13:02:42 +1000
User-agent: KMail/1.6.2

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)


reply via email to

[Prev in Thread] Current Thread [Next in Thread]