harvested resources
sign in

Media Format File Definition for Fairbairn 2013

File Type: csv
Get From: /app/public/data/fairbairn_fairb2/media.txt
Actual File Location: /app/public/data/fairbairn_fairb2/media.txt
Field Seperator: \t (tab)
Line Seperator: \n (newline)
UTF8 characters allowed: No.

Fields (31)

1. MediaID (287394) → to_media_pk
(must be unique) (must not be empty)
2. TaxonID (287395) → to_media_nodes_fk
(must not be empty)
3. Type (287396) → to_media_type
(must not be empty)
4. Subtype (287397) → to_media_type
5. Format (287398) → to_media_subtype
6. Subject (287399) → to_section
7. Title (287400) → to_media_name
8. Description (287401) → to_media_description
9. AccessURI (287402) → to_media_source_url
10. ThumbnailURL (287403) → to_ignored
11. FurtherInformationURL (287404) → to_media_source_page_url
12. DerivedFrom (287405) → to_ignored
13. CreateDate (287406) → to_ignored
14. Modified (287407) → to_ignored
15. Language (287408) → to_media_language
16. Rating (287409) → to_ignored
17. Audience (287410) → to_ignored
18. License (287411) → to_media_license
19. Rights (287412) → to_ignored
20. Owner (287413) → to_media_owner
21. BibliographicCitation (287414) → to_bibliographic_citation
22. Publisher (287415) → to_ignored
23. Contributor (287416) → to_ignored
24. Creator (287417) → to_ignored
25. AgentID (287418) → to_media_attributions_fk
26. LocationCreated (287419) → to_media_description
27. GenericLocation (287420) → to_ignored
28. Latitude (287421) → to_ignored
29. Longitude (287422) → to_ignored
30. Altitude (287423) → to_ignored
31. ReferenceID (287424) → to_media_ref_fks (|;)