CREATE TABLE my_company (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name varchar,
    address varchar,
    city varchar,
    state varchar,
    zip varchar,
    description varchar,
    contact_name varchar,
    contact_email varchar,
    contact_phone varchar
);

INSERT INTO my_company ( name, address, city, state, zip, description, contact_name, contact_email, contact_phone )
    VALUES ( 'Crow Motors', '12 E. Main', 'Paxton', 'NE', 69155, 'Car and Implement Sales and Service', 'EJ', 'ej@example.com', '1-800-CROW-MOT' );

CREATE TABLE customer (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name varchar,
    address varchar,
    city varchar,
    state varchar,
    zip varchar,
    description varchar,
    contact_name varchar,
    contact_email varchar,
    contact_phone varchar
);

INSERT INTO customer ( name, address, city, state, zip, description, contact_name, contact_email, contact_phone )
    VALUES ( 'Groover Nordqvist', '502 E. Third', 'Paxton', 'NE', 69155, 'Prime Customer', 'Groover', 'gnordqvist@example.com', 'Unlisted' );

CREATE TABLE line_item (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    due_date date,
    name varchar,
    invoice INTEGER,
    hours INTEGER,
    charge_per_hour INTEGER,
    notes text,
    description text
);

CREATE TABLE invoice (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    number varchar,
    status INTEGER,
    sent date,
    paid date,
    my_company INTEGER,
    customer INTEGER,
    notes text,
    description text
);

CREATE TABLE status (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name varchar,
    description varchar
);

INSERT INTO status ( name, description )
    VALUES ( 'Working', 'Work in Progress, NOT Billed' );

INSERT INTO status ( name, description )
    VALUES ( 'Sent', 'Mailed to Customer' );

INSERT INTO status ( name, description )
    VALUES ( 'Paid', 'Payment Received' );