| Table Name |
Name |
Data Type |
Primary Key |
Unique |
Required |
Autoincrement |
Charset |
Collation |
Comment |
|
employees
|
id
|
int(10) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
|
employees
|
name
|
varchar(20)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
employees
|
lastname
|
varchar(20)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
employees
|
birthday
|
date
|
|
|
|
|
NULL
|
NULL
|
|
|
employees
|
email
|
varchar(50)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
employees
|
website
|
varchar(50)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
employees
|
credit_card
|
varchar(30)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
employees
|
payment_method
|
enum('PayPal','Credit Card')
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
employees
|
country_code
|
char(3)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
employees
|
city_id
|
int(11)
|
|
|
|
|
NULL
|
NULL
|
|