[freeside] The first link for database diagrams

[ivan]

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