| id |
int(10)
|
|
|
|
| name |
varchar(190)
|
utf8mb4_general_ci
|
|
|
| vat_number |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| tax_code |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| email |
varchar(190)
|
utf8mb4_general_ci
|
|
|
| phone |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| website |
varchar(190)
|
utf8mb4_general_ci
|
|
|
| ftp_host |
varchar(190)
|
utf8mb4_general_ci
|
|
|
| ftp_port |
int(11)
|
|
|
|
| ftp_user |
varchar(190)
|
utf8mb4_general_ci
|
|
|
| ftp_pass |
varchar(190)
|
utf8mb4_general_ci
|
|
|
| ftp_path |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| ftp_ssl |
tinyint(1)
|
|
|
|
| ftp_mode |
enum('passive', 'active')
|
utf8mb4_general_ci
|
|
|
| address |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| city |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| province |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| zip |
varchar(15)
|
utf8mb4_general_ci
|
|
|
| country |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| notes |
text
|
utf8mb4_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
