People Table
Name: People
Describes the attributes of a person
Columns (any column not specified as mandatory is optional):
- PersonId
- firstName - mandatory
- LastName - Mandatory
- Prefix - Sir, Mr, Dr etc.
- Suffix - not very common in India but is in other countries (Jr etc)
- email - mandatory - primary contact email - This is also the primary key
- phone -
- mobile
- website
- blog
- Company (if employed or self-employed)
- address
- city
- state
- country
- regioncode (zip or pin)
- primary-im (instant messenger address)
- secondary-im (instant messenger address)
Comments (0)
You don't have permission to comment on this page.