The Blackaeonium Project: Workspace/Keeping-Place - An Archival Continuum of Creative Practice

PhD by Research Project, Lisa Cianci, 2012


homepage & table of contents >> appendix 4

Blackaeonium Archive System Database Structure

 

Database Structure

relationships table for the Blackaeonium archive system database (click to enlarge)

database structure

 

Table structure for table tblaccessrestrictions

Description:  access restrictions e.g.: open, closed partially closed. 
Used to restrict public access to specific content in the archive.
Linked to the inventory via the primary key ID field

Field

Type

Null

Default

accessID

int(11)

Yes

NULL

accessrestrictions

varchar(255)

Yes

NULL

deleted

tinyint(4)

Yes

0

 

Table structure for table tblconflict

Description:  conflict table used to determine if media types can be presented on the same web page.
For example, presenting many video files with audio on the one video page and auto starting all of them would lead to a clash of audio.
Another example would be in the instance of many very large images being loaded on the one web page.
Linked to the inventory via a joining table - tblInvConflict

Field

Type

Null

Default

conflictID

int(11)

Yes

NULL

conflict

varchar(50)

Yes

NULL

conflictrule

text

Yes

NULL

reason

text

Yes

NULL

dateappend

timestamp

Yes

CURRENT_TIMESTAMP

deleted

tinyint(4)

Yes

0

 

Table structure for table tblcopyright

Description: Rights management. Used for copyright statements and also creative commons licence statements.
linked to the Inventory via a joining table - tblInvCopy

Field

Type

Null

Default

copyrightID

int(11)

Yes

NULL

copyright

varchar(255)

Yes

NULL

copyrightdescription

text

Yes

NULL

dateappend

timestamp

Yes

CURRENT_TIMESTAMP

deleted

tinyint(4)

Yes

0

 

Table structure for table tblcontributor

Description:  the contributor may be used to list individuals or organisations that contributed to or participated in an aspect of the item.
Different to provenance because the contributor is not the main creator. For example, an editor, publisher, or photographer of an artwork.
Linked to the Inventory via a joining table - tblInvCont

Field

Type

Null

Default

contributorID

int(11)

Yes

NULL

contributor

varchar(255)

Yes

NULL

contributordescription

text

Yes

NULL

contributorfunction

varchar(50)

Yes

NULL

dateappend

timestamp

Yes

CURRENT_TIMESTAMP

deleted

tinyint(4)

Yes

0

 

Table structure for table tblfonds

Description: the fonds is an archival construct that groups an entire collection of items together – usually the collection belonging to a provenance entity or organisation.
The fonds is linked to the inventory via the primary key ID field.

Field

Type

Null

Default

fondsID

int(11)

Yes

NULL

fondstitle

varchar(255)

Yes

NULL

fondsdescription

text

Yes

NULL

dateAppend

timestamp

Yes

CURRENT_TIMESTAMP

datemodified

datetime

Yes

NULL

userID

int(11)

Yes

NULL

deleted

tinyint(4)

Yes

0

 

Table structure for table tblfondsrelated

Description:  this table links to the tblFonds table and the tblRelationships table to creating relationships between fonds.
This is the joining table linking the Fonds to each other, with a relationship defined

Field

Type

Null

Default

frID

int(11)

Yes

NULL

fondsID

int(11)

Yes

NULL

fondsrelatedID

int(11)

Yes

NULL

relationshipID

int(11)

Yes

NULL

 

Table structure for table tblformat

Description:  this table lists the formats for digital objects that form the items in the archive.
Linked to the inventory via the primary key ID field.

Field

Type

Null

Default

formatID

int(11)

Yes

NULL

formattitle

varchar(255)

Yes

NULL

formatdescription

text

Yes

NULL

dateappend

timestamp

Yes

CURRENT_TIMESTAMP

deleted

tinyint(4)

Yes

0

 

Table structure for table tblgroup

