Below are some must have’s or standard fields for a table
- id
- uuid – varchar(36). use uuid() function
- created_at
- created_by
- updated_at
- updated_by
- deleted_at
- deleted_by
example of uuid() generated value = 27764328539095040
example of uuid_short() generated value = 27764328539095040