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