Description: the group allows for selected items to be linked for the purposes of creating exhibitions, recombinant groupings and subsets of items from the collection.
The group is different to the Series in that an item can belong to many groups, but only one series.  Items may be added to groups at any time.
Linked to the inventory via a joining table - tblInvGroup

Field

Type

Null

Default

groupID

int(11)

Yes

NULL

grouptitle

varchar(255)

Yes

NULL

groupdescription

text

Yes

NULL

dateappend

timestamp

Yes

CURRENT_TIMESTAMP

datemodified

datetime

Yes

NULL

userID

int(11)

Yes

NULL

deleted

tinyint(4)

Yes

0

fav

tinyint(4)

Yes

0

 

Table structure for table tblgrouprelated

Description: this table links to the tblGroup table and the tblRelationships table to creating relationships between groups.
This is the joining table linking the Groups to each other, with a relationship defined

Field

Type

Null

Default

grID

int(11)

Yes

NULL

groupID

int(11)

Yes

NULL

grouprelatedID

int(11)

Yes

NULL

relationshipID

int(11)

Yes

NULL

 

Table structure for table tblhardware (removed from current prototype)

Description:  the hardware table lists types of hardware that may be required to access the inventory item, or was used in its creation.
This table is linked to the Inventory via a joining table - tblInvhw

Field

Type

Null

Default

hardwareID

int(11)

Yes

NULL

hardware

varchar(255)

Yes

NULL

hardwaredescription

text

Yes

NULL

hardwareversion

varchar(50)

Yes

NULL

dateappend

timestamp

Yes

CURRENT_TIMESTAMP

deleted

tinyint(4)

Yes

0

 

Table structure for table tblinvcopy

Description:  joining table linking tblInventory to tblCopyright

Field

Type

Null

Default

invcopyID

int(11)

Yes

NULL

itemID

int(11)

Yes

NULL

copyrightID

int(11)

Yes

NULL

 

Table structure for table tblinvcont

Description: joining table linking tblInventory to tlbContributor

Field

Type

Null

Default

invcontID

int(11)

Yes

NULL

itemID

int(11)

Yes

NULL

contributorID

int(11)

Yes

NULL

 

Table structure for table tblinventory

Description:  the Inventory table is the central point in the archival system that describes items at the finest granularity. 
Many of the other tables in the system are linked to the tblInventory – either in a one-to-many relationship through primary key fields,
or in many-to-many relationships via a joining table that links primary key fields from both tables.

Field

Type

Null

Default

itemID

int(11)

Yes

NULL

title

varchar(255)

Yes

NULL

title2

varchar(255)

Yes

NULL

descriptionContent

text

Yes

NULL

descriptionTechnical

text

Yes

NULL

descriptionOther

text

Yes

NULL

seriesID

int(11)

Yes

NULL

provenanceID

int(11)

Yes

NULL

fondsID

int(11)

Yes

NULL

userID

int(11)

Yes

NULL

filename

varchar(255)

Yes

NULL

filepath

varchar(255)

Yes

NULL

URI

varchar(255)

Yes

NULL

location

varchar(255)

Yes

NULL

size

int(11)

Yes

NULL

width

int(11)

Yes

NULL

height

int(11)

Yes

NULL

accessID

int(11)

Yes

NULL

accessdate

datetime

Yes

NULL

dateappend

timestamp

Yes

CURRENT_TIMESTAMP

datecreated

datetime

Yes

NULL

datemodified

datetime

Yes

NULL

datearchived

datetime

Yes

NULL

archived

tinyint(4)

Yes

0

deleted

tinyint(4)

Yes

0

 

Table structure for table tblinvformat

Description: joining table linking tblInventory to tlbFormat

Field

Type

Null

Default

invformatID

int(11)

Yes

NULL

itemID

int(11)

Yes

NULL

formatID

int(11)

Yes

NULL

 

Table structure for table tblinvformatconflict

Description: joining table linking tblInventory to tlbFormatConflict

Field

Type

Null

Default

