Database Glossary

Table: tblBasicSiteData (Basic Site Data)

SiteNo	Text	255	Site number
SiteAbbrev	Text	255	Standard site abbreviation for project
SiteAbbrevOrder	Text	255	Site abbreviation order
SiteNoOrder	Long Integer	4	Site number order
SiteNoSort	Text	255	Site number sort order
SiteName	Text	255	Site name
SiteDates	Text	255	Occupation dates
Affiliation	Text	255	Institution in charge of excavation or curated artifacts
RecordLocation	Text	255	Location of records
SiteType	Text	255	Site type (Native, Plantation, St. Marys City)
SiteType2	Text	255	Site type (secondary sort)
Summary	Text	255	Summary
ShortSummary	Text	255	Short summary
ASPPage	Text	255	Site summary page link
ThumbnailFile	Text	255	Thumbnail file
MainSiteMap	Text	255	Main site map
ImageFolder	Text	255	Folder where artifact images are kept
AccessFile	Text	255	Access file with artifact, context, and historical data for this site
GISMapsFile	Text	255	File with GIS maps for this site
SiteMapsFile	Text	255	File with site maps for this site
FaunalRpts	Text	255	Faunal reports?
HistoricalData	Text	255	Historical data?
SmallFinds	Text	255	Small find records?
MVC	Text	255	Minimum vessel counts?
Title	Yes/No	1	Title?
Probate	Yes/No	1	Probate records?
ArtifactRecords	Long Integer	4	Number of artifact records
ArtifactCount	Long Integer	4	Count of artifacts
ContextRecords	Long Integer	4	Number of context records
FullSiteName	Text	255	Full site name
OccupyStart	Long Integer	4	First year of occupation
OccupyEnd	Long Integer	4	Last year of occupation
CatalogTradition	Text	255	Cataloguing tradition

Table: tblArtifactCatalog (Artifact Catalog)

ObjectID	Long Integer	4	Identifier for artifact catalog table
SiteNo	Text	255	Site number
SiteAbbrev	Text	255	Standard site abbreviation for project
ContextNumber	Text	255	Context number
Count	Double	8	Number of fragments or objects
WeightOz	Text	255	Weight in ounces
WeightG	Text	255	Weight in grams
ObjectType	Text	255	Object type
ObjectSubType	Text	255	Object subtype
Material	Text	255	Material
MaterialSubType	Text	255	Material subtype
WareType	Text	255	Ware type
WareSubType	Text	255	Ware subtype
VarietyAttributes	Text	255	Variety or attributes
Taxonomy	Text	255	Taxonomy (for faunal and floral remains only)
Temper	Text	255	Temper
Technology	Text	255	Technology
Glaze	Text	255	Glaze
Paste	Text	255	Paste
SurfaceTreatment	Text	255	Surface treatment
Decoration	Text	255	Decoration
Color	Text	255	Color
Element	Text	255	Element
BoreDiameter	Text	255	Bore diameter
MakersMarks	Text	255	Text of makers marks if any
Condition	Text	255	Condition
Dimensions	Text	255	Dimensions
Remarks	Text	255	Other remarks or comments
MacCordLot	Text	255	Lot for Howard MacCord sites
OriginalLot	Long Integer	4	Original lot designation
HasSmallFind	Text	255	Is there a record in the small finds table?
SubTable	Text	50	Name of subtable with specialized data, if any
HasImage	Text	255	Is there at least one artifact image?

Table: tblSFMain (Small Finds)

