forecasts

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

CHAR

36

null

timeperiod_id

CHAR

36

√

null

forecast_type

VARCHAR

100

√

null

opp_count

INT

10

√

null

pipeline_opp_count

INT

10

√

0

pipeline_amount

DECIMAL

26,6

√

0.000000

closed_amount

DECIMAL

26,6

√

0.000000

opp_weigh_value

INT

10

√

null

best_case

DECIMAL

26,6

√

null

likely_case

DECIMAL

26,6

√

null

Showing 1 to 10 of 17 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
idx_forecast_user_tp	Performance	Asc/Asc/Asc	user_id + timeperiod_id + date_modified

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees