|
id
|
char(36)
|
|
|
|
|
name
|
varchar(50)
|
|
|
|
|
date_entered
|
datetime
|
|
|
|
|
date_modified
|
datetime
|
|
|
|
|
modified_user_id
|
char(36)
|
|
|
|
|
created_by
|
char(36)
|
|
|
|
|
description
|
text
|
|
|
|
|
deleted
|
tinyint(1)
|
|
|
0
|
|
assigned_user_id
|
char(36)
|
|
|
|
|
opportunity_type
|
varchar(255)
|
|
|
|
|
campaign_id
|
char(36)
|
|
|
|
|
lead_source
|
varchar(50)
|
|
|
|
|
amount
|
double
|
|
|
|
|
amount_usdollar
|
double
|
|
|
|
|
currency_id
|
char(36)
|
|
|
|
|
date_closed
|
date
|
|
|
|
|
next_step
|
varchar(100)
|
|
|
|
|
sales_stage
|
varchar(255)
|
|
|
|
|
probability
|
double
|
|
|
|