SmallFindID	Long Integer	4	Identifier for small finds table
ObjectID	Long Integer	4	Identifier for artifact catalog table
NoOfObject	Long Integer	4	Number of objects
SiteAbbrev	Text	255	Standard site abbreviation for project
SiteNo	Text	255	State site number
Location	Text	255	Location where small find was examined
Conserved	Yes/No	1	Conserved?
RecordDate	Date/Time	8	Date recorded
Recorder	Text	255	Recorded by
Color1	Text	255	Primary color
Color2	Text	255	Secondary color
Color3	Text	255	Tertiary color
Length	Text	255	Length
Width	Text	255	Width
Height	Text	255	Height
Diameter	Text	255	Diameter
Morphology	Text	255	Morphology
Category	Text	255	General functional category
SubCategory	Text	255	General functional subcategory
Country	Text	255	Country of origin
Manufactory	Text	255	City of origin
Marks	Text	255	Type of mark
MarkText	Text	255	Text of mark
Fashionability	Text	255	Fashionability
PostMod	Text	255	Post-
Remarks	Text	255	Remarks or comments
Disputed	Text	255	Disputed?
Verified	Date/Time	8	Verified?
VerifiedBy	Text	255	Verified by
RecLastUpdate	Date/Time	8	Date record last updated
Photolink1	Text	255	First photo link
Photolink2	Text	255	Second photo link
Photolink3	Text	255	Third photo link
SubTable	Text	255	Specialized table containing further information

Table: tblContext (Context Records)

ContextID	Long Integer	4	Identifier for context table
SiteNo	Text	50	Site number
SiteAbbrev	Text	50	Standard site abbreviation for project
ContextNumber	Text	50	Context number
ContextSort	Text	255	Sort order for context number
DepositType	Text	50	Deposit type
DepositSubType	Text	50	Deposit subtype
ShortSummary	Text	255	Summary of the context involved
ShortTitle	Text	255	Short title
ContextDescription	Text	255	Context description
CenterX	Double	8	Center point X (east-west) direction
CenterY	Double	8	Center point Y (north-south) direction
GridNorthCoord	Double	8	Grid north coordinate
GridEastCoord	Double	8	Grid east coordinate
NorthingY	Double	8	Northing
EastingX	Double	8	Easting
HorizLoc	Text	255	Horizontal location
ExcavationUnit	Text	50	Excavation unit
FeatureNumber	Text	50	Feature number
StratLevel	Text	50	Stratigraphic level
Provenience	Text	255	Provenience
Area	Text	50	Area
UnitSize	Text	50	Unit size
SizeMultiple	Double	8	Size multiple (for calculating to account for varying unit sizes)
SCNumber	Text	50	Surface collection number
MacCordUnit	Text	50	Unit assigned by Howard MacCord
MacCordAccNumber	Double	8	Accession number assigned by Howard MacCord
JPPMLot	Double	8	Lot number assigned by Jefferson Patterson Park
JPPMDistributionMap	Text	50	Has distribution map created by Jefferson Patterson Park?
ExcavationMethod	Text	50	Excavation method
ScreenType	Text	50	Screen type
FeatureType	Text	50	Feature type
BasinType	Text	50	Basin type
TemporalPeriod	Text	50	Temporal period
ContextType	Text	50	Context type
Remarks	Text	255	Remarks
ExcavatorsNotes	Text	255	Excavators notes
SupervisorsNotes	Text	255	Supervisors notes
ContextLater	Text	50	Context later
ContextEarlier	Text	50	Context earlier
TPQ	Text	50	TPQ
PlanShape	Text	50	Plan shape
ProfileShape	Text	50	Profile shape
SoilType	Text	50	Soil type
SoilTexture	Text	50	Soil texture
MunsellColor	Text	50	Munsell color
Length	Text	50	Length
Width	Text	50	Width
Depth	Text	50	Depth
XCoord	Text	50	X (east-west) coordinate
YCoord	Text	50	Y (north-south) coordinate
ZCoord	Text	50	Z (elevation) coordinate
ExcavatedBy	Text	50	Excavated by
ExcavatedDate	Date/Time	8	Excavation date

Table: tblBaleSeal (Bale Seals)

SmallFindID	Long Integer	4	Identifier for small finds table
Type	Text	255	Type
Sections	Long Integer	4	Sections
SealMotif	Text	255	Seal motif
Duty	Text	255	Duty
Shape	Text	255	Shape

