...
These are guidelines for using the Local Schemas on the Cornell LDP (Library Data Platform) reporting database. All users have access to create and delete tables on LDP local schemas, so it is important to be careful to follow the guidelines for using them.
Schema | Usage Guidelines | Where Schemas Implemented |
---|
local | The local schema is available to all reporting users. Please precede any tables you create in this schema with your netid, as in netid_mytable. | LDP Test and LDP Production |
local_automation | This schema is |
for use library automation team.Automation Team. | LDP Production only |
local_core | This schema is |
for use by the library reporting team.used by the Reporting Team. | LDP Test and LDP Production |
local_digpres | This schema is used by the HathiTrust team. | LDP Production only |
local_hathitrust | This schema is |
for use used by the HathiTrust team. | LDP Production only |
local_protected | This schema is used to store tables capturing daily updates that cannot be deleted | LDP Test and LDP Production |
local_statistics | This schema is |
for use Library the Assessment and Planning |
for annual statisticsteam. | LDP Production only |