Re: Form saving, db question ?

From:

Lew <lew@lewscanon.com>

Newsgroups:

comp.lang.java.programmer

Date:

Fri, 9 Jul 2010 07:28:39 -0700 (PDT)

Message-ID:

<c65d68b4-9b0d-4930-8576-e5531a42a1d7@x21g2000yqa.googlegroups.com>

On Jul 9, 8:28 am, vlado <vl...@miha.net> wrote:

CAR GARAGE NAME: CITY GARAGE (inputText)

------------------------------------------------------
| 2005 | 2006 =

| 2007 | 2008 |

-------------------------------------------------------
AMG | 200.000 | | =

| |

--------------------------------- ----------------------
OPEL | 15.000 | 20.000 | =

| |

-------------------------------------------------------

AND SO ON.....

Where Car garage name is inputText, and so are prices that are enetered
beneth years.
So can you please give me suggestion how the datatable(s) should look
like to save this form, and how
should entites look like ?

I already gave one answer to that question, but you didn't answer
mine.

-- PostgreSQL
CREATE TABLE garage
(
  garage VARCHAR(32) PRIMARY KEY,
  address TEXT,
  info TEXT
);

CREATE TABE make
(
  make VARCHAR(32) PRIMARY KEY
);

CREATE TABLE car
(
  car VARCHAR(32) PRIMARY KEY,
  make VARCHAR(32) NOT NULL FOREIGN KEY REFERENCES make (make)
  garage VARCHAR(32) FOREIGN KEY REFERENCES garage (garage),
  whenin DATE,
  info TEXT
);

-- no surrogate key ID needed or wanted

--
Lew