Archaeology
Reports Table Definitions
The Archaeological reports catalog of the IMNH database consists of a number of
related tables. The central table of the relation is the ArchaeologyReports
table, which contains the information about the report its self.
Additional information is provided through two linking tables. One linking
table, AuthorToReport, links the ArchaeologyReports table to the
Author table, which contains information about the authors of the report.
The other linking table, Location, is used to not only store locational
information, but also to link the Sties table to the ArchaeologyReports
table.
Click here for an Authoritative list
of database entries.
Table:
ArchaeologyReports
Columns |
Table:
Author
Columns |
| Name |
Type |
Size |
| Report number |
Text |
10 |
| AgencyReportNumber |
Text |
10 |
| PublicationTitle |
Text |
200 |
| SeriesName |
Text |
200 |
| Volume |
Text |
8 |
| Number |
Text |
8 |
| NumberOfPages |
Text |
8 |
| MonthlyQuarterly |
Text |
10 |
| WherePublished |
Text |
35 |
| Publisher |
Text |
50 |
| PublicationYear |
Long Integer |
4 |
| HomeLocation |
Text |
35 |
| EnteredBY |
Text |
35 |
| EntryDate |
Date/Time |
8 |
| Accession# |
Text |
8 |
| Received |
Long Integer |
4 |
| REC# |
Long Integer |
4 |
|
| Name |
Type |
Size |
| id |
Long Integer |
4 |
| lastname |
Text |
50 |
| firstname |
Text |
50 |
|
|
Table:
AuthorToReport
Columns |
|
|
| Name |
Type |
Size |
| author |
Long Integer |
4 |
| report |
Text |
50 |
|
|
Table:
Location
Column |
|
|
| Name |
Type |
Size |
| Location |
Long Integer |
4 |
| ReportNumber |
Text |
10 |
| SiteNumber |
Text |
12 |
| County |
Text |
10 |
|
|
|
|
|
|
|
|
|