Table Structure and Index

When we design a table we must determine the size of each field, for tbl_so_sales_details here is the size ;

1. sales_number : text : 15
2. revision_number : text : 3
3. sales_status : text : 15
4. customer_code_orig : text : 15
5. cco_name : text : 100
6. reference : text : 255

Also do not forget to make the index to speed up the search process, to avoid double data. as shown below

this table has 2 (two) field for primary key, sales_number and revision_number. if there is a process that insert row data for manipulation process, sales_number  and revision_number same data with another row will be rejected.

give the name of the table is tbl_so_sales_details.
Now you have table for data storage.