Workshop Aplication Using VB.Net and MySQL (Part 1)

First step to create project Workshop Aplication Using VB.Net and MySQL is create a database and tables in MySQL with design like below:

Database Name : WORKSHOP
Tables :
1. Customer
  

Fields	Type	Size	Note
customer_id customer_name sex birthday	varchar varchar varchar date	10 25 10 default	Pimary

2. Goods_Service

Fields	Type	Size	Note
item_code item_name price	varchar varchar float	10 25 default	Pimary

3. Service_header

Fields	Type	Size	Note
service_number date customer_id total	varchar date varchar float	10 default 10 default	Pimary

4. Service_detail

Fields	Type	Size	Note
id service_number item_code price qty sub_total	integer varchar varchar float float float	default 10 10 default default default	Pimary, Auto