Table clients {
    id               serial        [pk]
    client_name      varchar 
  }
  
  Table contacts {
    id               serial        [pk]
    client_id        int           [ref: > clients.id]  -- foreign key to clients
    prefix           varchar
    first_name       varchar
    middle_name      varchar
    last_name        varchar
    suffix           varchar
    pronunciation    varchar
    phone            varchar
    email            varchar
    job_title        varchar
    department       varchar
    notes            varchar
    isPrimaryContact boolean
    contactHierarchy int
    -- Any other fields (etc.)
  }
  
  Table addresses {
    id               serial        [pk]
    client_id        int           [ref: > clients.id]  -- foreign key to clients
    address_line1    varchar
    address_line2    varchar
    city             varchar
    state            varchar
    zip_code         varchar
    attention_line   varchar
  }
  
  Table jobs {
    id               serial        [pk]
    client_id        int           [ref: > clients.id]  -- foreign key to clients
    status           varchar       -- e.g. "Pending", "In Progress", "Completed"
    completion_date  date
    estimated_completion_date date
    created_date     date
    updated_date     date

  }
  
  Table proposals {
  id               serial        [pk]
  job_id        int           [ref: > jobs.id]  -- foreign key to job
  rfp_date
  rfp_status
  }

  Table bids {
    id               serial        [pk]
    job_id           int           [ref: > jobs.id]      -- foreign key to jobs
    bid_amount       numeric(12,2)
    bid_date         date
    accepted         boolean
  }
  
  Table rfc {
    id               serial        [pk]
    job_id           int           [ref: > jobs.id]      -- foreign key to jobs
    COMPONENTS OF RFC varchar
    description      text
    
  }
  
  Table rfa {
    id               serial        [pk]
    job_id           int           [ref: > jobs.id]      -- foreign key to jobs
    COMPONENTS OF RFA varchar
    description      text
  }
   
  Table estimates {
    id               serial        [pk]
    job_id           int           [ref: > jobs.id]      -- foreign key to jobs
                varchar
    description      text
  }

  Table phase_codes {
    id               serial        [pk]
    code             int
    description      varchar
}

   Table line_items {
   id               serial        [pk]
   phase_code_id    int           [ref: > phase_code.id]      -- foreign key to id
   description      varchar 
   }

  Table communications {
    id               serial        [pk]
    client_id        int           [ref: > clients.id]   -- Could link to a client
    contact_id       int           [ref: > contacts.id]  -- Possibly link to a specific contact
    job_id           int           [ref: > jobs.id]      -- Or link to a job if relevant
    communication_type varchar     -- e.g. "Proposal", "RFA", "Email", "Phone"
    communication_date date
    communication_text text        -- For notes or details
    internal_notes  text         --NOT TO BE SHARED for internal use
  }