This page really needs improving. Please see the page comments for suggestions of what to include, then remove this template when you're done.
The database activity module allows the teacher and/or students to build, display and search a bank of record entries about any conceivable topic. The format and structure of these entries can be almost unlimited, including images, files, URLs, numbers and text amongst other things.
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*).