Database Schema

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

vishwasrathi
Posts: 2
Joined: Wed Aug 28, 2019 11:20 am

Database Schema

Post by vishwasrathi » Wed Aug 28, 2019 11:27 am

Hi,

Is it possible to get a schema file or sql scripts with which I can create the tables for Global and EP databases? Basically all the TLS tables and REG tables, just the table definition without any data.

I have got the schema diagrams from the catalog files and those are very helpful. I am looking to create the empty databases so that I can write my scripts in sql management studio and use sql addins which will provide additional features. I will then copy my scripts and then run them on patstat online databases.

Obviously I can do this myself by using the schema PDF but that will involve a lot of typing. If anyone has already done that or if the sql scripts are available then that will be awesome.

Thanks


EPO / PATSTAT Support
Posts: 227
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: Database Schema

Post by EPO / PATSTAT Support » Thu Aug 29, 2019 7:57 am

Hi,

Here are the scripts to create the table:
PATSTAT_CreateScripts_2019Spring.zip
(57.29 KiB) Downloaded 225 times
They are also part of each delivery of the data.

Best regards,
Martin EPO/PATSTAT


vishwasrathi
Posts: 2
Joined: Wed Aug 28, 2019 11:20 am

Re: Database Schema

Post by vishwasrathi » Thu Aug 29, 2019 3:59 pm

Fabulous.

Thanks Martin,


Post Reply