This page really needs improving. Please see the page comments for suggestions of what to include, then remove this template when you're done.
This module will create one table per instance, but you may create as many instances you need. The records can be linked to other tables and all resources in the course, if you allow autolink in a name field, but you cannot build a SQL query.
The table is not created in the SQL database, it is just stored there in lines of other SQL tables (mdl_data*).