|
id
|
int(11)
|
|
|
|
|
name
|
varchar(255)
|
|
|
|
|
contact_person
|
varchar(150)
|
|
|
|
|
phone
|
varchar(50)
|
|
|
|
|
email
|
varchar(150)
|
|
|
|
|
address
|
varchar(255)
|
|
|
|
|
tax_number
|
varchar(100)
|
|
|
|
|
notes
|
text
|
|
|
|
|
is_active
|
tinyint(1)
|
|
|
1
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
rating
|
decimal(4,2)
|
|
|
|
|
eval_count
|
int(11)
|
|
|
0
|
|
category
|
enum
|
-- |
|
approved
|
|
bank_name
|
varchar(150)
|
|
|
|
|
bank_account
|
varchar(100)
|
|
|
|
|
payment_terms
|
varchar(100)
|
|
|
|