| accountid |
int
|
|
|
Browse foreign values
|
| account_no |
varchar(100)
|
utf8mb3_general_ci
|
|
|
| accountname |
varchar(100)
|
utf8mb3_general_ci
|
|
|
| parentid |
int
|
|
|
|
| account_type |
varchar(200)
|
utf8mb3_general_ci
|
|
|
| industry |
varchar(200)
|
utf8mb3_general_ci
|
|
|
| annualrevenue |
decimal(25,8)
|
|
|
|
| rating |
varchar(200)
|
utf8mb3_general_ci
|
|
|
| ownership |
varchar(50)
|
utf8mb3_general_ci
|
|
|
| siccode |
varchar(50)
|
utf8mb3_general_ci
|
|
|
| tickersymbol |
varchar(30)
|
utf8mb3_general_ci
|
|
|
| phone |
varchar(30)
|
utf8mb3_general_ci
|
|
|
| otherphone |
varchar(30)
|
utf8mb3_general_ci
|
|
|
| email1 |
varchar(100)
|
utf8mb3_general_ci
|
|
|
| email2 |
varchar(100)
|
utf8mb3_general_ci
|
|
|
| website |
varchar(100)
|
utf8mb3_general_ci
|
|
|
| fax |
varchar(30)
|
utf8mb3_general_ci
|
|
|
| employees |
int
|
|
|
|
| emailoptout |
varchar(3)
|
utf8mb3_general_ci
|
|
|
| notify_owner |
varchar(3)
|
utf8mb3_general_ci
|
|
|
| isconvertedfromlead |
varchar(3)
|
utf8mb3_general_ci
|
|
|
| tags |
varchar(1)
|
utf8mb3_general_ci
|
|
|