media

Document Sample
media Powered By Docstoc
					                                                                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

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:12/5/2011
language:
pages:80