invformatconflictID

int(11)

Yes

NULL

itemID

int(11)

Yes

NULL

formatID

int(11)

Yes

NULL

conflictID

int(11)

Yes

NULL

 

Table structure for table tblinvgroup

Description: joining table linking tblInventory to tlbGroup

Field

Type

Null

Default

invgroupID

int(11)

Yes

NULL

itemID

int(11)

Yes

NULL

groupID

int(11)

Yes

NULL

groupstartdate

datetime

Yes

NULL

groupenddate

datetime

Yes

NULL

 

Table structure for table tblinvhw

Description: joining table linking tblInventory to tlbHardware

Field

Type

Null

Default

invhwID

int(11)

Yes

NULL

itemID

int(11)

Yes

NULL

hardwareID

int(11)

Yes

NULL

 

Table structure for table tblinvlang

Description: joining table linking tblInventory to tlbLanguage

Field

Type

Null

Default

invlangID

int(11)

Yes

NULL

itemID

int(11)

Yes

NULL

languageID

int(11)

Yes

NULL

 

Table structure for table tblinvmime

Description: joining table linking tblInventory to tlbMimetype

Field

Type

Null

Default

invmimeID

int(11)

Yes

NULL

itemID

int(11)

Yes

NULL

mimetypeID

int(11)

Yes

NULL

 

Table structure for table tblinvos

Description: joining table linking tblInventory to tlbOperatingSystem

Field

Type

Null

Default

invosID

int(11)

Yes

NULL

itemID

int(11)

Yes

NULL

operatingsystemID

int(11)

Yes

NULL

 

Table structure for table tblinvplace

Description: joining table linking tblInventory to tlbPlacement

Field

Type

Null

Default

invplaceID

int(11)

Yes

NULL

itemID

int(11)

Yes

NULL

placementID

int(11)

Yes

NULL

 

Table structure for table tblinvprov

Description: joining table linking tblInventory to tlbProvenance

Field

Type

Null

Default

invprovID

int(11)

Yes

NULL

itemID

int(11)

Yes

NULL

provenanceID

int(11)

Yes

NULL

 

Table structure for table tblinvrelated

Description: this table links to the tblInventory table and the tblRelationships table to creating relationships between Inventory items.
This is the joining table linking the Inventory items to each other, with a relationship defined

Field

Type

Null

Default

invrelID

int(11)

Yes

NULL

itemID

int(11)

Yes

NULL

itemrelatedID

int(11)

Yes

NULL

relationshipID

int(11)

Yes

NULL

 

Table structure for table tblinvretention

Description: joining table linking tblInventory to tlbRetention

Field

Type

Null

Default

invretentionID

int(11)

Yes

NULL

itemID

int(11)

Yes

NULL

retentionID

int(11)

Yes

NULL

datereview

datetime

Yes

NULL

 

Table structure for table tblinvsw

Description: joining table linking tblInventory to tlbSoftware

Field

Type

Null

Default

invswID

int(11)

Yes

NULL

itemID

int(11)

Yes

NULL

softwareID

int(11)

Yes

NULL

 

Table structure for table tblinvtag

Description: joining table linking tblInventory to tlbTag

Field

Type

Null

Default

invtagid

int(11)

Yes

NULL

itemid

int(11)

Yes

NULL

tagid

int(11)

Yes

NULL

 

Table structure for table tblinvusergroup

Description: joining table linking tblInventory to tlbUserGroup

Field

Type

Null

Default

invusergroupID

int(11)

Yes

NULL

itemID

int(11)

Yes

NULL

usergroupID

int(11)

Yes

NULL

groupstartdate

datetime

Yes

NULL

groupenddate

datetime

Yes

NULL

 

Table structure for table tblitemplate

Description: the Inventory Template table is a copy of the Inventory, but saves templates which allow users to easily enter inventory items.
The template table links to other tables in the same way as the inventory, but has it’s own joining tables.

Field

Type

Null

Default

templateID

