Re: newbie db design question

2022-06-11 Thread Rino Mardo
thank you. i have received some tips on how to approach my problem. i will be trying them out. On Sat, 11 Jun 2022, 5:51 pm Peter J. Holzer wrote: > On 2022-06-11 09:43:46 +0100, Ray O'Donnell wrote: > > On 11 June 2022 08:05:41 Rino Mardo wrote: > > really noob question here. i have this e

Re: newbie db design question

2022-06-11 Thread Peter J. Holzer
On 2022-06-11 09:43:46 +0100, Ray O'Donnell wrote: > On 11 June 2022 08:05:41 Rino Mardo wrote: > really noob question here. i have this experimental database design: > > create table products ( > product_id serial primary key, > description text, > supplier_id) ; > >

Re: newbie db design question

2022-06-11 Thread Ray O'Donnell
On 11 June 2022 08:05:41 Rino Mardo 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

Re: newbie db design question

2022-06-11 Thread Gavan Schneider
On 11 Jun 2022, at 17:05, Rino Mardo wrote: > … 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

newbie db design question

2022-06-11 Thread Rino Mardo
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 supplie