Designing Default Value

From: Michael Fuchs <fuze_at_REMOVE.THIS.STUFFgmx.net>
Date: Mon, 20 Oct 2003 19:56:18 +0200
Message-ID: <bn17k5$mjl$1@bird.wu-wien.ac.at>

Having a list of values in one table, what would be the clean way to go to *design* a default value? (in an ER diagram)

I do NOT want to know about setting default values for CREATE TABLE statements when adding data, the question is how to design this information so that it can be read into my application.

example table:

---

|Currency| now i would like to have USD
|--------| as the default value,
| EUR | the application should then be
| USD | able to preselect this value
| CHF | to make usage easier;
| CAD |

---

Thank you very much everybody, your help is enormously appreciated!

Michael Received on Mon Oct 20 2003 - 12:56:18 CDT