int(11)

Yes

NULL

title

varchar(255)

Yes

NULL

title2

varchar(255)

Yes

NULL

descriptionContent

text

Yes

NULL

descriptionTechnical

text

Yes

NULL

descriptionOther

text

Yes

NULL

seriesID

int(11)

Yes

NULL

provenanceID

int(11)

Yes

NULL

fondsID

int(11)

Yes

NULL

userID

int(11)

Yes

NULL

filename

varchar(255)

Yes

NULL

filepath

varchar(255)

Yes

NULL

URI

varchar(255)

Yes

NULL

location

varchar(255)

Yes

NULL

size

int(11)

Yes

NULL

width

int(11)

Yes

NULL

height

int(11)

Yes

NULL

accessID

int(11)

Yes

NULL

accessdate

datetime

Yes

NULL

dateappend

timestamp

Yes

CURRENT_TIMESTAMP

datecreated

datetime

Yes

NULL

datemodified

datetime

Yes

NULL

datearchived

datetime

Yes

NULL

archived

tinyint(4)

Yes

NULL

deleted

tinyint(4)

Yes

0

 

Table structure for table tbllanguage

Description: the language table lists languages that were used in the Inventory item.
This table is linked to the Inventory via a many-to-many relationship via a joining table - tblinvlang

Field

Type

Null

Default

languageID

int(11)

Yes

NULL

language

varchar(255)

Yes

NULL

languagedescription

text

Yes

NULL

abbreviation

varchar(50)

Yes

NULL

dateappend

timestamp

Yes

CURRENT_TIMESTAMP

deleted

tinyint(4)

Yes

0

 

Table structure for table tblmimetype

Description:  the mimetype table lists mimetypes for the digital objects held in the Inventory.  The mime types relate to the format of the file and the file extension.
This table is linked to the Inventory via a many-to-many relationship via a joining table - tblinvmime

Field

Type

Null

Default

mimetypeID

int(11)

Yes

NULL

mimetype

varchar(10)

Yes

NULL

mimetitle

varchar(100)

Yes

NULL

authority

text

Yes

NULL

dateappend

timestamp

Yes

CURRENT_TIMESTAMP

deleted

tinyint(4)

Yes

0

 

Table structure for table tbloperatingsystem (not used in current prototype)

Description: this table is used for listing operating systems that may have been used in creating Inventory items, or may be required to access inventory items.
This table is linked to the Inventory via a many-to-many relationship via a joining table - tblinvos

Field

Type

Null

Default

operatingsystemID

int(11)

Yes

NULL

operatingsystem

varchar(255)

Yes

NULL

OSdescription

text

Yes

NULL

OSversion

varchar(50)

Yes

NULL

dateappend

timestamp

Yes

CURRENT_TIMESTAMP

deleted

tinyint(4)

Yes

0

 

Table structure for table tblplacement

Description:  this table is used to describe the placement of the digital item in the inventory within the webpage – i.e. linked, embedded, download.
This table is linked to the Inventory via a many-to-many relationship via a joining table - tblinvplace

Field

Type

Null

Default

placementID

int(11)

Yes

NULL

placement

varchar(50)

Yes

NULL

placementdescription

text

Yes

NULL

dateappend

timestamp

Yes

CURRENT_TIMESTAMP

deleted

tinyint(4)

Yes

0

 

Table structure for table tblprovenance

Description: the Provenance table lists the provenance entities - creators and custodians for the Inventory items.
This table is linked to the Inventory via a many-to-many relationship via a joining table - tblinvprov

Field

Type

Null

Default

provenanceID

int(11)

Yes

NULL

provenancetitle

varchar(255)

Yes

NULL

provenancedescription

text

Yes

NULL

provenancetype

varchar(50)

Yes

NULL

pfunction

varchar(255)

Yes

NULL

pfirstname

varchar(50)

Yes

NULL

plastname

varchar(50)

Yes

NULL

dateappend

timestamp

Yes

