From: Bill Guindon <agorilla@...>
Date: 2004-09-08T01:54:21+09:00
Subject: Re: Request for ideas: simple, useful web app

On Wed, 8 Sep 2004 01:09:13 +0900, Kirk Haines <khaines@enigo.com> wrote:

> The vague criteria are:
> 
> 1) Can't be too complex as I have to walk a person through building the
> whole thing.
> 2) Should interact with a db of some sort.
> 3) Would be great if one could do file uploads in it somewhere.
> 4) If it could do some sort of on-the-fly SVG or image generation or
> something like that, I could leverage that.

hmmm... this may be 'too complex', simplify as needed.

business card generator

company  
  id, login, pass, company_name, address1, address2, phone, fax,
email, contact, etc.

logo_text (creates image, stores it in 'logos' below)
  id, company_id, name, text, font_id, color_id, size, bold?, italic?
     -- could lose this and just use a form that fills in logos table.

logos (allows file uploads, or creates from text)
  id, company_id, name, filename, create_date, last_update_date 

cards (final results stored here)
  id, company_id, name, logo_id, template_id

lookup lists used during card creation:
  card_fonts
    id, name, font

  card_font_colors
    id, name, color

  card_templates
     id, name, sample_image_path


-- 
Bill Guindon (aka aGorilla)