Arelle's XBRL US Public Database Schema

On Arelle's Database documentation page, three general approaches are suggested for bulk loading of XBRL filings into databases:

At a high level, you can think of the Extracted XBRL Instance Document as a catalogue of:

• All the facts that appear in Tilray's 10-Q financial report for September 30, 2020, and
• All the contexts to which each one of these facts should be fixed

GIVE SOME BACKGROUND ON THE XBRL US PUBLIC DATABASE SCHEMA HERE

From this point on in the tutorial, the assumption is that you have successfully installed the Arelle XBRL package and the PostgreSQL relational database software.

And, in PostgreSQL, I assume you have created a new, empty database called "arelle".

In the next section where I discuss the installation of the Arelle XBRL-US public database schema, I will show command line examples from my Linux installation. For our purposes, I assume the software organization of the Arelle package is similar enough between the Windows and Linux platforms that Windows users should be able to use my examples to follow along.

When I installed Arelle, I copied the downloaded zip file to my /home/<my_user_name>/arelle base directory, and unzipped it from there. If you unzipped Arelle in a different base directory when you installed it, you will need to look for the Arelle files we'll use below under your own base directory.

ls -ltr /home/<my_user_name>/arelle/plugin/xbrlDB/sql/public/xbrlPublicPostgresDB.ddl

-rw-r--r-- 1 <my_user_name> <my_user_name> 963416 Apr 13 2016 /home/<my_user_name>/arelle/plugin/xbrlDB/sql/public/xbrlPublicPostgresDB.ddl

© Copyright 2021, Crosskeys Technologies