format
PRONOM 6
element implementation type value constraints cardinality
file_formats:
format id file_format_id Int N/A
file_formats:
format name format_name_text nvarchar(100) N/A
format_aliases:
name_text,
format_aliases:
format name aliases version_text nvarchar(50), nvarchar(50) N/A
file_formats:
format version version_text nvarchar(50) N/A
file_formats:
format description format_text nvarchar(2000) N/A
file_formats:
format release date release_date Datetime N/A
file_formats:
format withdrawn date withdrawn_date Datetime N/A
file_formats:
format withdrawn? withdrawn_flag Bit 1 (=yes) and 0 (=no)
format spec public disclosure file_formats:
level disclosure_text nvarchar(20) 'full', 'partial', 'none'
file_formats:
informative note note_text nvarchar(1000) N/A
file_formats:
agent who added record source_id Int FK to actors: actor_id
file_formats:
record creation time source_date Datetime N/A
file_formats:
record last modification time last_updated_date Datetime N/A
file_formats:
note about provenance provenance_text nvarchar(1000) N/A
FK to
puid_type:
file_formats: puid_type_i
type of ID for format Puid_type_id Int N/A d
file_formats:
public-facing ID for format Puid_value Int N/A
byte_orders:
byte order byte_order_text nvarchar(25) Little-endian, Big-endian or both
record verification date
record verification status
agent who verified record
record status
format_documentati
related documentation on: document_id Int FK to documents: document_id
related IPR format_ipr: ipr_id Int FK to
format_developers:
agent who created format developer_id Int FK to actors: actor_id
format_support:
agent who maintains format support_id Int FK to actors: actor_id
Page 1
format
format_families:
related format family name name_text nvarchar(50) N/A
related format family format_families:
description family_text nvarchar(1000) N/A
format_families:
related format family note note_text nvarchar(1000) N/A
ext_signature_types (the records in the type_name_text
external signature type : type_name_text nvarchar(50) column)
external_signatures:
external signature value signature_text nvarchar(1000)
external signature obligation
format_relationships
: source_id and
format_relationships
related format : target_id Int FK to format: format_id
format_relationship_
relationship type for a related types: (relationship types are listed as
format type_name_text nvarchar(50) records in this column)
format_relationship_
types:
inverse relationship type for a inverse_type_name
related format _text nvarchar(50) N/A
note about relationship for a format_relationships
related format : note_text nvarchar(1000) N/A
format_compression
compression used in a file _types:
format compression_id Int FK to
character encodings used in a format_encodings:
file format encoding_id Int FK to encoding: encoding_id
internal_signatures:
internal signature note note_text nvarchar(1000) N/A
agent who added the internal internal_signatures:
signature record source_id Int FK to actors: actor_id
time the internal signature internal_signatures:
record was created source_date Datetime
note about provenance for the internal_signatures:
internal signature record provenance_text nvarchar(1000)
Page 2
format
internal_signatures:
signature_name_tex
internal signature name t nvarchar(100)
is internal signature specific or internal_signatures: 0 (=specific) and 1 (=generic); 0 is
generic? generic_flag Bit default
position_types: (position types are the records in
byte sequence position type position_type_text nvarchar(50) this column)
byte_sequences:
byte sequence offset offset Int N/A
upper bound on the range of
the offsets
byte_sequences:
endianness of byte sequence big_endian_flag Bit 1 (=Big-endian)
byte_sequences:
byte sequence value byte_sequence nvarchar(1000) N/A
internal signature obligation
int_sig_relationships
: source_id and
int_sig_relationships FK to internal_signatures:
related internal signature : target_id Int signature_id
int_sig_relationship_
relationship type for a related types:
internal signature type_name_text nvarchar(50) N/A
int_sig_relationship_
types:
inverse relationship type for a inverse_type_name
related internal signature _text nvarchar(50) N/A
note about relationship for a int_sig_relationships
related internal signature : note_text nvarchar(1000) N/A
ext_sig_relationship
s: source_id and
ext_sig_relationship FK to internal_signatures:
related external signature s: target_id Int signature_id
ext_sig_relationship
relationship type for a related _types:
external signature type_name_text nvarchar(50) N/A
ext_sig_relationship
_types:
inverse relationship type for a inverse_type_name
related external signature _text nvarchar(50) N/A
note about relationship for a ext_sig_relationship
related external signature s: note_text nvarchar(1000) N/A
assessment of the format
known caveats about the
format
domain classification
composition classification
role classification
Page 3
format
link from
format_type_link:for
mat_type_id to
format_types:
genre classification format_type_text nvarchar(1000) (the records in this column)
subsidiary genre classification
transform classification
basis classification
file_formats:binary_f
form classification lag Bit 1 (=binary) and 0 (=text)
constraint classification
format grammar
internal signature
format MIME type
value of external identifier for format_identifiers:
format identifier_text nvarchar(150) N/A 0..*
format_identifier_typ
type of external identifier for es: (format identifier types listed as
format identifier_type_text nvarchar(50) records)
further information about format_identifiers:
external identifier for format note_text nvarchar(1000) N/A
agent who added record on format_identifiers:
external identifier for format source_id Int FK to actors: actor_id
date when record on external
identifier for format was format_identifiers:
created source_date Datetime N/A
date when record on external
identifier for format was last format_identifiers:
modified last_updated_date Datetime N/A
provenance note about record format_identifiers:
on external identifier for format provenance_text nvarchar(1000) N/A
Page 4
format
inherent properties and related
risk inherent_property
instance properties instance_property
instance_property_ri
risks of instance properties sk
name of tools that can be
used on formats tools: tool_name nvarchar(50) N/A
type of tools that can be used tool_types:
on formats tool_type nvarchar(50) (types listed as records)
description of tools that can be tools:
used on formats tool_description nvarchar(255) N/A
class name of tools that can
be used on formats tools: class_name nvarchar(255) N/A
Page 5
format
GDFR
implementation type value constraints cardinality
Base: SystemID long N/A 1
Product: Name String N/A 1
Product: Alias String N/A 0..*
Product: Version String N/A 0..1
Product: Description String N/A 0..1
Product: ReleaseDate DateTime ISO 8601 0..1
Product: WithdrawalDate DateTime ISO 8601 0..1
Base:Note String N/A 0..1
Base:CreationDate DateTime ISO 8601 1
Base:ModificationDate DateTime ISO 8601 0..1
Base: Provenance String N/A 0..1
Format: GDFRIdentifier (Identifier)
'BigEndian',
'BigAndLittleEndian',
'BigOrLittleEndian',
'LittleEndian',
Format:ByteOrder String 'NotApplicable', 'Unknown'
Base: VerificationDate DateTime ISO 8601 0..1
Base: VerificationStatus String 'NoReview', 'FullReview' 1
Base: VerifiedBy (Agent) N/A 0..1
Active', 'Deprecated',
Base: AdminStatus String 'Deleted', 'Provisional' 1
Product: HasDocumentation (Document) N/A 0..1
Product: Restricts (IPR) N/A 0..*
Product: HasCreator (Agent) N/A 0..*
Product: HasMaintainer (Agent) N/A 0..*
Page 6
format
(handled through role
classification of 'family' and a
format relationship)
(handled through the related
format's description)
(handled through the related
format's informative note)
'Extension', 'TypeCode',
ExternalSignature: Type String 'UniformTypeIdentifier' 1
If the value starts with “0x”
interpret it as case-
insensitive hexadecimal
Signature: Value String byte values 1
Optional', 'Required',
Signature: SignatureObligation String 'Unknown' 1
Product: Relation
'CanContain',
'HasAffinityFor',
'IsDefinedBy',
'IsExtensionOf',
'IsModificationOf',
'IsPreviousVersionOf',
'IsRequisiteFor',
'IsRestrictionOf',
'IsSemanticallyEquivalentT
o',
'IsSubsequentVersionOf',
'IsSyntacticallyEquivalence
Relationship: Type String To', 'MustContain'
(expressed through a
CanContain relationship)
(expressed through a
CanContain relationship)
Page 7
format
InternalSignature: Position String BOF', 'EOF', 'Variable' 1
Non-negative
InternalSignature: Offset integer 1
InternalSignature: Non-negative
OffsetRange integer 0..1
If the value starts with “0x”
interpret it as case-
insensitive hexadecimal
Signature: Value String byte values 1
Optional', 'Required',
Signature: SignatureObligation String 'Unknown' 1
Format: Assessment (Assessment) N/A 0..*
Format: Caveats String N/A 0..*
'astronomy', 'cad-cam', 'gis',
Format: Classification String 'web-archive' 0..*
unitary', 'container-bundle',
Format: Classification String 'container-wrapper' 0..*
family', 'file-format',
Format: Classification String 'encoding', 'serialization' 0..*
Page 8
format
aggregate', 'any',
'database', 'dataset',
'document', 'executable',
'model', 'moving-image',
'other', 'presentation',
'sound', 'spreadsheet', 'still-
Format: Classification String image', 'text' 0..*
aggregate', 'any',
'database', 'dataset',
'document', 'executable',
'model', 'moving-image',
'other', 'presentation',
'sound', 'spreadsheet', 'still-
Format: Classification String image', 'text' 0..*
compression', 'encryption',
Format: Classification String 'message-digest' 0..*
Format: Classification String sampled', 'symbolic' 0..*
Format: Classification String binary', 'text' 0..*
Format: Classification String structured', 'unstructured' 0..*
Format: Grammar (Grammar) See Grammar Sheet 0..*
(InternalSigantur See InternalSignature
Format: InternalSignature e) Sheet 0..*
Format: MimeType String N/A 0..*
Identifier: Value String N/A 0..*
'4CC', 'AFNOR', 'AIIM',
'ANSI', 'ARK', 'BCP', 'BSI',
'CallNumber', 'CCITT',
'DDC', 'DOI', 'ECMA', 'FDD',
'FIPS', 'GFID_URI', 'GUID',
'Handle', 'I3A', 'IEC', 'ISBN',
'ISO', 'ISSN', 'ITU', 'JEITA',
'LCC', 'LCCN', 'NISO',
'OCLC', 'PII', 'P/N',
'PUID_URI', 'PURL', 'RFC',
'S/N', 'Shelfmark', 'SICI',
'SMPTE', 'STD', 'TOM',
'URI', 'URL', 'URN', 'UUID',
Identifier: Type String 'Other', 'Unknown' 0..*
Page 9
format
(handled through software,
process, format relations)
(handled through software and
process types)
(handled through software
description)
Page 10
compression
PRONOM 6 GDFR
element implementation
UDFR requirement? type value constraints cardinality implementation
compression_type
compression id s: compression_id Int Base: SystemID
compression_type
s:
compression compression_nam
name e_text nvarchar(100) Product: Name
compression compression_type
version s: version_text nvarchar(50) Product: Version
compression_alias
es: name_text and
compression compression_alias nvarchar(50),
name aliases es: version_text nvarchar(50) N/A Product: Alias
compression_type
s: Product:
description compression_text nvarchar(2000) N/A Description
lossiness
options
associated with lossiness: (Values listed as
compression lossiness_text nvarchar(50) records) 0..*
compression_type Product:
release date s: release_date Datetime N/A ReleaseDate
compression_type Product:
withdrawal date s: withdrawn_date Datetime N/A WithdrawalDate
compression_type 1 (=yes) and 0
withdrawn? s: withdrawn_flag Bit (=no)
compression_type
informative note s: note_text nvarchar(1000) N/A Base:Note
agent who compression_type FK to actors:
added record s: source_id Int actor_id
record creation compression_type Base:CreationD
time s: source_date Datetime N/A ate
compression_type
record last s: Base:Modificatio
modification time last_update_date Datetime N/A nDate
note about compression_type Base:
provenance s: provenance_text nvarchar(1000) N/A Provenance
type of ID for compression_type FK to puid_type:
format s: Puid_type_id Int puid_type_id
public-facing ID compression_type Format:
for format s: Puid_value Int GDFRIdentifier
(handled through
role
classification of
'family' and a
name of related compression_famil format
encoding family ies: name_text nvarchar(50) N/A relationship)
Page 11
compression
(handled through
description of the related
related encoding compression_famil format's
family ies: family_text nvarchar(1000) N/A description)
(handled through
informative note the related
about related compression_famil format's
encoding family ies: note_text nvarchar(1000) N/A informative note)
compression_ipr: Product:
related IPR ipr_id Int FK to ipr: ipr_id Restricts
agent who compression_deve
created loper: FK to actors: Product:
compression developer_id Int actor_id HasCreator
agent who
maintains compression_supp FK to actors: Product:
compression ort: support_id Int actor_id HasMaintainer
documentation compression_docu FK to Product:
about mentation: documents: HasDocumentati
compression document_id Int document_id on
compression_relati
onships: source_id
and FK to
related compression_relati compression: Product:
compression onships: target_id Int compression_id Relation
relationship type compression_relati
for a related onship_types: (Values listed as Relationship:
compression type_name_text nvarchar(50) records) Type
inverse compression_relati
relationship type onship_types:
for a related inverse_type_nam
compression e_text nvarchar(50) N/A
note about
relationship for a
related compression_relati
compression onships: note_text nvarchar(1000) N/A
Page 12
compression
value of external compression_ident
identifier for ifiers:
compression identifier_text nvarchar(150) N/A 0..* Identifier: Value
(compression
type of external compression_ident identifier types
identifier for ifier_types: listed as
compression identifier_type_text nvarchar(50) records) Identifier: Type
further
information
about external
identifier for compression_ident
compression ifiers: note_text nvarchar(1000) N/A
agent who
added record on
external
identifier for compression_ident FK to actors:
compression ifiers: source_id Int actor_id
date when
record on
external
identifier for
compression compression_ident
was created ifiers: source_date Datetime N/A
date when
record on
external
identifier for
compression compression_ident
was last ifiers:
modified last_updated_date Datetime N/A
Page 13
compression
provenance note
about record on
external compression_ident
identifier for ifiers:
compression provenance_text nvarchar(1000) N/A
Format:ByteOrd
byte order er
Format:
external ExternalSignatur
signatures e
assessment of Format:
the format Assessment
known caveats
about the format Format: Caveats
domain Format:
classification Classification
composition Format:
classification Classification
role Format:
classification Classification
genre Format:
classification Classification
Page 14
compression
subsidiary genre Format:
classification Classification
transform Format:
classification Classification
basis Format:
classification Classification
form Format:
classification Classification
constraint Format:
classification Classification
Format:
format grammar Grammar
Format:
internal InternalSignatur
signature e
format MIME Format:
type MimeType
record Base:
verification date VerificationDate
record Base:
verification VerificationStatu
status s
agent who
verified record Base: VerifiedBy
Base:
record status AdminStatus
Page 15
compression
type value constraints cardinality
long N/A 1
String N/A 1
String N/A 0..1
String N/A 0..*
String N/A 0..1
DateTime ISO 8601 0..1
DateTime ISO 8601 0..1
String N/A 0..1
DateTime ISO 8601 1
DateTime ISO 8601 0..1
String N/A 0..1
(Identifier)
Page 16
compression
(IPR) N/A 0..*
(Agent) N/A 0..*
(Agent) N/A 0..*
(Document) N/A 0..1
'CanContain',
'HasAffinityFor',
'IsDefinedBy',
'IsExtensionOf',
'IsModificationOf
',
'IsPreviousVersi
onOf',
'IsRequisiteFor',
'IsRestrictionOf',
'IsSemanticallyE
quivalentTo',
'IsSubsequentVe
rsionOf',
'IsSyntacticallyE
quivalenceTo',
String 'MustContain'
Page 17
compression
String N/A 0..*
'4CC', 'AFNOR',
'AIIM', 'ANSI',
'ARK', 'BCP',
'BSI',
'CallNumber',
'CCITT', 'DDC',
'DOI', 'ECMA',
'FDD', 'FIPS',
'GFID_URI',
'GUID', 'Handle',
'I3A', 'IEC',
'ISBN', 'ISO',
'ISSN', 'ITU',
'JEITA', 'LCC',
'LCCN', 'NISO',
'OCLC', 'PII',
'P/N',
'PUID_URI',
'PURL', 'RFC',
'S/N',
'Shelfmark',
'SICI', 'SMPTE',
'STD', 'TOM',
'URI', 'URL',
'URN', 'UUID',
'Other',
String 'Unknown' 0..*
Page 18
compression
'BigEndian',
'BigAndLittleEndi
an',
'BigOrLittleEndia
n', 'LittleEndian',
'NotApplicable',
String 'Unknown'
(ExternalSignatu
re) 0..*
(Assessment) N/A 0..*
String N/A 0..*
'astronomy', 'cad-
cam', 'gis', 'web-
String archive' 0..*
unitary',
'container-
bundle',
'container-
String wrapper' 0..*
'family', 'file-
format',
'encoding',
String 'serialization' 0..*
aggregate', 'any',
'database',
'dataset',
'document',
'executable',
'model', 'moving-
image', 'other',
'presentation',
'sound',
'spreadsheet',
String 'still-image', 'text' 0..*
Page 19
compression
aggregate', 'any',
'database',
'dataset',
'document',
'executable',
'model', 'moving-
image', 'other',
'presentation',
'sound',
'spreadsheet',
String 'still-image', 'text' 0..*
'compression',
'encryption',
'message-digest'
(this would equal
String compression) 0..*
sampled',
String 'symbolic' 0..*
String binary', 'text' 0..*
structured',
String 'unstructured' 0..*
See Grammar
(Grammar) Sheet 0..*
See
(InternalSigantur InternalSignatur
e) e Sheet 0..*
String N/A 0..*
DateTime ISO 8601 0..1
'NoReview',
String 'FullReview' 1
(Agent) N/A 0..1
Active',
'Deprecated',
'Deleted',
String 'Provisional' 1
Page 20
character encoding
PRONOM 6 GDFR
element implementation
UDFR requirement? type value constraints cardinality implementation
encoding:
encoding ID encoding_id Int N/A Base: SystemID
encoding_aliase
s: name_text,
encoding name encoding_aliase nvarchar(50),
alias s: version_text nvarchar(50) N/A Product: Alias
encoding:
character encoding_name
encoding type _text nvarchar(100) N/A Product: Name
character
encoding type encoding:
version version_text nvarchar(50) N/A Product: Version
encoding: Product:
description encoding_text nvarchar(2000) N/A Description
encoding:
code page code_page Int N/A
encoding:
code unit width code_unit_width
in bits _text nvarchar(50) N/A
encoding form encoding:
width in code encoding_form_
units width_text nvarchar(50) N/A
encoding encoding_releas Product:
release date e_date Datetime N/A ReleaseDate
encoding encoding: Product:
withdrawal date withdrawn_date Datetime N/A WithdrawalDate
encoding encoding: 1 (=yes) and 0
withdrawn? withdrawn_flag Bit (=no)
encoding:
informative note note_text nvarchar(1000) N/A Base:Note
agent who encoding: FK to actors:
added record source_id Int actor_id
record creation encoding: Base:CreationD
time source_date Datetime N/A ate
encoding:
record last last_updated_da Base:Modificatio
modification time te Datetime N/A nDate
note about encoding: Base:
provenance provenance_text nvarchar(1000) N/A Provenance
type of ID for encoding: FK to puid_type:
encoding Puid_type_id Int puid_type_id
public-facing ID encoding: Format:
for encoding Puid_value Int GDFRIdentifier
(handled through
role
classification of
'family' and a
name of related encoding_familie format
encoding family s: name_text nvarchar(50) N/A relationship)
Page 21
character encoding
(handled through
description of the related
related encoding encoding_familie format's
family s: family_text nvarchar(1000) N/A description)
(handled through
informative note the related
about related encoding_familie format's
encoding family s: note_text nvarchar(1000) N/A informative note)
encoding_ipr: Product:
related IPR ipr_id Int FK to ipr: ipr_id Restricts
agent who encoding_develo
created per: FK to actors: Product:
encoding developer_id Int actor_id HasCreator
agent who
maintains encoding_suppo FK to actors: Product:
encoding rt: support_id Int actor_id HasMaintainer
encoding_docu FK to Product:
documentation mentation: documents: HasDocumentati
about encoding document_id Int document_id on
encoding_relatio
nships:
source_id and
encoding_relatio FK to encoding: Product:
related encoding nships: target_id Int encoding_id Relation
relationship type encoding_relatio
for a related nship_types: (Values listed as Relationship:
encoding type_name_text nvarchar(50) records) Type
inverse encoding_relatio
relationship type nship_types:
for a related inverse_type_na
encoding me_text nvarchar(50) N/A
note about
relationship for a encoding_relatio
related encoding nships: note_text nvarchar(1000) N/A
Page 22
character encoding
value of external encoding_identifi
identifier for ers:
encoding identifier_text nvarchar(150) N/A 0..* Identifier: Value
encoding_identifi (encoding
type of external er_types: identifier types
identifier for identifier_type_t listed as
encoding ext nvarchar(50) records) Identifier: Type
further
information
about external
identifier for encoding_identifi
encoding ers: note_text nvarchar(1000) N/A
agent who
added record on
external
identifier for encoding_identifi FK to actors:
encoding ers: source_id Int actor_id
date when
record on
external
identifier for
encoding was encoding_identifi
created ers: source_date Datetime N/A
date when
record on
external encoding_identifi
identifier for ers:
encoding was last_updated_da
last modified te Datetime N/A
Page 23
character encoding
provenance note
about record on
external encoding_identifi
identifier for ers:
encoding provenance_text nvarchar(1000) N/A
Format:ByteOrd
byte order er
Format:
external ExternalSignatur
signatures e
assessment of Format:
the format Assessment
known caveats
about the format Format: Caveats
domain Format:
classification Classification
composition Format:
classification Classification
role Format:
classification Classification
genre Format:
classification Classification
Page 24
character encoding
subsidiary genre Format:
classification Classification
transform Format:
classification Classification
basis Format:
classification Classification
form Format:
classification Classification
constraint Format:
classification Classification
Format:
format grammar Grammar
Format:
internal InternalSignatur
signature e
format MIME Format:
type MimeType
record Base:
verification date VerificationDate
record Base:
verification VerificationStatu
status s
agent who
verified record Base: VerifiedBy
Base:
record status AdminStatus
Page 25
character encoding
type value constraints cardinality
long N/A 1
String N/A 0..*
String N/A 1
String N/A 0..1
String N/A 0..1
DateTime ISO 8601 0..1
DateTime ISO 8601 0..1
String N/A 0..1
DateTime ISO 8601 1
DateTime ISO 8601 0..1
String N/A 0..1
(Identifier)
Page 26
character encoding
(IPR) N/A 0..*
(Agent) N/A 0..*
(Agent) N/A 0..*
(Document) N/A 0..1
'CanContain',
'HasAffinityFor',
'IsDefinedBy',
'IsExtensionOf',
'IsModificationOf
',
'IsPreviousVersi
onOf',
'IsRequisiteFor',
'IsRestrictionOf',
'IsSemanticallyE
quivalentTo',
'IsSubsequentVe
rsionOf',
'IsSyntacticallyE
quivalenceTo',
String 'MustContain'
Page 27
character encoding
String N/A 0..*
'4CC', 'AFNOR',
'AIIM', 'ANSI',
'ARK', 'BCP',
'BSI',
'CallNumber',
'CCITT', 'DDC',
'DOI', 'ECMA',
'FDD', 'FIPS',
'GFID_URI',
'GUID', 'Handle',
'I3A', 'IEC',
'ISBN', 'ISO',
'ISSN', 'ITU',
'JEITA', 'LCC',
'LCCN', 'NISO',
'OCLC', 'PII',
'P/N',
'PUID_URI',
'PURL', 'RFC',
'S/N',
'Shelfmark',
'SICI', 'SMPTE',
'STD', 'TOM',
'URI', 'URL',
'URN', 'UUID',
'Other',
String 'Unknown' 0..*
Page 28
character encoding
'BigEndian',
'BigAndLittleEndi
an',
'BigOrLittleEndia
n', 'LittleEndian',
'NotApplicable',
String 'Unknown'
(ExternalSignatu
re) 0..*
(Assessment) N/A 0..*
String N/A 0..*
'astronomy', 'cad-
cam', 'gis', 'web-
String archive' 0..*
unitary',
'container-
bundle',
'container-
String wrapper' 0..*
'family', 'file-
format',
'encoding',
'serialization'
(This would
String equal encoding) 0..*
aggregate', 'any',
'database',
'dataset',
'document',
'executable',
'model', 'moving-
image', 'other',
'presentation',
'sound',
'spreadsheet',
String 'still-image', 'text' 0..*
Page 29
character encoding
aggregate', 'any',
'database',
'dataset',
'document',
'executable',
'model', 'moving-
image', 'other',
'presentation',
'sound',
'spreadsheet',
String 'still-image', 'text' 0..*
compression',
'encryption',
String 'message-digest' 0..*
sampled',
String 'symbolic' 0..*
String binary', 'text' 0..*
structured',
String 'unstructured' 0..*
See Grammar
(Grammar) Sheet 0..*
See
(InternalSigantur InternalSignatur
e) e Sheet 0..*
String N/A 0..*
DateTime ISO 8601 0..1
'NoReview',
String 'FullReview' 1
(Agent) N/A 0..1
Active',
'Deprecated',
'Deleted',
String 'Provisional' 1
Page 30
software
PRONOM 6 GDFR
element implementation
UDFR requirement? type value constraints cardinality implementation
software:
software id software_id Int N/A Base: SystemID
software:
software_name_
software name text nvarchar(100) N/A Product: Name
software_aliases
: name_text,
software name software_aliases nvarchar(50),
aliases : version_text nvarchar(50) N/A Product: Alias
software:
software version version_text nvarchar(50) N/A Product: Version
software software: Product:
description software_text nvarchar(2000) N/A Description
service pack or
patch level software:
applied to service_pack_te Software:
software xt nvarchar(50) N/A ServicePack
software: Product:
release date release_date Datetime N/A ReleaseDate
software: Product:
withdrawal date withdrawn_date Datetime N/A WithdrawalDate
software: 1 (=yes) and 0
withdrawn? withdrawn_flag Bit (=no)
software:
informative note note_text nvarchar(1000) N/A Base:Note
FK to
software_types:
software software: software_type_t
category category_id nvarchar(50) ext Software: Type
software:
location_held_te
? xt
software:
technical_depen
? dencies_text
agent who software: FK to actors:
added record source_id Int actor_id
record creation software: Base:CreationD
time source_date Datetime N/A ate
software:
record last last_updated_da Base:Modificatio
modification time te Datetime N/A nDate
note about software: Base:
provenance provenance_text nvarchar(1000) N/A Provenance
type of ID for software: FK to puid_type:
software Puid_type_id Int N/A puid_type_id
Page 31
software
public-facing ID software:
for software Puid_value Int N/A
name of related software_familie
software family s: name_text nvarchar(50) N/A
description of
related software software_familie
family s: family_text nvarchar(1000) N/A
informative note
about related software_familie
software family s: note_text nvarchar(1000) N/A
IPR related to software_ipr: Product:
software ipr_id Int FK to Restricts
software_images
:
base64-encoded base64_encode
software image d text(16) base64-encoded
original name of
software binary software_images
file : file_name_text nvarchar(255) N/A
description of
the software software_images
image : description_text nvarchar(255) N/A
software_develo
agent who pers: FK to actors: Product:
created software developer_id Int actor_id HasCreator
agent who software_maintai
maintains ners: FK to actors: Product:
software maintainer_id Int actor_id HasMaintainer
value of external software_identifi
identifier for ers:
software identifier_text nvarchar(150) N/A 0..* Identifier: Value
software_identifi (software
type of external er_types: identifier types
identifier for identifier_type_t listed as
software ext nvarchar(50) records) Identifier: Type
further
information
about external
identifier for software_identifi
software ers: note_text nvarchar(1000) N/A
Page 32
software
agent who
added record on
external
identifier for software_identifi FK to actors:
software ers: source_id Int actor_id
date when
record on
external
identifier for
software was software_identifi
created ers: source_date Datetime N/A
date when
record on
external software_identifi
identifier for ers:
software was last_updated_da
last modified te Datetime N/A
provenance note
about record on
external software_identifi
identifier for ers:
software provenance_text nvarchar(1000) N/A
software languages:
language language_text nvarchar(50) N/A
software- FK link to Product:
software documentation: documents: HasDocumentati
documentation document_id Int document_id on
metadata the
software can
extract from a extracted_metad
particular format ata
processes
supported by the
software for a processes (see Software:
particular format process sheet) Instantiates
software_relatio
nships:
source_id and FK to
software_relatio compression:
related software nships: target_id Int compression_id
relationship type software_relatio
for a related nship_types:
software type_name_text nvarchar(50) N/A
inverse software_relatio
relationship type nship_types:
for a related inverse_type_na
software me_text nvarchar(50) N/A
note about
relationship for a software_relatio
related software nships: note_text nvarchar(1000) N/A
Page 33
software
storage medium storage_media: (Media modeled
formats storage_medium explicitly as a
available _text nvarchar(1000) N/A 0..* separate entity)
record Base:
verification date VerificationDate
record Base:
verification VerificationStatu
status s
agent who
verified record Base: VerifiedBy
Base:
record status AdminStatus
required required_softwar
software for e_for_software: FK to software: Product:
software software_id Int software_id Dependency
qualifier requirement_qua
description on lifiers: Dependency:
requirement description varchar(100) N/A Qualifier
required_softwar
e_for_hardware:
requirement note note nvarchar(1000) N/A
required required_hardwa
hardware for re_for_software: Product:
software req_hardware_id Dependency
qualifier requirement_qua
description on lifiers: (values listed as Dependency:
requirement description varchar(100) records) Qualifier
required_softwar
e_for_hardware:
requirement note note nvarchar(1000) N/A
(kind of
addresses this
through
processes: Software:
default format default_flag) HasDefault
Page 34
software
type value constraints cardinality
long N/A 1
String N/A 1
String N/A 0..*
String N/A 0..1
String N/A 0..1
String N/A 0..1
DateTime ISO 8601 0..1
DateTime ISO 8601 0..1
String N/A 0..1
'Applet', 'Application', 'BIOS',
'CommandShell', 'Compiler',
'DeviceDriver', 'Firmware',
'GUI', 'Interpreter', 'library',
'OperatingSystem', 'Script',
'Servlet', 'VirtualMachine',
'WebService', 'Other',
String 'Unknown' 1
DateTime ISO 8601 1
DateTime ISO 8601 0..1
String N/A 0..1
Page 35
software
(IPR) N/A 0..*
(Agent) N/A 0..*
(Agent) N/A 0..*
String N/A 0..*
'4CC', 'AFNOR', 'AIIM',
'ANSI', 'ARK', 'BCP', 'BSI',
'CallNumber', 'CCITT', 'DDC',
'DOI', 'ECMA', 'FDD', 'FIPS',
'GFID_URI', 'GUID', 'Handle',
'I3A', 'IEC', 'ISBN', 'ISO',
'ISSN', 'ITU', 'JEITA', 'LCC',
'LCCN', 'NISO', 'OCLC', 'PII',
'P/N', 'PUID_URI', 'PURL',
'RFC', 'S/N', 'Shelfmark',
'SICI', 'SMPTE', 'STD', 'TOM',
'URI', 'URL', 'URN', 'UUID',
String 'Other', 'Unknown' 0..*
Page 36
software
(Document) N/A 0..1
(Process) - see
process sheet
Page 37
software
DateTime ISO 8601 0..1
String 'NoReview', 'FullReview' 1
(Agent) N/A 0..1
Active', 'Deprecated',
String 'Deleted', 'Provisional' 1
Equivalent', 'Exact',
String 'Minimum', 'Other'
Equivalent', 'Exact',
String 'Minimum', 'Other'
(Format) N/A 0..*
Page 38
process
PRONOM 6 GDFR
element implementation
UDFR requirement? type value constraints cardinality implementation
(process types
process_types: are listed as
process_type_te records in this
process type xt nvarchar(50) column) Process: Type
process id Base: SystemID
process:
informative note note_text nvarchar(1000) N/A Base:Note
agent who process: FK to actors:
created record source_id Int actor_id
record creation process: Base:CreationD
time source_date Datetime N/A ate
process:
record last last_update_dat Base:Modificatio
modification time e Datetime N/A nDate
note about process: Base:
provenance provenance_text nvarchar(1000) N/A Provenance
record Base:
verification date VerificationDate
record Base:
verification VerificationStatu
status s
agent who
verified record Base: VerifiedBy
Base:
record status AdminStatus
degree of
invariance
associated with invariances:
the process invariance_text nvarchar(50) N/A
process_docum FK to
process entation: documents:
documentation document_id Int document_id
Page 39
process
type value constraints cardinality
'Assess',
'Characterize',
'Create', 'Edit',
'Identify',
'Render',
'Transcode',
'Validate',
'Other',
'Unknown'
long N/A 1
String N/A 0..1
DateTime ISO 8601 1
DateTime ISO 8601 0..1
String N/A 0..1
DateTime ISO 8601 0..1
'NoReview',
String 'FullReview' 1
(Agent) N/A 0..1
Active',
'Deprecated',
'Deleted',
String 'Provisional' 1
Page 40
hardware
PRONOM 6 GDFR
element implementation
UDFR requirement? type value constraints cardinality implementation
hardware:
hardware id hardware_id Int N/A Base: SystemID
hardware:
hardware name hardware_name varchar(50) N/A Product: Name
hardware_aliase
s: name_text,
hardware name hardware_aliase nvarchar(50),
aliases s: version_text nvarchar(50) N/A Product: Alias
hardware hardware:
version version varchar(50) N/A Product: Version
Product:
description Description
hardware: Product:
release date release_date Date N/A ReleaseDate
hardware: Product:
withdrawal date withdrawn_date Date N/A WithdrawalDate
hardware_ 1 (=yes) and 0
withdrawn? withdrawn_flag Bit (=no)
informative note hardware_note varchar(1000) N/A Base:Note
agent who hardware: FK to actors:
added record source_id Int actor_id
record creation hardware: Base:CreationD
time source_date Datetime N/A ate
hardware:
record last last_updated_da Base:Modificatio
modification time te Datetime N/A nDate
note about hardware: Base:
provenance provenance_text nvarchar(1000) N/A Provenance
name of related hardware_famili
hardware family es: name_text nvarchar(50) N/A
description of
related hardware hardware_famili
family es: family_text nvarchar(1000) N/A
informative note
about related hardware_famili
hardware family es: note_text nvarchar(1000) N/A
IPR related to hardware_ipr: Product:
hardware ipr_id Int FK to Restricts
hardware_image
s:
base64-encoded base64_encode
hardware image d text(16) base64-encoded
hardware_image
original name of s:
binary file file_name_text nvarchar(255) N/A
Page 41
hardware
hardware_image
description of s:
the image description_text nvarchar(255) N/A
value of external hardware_identif
identifier for iers:
hardware identifier_text nvarchar(150) N/A 0..* Identifier: Value
hardware_identif (software
type of external ier_types: identifier types
identifier for identifier_type_t listed as
hardware ext nvarchar(50) records) Identifier: Type
further
information
about external
identifier for hardware_identif
hardware iers: note_text nvarchar(1000) N/A
agent who
added record on
external
identifier for hardware_identif FK to actors:
hardware iers: source_id Int actor_id
date when
record on
external
identifier for hardware_identif
hardware was iers:
created source_date Datetime N/A
date when
record on
external hardware_identif
identifier for iers:
hardware was last_updated_da
last modified te Datetime N/A
Page 42
hardware
provenance note
about record on
external hardware_identif
identifier for iers:
hardware provenance_text nvarchar(1000) N/A
agent who hardware_devel
created opers: FK to actors: Product:
hardware developer_id Int actor_id HasCreator
agent who hardware_maint
maintains ainers: FK to actors: Product:
hardware maintainer_id Int actor_id HasMaintainer
hardware_types:
hardware type name varchar(50) N/A Hardware: Type
hardware_docu FK to Product:
hardware mentation: documents: HasDocumentati
documentation document_id Int document_id on
hardware_relatio
nships:
source_id and FK to
hardware_relatio compression:
related hardware nships: target_id Int compression_id
relationship type hardware_relatio
for a related nship_types:
hardware type_name_text nvarchar(50) N/A
inverse hardware_relatio
relationship type nship_types:
for a related inverse_type_na
hardware me_text nvarchar(50) N/A
note about
relationship for a hardware_relatio
related hardware nships: note_text nvarchar(1000) N/A
required required_softwar
software for e_for_hardware: FK to software: Product:
hardware software_id Int software_id Dependency
Page 43
hardware
qualifier requirement_qua
description on lifiers: Dependency:
requirement description varchar(100) N/A Qualifier
required_softwar
e_for_hardware:
requirement note note nvarchar(1000) N/A
required required_hardwa
hardware for re_for_hardware: FK to hardware: Product:
hardware req_hardware_id Int hardware_id Dependency
qualifier requirement_qua
description on lifiers: Dependency:
requirement description varchar(100) N/A Qualifier
required_softwar
e_for_hardware:
requirement note note nvarchar(1000) N/A
record Base:
verification date VerificationDate
record Base:
verification VerificationStatu
status s
agent who
verified record Base: VerifiedBy
Base:
record status AdminStatus
Page 44
hardware
type value constraints cardinality
long N/A 1
String N/A 1
String N/A 0..*
String N/A 0..1
String N/A 0..1
DateTime ISO 8601 0..1
DateTime ISO 8601 0..1
String N/A 0..1
DateTime ISO 8601 1
DateTime ISO 8601 0..1
String N/A 0..1
(IPR) N/A 0..*
Page 45
hardware
String N/A 0..*
'4CC', 'AFNOR',
'AIIM', 'ANSI',
'ARK', 'BCP',
'BSI',
'CallNumber',
'CCITT', 'DDC',
'DOI', 'ECMA',
'FDD', 'FIPS',
'GFID_URI',
'GUID', 'Handle',
'I3A', 'IEC',
'ISBN', 'ISO',
'ISSN', 'ITU',
'JEITA', 'LCC',
'LCCN', 'NISO',
'OCLC', 'PII',
'P/N',
'PUID_URI',
'PURL', 'RFC',
'S/N',
'Shelfmark',
'SICI', 'SMPTE',
'STD', 'TOM',
'URI', 'URL',
'URN', 'UUID',
'Other',
String 'Unknown' 0..*
Page 46
hardware
(Agent) N/A 0..*
(Agent) N/A 0..*
'CD-ROMDrive',
'CPU', 'Dongle',
'DVD-
ROMDrive',
'FlexibleDiskDriv
e',
'HardDiskDrive',
'Modem',
'Motherboard',
'NetworkCard',
'ParallelIOPort',
'RAM',
'SerialIOPort',
'SoundCard',
'USBPort',
'VideoCard',
'ZipDrive',
'Other',
String 'Unknown' 1
(Document) N/A 0..1
Page 47
hardware
Equivalent',
'Exact',
'Minimum',
String 'Other'
Equivalent',
'Exact',
'Minimum',
String 'Other'
DateTime ISO 8601 0..1
'NoReview',
String 'FullReview' 1
(Agent) N/A 0..1
Active',
'Deprecated',
'Deleted',
String 'Provisional' 1
Page 48
media
PRONOM 6 GDFR
element UDFR requirement? implementation type value constraints cardinality implementation
media id Base: SystemID
media name Product: Name
media name
aliases Product: Alias
media version Product: Version
media Product:
description Description
media release Product:
date ReleaseDate
media withdrawn Product:
date WithdrawalDate
Base:
record status AdminStatus
record creation Base:CreationD
date ate
record last
modification Base:Modificatio
date nDate
informative note Base:Note
Base:
provenance note Provenance
record Base:
verification date VerificationDate
record Base:
verification VerificationStatu
status s
agent who
verified record Base: VerifiedBy
Product:
media HasDocumentati
documentation on
storage Media:
documentation HasStorageDoc
for media umentation
longevity Media:
documentation HasLongevityDo
for media cumentation
agent who Product:
created media HasCreator
agent who Product:
maintains media HasMaintainer
Product:
related IPR Restricts
Media:
access type AccessType
coercivity in
units of Media:
Oersteds (Oe) Coercivity
Page 49
media
Media:
compressed CompressedCap
storage capacity acity
media Media:
dimensions Dimensions
error correction Media:
description ErrorCorrection
special handling
requirements Media:
description HandlingNote
number of layers Media: Layers
estimated
longevity Media: Longevity
read speed (unit
of size per unit Media:
of time) ReadSpeed
number of sides Media: Sides
recommended
environmental Media:
storage StorageConditio
conditions ns
special storage
requirements Media:
description StorageNote
media type Media: Type
Media:
uncompressed UncompressedC
storage capacity apacity
write protection Media:
description WriteProtection
write speed (unit
of size per unit Media:
of time) WriteSpeed
Media:
write type WriteType
Page 50
media
type value constraints cardinality
long N/A 1
String N/A 1
String N/A 0..*
String N/A 0..1
String N/A 0..1
DateTime ISO 8601 0..1
DateTime ISO 8601 0..1
Active',
'Deprecated',
'Deleted',
String 'Provisional' 1
DateTime ISO 8601 1
DateTime ISO 8601 0..1
String N/A 0..1
String N/A 0..1
DateTime ISO 8601 0..1
'NoReview',
String 'FullReview' 1
(Agent) N/A 0..1
(Document) N/A 0..1
(Document) N/A 0..1
(Document) N/A 0..1
(Agent) N/A 0..*
(Agent) N/A 0..*
(IPR) N/A 0..*
Random',
'Sequential',
String 'Unknown' 1
Non-negative
integer 0..1
Page 51
media
String N/A 0..1
String N/A 0..1
String N/A 0..1
String N/A 0..1
Non-negative
integer 0..1
String N/A 0..1
String N/A 0..1
Non-negative
integer 0..1
String N/A 0..1
String N/A 0..1
'FlexibleMagneti
cDisk',
'HardMagneticDi
sk',
'MagneticTapeC
atridge',
'MagneticTapeR
eel', 'Megnetic-
opticalDisk',
'PaperTape',
'PunchCard',
'SolidState',
'Other',
String 'Unknown'
String N/A 0..1
String N/A 0..1
String N/A 0..1
'ReadOnly',
'Rewriteable',
'WriteOnce',
String 'Unknown'
Page 52
agent
PRONOM 6
element implementation
UDFR requirement? type value constraints
agent ID actors: Actor_id Int N/A
agent name actors: Name_text nvarchar(50) N/A
job title actors: job_title_text nvarchar(100) N/A
organization name actors: organisation_name_text nvarchar(100) N/A
(agent types
listed as
agent type actor_types: actor_type_text nvarchar(100) records)
telephone actors: Telephone_text nvarchar(20) N/A
fax
email actors: contact_email_text nvarchar(50) N/A
developer/maintainer website actors: Website_text nvarchar(150) N/A
address actors: Address_Text nvarchar(750) N/A
country code actors: country_code_text nvarchar(4) N/A
country name Countries: country_name_text nvarchar(100) N/A
support website URL actors: support_website_text nvarchar(150) N/A
FK to actors:
agent who added record actors:source_id Int actor_id
record creation time actors:source_date Datetime N/A
record last modification time actors:last_updated_date Datetime N/A
note about provenance actors:provenance_text nvarchar(1000) N/A
text of historical event related to
agent actor_history: event_text nvarchar(1000) N/A
date of historical event related
to agent actor_history: event_date Datetime N/A
affiliated agent
record verification date
record verification status
agent who verified record
Page 53
agent
record status
informative note
Page 54
agent
GDFR
cardinality implementation type value constraints cardinality
Base: SystemID long N/A 1
Agent: formatted as: surname, given
PersonalName String name(s), generation identifier 0..1
Agent: Title String N/A 0..1
Agent:
CorporateName String N/A 0..1
'CentralGovernmentOrganization',
'Charity', 'CommercialOrganization',
'EducationalInstitution',
'GovernmentAgency', 'Individual',
'LocalGovernmentOrganization',
'NonProfitOrganization',
'ProfessionalAssociation',
Agent: 'StandardsBody', 'TradeAssociation',
AgentType String 'Other', 'Unknown' 1
Agent: ITU-T E.164-formatted telephone
Telephone String number 0..*
ITU-T E.164-formatted telephone
Agent: Fax String number 0..*
Agent: RFC 2821-formatted SMTP Internet
EmailAddress String email address 0..*
Agent: WebSite String RFC 3986 URI 0..*
Agent: expressed in terms of the UPU S42
PostalAddress String data model 0..1
Agent: Country String ISO 3166-1 alpha-2 country codes 0..1
Base:
CreationDate DateTime ISO 8601 1
Base:
ModificationDate DateTime ISO 8601 0..1
Base:
Provenance String 0..1
Agent:
HasAffiliation (Agent) N/A 0..*
Base:
VerificationDate DateTime ISO 8601 0..1
Base:
VerificationStatu
s String 'NoReview', 'FullReview' 1
Base: VerifiedBy (Agent) N/A 0..1
Page 55
agent
Base: Active', 'Deprecated', 'Deleted',
AdminStatus String 'Provisional' 1
Base:Note String N/A 0..1
Page 56
documents
PRONOM 6 GDFR
element implementation type value constraints cardinality implementation
documents:
document ID document_id Int N/A Base: SystemID
alternative names Product: Alias
(The document_types is
more like document
document type intent) Document: Type
bibliographic display text documents: display_text nvarchar(1000) N/A
FK to actors:
agent who added record documents: source_id Int actor_id
record creation time documents: source_date Datetime N/A Base:CreationDate
record last modification documents: Base:ModificationD
time last_updated_date Datetime N/A ate
documents:
note about provenance provenance_text nvarchar(1000) N/A Base: Provenance
documents:
publication date publication_date Datetime N/A Document: Date
(document types
document_types: listed as
document intent document_type_text nvarchar(50) records) Document: Intent
Document:
document language Language
document title documents: title_text nvarchar(150) N/A Document: Title
availability:
availability description availability_text nvarchar(50) N/A Holding: Availability
additional information
about document documents:
availability availability_text nvarchar(800) N/A
informative note about the documents:
document document_note_text nvarchar(800) N/A
IPR related to document document_ipr: ipr_id Int FK to ipr: ipr_id Product: Restricts
document_publishers: FK to actors: Document:
document publishers publisher_id Int actor_id 0..* HasPublisher
document_authors: FK to actors:
document authors author_id Int actor_id 0..*
value of external identifier document_identifiers:
for document identifier_text nvarchar(150) N/A 0..* Identifier: Value
(document
identifier types
type of external identifier document_identifier_type listed as
for document s: identifier_type_text nvarchar(50) records) Identifier: Type
further information about
external identifier for a document_identifiers:
document note_text nvarchar(1000) N/A
agent who added record
on external identifier for document_identifiers: FK to actors:
document source_id Int actor_id
Page 57
documents
date when record on
external identifier for document_identifiers:
document was created source_date Datetime N/A
date when record on
external identifier for
document was last document_identifiers:
modified last_updated_date Datetime N/A
provenance note about
record on external document_identifiers:
identifier for document provenance_text nvarchar(1000) N/A
document_relationships:
source_id and FK to
document_relationships: documents:
related document target_id Int document_id 0..*
relationship type for a document_relationship_t
related document ypes: type_name_text nvarchar(50) N/A
document_relationship_t
inverse relationship type ypes:
for a related document inverse_type_name_text nvarchar(50) N/A
note about relationship for document_relationships:
a related document note_text nvarchar(1000) N/A
file that instantiates this Document:
document HasInstantiation
Base:
record verification date VerificationDate
Base:
record verification status VerificationStatus
agent who verified record Base: VerifiedBy
record status Base: AdminStatus
Page 58
documents
type value constraints cardinality
long N/A 1
String N/A 0..*
'Article', 'Codebook', 'Correspondence',
'DataDictionary', 'Manual', 'Dissertation',
'Memorandum', 'Note', 'Paper', 'Presentation',
'Recommendation', 'Report', 'Specification',
String 'Standard', 'Thesis', 'WebSite', 'Other', 'Unknown' 1
DateTime ISO 8601 1
DateTime ISO 8601 0..1
String N/A 0..1
DateTime N/A 0..1
Authoritative', 'Informative', 'Speculative', 'Other',
String 'Unknown' 1
String ISO 639-2 alpha-3 language code 0..*
String N/A 1
String Public', 'Private', 'Unknown', 'Restricted' 1
(IPR) N/A 0..*
(Agent) N/A 0..*
String N/A 0..*
'4CC', 'AFNOR', 'AIIM', 'ANSI', 'ARK', 'BCP', 'BSI',
'CallNumber', 'CCITT', 'DDC', 'DOI', 'ECMA',
'FDD', 'FIPS', 'GFID_URI', 'GUID', 'Handle', 'I3A',
'IEC', 'ISBN', 'ISO', 'ISSN', 'ITU', 'JEITA', 'LCC',
'LCCN', 'NISO', 'OCLC', 'PII', 'P/N', 'PUID_URI',
'PURL', 'RFC', 'S/N', 'Shelfmark', 'SICI', 'SMPTE',
'STD', 'TOM', 'URI', 'URL', 'URN', 'UUID', 'Other',
String 'Unknown' 0..*
Page 59
documents
(File) N/A 0..*
DateTime ISO 8601 0..1
String 'NoReview', 'FullReview' 1
(Agent) N/A 0..1
String Active', 'Deprecated', 'Deleted', 'Provisional' 1
Page 60
file
PRONOM 6 GDFR
element implementation
UDFR requirement? type value constraints cardinality implementation
reference_files:
file ID reference_file_id Int N/A Base: SystemID
reference_files:
file name file_name_text nvarchar(100) N/A Product: Name
file name aliases Product: Alias
Product:
file description Description
Product:
file release date ReleaseDate
Product:
file withdrawal date WithdrawalDate
file version Product: Version
message digest type File: Digest
TypedNotation:
message digest value Value
Holding:
holding availability Availability
Holding:
holding identifier Identifier
file purpose File: Purpose
file type File: Type
file contents File: Value
FK to
reference_files: file_formats:
file format file_format_id Int file_format_id File: IsOfFormat
Base:
record verification date VerificationDate
Base:
VerificationStatu
record verification status s
agent who verified
record Base: VerifiedBy
Page 61
file
Base:
record status AdminStatus
agent who created reference_files: FK to actors:
record source_id Int actor_id
reference_files: Base:CreationD
record creation date source_date Datetime N/A ate
record last modification reference_files: Base:Modificatio
date last_updated_date Datetime N/A nDate
reference_files:
informative note note_text nvarchar(1000) N/A Base:Note
reference_files: Base:
note about provenance provenance_text nvarchar(1000) N/A Provenance
reference_file_docu FK to Product:
documentation related mentation: documents: HasDocumentati
to file document_id Int document_id on
reference_file_ipr: Product:
IPR related to the file ipr_id Int FK to ipr: ipr_id Restricts
reference_file_relati
onships: source_id
and FK to
reference_file_relati documents:
related file onships: target_id Int document_id 0..*
reference_file_relati
relationship type for a onship_types:
related file type_name_text nvarchar(50) N/A
reference_file_relati
onship_types:
inverse relationship type inverse_type_name
for a related file _text nvarchar(50) N/A
note about relationship reference_file_relati
for a related file onships: note_text nvarchar(1000) N/A
value of external reference_file_identi
identifier for file fiers: identifier_text nvarchar(150) N/A 0..* Identifier: Value
Page 62
file
(document
reference_file_identi identifier types
type of external identifier fier_types: listed as
for file identifier_type_text nvarchar(50) records) Identifier: Type
further information about
external identifier for a reference_file_identi
file fiers: note_text nvarchar(1000) N/A
agent who added record
on external identifier for reference_file_identi FK to actors:
file fiers: source_id Int actor_id
date when record on
external identifier for file reference_file_identi
was created fiers: source_date Datetime N/A
date when record on reference_file_identi
external identifier for file fiers:
was last modified last_updated_date Datetime N/A
provenance note about reference_file_identi
record on external fiers:
identifier for file provenance_text nvarchar(1000) N/A
Page 63
file
type value constraints cardinality
long N/A 1
String N/A 1
String N/A 0..*
String N/A 0..1
DateTime ISO 8601 0..1
DateTime ISO 8601 0..1
String N/A 0..1
CRC-32',
'HAVAL', 'MD5',
'SHA-1', 'SHA-
224', 'SHA-256',
'SHA-384', 'SHA-
512', 'TIGER',
'WHIRLPOOL' 0..*
String N/A 0..*
Public', 'Private',
'Unknown',
String 'Restricted' 1
(see
Identifier_GDFR
(Identifier) sheet) 0..*
Document',
'Image',
'Reference',
'Software',
'Unknown',
String 'Other' 1
'Data',
'Executable',
'ObjectCode',
'SourceCode',
'Other',
String 'Unknown' 1
ByteStream N/A 1
(Format) N/A 0..*
DateTime ISO 8601 0..1
'NoReview',
String 'FullReview' 1
(Agent) N/A 0..1
Page 64
file
Active',
'Deprecated',
'Deleted',
String 'Provisional' 1
DateTime ISO 8601 1
DateTime ISO 8601 0..1
String N/A 0..1
String N/A 0..1
(Document) N/A 0..1
(IPR) N/A 0..*
String N/A 0..*
Page 65
file
'4CC', 'AFNOR',
'AIIM', 'ANSI',
'ARK', 'BCP',
'BSI',
'CallNumber',
'CCITT', 'DDC',
'DOI', 'ECMA',
'FDD', 'FIPS',
'GFID_URI',
'GUID', 'Handle',
'I3A', 'IEC',
'ISBN', 'ISO',
'ISSN', 'ITU',
'JEITA', 'LCC',
'LCCN', 'NISO',
'OCLC', 'PII',
'P/N',
'PUID_URI',
'PURL', 'RFC',
'S/N',
'Shelfmark',
'SICI', 'SMPTE',
'STD', 'TOM',
'URI', 'URL',
'URN', 'UUID',
'Other',
String 'Unknown' 0..*
Page 66
IPR
PRONOM 6 GDFR
element implementation
UDFR requirement? type value constraints cardinality implementation
IPR ID ipr: ipr_id Int N/A Base: SystemID
ipr_types: (IPR types listed
type of IPR ipr_type_text nvarchar(50) in this column) IPR: Type
date of IPR ipr: ipr_date Datetime N/A
date IPR
became IPR:
effective EffectiveDate
IPR:
date IPR expires ExpirationDate
PRONOM
country authority
file + 'European
ipr_jurisdictions: Union' +
IPR jurisdiction jurisdiction_text nvarchar(100) 'worldwide' IPR: Jurisdiction
ipr:
license details license_details_text nvarchar(1000) N/A License
informative note ipr: note_text nvarchar(1000) N/A Base:Note
agent who FK to actors:
added record ipr: source_id Int actor_id
record creation Base:CreationD
time ipr: source_date Datetime N/A ate
record last ipr: Base:Modificatio
modification time last_updated_date Datetime N/A nDate
note about Base:
provenance ipr: provenance_text nvarchar(1000) N/A Provenance
FK to actors:
IPR owners ipr_owners: owner_id Int actor_id IPR: HeldBy
value of external ipr_id_identifiers:
identifier for IPR identifier_text Int N/A Identifier: Value
Page 67
IPR
type of external ipr_identifier_types:
identifier for IPR identifier_type_text nvarchar(50) N/A Identifier: Type
informative note
about external ipr_identifier_types:
identifier for IPR note_text nvarchar(1000) N/A
agent who ipr_identifier_types: FK to actors:
added record source_id Int actor_id
record creation ipr_identifier_types:
time source_date Datetime N/A
record last ipr_identifier_types:
modification time last_updated_date Datetime N/A
note about ipr_identifier_types:
provenance provenance_text nvarchar(1000) N/A
document_ipr:
document_id;
encoding_ipr:
encoding_id;
compression_ipr:
compression_id;
format_ipr:
file_format_id;
reference_file_ipr:
reference_file_id;
software_ipr:
software_id;
product hardware_ipr:
restricted by IPR hardware_id; IPR: Restricts
Base:
record status AdminStatus
record Base:
verification date VerificationDate
Page 68
IPR
record Base:
verification VerificationStatu
status s
agent who
verified record Base: VerifiedBy
Page 69
IPR
type value constraints cardinality
long N/A 1
'Copyright',
'Patent',
'TradeSecret',
'Other' 1
DateTime N/A 0..1
DateTime N/A 0..1
EU', 'Worldwide',
String 'Unknown' 1
String N/A 0..1
String N/A 0..1
DateTime ISO 8601 1
DateTime ISO 8601 0..1
String 0..1
(Agent) (see agent sheet) 0..*
String N/A 0..*
Page 70
IPR
'4CC', 'AFNOR',
'AIIM', 'ANSI',
'ARK', 'BCP', 'BSI',
'CallNumber',
'CCITT', 'DDC',
'DOI', 'ECMA',
'FDD', 'FIPS',
'GFID_URI',
'GUID', 'Handle',
'I3A', 'IEC', 'ISBN',
'ISO', 'ISSN', 'ITU',
'JEITA', 'LCC',
'LCCN', 'NISO',
'OCLC', 'PII', 'P/N',
'PUID_URI',
'PURL', 'RFC',
'S/N', 'Shelfmark',
'SICI', 'SMPTE',
'STD', 'TOM', 'URI',
'URL', 'URN',
'UUID', 'Other',
String 'Unknown' 0..*
(Product -
format, software,
media,
hardware, file,
typedNotation,
Document) 0..*
Active',
'Deprecated',
'Deleted',
String 'Provisional' 1
DateTime ISO 8601 0..1
Page 71
IPR
'NoReview',
String 'FullReview' 1
(Agent) N/A 0..1
Page 72
grammar
PRONOM 6 GDFR
element implementation
UDFR requirement? type value constraints cardinality implementation
Format:
format grammar Grammar;
type Grammar: Type
grammar id Base: SystemID
grammar name Product: Name
grammar name
aliases Product: Alias
grammar version Product: Version
grammar Product:
description Description
grammar Product:
release date ReleaseDate
grammar Product:
withdrawn date WithdrawalDate
Base:
record status AdminStatus
record creation Base:CreationD
date ate
record last
modification Base:Modificatio
date nDate
informative note Base:Note
Base:
provenance note Provenance
record Base:
verification date VerificationDate
record Base:
verification VerificationStatu
status s
agent who
verified record Base: VerifiedBy
Product:
grammar HasDocumentati
documentation on
agent who
created Product:
grammar HasCreator
agent who
maintains Product:
grammar HasMaintainer
Product:
related IPR Restricts
Page 73
grammar
type value constraints cardinality
'BNF', 'BSDL',
'DFDL', 'DTD-
SGML', 'ABNF',
'DTD-XML',
'EAST', 'RELAX',
'Schema',
String 'Schematron' 0..*
long N/A 1
String N/A 1
String N/A 0..*
String N/A 0..1
String N/A 0..1
DateTime ISO 8601 0..1
DateTime ISO 8601 0..1
Active',
'Deprecated',
'Deleted',
String 'Provisional' 1
DateTime ISO 8601 1
DateTime ISO 8601 0..1
String N/A 0..1
String N/A 0..1
DateTime ISO 8601 0..1
'NoReview',
String 'FullReview' 1
(Agent) N/A 0..1
(Document) N/A 0..1
(Agent) N/A 0..*
(Agent) N/A 0..*
(IPR) N/A 0..*
Page 74
assessment
PRONOM 6 GDFR
element implementation
UDFR requirement? type value constraints cardinality implementation
Assessment:
AssessessForm
format assessed at
Assessment:
assessment type Type
assessment TypedNotation:
content Value
assessment id Base: SystemID
assessment
name Product: Name
assessment
name aliases Product: Alias
assessment
version Product: Version
assessment Product:
description Description
assessment Product:
release date ReleaseDate
assessment Product:
withdrawn date WithdrawalDate
Base:
record status AdminStatus
record creation Base:CreationD
date ate
record last
modification Base:Modificatio
date nDate
informative note Base:Note
Base:
provenance note Provenance
record Base:
verification date VerificationDate
record Base:
verification VerificationStatu
status s
agent who
verified record Base: VerifiedBy
Product:
assessment HasDocumentati
documentation on
agent who
created Product:
assessment HasCreator
agent who
maintains Product:
assessment HasMaintainer
Product:
related IPR Restricts
Page 75
assessment
type value constraints cardinality
(Format) N/A 1
String FDD' 1
String N/A 1
long N/A 1
String N/A 1
String N/A 0..*
String N/A 0..1
String N/A 0..1
DateTime ISO 8601 0..1
DateTime ISO 8601 0..1
Active',
'Deprecated',
'Deleted',
String 'Provisional' 1
DateTime ISO 8601 1
DateTime ISO 8601 0..1
String N/A 0..1
String N/A 0..1
DateTime ISO 8601 0..1
'NoReview',
String 'FullReview' 1
(Agent) N/A 0..1
(Document) N/A 0..1
(Agent) N/A 0..*
(Agent) N/A 0..*
(IPR) N/A 0..*
Page 76
migration pathways
PRONOM 6 GDFR
element implementation
UDFR requirement? type value constraints cardinality implementation
migration_pathw
ay:
migration migration_pathw
pathway id ay_id Int N/A
migration_pathw
ay: FK to
orig_file_format_ file_formats:
source format id Int file_format_id
migration_pathw
ay: FK to
target_file_forma file_formats:
target format t_id Int file_format_id
migration_pathw
ay:
migration_tool_i FK to tools:
migration tool id d Int tool_id
migration_pathw
ay_types:
migration migration_pathw
pathway type ay_type nvarchar(255) N/A
user who
approved migration_pathw
migration ay_approval: FK to actors:
pathway approved_by Int Actor_id
date migration migration_pathw
pathway was ay_approval:
approved Approved_date Date N/A
migration_pathw
is this the latest ay_approval:
pathway? Current_pathway Bit
migration_pathw
ay_property_veri
migration source fication: FK to
instance orig_instance_pr instance_propert
property operty_id Int y: property_id
migration_pathw
ay_property_veri
migration target fication: FK to
instance target_instance_ instance_propert
property property_id Int y: property_id
migration_pathw
is the property ay_property_veri
invariant? fication: invariant float ?
migration_pathw
property ay_property_veri
migration notes fication: notes nvarchar(255) N/A
user who
approved migration_pathw
migration ay_property_app
pathway for a roval: FK to actors:
property Approved_by Int Actor_id
Page 77
migration pathways
date migration migration_pathw
pathway for a ay_property_app
property was roval:
approved Approved_date Date N/A
order to use
tools for a migration_pathw
migration ay_tools:
pathway tool_order ? ?
Page 78
migration pathways
type value constraints cardinality
Page 79
migration pathways
Page 80