search

gtfierro / walkthedinosaur

Batch SQL Job Scheduler/Emailer
7 stars 2 forks source link

Linking tables #7

Open dalek2point3 opened 10 years ago

dalek2point3 commented 10 years ago

The data description document describes many "linking tables" that help link inventors to locations, and patents to inventors and so on. Would it be possible to provide these data on the "common downloads" page, or is there some other way to link data at the moment?

gtfierro commented 10 years ago

The linking tables are really just a shortcut for connecting the primary/foreign keys through the tables that are available on http://rosencrantz.berkeley.edu/batchsql/downloads. Linking rawassignee.assignee_id to assignee.id is the pattern that the linking tables follow.

I refrained from placing them online because the tables just contain a mapping of keys, and no information outside of that. It can be misleading for users to download a file named location_assignee and have it only contain UUID strings.