OR0000: Organisation (132 rows of data)
| FID |
Field |
Type |
Null |
Key |
Default |
Extra |
| 380 |
organisation_id |
varchar(9) |
NO |
PRI |
|
|
| 376 |
organisation_country_code |
char(2) |
YES |
|
|
|
| 178 |
organisation_code |
char(3) |
YES |
|
|
|
| 390 |
organisation_initials |
varchar(8) |
YES |
|
|
|
| 391 |
organisation_name |
varchar(60) |
YES |
|
|
|
| 386 |
address_line_1 |
varchar(50) |
YES |
|
|
|
| 387 |
address_line_2 |
varchar(50) |
YES |
|
|
|
| 388 |
address_line_3 |
varchar(50) |
YES |
|
|
|
| 389 |
address_line_4 |
varchar(50) |
YES |
|
|
|
| 392 |
city |
varchar(25) |
YES |
|
|
|
| 377 |
state_code |
char(2) |
YES |
|
|
|
| 378 |
postcode |
varchar(12) |
YES |
|
|
|
| 379 |
postcode_first_YN |
smallint(1) |
YES |
|
|
|
| 395 |
address_country_code |
char(2) |
YES |
|
|
|
| 506 |
country_name |
varchar(25) |
YES |
|
|
|
| 393 |
organisation_coverage |
enum() |
YES |
|
|
|
| 394 |
organisation_grouping |
enum() |
YES |
|
|
|
| 381 |
organisation_type |
enum() |
YES |
|
|
|
| 382 |
organisation_defunct_YN |
smallint(1) |
YES |
|
|
|
| 383 |
final_year_if_defunct |
varchar(4) |
YES |
|
|
|
| 384 |
current_org_id_if_defunct |
varchar(9) |
YES |
|
|
|
| 416 |
initials_of_current_org |
varchar(8) |
YES |
|
|
|
|