CREATE TABLE planes_for_sale(
 ID INT PRIMARY KEY,
 AD_ID INT,
 FOREIGN KEY (AD_ID) REFERENCES ad (ID)
 )
 
 CREATE TABLE ad(
 ID SERIAL PRIMARY KEY,
 YEAR INT,
 MAKE VARCHAR(64) NOT NULL,
 MODEL VARCHAR(16) NOT NULL,
 COLOR VARCHAR(32),
 SELLER_ID INT,
 FOREIGN KEY (SELLER_ID) REFERENCES seller (ID)
 )

 CREATE TABLE seller(
 ID INT PRIMARY KEY,
 SELLER VARCHAR(64),
 LICENSE VARCHAR(32)
 )

 INSERT INTO TABLE ad (ID, YEAR, MAKE, MODEL, COLOR, SELLERID)
 VALUES(1, 1960, "CESSNA", "150", "white", 1),
 (2, 1945, "DOUGLAS AIRCRAFT COMPANY", "DC-3", "red", 2);
 
 INSERT INTO TABLE planes_for_sale (ID, AD_ID)
 VALUES (123, 1), (456, 2);
 
 INSERT INTO TABLE seller (ID, SELLER, LICENSE)
 VALUES (1, "DURAN DURAN", "12345678"),
 (2, "GYRO GEARLOOSE", "ABCDEFG")

 Table1 : Planes_For_Sale (Planes_for_sale_ID, AD_ID)
 Table2 : AD(AD_ID, year, make, model, color, price, seller_ID)
 Table3 : Seller(seller_ID, seller, license)

 Planes_For_sale
 1 | 1
 1 | 2 

 AD
 1 | 1960 | &c; | white | 1
 2 | 1945 | Douglas Aircraft Company | red | 2

 Seller
 1 | Duran Duran | 12345678
 2 | Gyro Gearloose | ABCDEFG

	create table planes_for_sale(
	plane_id integer,
	ad_id integer
	foreign key constraint ad_id references ad
	)

	create table ad (
	ad_id integer,
	year integer,
	make varchar(64),
	model varchar(64),
	color varchar(32),
	price double,
	seller integer
	foreign key constraint seller references ad
	)

	create table seller(
	seller_id integer,
	seller_name varchar(128),
	ad_id integer
	foreign key constraint ad_id references ad
	);

	insert into ad (ad_id, year, make, model, color, price, seller)
	values (1, 2020, 'make1', 'model16', 'silver', 100000.00, 99778),
	(2, 1999, 'make000', 'model322', 'jet-black', 59999.88, 6652632);

	insert into planes_for_sale (plane_id, ad_id)
	values (16782632, 1), (33345324, 2);

	insert into seller (seller_id, seller_name, ad_id)
	values (99778, 'seller1', 1),
	(6652632, 'seller2', 2);

 PlanesForSale (plane_id)
 Ad (plane_id, ad_id, year, make, model, color, price, seller_id)
 Seller (seller_id, seller, license)

 PlanesForSale
 plane_id
 1
 2

 Ad
 plane_id ad_id year make model color price seller_id
 1 1 2016 "maker1" "model1" "black" 1000 10
 1 2 2005 "maker1" "model3" "red" 1200 12

 Seller
 seller_id seller license
 10 "seller10" 12345
 12 "seller12" 34321

 planes_for_sale(id)
 id
 1

 ad(id, parent_id, year, make, model, color, price, seller_id)
 id    parent_id     year    make                model   color   price   seller_id
 1       1           1960    &c;                 150     white   NULL     1
 2       1           1945    Douglas Aircraft    DC-3    red     NULL     2 
                            

 seller(id,name,license)
 id        name            license
 1         Duran Duran     12345678
 2         Gyro Gearloose  ABCDEFG

 planes
 ID  
 1	

 ad
 ID	planesID	year	make 	     model   color
 1	1	 	1960	&c;	     150     white
 2	1		1945	Douglas...   DC-3    red

 seller 
 ID      adID    name      license
 1       1       Duran...  12345678   
 2       2       Gyro...   ABCDEFG

 planes_for_sale_ID
 1

 ad_ID   year   make              model  color  seller          planes_for_sale_ID
 1       1960   &c;               150    white  Duran Duran     1
 2       1945   Douglas Aicraft   DC-3   red    Gyro Gearloose  1

 seller_ID  license    ad_ID
 1          12345678   1
 2          ABCDEFG    2

 Table: planes_for_sale
 ad_id int
 1      
 2            

 Table: ad
 id, year, make, model, color,  seller,     seller_id, 
 1   1960  cessna 150    white Duran Duran    1 
 2   1945  douglas DC-3  red   Gyro Gearloose 2 

 Table: seller
 seller_id, ad_id, seller_liscense
     1       1       12345678
     2       2       ABCDEFG