harvested resources
sign in

Media Format File Definition for Hone et al Pterosaur Data

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

Fields (31)

1. MediaID (278872) → to_media_pk
(must be unique) (must not be empty)
2. TaxonID (278873) → to_media_nodes_fk
(must not be empty)
3. Type (278874) → to_media_type
(must not be empty)
4. Subtype (278875) → to_media_type
5. Format (278876) → to_media_subtype
6. Subject (278877) → to_section
7. Title (278878) → to_media_name
8. Description (278879) → to_media_description
9. AccessURI (278880) → to_media_source_url
10. ThumbnailURL (278881) → to_ignored
11. FurtherInformationURL (278882) → to_media_source_page_url
12. DerivedFrom (278883) → to_ignored
13. CreateDate (278884) → to_ignored
14. Modified (278885) → to_ignored
15. Language (278886) → to_media_language
16. Rating (278887) → to_ignored
17. Audience (278888) → to_ignored
18. License (278889) → to_media_license
19. Rights (278890) → to_ignored
20. Owner (278891) → to_media_owner
21. BibliographicCitation (278892) → to_bibliographic_citation
22. Publisher (278893) → to_ignored
23. Contributor (278894) → to_ignored
24. Creator (278895) → to_ignored
25. AgentID (278896) → to_media_attributions_fk
26. LocationCreated (278897) → to_media_description
27. GenericLocation (278898) → to_ignored
28. Latitude (278899) → to_ignored
29. Longitude (278900) → to_ignored
30. Altitude (278901) → to_ignored
31. ReferenceID (278902) → to_media_ref_fks (|;)