Table: tblBead (Beads)

SmallFindID	Long Integer	4	Identifier for small finds table
ManufMeth	Text	255	Manufacturing method
Construction	Text	255	Construction
Shape	Text	255	Shape
Opacity	Text	255	Opacity
AddMod	Text	255	Additional modification
Dimensions	Text	255	Dimensions
Classification	Text	255	Classification

Table: tblBit (Bits)

SmallFindID	Long Integer	4	Identifier for small finds table
BitType	Text	255	Bit type
Mouthpiece	Text	255	Mouthpiece
MouthpieceLength	Text	255	Mouthpiece length
ShankLength	Text	255	Shank length
PurchaseLength	Text	255	Purchase length
AddHardware	Text	255	Additional hardward
BridleBossType	Text	255	Bridle boss type
BBStyle	Text	255	Bridle boss style
BBCrossType	Text	255	Bridle boss cross type
BBPlating	Text	255	Bridle boss plating
BBRivetMat	Text	255	Bridle boss rivet material
BBRivetStyle	Text	255	Bridle boss rivet style

Table: tblBuckle (Buckles)

SmallFindID	Long Integer	4	Identifier for small finds table
BuckleType	Text	255	Buckle type
Dimensions	Text	255	Dimensions
Shape	Text	255	Shape
Technology	Text	255	Technology
FrameType	Text	255	Frame type
HookType	Text	255	Hook type
PinTerminal	Text	255	Pin terminal
PinOrientation	Text	255	Pin orientation
PinCenterMeasure	Text	255	Pin center measurement
Tongue	Text	255	Tongue
Plating	Text	255	Plating
Decoration	Text	255	Decoration
Motif	Text	255	Motif
Element	Text	255	Element

Table: tblButtonCuffStud (Buttons, Cufflinks, and Studs)

SmallFindID	Long Integer	4	Identifier for small finds table
ButtonType	Text	255	Button type
Shape	Text	255	Shape
ShankType	Text	255	Shank type
SecondaryMat	Text	255	Secondary material
Completeness	Text	255	Completeness
Decoration	Text	255	Decoration
Diameter	Text	255	Diameter
MakersMark	Text	255	Makers mark

Table: tblCandlestick (Candlesticks)

SmallFindID	Long Integer	4	Identifier for small finds table
CandleType	Text	255	Candle type
Technology	Text	255	Technology
FootShape	Text	255	Foot shape
ColumnFeature	Text	255	Column feature
DripPanType	Text	255	Drip pan type
HandleType	Text	255	Handle type
Nozzle	Text	255	Nozzle
ColumnDiam	Text	255	Column diameter
BaseDiam	Text	255	Base diameter
Element	Text	255	Element

Table: tblCeramics (Ceramics)

SmallFindID	Long Integer	4	Identifier for small finds table
VesselForm	Text	255	Vessel form
Marks	Text	255	Marks
Style	Text	255	Style

Table: tblCoins (Coins)

SmallFindID	Long Integer	4	Identifier for small finds table
Denomination	Text	255	Denomination
CoinDate	Text	255	Coin date

Table: tblComb (Combs)

SmallFindID	Long Integer	4	Identifier for small finds table
ToothLength	Text	255	Tooth length
ToothSpacing	Text	255	Tooth spacing

Table: tblCurtainRing (Curtain Rings)

SmallFindID	Long Integer	4	Identifier for small finds table
Completeness	Text	255	Completeness

Table: tblGlassware (Glassware)

SmallFindID	Long Integer	4	Identifier for small finds table
Composition	Text	255	Composition
FootringDiam	Text	255	Footring diameter
RimDiam	Text	255	Rim diameter
FootringType	Text	255	Footring type

Table: tblGrommet (Grommets)

SmallFindID	Long Integer	4	Identifier for small finds table
Technology	Text	255	Technology
Dimensions	Text	255	Dimensions

