01. Database
01.01. Data Sheet
01.01.01. Naming best looks in the word, avoiding the use of database keywords.
01.01.02. Named will be uppercase letters.
01.01.03. English word singular name. Example: Factory.
01.01.04. English word abbreviation name. Example: DEPT.
01.01.05. Use the underline between the English words, and each word is singular. Example: Barcode_Station.
01.01.06. Data sheet is used to store historical data, named History. Example: Barcode_history.
01.01.07. The data sheet is used to store log data, named LOG end. Example: Enduser_log.
01.01.08. Data sheet is used to store category information, named TYPE. Example: program_type.
01.02. Data table field
01.02.01. Naming best looks in the word, avoiding the use of database keywords.
01.02.02. English word singular name. Example: Mail.
01.02.03. English Word abbreviation name. Example: dept_id.
Underlined lines between English words, and each word is singular. Example: user_name.
01.02.05. The field is used to store the flow line, named the end of the ID. Example: Barcode_ID.
01.02.06. Field is used to store code, named NO end. Example: Barcode_no.
01.02.07. Field is used to store the date, named DATE end. Example: create_date.
01.02.08. The field is used to store the quantity, named QTY end. Example: Plan_qty.
01.02.09. Field is used to store classes, named Type end. Example: station_type.
01.02.10. The field is used to store the name, named Name end. Example: Enduser_name.
01.02.11. Field is used to store descriptions, named DESC end. Example: station_desc.
01.02.12. Field is used to store code, named CODE end. Example: Error_code.
01.02.13. Field is used to store the flag, named FLAG. Example: debug_flag.
01.02.14. The field is used to store English names or descriptions, named EN end. Example user_name_en or code_desc_en.
