Does anybody know of a relational database schema that can be used to store XBRL data? I am looking to store financial report data (balance sheet, income statement and profit/loss statement data) along with other company data (Name, Stock Ticker, etc.) in MySQL.
closed as not constructive by Mark Storey-Smith, Paul White, dezso, RolandoMySQLDBA, JNK♦ Feb 22 at 13:46
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.
Wouldn't any db supporting the XML sections of SQL2003 work? If you are trying to store the document as reported, I think you'd want to store as an XML file, not breaking it apart.
So I think if you are storing these as records of documents, your schema is not going to be based on XBRL but rather based on simple document management.