Table: tblGunflint (Gunflints)

SmallFindID	Long Integer	4	Identifier for small finds table
Origin	Text	255	Origin
Type	Text	255	Type
Cortex	Yes/No	1	Cortex?

Table: tblGuns (Guns)

SmallFindID	Long Integer	4	Identifier for small finds table
LockType	Text	255	Lock type
LockPlateShape	Text	255	Lockplate shape
MountScrews	Long Integer	4	Number of mounting screws
TriggerType	Text	255	Trigger type
SearType	Text	255	Sear type
Element	Text	255	Element

Table: tblHinge (Hinges)

SmallFind ID	Long Integer	4	Identifier for small finds table
HingeType	Text	255	Hinge type
Mounting	Text	255	Mounting
Symmetry	Yes/No	1	Symmetry?
JointType	Text	255	Joint type
Notes	Text	255	Notes

Table: tblHorseshoe (Horseshoes)

SmallFindID	Long Integer	4	Identifier for small finds table
HorseshoeType	Text	255	Horseshoe type
NoNailHoles	Long Integer	4	Number of nail holes
Fullering	Text	255	Fullering
Calkins	Yes/No	1	Calkins?

Table: tblJettonToken (Jettons and Tokens)

SmallFindID	Long Integer	4	Identifier for small finds table
Maker	Text	255	Maker
DateRange	Text	255	Date range

Table: tblJewelry (Jewelry)

SmallFindID	Long Integer	4	Identifier for small finds table
JewelryType	Text	255	Jewelry type
JewelrySubtype	Text	255	Jewelry subtype
Diameter	Text	255	Diameter
Decor	Text	255	Decoration
Completeness	Text	255	Completeness

Table: tblKey (Keys)

SmallFindID	Long Integer	4	Identifier for small finds table
BowType	Text	255	Bow type
BitType	Text	255	Bit type
Collar	Yes/No	1	Collar?
SolidShank	Yes/No	1	Solid shank?

Table: tblLeadShotSprue (Lead Shot and Sprues)

SmallFindID	Long Integer	4	Identifier for small finds table
Type	Text	255	Type
Subtype	Text	255	Subtype
Weight	Text	255	Weight
Caliber	Text	255	Caliber
ShotSprue	Text	255	Shot or sprue
ShotTechnology	Text	255	Shot technology
Condition	Text	255	Condition
Completeness	Text	255	Completeness

Table: tblLeatherOrnaments (Leather Ornaments)

SmallFindID	Long Integer	4	Identifier for small finds table
TineType	Text	255	Tine type
TineLength	Text	255	Tine length
LeatherThickness	Text	255	Leather thickness
Style	Text	255	Style
Plating	Text	255	Plating

Table: tblLithic (Lithics)

SmallFindID	Long Integer	4	Identifier for small finds table
Type	Text	255	Type
Period	Text	255	Period
Source	Text	255	Source
Notes	Text	255	Notes

Table: tblLock (Locks)

SmallFindID	Long Integer	4	Identifier for small finds table
LockType	Text	255	Lock type
Shape	Text	255	Shape
Housing	Text	255	Housing
ShackleType	Text	255	Shackle type
KeyholeCover	Text	255	Keyhole cover
NoBolts	Text	255	Numer of bolts

Table: tblMedals (Medals)

SmallFindID	Long Integer	4	Identifier for small finds table
Thickness	Text	255	Thickness
ObjectText	Text	255	Object text
Decoration	Text	255	Decoration

Table: tblNativeCeramics (Native Ceramics)

SmallFindID	Long Integer	4	Identifier for small finds table
Period	Text	255	Period
MaxThickness	Text	255	Maximum thickness
MinThickness	Text	255	Minimum thickness
ExteriorTreatment	Text	255	Exterior treatment
InteriorTreatment	Text	255	Interior treatment
Type	Text	255	Type

