really noob question here. i have this experimental database design:
create table products (
product_id serial primary key,
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?