X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f996b,9a42a4d1961ee2ed,start X-Google-Attributes: gidf996b,public X-Google-Thread: 110f55,9a42a4d1961ee2ed,start X-Google-Attributes: gid110f55,public X-Google-Thread: fbb9d,9a42a4d1961ee2ed,start X-Google-Attributes: gidfbb9d,public X-Google-ArrivalTime: 1994-06-08 15:39:57 PST Path: nntp.gmd.de!Germany.EU.net!EU.net!uunet!news2.sprintlink.net!news.sprintlink.net!sashimi.wwa.com!gagme.wwa.com!not-for-mail From: w_costa@unhn.unh.edu (Bill Costa, x2-3056, Computing & Info Srvs) Newsgroups: rec.arts.ascii,alt.ascii-art,alt.binaries.pictures.ascii Subject: LINE: illustrating a database structure Date: 8 Jun 1994 17:30:20 -0500 Organization: WorldWide Access (SM) Chicagoland Internet Services Lines: 66 Sender: boba@gagme.wwa.com Approved: boba@gagme.wwa.com Distribution: world Message-ID: <2t5gps$n3s@gagme.wwa.com> NNTP-Posting-Host: gagme.wwa.com Xref: nntp.gmd.de rec.arts.ascii:70 alt.ascii-art:11353 Well it's nice to see some of those examples. It makes me feel a bit better. I've been drawing simple diagrams using ASCII line art for a while now. I thought I was nuts. Now I think I'm not, or at least I have a lot of company. Here's a very typical example I was working on just a few days ago - it's contained within the comments to a database code definition file. Later......BC PS: It really helps to have a text editor that can do `rectangular' cut and paste! ## ## ## ## +------------------------------[ Bill.Costa@UNH.EDU ]---+ ## ### ## ## | Bill Costa | ## #### ## ## | Computing & Information Srvs | ## ## ## ######## | Kingsbury Hall PHONE: +1-603-862-3056 | ## ## #### ## | University of New Hampshire FAX: +1-603-862-4778 | ## ## ### ## | Durham, NH 03824-3591 | ####### ## ## +------------------[ No good deed goes un-punished. ]---+ !============================================================================== ! ! File: BUDGET.DMD ! System: VAX/VMS version V5.5-2 ! Language: System 1032 Data Definition Language (DDL). ! Created on: 7-JUN-1994 : : : ! ! Ledger.DMS Budget_Codes.DMS ! +---------------------------+ 1:n +--------------------+ ! | Transaction_Amount |+ +----> | Budget_Code |+ ! | Transaction_Description ||+ | | Budget_Name ||+ ! | Transaction_Date |||+ | +--------------------+||+ ! | Budget_Code - - - - - - | - - - - + +--------------------+|| ! | Transaction_Code - - - - | - - - - + +--------------------+| ! | Check_Number |||| | +--------------------+ ! | Posted_Date |||| | ! 1:n | Account_Code - - - - - - | - - -+ | Transaction_Codes.DMS ! +--> | Statement_ID |||| | | +--------------------+ ! | | Transaction_Link |||| | +----> | Transaction_Code |+ ! | | Transaction_ID |||| | 1:n | Transaction_Name ||+ ! | +---------------------------+||| | +--------------------+||+ ! | +---------------------------+|| | +--------------------+|| ! | +---------------------------+| | +--------------------+| ! | +---------------------------+ | +--------------------+ ! | | ! | | Account_Codes.DMS ! | | 1:n +--------------------+ ! | Statement_Info.DMS +-------> | Account_Code |+ ! | +---------------------------+ | Account_Name ||+ ! +--- | Statement_ID |+ +--------------------+||+ ! | Date_Issued ||+ +--------------------+|| ! | Due_Date |||+ +--------------------+| ! | Date_Mailed |||| +--------------------+ ! | Check_Number |||| ! | Comments |||| ! +---------------------------+||| ! +---------------------------+|| ! +---------------------------+| ! +---------------------------+ !