[freeside] The first link for database diagrams

[ivan]

wrt dd1-2.jpg:

prepay_credit: I don't think that technically "links" anywhere.  Take a
look at the code in FS::cust_main::insert and decide for yourself

cust_pay_batch: invnum and custnum link to cust_bill and cust_main, as you
would expect

cust_main_county: Again, isn't technically linked anywhere either, but the
state, county and country fields in cust_main are checked (together) to
make sure there's an entry in cust_main_county corresponding to the
triplet.  I'm aware this is not "Normal Form", but in this specific case I
think it is wise not to abstract the customer's state and country behind a
foreign key.

On Fri, Sep 07, 2001 at 09:55:19PM -0700, ivan wrote:
> The svc_ tables in dd1-1.jpg which have a svcnum primary key (svc_acct,
> svc_acct_sm, svc_domain, and svc_www) are linked to cust_svc in dd1-3.jpg. 
> For any given svcnum there will be an entry in cust_svc and one (or no)
> entry in one of (svc_acct, svc_acct_sm, svc_domain, svc_www, and, in 1.4,
> svc_forward).
> 
> On Fri, Sep 07, 2001 at 05:44:58PM -0600, Kevin Steffensen wrote:
> > I did this fairly quickly, and I intend to do more it later.  But here is
> > the link.
> > 
> > http://trevor.ikano.com
> > 
> > There are three different images here that show different tables.
> > 
> > This was done with the old 1.3.1 schema (I have not yet upgraded to the new
> > beta, I will probably set that up later.)
> > 
> > My TODO list is as follows:
> > 
> > a. Get the relationships defined correctly
> > b. Combine the entire diagram into one file.
> > c. Upgrade the schema to 1.4
> > d. Create the diagram in Dia
> > e. Document the relationships (Primary-key table to Foreign-key table and
> > what columns are joined)
> 
> -- 
> _ivan

-- 
_ivan