Re: Table Relationships

Поиск
Список
Период
Сортировка
От Aaron Bono
Тема Re: Table Relationships
Дата
Msg-id bf05e51c0610311243u6a1c05f7n263de118da4d2037@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Table Relationships  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Список pgsql-sql
On 10/31/06, A. Kretschmer <andreas.kretschmer@schollglas.com> wrote:
am  Tue, dem 31.10.2006, um 21:08:24 +0100 mailte A. Kretschmer folgendes:
> am  Tue, dem 31.10.2006, um 13:32:59 -0600 mailte Aaron Bono folgendes:
> > I would go further by adding a type table like this:
> >
> > operation_type (
> >     operation_type_id bigserial (PK),
>
> You are sure, that you need bigserial?

Hey, your idea is okay, but i think, we don't need *BIG*serial for this.
Okay?


Andreas

Sorry, just force of habbit.  Serial works or you can just drop the id and use the code as the primary key.  You should at the very least put a unique constraint on the code field.

--
==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
==================================================================

В списке pgsql-sql по дате отправления:

Предыдущее
От: "George Pavlov"
Дата:
Сообщение: record datatype comparisons
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Round Numeric Type