Re: Newbie Question: field length

If you think that you would needto identify if the address is home address, work etc, then you need to breakup your table into few more tables. This is how I would have done it.
each table has its'own PK eg address_type_id, address_id phone_type_id, phone_id and person_id
one table for

    address_types (Home, Work, firend ....)     adress (address_type_id FK)

    phone_type (Home, Work, firend ....)     phone (Phone_type_id FK)

    person
    peron_id
    phon_id (FK)
    adress_id (FK)

Ingeneral I would recomand varchar it is easy and you do not have to be wory about extra space.

 Good Luck
Tom

J. Park <johan_park_at_hotmail.com> wrote in message news:89j0hn$bnu$1_at_tesla.a2000.nl...
> I'm making my first oracle database
> and I am wondering for example
> what should be the the length of some fields
>
> this what I have at this moment.
> firstname (50 chars)
> surname (50 chars)
> initials (15 chars)
> telephone (20 chars)
> fax (20 chars)
> street (50 chars)
> zipcode (10 chars)
> city (50 chars)
> country (50 chars)
>
> Are they to long ( or to short ) ?
>
> thanks in advance,
> Johan (from Amsterdam, the Nethelands)
>
>
>
Received on Thu Mar 02 2000 - 00:00:00 CST