Which default fields should a table have in an ERP project?

1. Several fields are required PKID (auto-increment), Business ID (self-controlled can be equal to PKID), Operator, company ID (BranchNo ),

CreateDate, OperateDate, IsActive, department ID)

(1) Business ID (which can be equal to PKID under self-control). For example, you must control the IP address of a sub-Table. Otherwise, data import and export will be very troublesome.

(2) Operator and other fields should be unified by a company: The company will sort out all the projects, and if the names are different, it will be miserable (experience !)

(3) For the OperateDate field, operations on this table must be changed. For example, you have created a pick-up details. The pick-up details are associated with the order. In this case, you must change the OperateDate field in addition to changing the pick-up mark in the order.

(4) data cannot be deleted. Deletion can only mark IsActive. This is a good habit. Because this can be well documented.

(5) CreateDate is also necessary.

Please participate in the discussion! Thank you.