9.2. Database structure

You can view the database structure in several ways.

Note that your administrator only has to tell CRATE about the database(s) and the way they’re linked, not about all tables in the database(s) – CRATE works out the rest by reading the database(s) directly.

9.2.1. Online in paginated tabular format

This shows the structure for all databases that CRATE knows about, in a paginated table. The columns are:

  • Schema

  • Table

  • Column

  • Comment

  • Data type (e.g. VARCHAR(32), INT(11), DATETIME)

  • May be NULL?

  • Indexed?

  • FULLTEXT index?

9.2.2. Online in single-page tabular format

This is like the paginated version, but all on one page.

Warning

May be slow for large databases.

9.2.3. Online in collapsible tree form

This shows a list of table names; each one is associated with a table of details (as above) that can be expanded and collapsed.

Warning

May be slow for large databases.

9.2.4. Download in tab-separated values (TSV) format

The same information as for the HTML view described above, but as a TSV file.

9.2.5. Download in Excel (.XLSX) format

The same information as for the HTML view described above, but as a single-sheet Office Open XML (Excel .XLSX) file.

9.2.6. Help on local database structure

This simply shows a page defined by your administrator.

(See DATABASE_HELP_HTML_FILENAME in Web config file.)