eplus

A set of database conventions used in addition to Laravel’s Eloquent database model.

Field Order

Fields are organized by field type. Fields are placed in the following order:

• id (primary key)
• char, varchar, and text
• blob, binary, and varbinary
• json
• integer, smallint, tinyint, mediumint, and bigint
• decimal, numeric, float, and double
• enums and sets
• foreign keys
• dates
• timestamps
• soft deletes

Dates

All date and time fields are named after their event and then _at. For example published_at.

The default timestamps fieldnames are created_at and updated_at. The default soft delete field name is deleted_at.

Enums and Boolean

Fields that have three or more values should use the type enum with possible values listed in alphabetical order. Fields that have only two possible values should use the type boolean and be named is_ and then their value. For example is_active or is_approved.

---