The attached spreadsheet lists all the tables and columns in Biotics 5, with datatype and column length. It also indicates primary key (PK) and foreign key (FK) columns. For foreign keys, columns H and I show the table and column they come from.

Only standard tables that exist in all databases are listed, no extensible tables.

If changes are made to the Biotics data structure, this spreadsheet will be updated, as will the version number of Biotics that it reflects.  If the version number in the spreadsheet is lower than your current Biotics version, that means there have been no data model changes in the interim versions.