CURRENT_TIMESTAMP

datemodified

datetime

Yes

NULL

userID

int(11)

Yes

NULL

deleted

tinyint(4)

Yes

0

 

Table structure for table tblprovenancerelated

Description: this table links to the tblProvenance table and the tblRelationships table to creating relationships between provenance entities.
This is the joining table linking the provenance entities to each other, with a relationship defined

Field

Type

Null

Default

prID

int(11)

Yes

NULL

provenanceID

int(11)

Yes

NULL

provrelatedID

int(11)

Yes

NULL

relationshipID

int(11)

Yes

NULL

 

Table structure for table tblprovtype

Description:  this table lists the types of provenance entities. It is linked to the tblProvenance table via the primary key ID field

Field

Type

Null

Default

provtypeID

int(11)

Yes

NULL

provenancetype

varchar(50)

Yes

NULL

deleted

tinyint(4)

Yes

0

 

Table structure for table tblrelationships

Description:  this table lists all the relationships types for inventory, fonds, series, provenance and group.
It links to the joining tables for these construct tables via the primary key ID field

Field

Type

Null

Default

relationshipID

int(11)

Yes

NULL

relationship

varchar(50)

Yes

NULL

relatedID

int(11)

Yes

NULL

granularity

varchar(10)

Yes

NULL

 

Table structure for table tblretention

Description:  this table lists the retention schedule details which are linked to the Inventory item.
This table is linked to the Inventory via the primary key ID field

Field

Type

Null

Default

retentionID

int(11)

Yes

NULL

retention

varchar(255)

Yes

NULL

retentiondescription

text

Yes

NULL

dateappend

timestamp

Yes

CURRENT_TIMESTAMP

deleted

tinyint(4)

Yes

0

 

Table structure for table tblsavedqueries (not used in the current prototype)

Description:  this table allows users to save a query search string to allow for the same query to be used at a later date.
It is linked to the tblUser and tblPublicUser via the primary key ID fields for those tables.

Field

Type

Null

Default

queryID

int(11)

Yes

NULL

query

text

Yes

NULL

userID

int(11)

Yes

NULL

publicUserID

int(11)

Yes

NULL

 

Table structure for table tblseries

Description:  The tblSeries table lists the series and details for groups of items in the Inventory.
Inventory items are allocated a series at the time of upload to the archival system.
This table is linked to the Inventory via the primary key ID field.

Field

Type

Null

Default

seriesID

int(11)

Yes

NULL

seriestitle

varchar(255)

Yes

NULL

seriesdescription

text

Yes

NULL

dateappend

timestamp

Yes

CURRENT_TIMESTAMP

datemodified

datetime

Yes

NULL

userID

int(11)

Yes

NULL

deleted

tinyint(4)

Yes

0

 

Table structure for table tblseriesrelated

Description: this table links to the tblSeries table and the tblRelationships table to creating relationships between series of items.
This is the joining table linking the series to each other, with a relationship defined

Field

Type

Null

Default

srID

int(11)

Yes

NULL

seriesID

int(11)

Yes

NULL

seriesrelatedID

int(11)

Yes

NULL

relationshipID

int(11)

Yes

NULL

 

Table structure for table tblsessionitems

Description: this table lists the inventory items saved in the “shopping cart” column in the search screen.
this table is used throughout a session to save items selected for the shopping cart, which can then be saved as   groups or usergroups.
this table is linked to the tblInventory via the primary key ID field from that table.

Field

Type

Null

Default

sessionitemID

int(11)

Yes

NULL

sessionID

varchar(50)

Yes

NULL

itemID

int(11)

Yes

NULL

dateappend

timestamp

Yes

CURRENT_TIMESTAMP

 

Table structure for table tblsoftware

Description:  this table lists software applications that were sued to create the Inventory item, or are required to access the Inventory item.
This table is linked to the tblInventory via a joining table - tblInvsw

Field

Type

Null

Default

softwareID

int(11)

