> > 1) BIC and IBAN are not really used by the rest of the application. I
> > am thinking of breaking these off into a separate table anyway.
>
> This sounds very reasonable, to me
>
> > 2) A customer could also be a vendor. So entity_id could not be
> > assumed to be unique. Furthermore, you n
Hi Chris;
>
> Looking at these tables at the moment here are the thoughts that
> occur to me:
>
> 1) BIC and IBAN are not really used by the rest of the application. I
> am thinking of breaking these off into a separate table anyway.
This sounds very reasonable, to me
> 2) A customer could a
Hi Aurynn,
Looking at these tables at the moment here are the thoughts that occur to me:
1) BIC and IBAN are not really used by the rest of the application. I
am thinking of breaking these off into a separate table anyway.
2) A customer could also be a vendor. So entity_id could not be
assumed
Hiya;
I'm digging around in the Vendor and Customer tables, per JD's entity
modifications, and it looks like both tables are fundamentally
identical - The only difference is the customer table has
customer.invoice_notes and customer.id.
I'm going to remove both tables and replace it with en
