Page History

CREATE TABLE user
(
  user_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  client_id INTEGER,
  name TEXT NOT NULL,
  username TEXT NOT NULL,
  password TEXT NOT NULL,
  FOREIGN KEY(client_id) REFERENCES client(client_id)
);

-- Describe CLIENT
CREATE TABLE client
(
  client_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  name TEXT
);

CREATE TABLE project
(
  project_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  name TEXT,
  header TEXT, --Header to paper reports
  header TEXT, --sub header to paper reports
  date DATETIME,
  parent_project_id INTEGER,
  client_id INTEGER,
  author TEXT,
  notes TEXT,
  ActiveProject Boolean NOT NULL, -- only one prject active at time
  FOREIGN KEY(client_id) REFERENCES client(client_id)
);