Paddy's Market
Part of the Exploring the Archaeology of the Modern City project
Creator(s): Penny Crook; Tim Murray
Year: 2006
Summary
Artefact and context data from the Paddy's Market excavation in 1993. Records were compiled and assessed by not modified by the EAMC team. The original catalogue was prepared by Godden Mackay Logan and Wendy Thorp.
Cite this Record
Paddy's Market. Penny Crook, Tim Murray. 2006 ( tDAR id: 407305) ; doi:10.6067/XCV8CV4KTS
Restricted Access Some or all of this resource's attached file(s) are not publicly accessible.
Data Set Structure
Measurement Column
Count Column
Coded Column
Filename Column
Integration Column (has Ontology)
Table Information: Artefacts
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| UpdatedBy | The log-on name of the person who modified the record while using the Artefacts Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| IDNumber | Unique identification number allocated to each artefact. For all artefacts catalogued prior to 2001 this is the 'original' number and appears on the bag. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| CatalogueNumber | The IDNumber preceded by an abbreviated Site code. This allows multiple catalogues each numbered 1 to ~ to be combined in the same database. All labels printed from 2001 onwards show the Catalogue Number rather than IDNumber. (Added by the EAMC) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Site | The excavation site code, often including the year of excavation, eg CUGL1994 | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unit | The stratigraphic Unit from which the artefact was excavated, eg B101. (From the original CUGL catalogue) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| UnitArea | A sub-strata of the Unit, ie a grid square within a Unit (eg B101/B1). The 'UnitArea' as defined in the original CUGL catalogue. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| UnitandArea | The full stratigraphic Unit reference for the deposit from which the artefact was recovered | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| PhaseA | The first Site Phase to which the stratigraphic Unit from which the artefact was recovered may be dated. (From the original CUGL catalogue) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| BoneNoFrag | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| PhaseB | The last Site Phase to which the stratigraphic Unit from which the artefact was recovered may be dated. (From the original CUGL catalogue) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Activity | The pre-defined, broad functional Activity group to which the artefact was likely to belong. Activity is the first of three tiers of fields that describe the likely function of the artefact (or the vessel or object from which it came). | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ActivityQ | A checkbox to be ticked when the allocated Activity group is considered tentative or speculative. (Added by the EAMC) | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| Function | The pre-defined, Function group to which the artefact was likely to belong. Function is the second of three tiers of fields that describe the likely function of the artefact (or the vessel or object from which it came). | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| FunctionQ | A checkbox to be ticked when the allocated Function group is considered tentative or speculative. (Added by the EAMC) | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| DateTo | Numeric field recording the last year of the period in which the artefact may have been manufactured. | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Subfunction | The pre-defined, a more specific functional group to which the artefact was likely to belong. Function is the second of three tiers of fields that describe the likely function of the artefact (or the vessel or object from which it came). | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SubfunctionQ | A checkbox to be ticked when the allocated Subfunction group is considered tentative or speculative. (Added by the EAMC) | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| Arteclass | Broad Artefact Class for each artefact (eg Glass, Ceramic, Building Material). | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Material | Specific Material class for each artefact (eg Fine Earthenware, Porcelain). | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| MaterialQ | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| CeramicBody | The specific fabric of a ceramic vessel (eg 'Creamware', where 'Fine Earthenware' appears in the Material field). (From the original LV and FGH-YRP catalogues. In the CUGL system the Ceramic Body is described via the Type Series.) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Integrity | Describes the Integrity or completeness of sherd within one bag by recording the relationship of elements within that bag. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Percentage | Estimated percentage of the total vessel or piece that the elements in the bag represent. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Quantity | The number of sherds or individual elements in the bag, regardless of whether they conjoin to form a whole piece. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Images | TEXT | Uncoded Value | uncategorized | none | none | true |
| Form | Description of the profile of the original vessel or part there of (eg base or rim), as determined from the surviving sherd (eg 'everted rim', 'London-profile' for a tea cup). | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Shape | Description of the section of vessel, as determined from the sherd (eg 'round' for a teacup, 'oval' for a platter etc) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Portion | The part of the vessel that artefact derived. Eg the 'stem' of a pipe, or 'rim' of tea cup. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Decoration | The method of applying the decoration (eg 'transfer-print', 'hand-painted' etc) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DecorationPlacement | The face(s) of the vessel or sherd on which the decoration appears. This aids the identification of function, eg decoration appears on the 'concave' face of plates and saucers; teacups are 'double-sided'. (Added by the EAMC, Nov 2002) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Colour | The colour(s) of the decoration on the vessel (eg 'red' transfer-print, or the body of an undecorated vessel or object (eg 'olive-green' glass). | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Pattern | The name of a known pattern or decorative style (eg ‘Lachlander’ pipe; ‘Willow’ plate), or general description (eg ‘Scenic’; 'Floral') if the precise pattern name is not known. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TechniqueManuf | The technological process by which the artefact was manufactured, eg 'hand-thrown', 'moulded', 'blown'. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Modifictns | Changes to the artefact occurring after its manufacture, while in use or after discard and deposition, excluding breakage, eg 'mended', 'inscribed'. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| IDMarks | Function or purpose of any mark found on an artefact, as described in the Transcript field, eg 'Manufacturer's mark', 'Slogan'. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Transcript | Direct transcription of any text found on the artefact; gaps or speculative text should be enclosed in square parentheses: [ and ]. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| RecordAdmin | Memo field to record any alterations made to Artefact Record since the initial phases of cataloguing and data entry. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| MakerID | Dedicated field for the name of the Maker, as identified from basemarks, unique patterns, etc. This field contained a unique identifier for each maker, stored in the ListOfMakers table. (Added by the EAMC; Feb 2002) | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| DistributorID | Dedicated field for the name of the Distributor, as identified from basemarks, unique patterns, etc. This field contained a unique identifier for each distributor, stored in the ListOfMakers table. (Added by the EAMC; Feb 2002) | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Lengthinmm | Actual or estimated length of the vessel from which the sherd derives, in mm. This field does not record the length of sherds in their current state. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Widthinmm | Actual or estimated width or diameter of the vessel from which the sherd derives, in mm. This field does not record the width of sherds in their current state. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Heightinmm | Actual or estimated height of the vessel from which the sherd derives, in mm. This field does not record the height of sherds in their current state. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Thickinmm | Thickness of a specific part of the vessel from which the sherd derives, in mm. Eg base or body thickness. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Tilestrike | For CUGL Building Materials only. (From the original CUGL catalogue) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TSName | Name of the Type Series to which the artefact has been allocated, eg 'TP Earthenware Blue'. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TSNo | The Specific Number in the Type group described in the TS Name field, to which the artefact has been allocated, 'TP Earthenware Blue 12'. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| TSDetails | Whether the artefact is the first representative Type (‘T’), or a ‘Repeat’ (‘R’) of that sub-Type. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateFrom | Numeric field recording the artefact’s date of manufacture, or the first year of the period in which the artefact may have been manufactured. | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| DateNote | Text field for additional notes regarding the Dates To and From that cannot be accommodated in those numeric fields. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Provenance | The country or town where the artefact was made. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| WeightGrms | Weight of all sherds in the bag (in grams). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Condition | Brief description of the condition of the artefact. (From the original LV and FGH-YRP catalogues.) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Conservation | Brief description of any treatment applied to the artefact in order to conserve it. (From the original LV and FGH-YRP catalogues.) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Notes | General notes about the artefact. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| References | Bibliographic references for any piece of information provided in the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| BoxNumber | The number of the box in which the artefact is stored. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| VesselIDno | Identification number to represent sherds recovered from different contexts (and hence in different bags) that conjoin to form a single object. (Added by the EAMC, 2001) | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| MNVID | Identification number to group artefacts that potentially are part of the same vessel, for the purposes of Minimum Vessel Counts (MVC) only. (Added by the EAMC, Feb 2003) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| MNVQty | Minimum number of vessels or objects represented by the MNVID. (Added by the EAMC, Feb 2003) | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| MNVNotes | Field to contain notes relating to the grouping of the artefact(s) under the chosen MNVID. (Added by the EAMC, Feb 2003) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| MNVtocheck | Administrative checkbox to indicate that the artefact must be inspected to verify the MVC. (100% complete vessels do not require physical verification for the purpose of MVC counts.) (Added by the EAMC, Feb 2003) | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| MNVverified | Administrative checkbox to indicate that the MNVID and MNVQty for this artefact have been verified. (Added by the EAMC, Feb 2003) | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| SpecialFindNo | The Special Find Number allocated to some artefacts during excavation. (Added by the EAMC to track the SF numbers in the FGH catalogue) | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| MatchingSetID | Unique Identification number to group artefacts that potentially formed part of a matching set. (Added by the EAMC, Feb 2003) | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| MatchingSetType | Whether the Matching Set is considered 'Complementary' or an exact match. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| OriginalContext | Field containing the stratigraphic Unit as it was when imported into the database. Several FGH Units were originally mistyped and referred to unknown strata. These were corrected in order to link to Contexts table; and the original data retained.. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SplitFrom | For bags split after the initial phase of cataloguing, this field records the original Catalogue Number. | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| LabelPrinted | Administrative checkbox to indicate whether a label has been printed for the artefact. | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the Artefacts Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| QRNotes | Notes field used by the EAMC team during the Quality Review Assessment. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| QRChecked | Administrative check box used to mark all artefact checked during the Quality Review Assessment. | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| QRProblem | Any Problem with the artefact record identified during the Quality Review Assessment. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| QRAssess | Overall Assessment of the extent of Problems identified during the Quality Review Assessment. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SpeciesName | TEXT | Uncoded Value | uncategorized | none | none | true |
| SkeletalElGroup | TEXT | Uncoded Value | uncategorized | none | none | true |
| SkeletalEl | TEXT | Uncoded Value | uncategorized | none | none | true |
| BoneNoComp | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| BoPortName | TEXT | Uncoded Value | uncategorized | none | none | true |
| BoPortPerc | TEXT | Uncoded Value | uncategorized | none | none | true |
| BoCondName | TEXT | Uncoded Value | uncategorized | none | none | true |
| BoCondDesc | TEXT | Uncoded Value | uncategorized | none | none | true |
| BoCondAss | TEXT | Uncoded Value | uncategorized | none | none | true |
| BoAttriTyp | TEXT | Uncoded Value | uncategorized | none | none | true |
| BoAttriTLC | TEXT | Uncoded Value | uncategorized | none | none | true |
| BoAttriTAS | TEXT | Uncoded Value | uncategorized | none | none | true |
| BoAgeInGLC | TEXT | Uncoded Value | uncategorized | none | none | true |
| BOAgeInGST | TEXT | Uncoded Value | uncategorized | none | none | true |
| BoneRelativeAge | Relative age of animal, ie mature or juvenile. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| BoneAnimalSide | Left, right or centre of animal, eg the left or right femur. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TeethTooth | TEXT | Uncoded Value | uncategorized | none | none | true |
| TeethCond | TEXT | Uncoded Value | uncategorized | none | none | true |
| ButchLocat | TEXT | Uncoded Value | uncategorized | none | none | true |
| ButchType | TEXT | Uncoded Value | uncategorized | none | none | true |
| ButchOrien | TEXT | Uncoded Value | uncategorized | none | none | true |
| AnimalSize | TEXT | Uncoded Value | uncategorized | none | none | true |
| AniMaxSize | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Seed | TEXT | Uncoded Value | uncategorized | none | none | true |
| Organic | TEXT | Uncoded Value | uncategorized | none | none | true |
| ShellScien | TEXT | Uncoded Value | uncategorized | none | none | true |
| ShellCommn | TEXT | Uncoded Value | uncategorized | none | none | true |
| ShellNoCom | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| ShellNoFra | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| ShellNoLid | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| ShellNoBas | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| ShellCond | TEXT | Uncoded Value | uncategorized | none | none | true |
| Mineral | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Contexts
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Site | Site code | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| MasterContext | Overarching Context Number allocated to a group of stratigraphic contexts or Units deposited as part of the same event, but excavated separately (added by EAMC, 2002) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unit | Trench or area number of the stratigraphic context or feature | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| UnitArea | Specific unit number of the stratigraphic context or feature | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| UnitandArea | Full unit code including Trench and Unit Number, and Site if required to distinguish from other contexts. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| UnitCode | Unique code incorporating Site and Unit number | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| AreaAlph | Alpha ref or square for gridded occupation deposits, eg 'A' for square 'A1' | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| AreaNo | Numerical ref of square for gridded occupation deposits, eg '1' for square 'A1' | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Spit | Spit number, where relevant | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| ContextType1 | The broad category of strata, eg 'Fill', 'Service feature', 'Structural element' | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ContextType2 | The specific kind of context eg 'Fill - cesspit', 'Service feature - drain', etc | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| BldgPhase | TEXT | Uncoded Value | uncategorized | none | none | true |
| BldgCode | Code of the building with which this Unit is associated. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| BldgCodeNotes | Additional notes about bldg code, where necessary | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| BldgArea | The Area of the Building in which this Unit or feature was revealed. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Location | The part of the site where this Unit or feature was revealed. This is designed to allow for Units or features revealed in the locale of a building bu could not be associated with the Building itself (ie it may have been earlier or later). | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Description | Brief description of context | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Notes | More detailed notes about the Unit. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ExcavationPhase | Phase of the site's excavation during which the context was dug; added largely to cater for FGH | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ExcavatedBy | Name of the excavator, where known | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ExcavatedDate | Date excavation began, where known | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| Below | The Unit above the current Unit, ie the current Unit is Below Unit X | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Above | The Unit below the current Unit, ie the current Unit is Above Unit X | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SameAs | Other Units identified during excavation to be the same as the current Unit. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Disturbed | Whether or not the Unit or feature has been disturbed by later deposition (added by the EAMC) | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| ConjoinsWith | Other Units identified as containing sherds that conjoin with artefacts in the current Unit. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Priority1 | Priority for detailed cataloguing as identified for the CUGL assemblage. (For the CUGL catalogue only.) | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Priority2 | Priority for detailed cataloguing as identified for the CUGL assemblage. (For the CUGL catalogue only.) | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Phase1 | The earliest Site Phase in which the Unit or feature may have been created | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Phase2 | The latest Site Phase in which the Unit or feature may have been created | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| PhaseNotes | Notes about the phasing of the Unit or feature. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| MinDate | TPQ, or the earliest minimum year in which the Unit or feature may have been created, as determined by the artefact with the latest minimum manufacture date | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| MinDateNotes | Notes regarding the determination of the TPQ. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| MaxDate | TAQ, or the latest maximum year in which the Unit or feature may have been created, usually determined by the minimum date of the strata above this Unit. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| MaxDateNotes | Notes regarding the determination of the TAQ. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateNotes | General notes about dating the Unit or feature. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Volume | Volume of the Unit, if provided on the Context Sheet. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Reference | Bibliographic reference for the Unit or feature. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Plans | Plans showing the Unit or feature. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the Contexts Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the Contexts Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| Colour | Colour of the deposit (Added 17 July 02 to accommodate LV context sheets) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Texture | Texture of the deposit (Added 17 July 02 to accommodate LV context sheets) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Moisture | Moisture level of the deposit (Added 17 July 02 to accommodate LV context sheets) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Components | Components within the deposit (Added 17 July 02 to accommodate LV context sheets) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Length | Length of the deposit or feature (Added 17 July 02 to accommodate LV context sheets) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Width | Width of the deposit or feature (Added 17 July 02 to accommodate LV context sheets) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Diameter | Diameter of the deposit or feature (Added 17 July 02 to accommodate LV context sheets) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| HeightOrDepth | Height or depth of the deposit or feature (Added 17 July 02 to accommodate LV context sheets) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: CurrentSite
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| CurrentSite | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: ListOfActivities
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
| ActivityID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Activity | TEXT | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
| OtherNames | TEXT | Uncoded Value | uncategorized | none | none | true |
| Source | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ListOfArtefactClasses
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ArteclassID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Arteclass | TEXT | Uncoded Value | uncategorized | none | none | true |
| Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ListofColours
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ColourID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ColourName | TEXT | Uncoded Value | uncategorized | none | none | true |
| Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ListofContextTypes
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| context type 1 | TEXT | Uncoded Value | uncategorized | none | none | true |
| context type 2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ListofDecorations
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| DecorationID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| DecorationName | TEXT | Uncoded Value | uncategorized | none | none | true |
| Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ListofFormProfiles
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| FormID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| FormName | TEXT | Uncoded Value | uncategorized | none | none | true |
| Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ListofFormSections
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SectionShapeID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SectionShapeName | TEXT | Uncoded Value | uncategorized | none | none | true |
| Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ListofFunctions
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| FunctionID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| OldFunctionID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Activity | TEXT | Uncoded Value | uncategorized | none | none | true |
| FunctionName | TEXT | Uncoded Value | uncategorized | none | none | true |
| SampleSubfunctions | TEXT | Uncoded Value | uncategorized | none | none | true |
| Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ListofIDMarks
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
| MarkID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| IDMarkName | TEXT | Uncoded Value | uncategorized | none | none | true |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ListofMakers
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| MakerID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| MakerName | TEXT | Uncoded Value | uncategorized | none | none | true |
| MakerType | M for Maker, D for Distributor | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ProductType | TEXT | Uncoded Value | uncategorized | none | none | true |
| MakerProvinence | TEXT | Uncoded Value | uncategorized | none | none | true |
| MakerDates | TEXT | Uncoded Value | uncategorized | none | none | true |
| MakerNotes | TEXT | Uncoded Value | uncategorized | none | none | true |
| References | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ListOfMaterials
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| MaterialID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| MaterialName | TEXT | Uncoded Value | uncategorized | none | none | true |
| ArtefactClass | TEXT | Uncoded Value | uncategorized | none | none | true |
| ArtefactClassID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ListofModifications
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ModificationID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ModificationName | TEXT | Uncoded Value | uncategorized | none | none | true |
| Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ListOfPatterns
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| PatternID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| PatternName | TEXT | Uncoded Value | uncategorized | none | none | true |
| PatternType | TEXT | Uncoded Value | uncategorized | none | none | true |
| Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ListOfPortions
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| PortionID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| PortionName | TEXT | Uncoded Value | uncategorized | none | none | true |
| Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ListofProvenance
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ProvenanceID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ProvenanceName | TEXT | Uncoded Value | uncategorized | none | none | true |
| Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ListofRemovalReasons
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| RemovalReasonID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| RemovalReasonType | TEXT | Uncoded Value | uncategorized | none | none | true |
| RemovalReason | TEXT | Uncoded Value | uncategorized | none | none | true |
| Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ListOfSites
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| DateUpdated | The last date on which any field in this record was modified while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SiteID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SiteCode | TEXT | Uncoded Value | uncategorized | none | none | true |
| SiteName | TEXT | Uncoded Value | uncategorized | none | none | true |
| CatalogueNumberPrefix | TEXT | Uncoded Value | uncategorized | none | none | true |
| Address | TEXT | Uncoded Value | uncategorized | none | none | true |
| SiteOwner | TEXT | Uncoded Value | uncategorized | none | none | true |
| Excavator | TEXT | Uncoded Value | uncategorized | none | none | true |
| Year/s | TEXT | Uncoded Value | uncategorized | none | none | true |
| Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ListofSkeletalElements
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| skeletal element | TEXT | Uncoded Value | uncategorized | none | none | true |
| area of body | TEXT | Uncoded Value | uncategorized | none | none | true |
| Activity | TEXT | Uncoded Value | uncategorized | none | none | true |
| Use | TEXT | Uncoded Value | uncategorized | none | none | true |
| Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ListofSubfunctions
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SubfunctionID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SubfunctionName | TEXT | Uncoded Value | uncategorized | none | none | true |
| Order | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
| FunctionID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ActivityID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ListofTechniques
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| TechniqueManufID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| TechniqueName | TEXT | Uncoded Value | uncategorized | none | none | true |
| Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateEntered | The date the database record was created. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The log-on name of the person who created the record. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The last date on which any field in this record was modified while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The log-on name of the person who modified the record while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: Phases
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| PhaseID | Unique ID number allocated to each database record of a Site Phase | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Site | Site Code | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| PhaseNo | The number allocated to each Phase by the excavators | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| PhaseCode | Code combing the Site and Phase No, to distinguish phases from each site in the database | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| PhaseName | The name allocated to each Phase by the excavators | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateFrom | The minimum year allocated to each Phase by the excavators | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateTo | The maximum year allocated to each Phase by the excavators | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Notes | Description of the Phase | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: Type Series
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Notes | General notes about this subgroup | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Site | Must match the site code in the artefacts database | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Project | Specify project if not part of the original catalogue, ie EAMC. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Arteclass | Artefact Class | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TSName | Name of this Type Series group | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TSNo | Number of the subgroup within Type Series group | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| ArtID | ID number of the artefact selected as the representative Type ('T') for this Type Group. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ArtefactID | ID number of the artefact selected as the representative Type ('T') for this Type Group. | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Description | Description of this subgroup | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Colour/pattern | Colour or pattern name, where appropriate | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Portion | The portion of artefact defined by this subgroup, where appropriate (eg pushup bases for bottle groups) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Dimensions | Dimensions of artefacts as defined by this subgroup, where appropriate | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TS abbrev | Abreviation of the TS Name, used in cataloguing, where known (eg AW for Aerated Waters') | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Maker | Name of Maker defined by this subgroup, where appropriate | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Provenance | Provenance or place made, as defined by this subgroup, where appropriate | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| From | The earliest production date of artefacts defined by this subgroup, where known | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| To | The latest production date of artefacts defined by this subgroup, where known | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Photographed | Whether or not the representative Type ('T') for this subgroup has been photographed. | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| EnteredBy | The date the database record was created. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateEntered | The log-on name of the person who created the record. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UpdatedBy | The last date on which any field in this record was modified while using the List Form. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateUpdated | The log-on name of the person who modified the record while using the List Form. | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
Data Table Relationships:
| Type | Local Table | Foreign Table | Column Relationships |
|---|---|---|---|
| MANY_TO_ONE | Artefacts | Contexts | Site Site UnitandArea UnitandArea |
| MANY_TO_ONE | Phases | Contexts | PhaseNo Phase2 |
| MANY_TO_ONE | Artefacts | Type Series | TSNo TSNo Site Site TSName TSName |
| MANY_TO_ONE | Phases | Contexts | PhaseNo Phase1 |
Keywords
Culture
Historical Archaeology (incl. Industrial Archaeology) (FOR 210108)
Material
Building Materials
•
Ceramic
•
Glass
•
Metal
•
miscellaneous
•
Organic
Site Name
Paddy's Market site (Haymarket)
Site Type
Cottage
•
Domestic
•
House
•
Terrace
•
Urban
Geographic Keywords
Sydney
•
Sydney, New South Wales, Australia
Temporal Keywords
19th Century
•
early-20th century
Spatial Coverage
min long: 151.204; min lat: -33.88 ; max long: 151.205; max lat: -33.879 ;
Individual & Institutional Roles
Contributor(s): Penny Crook; Tim Murray
Principal Investigator(s): Wendy Thorp; Mafalda Rossi; Graham Wilson; Martin Carney; Anthony Lowe; Jennie Lindbergh; Rachel Sparks; Margaret O'Hea; Dominic Steele
Sponsor(s): Sydney Harbour Foreshore Authority; Godden Mackay Logan; Heritage Victoria; NSW Heritage Office ; City of Sydney; Historic Houses Trust
Repository(s): Sydney Harbour Foreshore Authority; Sydney Harbour Foreshore Authority
Prepared By(s): Godden Mackay Logan; Godden Mackay Logan
Record Identifiers
Site Code(s): PM
TDAR ID(s): 6878
FAIMS ID(s): repo.fedarch.org/dataset/6878
Notes
General Note: The post-ex team comprised: Co-ordinator: Wendy Thorp; Ceramics: Mafalda Rossi, Graham Wilson, Wendy Thorp; Glass & bottle stoppers: Martin Carney; Building Materials: Anthony Lowe and Jenni Lindbergh; Metal: Rachel Sparks; Other activity categories: Wendy Thorp, Margaret O’Hea; Leather: Graham Wilson; Animal bone & shell: Dominic Steele; Soil samples: Roy Lawrie; Entological advice: John McDonald; Palynological: Mike McPhail; Conservation: Sue Frost and Coenrad Haartman.
Rights & Attribution: © EAMC Industry Partners 2012
File Information
| Name | Size | Creation Date | Date Uploaded | Access | |
|---|---|---|---|---|---|
| eamc_pm.mdb | 30.61mb | Aug 20, 2016 11:53:46 AM | Confidential |