Yes

NULL

software

varchar(255)

Yes

NULL

softwaredescription

text

Yes

NULL

softwareversion

varchar(20)

Yes

NULL

dateappend

timestamp

Yes

CURRENT_TIMESTAMP

deleted

tinyint(4)

Yes

0

 

Table structure for table tblsystem

Description:  this table holds the basic system information for each iteration of the archival system. 
Information stored in this table is displayed on every page

Field

Type

Null

Default

systemID

int(11)

Yes

NULL

systemtitle

varchar(100)

Yes

NULL

systemauthor

varchar(50)

Yes

NULL

systememail

varchar(50)

Yes

NULL

systemdatecreated

timestamp

Yes

CURRENT_TIMESTAMP

systemstyle

varchar(150)

Yes

NULL

systemhomegroupID

int(11)

Yes

NULL

systemlogo

varchar(50)

Yes

NULL

systemfavicon

varchar(50)

Yes

NULL

systemabout

text

Yes

NULL

deleted

tinyint(4)

Yes

0

 

Table structure for table tbltag

Description:  this table lists the tags which are used to categorise the inventory items.
This table is linked to the tblInventory in a many-to-many relationship via a joining table -  tblinvtag

Field

Type

Null

Default

tagid

int(11)

Yes

NULL

tag

varchar(50)

Yes

NULL

 

Table structure for table tbltempcopy

Description: joining table linking tblInvtemplate to tblCopyright

Field

Type

Null

Default

tempcopyID

int(11)

Yes

NULL

templateID

int(11)

Yes

NULL

copyrightID

int(11)

Yes

NULL

 

Table structure for table tbltempformat

Description: joining table linking tblInvtemplate to tblFormat

Field

Type

Null

Default

tempformatID

int(11)

Yes

NULL

templateID

int(11)

Yes

NULL

formatID

int(11)

Yes

NULL

 

Table structure for table tbltempformatconflict

Description: joining table linking tblInvtemplate to tblFormatConflict

Field

Type

Null

Default

tempformatconflictID

int(11)

Yes

NULL

templateID

int(11)

Yes

NULL

formatID

int(11)

Yes

NULL

conflictID

int(11)

Yes

NULL

 

Table structure for table tbltempgroup

Description: joining table linking tblInvtemplate to tblGroup

Field

Type

Null

Default

tempgroupID

int(11)

Yes

NULL

templateID

int(11)

Yes

NULL

groupID

int(11)

Yes

NULL

groupstartdate

datetime

Yes

NULL

groupenddate

datetime

Yes

NULL

 

Table structure for table tbltemphw

Description: joining table linking tblInvtemplate to tblhardware

Field

Type

Null

Default

temphwID

int(11)

Yes

NULL

templateID

int(11)

Yes

NULL

hardwareID

int(11)

Yes

NULL

 

Table structure for table tbltempmime

Description: joining table linking tblInvtemplate to tblmimetype

Field

Type

Null

Default

tempmimeID

int(11)

Yes

NULL

templateID

int(11)

Yes

NULL

mimetypeID

int(11)

Yes

NULL

 

Table structure for table tbltempos

Description: joining table linking tblInvtemplate to tbloperatingsystem

Field

Type

Null

Default

temposID

int(11)

Yes

NULL

templateID

int(11)

Yes

NULL

operatingsystemID

int(11)

Yes

NULL

 

Table structure for table tbltempplace

Description: joining table linking tblInvtemplate to tblplacement

Field

Type

Null

Default

tempplaceID

int(11)

Yes

NULL

templateID

int(11)

Yes

NULL

placementID

int(11)

Yes

NULL

 

Table structure for table tbltempprov

Description: joining table linking tblInvtemplate to tblProvenance

Field

Type

Null

Default

tempprovID

int(11)

Yes

NULL

templateID

int(11)

Yes

NULL

provenanceID

int(11)

Yes

NULL

 

Table structure for table tbltempretention

