gistfile1.sql

create table contact (
  id int primary key auto_incrementing not null,
  name text,
  phone text,
  customer_id int,
  foreign key customer_id references customer(id),
  project_id int,
  foreign key project_id references project(id),
  account_id int,
  foreign key account_id references account(id),
);

create table customer (
  id int primary key auto_incrementing not null,
  name text
);

create table project (
  id int primary key auto_incrementing not null,
  name text,
  value double
);

create table account (
  id int primary key auto_incrementing not null,
  name text
);