| id |
varchar(36)
|
utf8mb4_general_ci
|
|
|
| name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| email |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| phone |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| address |
text
|
utf8mb4_general_ci
|
|
|
| rating |
decimal(3,2)
|
|
|
|
| products_count |
int(11)
|
|
|
|
| total_orders |
int(11)
|
|
|
|
| status |
enum('active', 'inactive')
|
utf8mb4_general_ci
|
|
|
| category |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| display_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| trn |
varchar(15)
|
utf8mb4_general_ci
|
|
|
| work_phone |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| mobile |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| address_line_1 |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| bank_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| account_number |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| iban |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| swift_code |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| branch |
varchar(255)
|
utf8mb4_general_ci
|
|
|