Re: newbie db design question
От
Ray O'Donnell
Тема
Re: newbie db design question
Дата
Msg-id
18151eefdd0.2834.f9dd809031fc0469edf0bbbf79c1d468@rodonnell.ie
Ответ на
newbie db design question (Rino Mardo)
Список
Дерево обсуждения
newbie db design question Rino Mardo <rino19ny@gmail.com>
Re: newbie db design question "Ray O'Donnell" <ray@rodonnell.ie>
Re: newbie db design question "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: newbie db design question Rino Mardo <rino19ny@gmail.com>
Re: newbie db design question Gavan Schneider <list.pg.gavan@pendari.org>
On 11 June 2022 08:05:41 Rino Mardo <rino19ny@gmail.com> wrote:
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
Hi there,
"serial" isn't a real type - it's just a shortcut for "integer not null default nextval(....)". Read about it here:
So the supplier_id column in the first table should be of type "integer".
supplier_id serial primary key references supplierbut it won't allow multiple primary key.how then to proceed?
You need a foreign key.... add this to the first table:
constraint <constraint name> foreign key (supplier_id) references supplier(supplier_id)
I hope this helps.
Ray.
regards,
В списке pgsql-general по дате отправления
