media licensing

[dustymc]

Coming from

https://github.com/ArctosDB/internal/issues/363
#7348

Should we require media licensing, and if not can we document what a NULL license means?

FWIW I believe that nearly everyone will view unlicensed media as free for the taking, no matter what we might decide or hope for.

The code table is https://arctos.database.museum/info/ctDocumentation.cfm?table=ctmedia_license

(Not entirely related, I have trouble understanding how many of those are 'licenses' - eg https://www.uaf.edu/museum/collections/fineart/collection/image-use-requests/ tells me how to ask for media, but if I'm coming from media I've already found that so ??????)

Current status:

select 
    coalesce(display,'NO LICENSE!!') display,
    count(*) c
from
    media
    left outer join ctmedia_license on media.media_license_id=ctmedia_license.media_license_id
group by display
order by count(*) desc;
            display            |   c    
-------------------------------+--------
 NO LICENSE!!                  | 531679
 CC BY-NC-ND                   | 140005
 CC BY-NC-SA                   | 115528
 CC BY-NC                      | 113257
 CC BY                         |  70309
 Arctos Data Ownership and Use |  53276
 UCM Image Reproduction Policy |  12623
 DMNS                          |   7424
 JSNM Acceptable Use           |   7144
 CC0                           |   5910
 UAMN Fine Arts Image Use      |   4343
 CC BY-SA                      |    592
 Copyright Restricted          |    579
 CC BY-ND                      |      6