Description: joining table linking tblInvtemplate to tblretention

Field

Type

Null

Default

tempretentionID

int(11)

Yes

NULL

templateID

int(11)

Yes

NULL

retentionID

int(11)

Yes

NULL

datereview

datetime

Yes

NULL

 

Table structure for table tbltempsw

Description: joining table linking tblInvtemplate to tblsoftware

Field

Type

Null

Default

tempswID

int(11)

Yes

NULL

templateID

int(11)

Yes

NULL

softwareID

int(11)

Yes

NULL

 

Table structure for table tbluser

Description:  this table lists the details of users permitted to access the administrative area of the archival system

Field

Type

Null

Default

userID

int(11)

Yes

NULL

lastname

varchar(50)

Yes

NULL

firstname

varchar(50)

Yes

NULL

login

varchar(12)

Yes

NULL

password

varchar(12)

Yes

NULL

email

varchar(100)

Yes

NULL

usertypeID

int(11)

Yes

NULL

phone

varchar(255)

Yes

NULL

addressstreet

varchar(100)

Yes

NULL

addresssuburb

varchar(100)

Yes

NULL

addresspostcode

varchar(10)

Yes

NULL

addressstate

varchar(5)

Yes

NULL

addresscountry

varchar(50)

Yes

NULL

archive

tinyint(4)

Yes

0

deleted

tinyint(4)

Yes

0

 

Table structure for table tblusergroup

Description:  this table lists the groups saved by guest remixers.
it is linked to the Inventory table with a man-to-many relationship via a joining table -   tblInvusergroup

Field

Type

Null

Default

usergroupID

int(11)

Yes

NULL

ugrouptitle

varchar(255)

Yes

NULL

ugroupdescription

text

Yes

NULL

dateappend

timestamp

Yes

CURRENT_TIMESTAMP

datemodified

datetime

Yes

NULL

userID

int(11)

Yes

NULL

username

varchar(50)

Yes

NULL

useremail

varchar(50)

Yes

NULL

deleted

tinyint(4)

Yes

0

 

Table structure for table tblusertype

Description: this table lists the types of user allowed access to the archival system – for example, “guest” can only access searches and guest remixing areas
whilst “admin” users can access all areas of the site and perform all data transactions.

Field

Type

Null

Default

usertypeID

int(11)

Yes

NULL

usertype

varchar(20)

Yes

NULL

 

top of page | homepage & table of contents

 

 

this page produced by lisa cianci on her website www.blackaeonium.net
comments and queries to lisa's email address on scr.im (for humans only)
created 01/12/2011
last modified 30/07/2012

Database Structure for the Blackaeonium Archive System from 2006 (click here to see larger image in a new window)
http://exegesis.blackaeonium.net/appendix4_BlackaeoniumDatabaseStructure.html
exegesis.blackaeonium.net
crawl=CC-MAIN-2017-26
100147
application/http; msgtype=response
sha1:EI7CKMXP45IJB5ITXYNDI5VRVICXCJU6
<urn:uuid:3c52a8e4-14ef-4344-a1a6-2e2bc04c34b0>
2017-06-28T22:45:13Z
66.96.132.205
text/html
sha1:XD4AD4RU3HDDZHQDSMC6K2BWFPOU4LPY
<urn:uuid:8d0d6441-bc43-4a33-bad2-ad50a1d3b631>
http://exegesis.blackaeonium.net/appendix4_BlackaeoniumDatabaseStructure.html
response
<urn:uuid:13023d58-e94c-493d-9653-6b9fff5f4a79>
robots: classic
hostname: ip-10-183-66-206.ec2.internal
software: Nutch 1.6 (CC)
isPartOf: CC-MAIN-2017-26
operator: Common Crawl Admin
description: Wide crawl of the web for June 2017
publisher: Common Crawl
format: WARC File Format 1.0
conformsTo: http://bibnum.bnf.fr/WARC/WARC_ISO_28500_version1_latestdraft.pdf