...
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 used by the Automation Team. | LDP Production only |
local_core | This schema is 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 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 used by the Assessment and Planning team. | LDP Production only |