PE0000: Person (1319 rows of data)
| FID |
Field |
Type |
Null |
Key |
Default |
Extra |
| 478 |
person_id |
varchar(10) |
NO |
PRI |
|
|
| 479 |
surname |
varchar(30) |
YES |
|
|
|
| 480 |
usual_first_name |
varchar(20) |
YES |
|
|
|
| 481 |
middle_initial |
varchar(5) |
YES |
|
|
|
| 482 |
initials_for_given_names |
varchar(10) |
YES |
|
|
|
| 483 |
title |
varchar(20) |
YES |
|
|
|
| 484 |
address_line_1 |
varchar(50) |
YES |
|
|
|
| 485 |
address_line_2 |
varchar(50) |
YES |
|
|
|
| 486 |
address_line_3 |
varchar(50) |
YES |
|
|
|
| 487 |
address_line_4 |
varchar(50) |
YES |
|
|
|
| 488 |
city_or_suburb |
varchar(25) |
YES |
|
|
|
| 490 |
state_code |
char(2) |
YES |
|
|
|
| 491 |
postcode |
varchar(12) |
YES |
|
|
|
| 492 |
country_name |
varchar(25) |
YES |
|
|
|
| 493 |
country_code |
char(2) |
YES |
|
|
|
| 494 |
email_address |
varchar(30) |
YES |
|
|
|
| 495 |
phone_numbers_prefix |
varchar(15) |
YES |
|
|
|
| 496 |
home_phone_number |
varchar(18) |
YES |
|
|
|
| 497 |
work_phone_number |
varchar(18) |
YES |
|
|
|
| 498 |
mobile_phone_number |
varchar(18) |
YES |
|
|
|
| 499 |
fax_phone_number |
varchar(18) |
YES |
|
|
|
| 500 |
pager_phone_user_number |
varchar(20) |
YES |
|
|
|
| 501 |
organisation_code_1 |
char(3) |
YES |
|
|
|
| 502 |
organisation_code_2 |
char(3) |
YES |
|
|
|
| 503 |
organisation_code_3 |
char(3) |
YES |
|
|
|
|