Database Limitations
Overview¶
This section explains the limitations that arise when using Enterprise Edition and Pleasanter Extensions, which are available to subscribers of the annual support service, depending on the database selected during setup (SQL Server, PostgreSQL, or MySQL).
1. Maximum Number of Columns that Can be Added with Column Extensions¶
In Community Edition, you can use 26 of each column type ("Class Column", "Numeric Value Column", "Date Column", "Description Column", "Check Column" and "Attachment Column"), for a total of 156 columns. However, you can add additional columns in the Enterprise Edition. The maximum number of columns that can be added varies depending on the database selected during setup.
| DB | Maximum number of columns that can be added in Enterprise Edition |
|---|---|
| SQL Server | Maximum of 744 columns in total across six column types (expandable up to 900 columns with the 156 columns available in Community Edition) |
| PostgreSQL | Maximum of 744 columns in total across six column types (expandable up to 900 columns with the 156 columns available in Community Edition) |
| MySQL | Maximum of 100 columns in total across six column types (expandable up to 256 columns with the 156 columns available in Community Edition) |
2. Pleasanter Extensions Limitations¶
The lineup of available Pleasanter Extensions varies depending on the database selected during setup.
| DB | Development Tools | Operations Tools |
|---|---|---|
| SQL Server | Available | Available |
| PostgreSQL | Available | Available |
| MySQL | Not available | Not available |