Table: tblNeedleBodkin (Needles and Bodkins)

SmallFindID	Long Integer	4	Identifier for small finds table
EyeLength	Text	255	Eye length
EarScoop	Text	255	Ear scoop

Table: tblPin (Pins)

SmallFindID	Long Integer	4	Identifier for small finds table
Weight	Text	255	Weight
Technology	Text	255	Technology
HeadType	Text	255	Head type

Table: tblProjPoint (Projectile Points)

SmallFindID	Long Integer	4	Identifier for small finds table
PointType	Text	255	Point type
Period	Text	255	Period
Source	Text	255	Source

Table: tblScissors (Scissors)

SmallFindID	Long Integer	4	Identifier for small finds table
Tip	Text	255	Tip
EyeRingDim	Text	255	Eye ring dimensions
BladeWidth	Text	255	Blade width
BladeLength	Text	255	Blade length
HandleType	Text	255	Handle type
HandleDecor	Text	255	Handle decoration

Table: tblSmokersCompanion (Smokers Companions)

SmallFindID	Long Integer	4	Identifier for small finds table
ObjectSubtype	Text	255	Object subtype
SpineThickness	Text	255	Spine thickness
BasalNotch	Yes/No	1	Basal notch?

Table: tblSnuffer (Snuffers)

SmallFindID	Long Integer	4	Identifier for small finds table
HandleType	Text	255	Handle type

Table: tblSpurs (Spurs)

SmallFindID	Long Integer	4	Identifier for small finds table
ArmLength	Text	255	Arm length
StudLength	Text	255	Stud length
RowelBoxDim	Text	255	Rowel box diameter
NeckLength	Text	255	Neck length
StudType	Text	255	Stud type
ChapeType	Text	255	Chape type
TerminalShape	Text	255	Terminal shape
BuckleShape	Text	255	Buckle shape

Table: tblStirrup (Stirrups)

SmallFindID	Long Integer	4	Identifier for small finds table
PlatformType	Text	255	Platform type
SideProfile	Text	255	Side profile
EyeLoop	Text	255	Eye loop

Table: tblSwordBlade (Sword Blades)

SmallFindID	Long Integer	4	Identifier for small finds table
Type	Text	255	Type
BladeType	Text	255	Blade type
Technology	Text	255	Technology
MakersMark	Text	255	Makers mark
Element	Text	255	Element
HiltType	Text	255	Hilt type
HiltMat	Text	255	Hilt material
HiltTech	Text	255	Hilt technology
ShellType	Text	255	Shell type
Quillion	Text	255	Quillion
PommelShape	Text	255	Pommel shape
KnuckleGuard	Yes/No	1	Knuckle guard?
SpineWidth	Text	255	Spine width
Tang	Text	255	Tang
Fuller	Yes/No	1	Fuller?
PointType	Text	255	Point type

Table: tblTack (Tacks)

SmallFindID	Long Integer	4	Identifier for small finds table
Decoration	Text	255	Decoration
TackElement	Text	255	Tack element

Table: tblUtensil (Utensils)

SmallFindID	Long Integer	4	Identifier for small finds table
UtensilType	Text	255	Utensil type
Form	Text	255	Form
Plating	Text	255	Plating
Decor	Text	255	Decoration
Element	Text	255	Element
Technology	Text	255	Technology
ShapeHandle	Text	255	Shape handle
ShapeBlade	Text	255	Shape blade
ShapeBowl	Text	255	Shape bowl
Tang	Text	255	Tang
Rattail	Yes/No	1	Rattail?

Table: tblWeights (Weights)

SmallFindID	Long Integer	4	Identifier for small finds table
Standard	Text	255	Standard
WeightUnit	Text	255	Weight unit
Marks	Text	255	Marks
Shape	Text	255	Shape

Table: tblOccupant (Historical Data, Owners and Occupants)

