Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In addition to the constraints above, particular database identifier types have additional constraints. Maximum lengths were initially derived from the MySQL manual. While some of these restrictions are not mandatory, following them to the letter will help ensure database portability.

Database

maxlength:

...

Table

...

255 characters

Identifier Type

Max length (characters)

Example

database/schema

64

mifos

table

64

customer_transactions

...

column

...

64

...


...

transaction_date

...

index

...

64

...


...

cust_hierarchy_idx

...

view

...

64

...


...

customer_loan_view

...

alias

...

255

...