newbie db design question

Поиск
Список
Период
Сортировка
От Rino Mardo
Тема newbie db design question
Дата
Msg-id CAGnasUXDC2R4juLfXrJ=P2fsnPZMt_M6tGdtZ=BEp+0j1=FxMQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: newbie db design question
Re: newbie db design question
Список pgsql-general
hello!

really noob question here. i have this experimental database design:

create table products (
product_id serial primary key,
description text,
supplier_id????) ;

create table supplier (
supplier_id serial primary key,
description text) ;


the products table should be linked to the supplier table via "supplier_id" column. i can't find out what would be the data type of supplier_id in table products to do that. i tried

supplier_id serial primary key references supplier

but it won't allow multiple primary key.

how then to proceed? 


regards,




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