OccupantID	Long Integer	4	Identifier for occupant table
OccupantName	Text	255	Name of owner or occupant
Occupation	Text	255	Occupation
Born	Long Integer	4	Year born
Death	Long Integer	4	Year died
Ethnicity	Text	255	Ethnicity
Religion	Text	255	Religion
PlaceBirth	Text	255	Place of birth
PlaceDeath	Text	255	Place of death
MotherName	Text	255	Mothers name
MotherOrigin	Text	255	Mothers origin
FatherName	Text	255	Fathers name
FatherOrigin	Text	255	Fathers origin
EstateValue	Text	255	Estate value in pounds
TotSlaves	Long Integer	4	Total number of slaves
MSlaves	Long Integer	4	Number of male slaves
FSlaves	Long Integer	4	Number of female slaves
TotServ	Long Integer	4	Total number of servants
MServ	Long Integer	4	Number of male servants
FServ	Long Integer	4	Number of female servants
OccupantNameLF	Text	255	Name of owner or occupant, last name first

Table: tblOccLink (Historical Data, Link to Occupant)

OccLinkID	Double	8	Identifier for occupant link table
OccupantID	Double	8	Identifier for occupant table
SiteAbbrev	Text	255	Standard site abbreviation for project
OwnOcc	Text	255	Owner or occupant
OccupantName	Text	255	Name of owner or occupant

Table: tblOccSpouse (Historical Data, Spouses)

SpouseID	Long Integer	4	Identifier for spouse table
OccupantID	Long Integer	4	Identifier for occupant table
SpouseName	Text	255	Name of spouse
MarriageDate	Long Integer	4	Date of marriage
MarriagePlace	Text	255	Place of marriage
SpouseOccupantID	Long Integer	4	Occupant ID of spouse

Table: tblOccChild (Historical Data, Children)

ChildID	Long Integer	4	Identifier for child table
ChildName	Text	255	Name of child
ChildBirth	Long Integer	4	Year of childs birth
ChildOccupantID	Long Integer	4	Occupant ID of parent

Table: tblOccChLink (Historical Data, Children Linking Table)

OccupantID	Long Integer	4	Identifier for occupant table
ChildID	Long Integer	4	Identifier for child table
ChLinkID	Long Integer	4	Linking field to link occupant table to child table

Table: tblOccChLink (Historical Data, Children Linking Table)

OccupantID	Long Integer	4	Identifier for occupant table
ChildID	Long Integer	4	Identifier for child table
ChLinkID	Long Integer	4	Linking field to link occupant table to child table

Table: tblOccLand (Historical Data, Landholding)

LandID	Long Integer	4	Identifier for land table
OccupantID	Long Integer	4	Identifier for occupant table
Tract	Text	255	Tract
Acreage	Long Integer	4	Acreage
Reference	Text	255	Reference
Notes	Text	255	Notes

Table: tblProbate (Historical Data, Probate Records)

ProbateID	Long Integer	4	Identifier for probate table
OccupantID	Long Integer	4	Identifier for occupant table
OccupantName	Text	255	Name of owner or occupant
RecRef	Text	255	Reference
RecType	Text	255	Record type
RecDate	Text	255	Record date
RecPersons	Text	255	Persons
RecNotes	Text	255	Notes

Table: tblTitle (Historical Data, Land Titles)

TitleID	Long Integer	4	Identifier for title table
SiteName	Text	255	Site name
Grantor	Text	255	Grantor
Grantee	Text	255	Grantee
GrantDate	Text	255	Grant date
Reference	Text	255	Reference
TitleRank	Long Integer	4	Chronological order of title
Notes	Text	255	Notes
SiteAbbrev	Text	255	Standard site abbreviation for project
GrantorOccupantID	Long Integer	4	Occupant ID of grantor
GranteeOccupantID	Long Integer	4	Occupant ID of grantee

Table: tblInterpPapers (Interpretive Papers and Documents)

