-- Atoms found in organic molecules.
create table atom(name text not null,
                  symbol text not null,
                  number integer not null,
                  weight real not null);

insert into atom values('hydrogen', 'H', 1, 1.0079);
insert into atom values('carbon', 'C', 6, 12.011);
insert into atom values('nitrogen', 'N', 7, 14.0067);
insert into atom values('oxygen', 'O', 8, 15.9994);
insert into atom values('phosphorus', 'P', 15, 30.97376);
insert into atom values('sulfur', 'S', 16, 32.06);
insert into atom values('calcium', 'Ca', 20, 40.08);
insert into atom values('iron', 'Fe', 26, 55.847);

create table molecule(name text not null,
                      atom text not null,
                      number integer not null);

insert into molecule values('water', 'H', 2);
insert into molecule values('water', 'O', 1);

insert into molecule values('ammonia', 'N', 1);
insert into molecule values('ammonia', 'H', 3);

insert into molecule values('methane', 'C', 1);
insert into molecule values('methane', 'H', 4);

insert into molecule values('methanol', 'C', 1);
insert into molecule values('methanol', 'O', 1);
insert into molecule values('methanol', 'H', 4);

insert into molecule values('lactic acid', 'C', 3);
insert into molecule values('lactic acid', 'O', 3);
insert into molecule values('lactic acid', 'H', 6);

insert into molecule values('thiamine', 'C', 13);
insert into molecule values('thiamine', 'H', 20);
insert into molecule values('thiamine', 'N', 4);
insert into molecule values('thiamine', 'O', 1);
insert into molecule values('thiamine', 'S', 1);