Essential Database Design: Five Fields Every Table Must Have
Essential Fields Be it relational or not, every table should have these 5 fields: created_at (default now()) updated_at (default now()) deleted_at (default null) created_by (not null) updated_by (not null) Just to be clear, every table should have these 5 fields and not must. Adding these fields have other side-effects such as bloat, performance and disk size. But, if you’re having these problems, i hope you’re profitable. Why should you include this fields ?...