PaperID	Text	255	Identifier for interpretive papers table
Title	Text	255	Title
Author	Text	150	Author(s)
ArticleDate	Text	50	Date produced
Imprint	Text	255	Imprint
AuthoredBy	Text	255	Author(s)
ThumbImage	Text	50	Thumb image
SummaryText	Memo	-	Summary text
PDFFile	Text	250	Name of PDF file
PDFSize	Text	50	Size of PDF file

Table: tblReports (Site and Ancillary Reports)

ReportOrder	Text	10	Report order
SiteAbbrev	Text	255	Standard site abbreviation for project
Title	Text	255	Title
Author	Text	150	Author(s)
ArticleDate	Text	50	Date produced
Imprint	Text	255	Imprint
AuthoredBy	Text	255	Author(s)
ThumbImage	Text	50	Thumb image
SummaryText	Memo	-	Summary text
PDFFile	Text	50	Name of PDF file
PDFSize	Text	50	Size of PDF file
ReportType	Text	50	Report type (site report or other report)

Table: tblImageFiles (Artifact and Field Photos, Site and GIS Maps)

ImageID	Long Integer	4	Identifier for images table
SiteAbbrev	Text	255	Standard site abbreviation for project
Folder	Text	255	Folder containing the image
FileName	Text	255	File name
Caption	Text	255	Object or map description
Credit	Text	255	Image credit
Context	Text	255	Context description
ObjectID	Text	255	Object ID, link to artifact catalog
Unused	Text	255	File not usedd?
ImageType	Text	255	Image type
Problems	Text	255	Problems with file?
ObjectIDText	Text	255	Object IDs associated with this record
PrimaryGalleryImage	Yes/No	1	Primary gallery image?

Table: tblImagesToArtCatalog (Artifact Photos, Link to Artifact Catalog)

ImageID	Long Integer	4	Unique identifier
SiteAbbrev	Text	255	Standard site abbreviation for project
ObjectID	Long Integer	4	Object ID associated with this record
ObjectIDText	Text	255	Object IDs associated with this record

Table: tblTags (Artifact Photos, Link to Tags)

TagID	Long Integer	4	Identifier for tag links table
ImageID	Long Integer	4	Identifier for images table
Tag	Text	255	Category

Table: tblTagsAuthority (Artifact Photos, Tag Authority Table)

Tag

Text

255

Category

Table: tblArtifactInventories (Artifact Inventories)

ArtifactInvID	Text	255	Artifact inventory ID
SiteAbbrev	Text	255	Standard site abbreviation for project
FileName	Text	255	File name
Caption	Text	255	Caption
Reference	Text	255	Reference
ToDo	Text	255	Notes for to do

Table: tblProbateInventories (Probate Inventories)

ProbateInvID	Text	255	Probate inventory ID
OccupantName	Text	255	Name of owner or occupant
OccupantNameLF	Text	255	Name of owner or occupant, last name first
FileName	Text	255	File name
OccupantID	Long Integer	4	Occupant ID
Reference	Text	255	Reference
SiteAbbrev	Text	255	Standard site abbreviation for project

Table: tblMVCs (Minimum Vessel Counts)

MVCID	Text	255	Minimum vessel count ID
SiteAbbrev	Text	255	Standard site abbreviation for project
FileName	Text	255	File name
Caption	Text	255	Caption
Reference	Text	255	Reference
ToDo	Text	255	Notes for to do

Table: tblLinks (Other Links)

LinkID	Text	255	Link ID
SiteAbbrev	Text	255	Standard site abbreviation for project
LinkURL	Text	255	Full URL to link
Caption	Text	255	Caption
Reference	Text	255	Reference
ToDo	Text	255	Notes for to do

Table: tblLookupTaxonomy (Taxonomy Lookup)

Taxonomy	Text	255	Taxonomy identifier
TaxonomicName	Text	255	Taxonomic name
TaxonomicOrder	Text	10	Taxonomic order