-- TABLES --

CONSACCOUNTINFO {
    consaccountinfo_id serial primary key, 
    description
}
- has about 200 records

CONSACCOUNT {
    consaccount_id serial primary key,
    consaccountinfo_id integer references Consaccountinfo(consaccountinfo_id), 
}
- 700 records

ACCOUNT {
    account_id serial primary key,
    consaccount_id integer references Consaccount(consaccount_id),
    ...
}
- 4700 records

PHONE {
    phone_id serial primary key,
    account_id integer references account(account_id),
    ...
}
- 150 000 records 
- index on account_id 

ITEM {
    item_id serial primary key
    phone_id integer references phone(phone_id),
    ...
}
- 70 000 records
- index on phone_id

CONSACCOUNT_ALLOCATED {
    consaccount_id integer references Consaccount(consaccount_id),
    ...
} 
- 1 record

CONSACCOUNT_APPROVED{
    consaccount_id integer references Consaccount(consaccount_id),
    ...
}
- 2 records

CONSACCOUNT_PAID{
    consaccount_id integer references Consaccount(consaccount_id),
    ...
}
- 2 records