Dream Valley CRM · ERDdrag a table to move it · click it for relations · scroll to zoom
Quotation BuilderActivity & HistoryCore RecordsMaster DataUsers & AccessSystem
contacts
idbigintPK
first_namestring
last_namestring
emailstring
phonestringUK
alternate_phonestring
companystring
citystring
statestring
lifecycle_stagestring
do_not_callboolean
do_not_smsboolean
do_not_emailboolean
owner_idbigintFK
notesstring
created_atdatetime
updated_atdatetime
created_bybigintFK
leads
idbigintPK
lead_numberstringUK
contact_idbigintFK
booking_type_idbigintFK
source_idbigintFK
subsource_idbigintFK
referred_bystring
stage_idbigintFK
lost_reason_idbigintFK
temperaturestring
owner_idbigintFK
assigned_atdatetime
event_datedate
check_out_datedate
num_adultsint
num_childrenint
rooms_countint
room_category_idbigintFK
meal_plan_idbigintFK
venue_idbigintFK
occasion_idbigintFK
school_namestring
estimated_valuedecimal
notesstring
last_contacted_atdatetime
next_follow_up_atdatetime
call_attemptsint
created_atdatetime
updated_atdatetime
created_bybigintFK
lead_attribution
lead_idbigintPKFK
utm_sourcestring
utm_mediumstring
utm_campaignstring
utm_termstring
utm_contentstring
gclidstring
fbclidstring
platformstring
campaign_idstring
campaign_namestring
adset_idstring
adset_namestring
ad_idstring
ad_namestring
form_idstring
justdial_lead_idstring
ota_referencestring
landing_pagestring
referrer_urlstring
ip_addressstring
raw_payloadjson
captured_atdatetime
opportunities
idbigintPK
opportunity_numberstringUK
lead_idbigintFK
contact_idbigintFK
booking_type_idbigintFK
stagestring
owner_idbigintFK
expected_close_datedate
event_datedate
check_out_datedate
num_adultsint
num_childrenint
room_category_idbigintFK
venue_idbigintFK
meal_plan_idbigintFK
quoted_amountdecimal
discountdecimal
final_amountdecimal
gst_amountdecimal
advance_expecteddecimal
outcomestring
lost_reason_idbigintFK
created_atdatetime
updated_atdatetime
created_bybigintFK
bookings
idbigintPK
booking_numberstringUK
opportunity_idbigintFK
contact_idbigintFK
room_idbigintFK
venue_idbigintFK
check_in_datedate
check_out_datedate
final_amountdecimal
advance_paiddecimal
balance_amountdecimal
statusstring
cancellation_reasonstring
accepted_version_idbigintFK
created_atdatetime
updated_atdatetime
created_bybigintFK
payments
idbigintPK
opportunity_idbigintFK
booking_idbigintFK
amountdecimal
payment_typestring
methodstring
reference_nostring
paid_atdatetime
statusstring
created_atdatetime
created_bybigintFK
calls
idbigintPK
lead_idbigintFK
opportunity_idbigintFK
contact_idbigintFK
agent_idbigintFK
directionstring
from_numberstring
to_numberstring
duration_secondsint
recording_urlstring
dispositionstring
providerstring
provider_call_idstring
occurred_atdatetime
created_atdatetime
tasks
idbigintPK
lead_idbigintFK
opportunity_idbigintFK
owner_idbigintFK
task_typestring
titlestring
notesstring
due_atdatetime
statusstring
completed_atdatetime
created_atdatetime
created_bybigintFK
activities
idbigintPK
contact_idbigintFK
lead_idbigintFK
opportunity_idbigintFK
activity_typestring
summarystring
detailstring
ref_tablestring
ref_idbigint
metadatajson
actor_idbigintFK
occurred_atdatetime
created_atdatetime
stage_history
idbigintPK
lead_idbigintFK
from_stage_idbigintFK
to_stage_idbigintFK
lost_reason_idbigintFK
changed_bybigintFK
changed_atdatetime
quotations
idbigintPK
quote_numberstringUK
opportunity_idbigintFK
statusstring
tierstring
valid_untildate
created_atdatetime
updated_atdatetime
created_bybigintFK
quotation_versions
idbigintPK
quotation_idbigintFK
version_noint
subtotaldecimal
discountdecimal
gst_amountdecimal
grand_totaldecimal
change_notestring
is_acceptedboolean
created_atdatetime
created_bybigintFK
quotation_line_items
idbigintPK
version_idbigintFK
item_typestring
room_category_idbigintFK
meal_plan_idbigintFK
venue_idbigintFK
add_on_idbigintFK
descriptionstring
quantitydecimal
nightsint
unit_pricedecimal
amountdecimal
booking_types
idbigintPK
namestring
is_activeboolean
lead_sources
idbigintPK
namestring
is_activeboolean
lead_subsources
idbigintPK
source_idbigintFK
namestring
is_activeboolean
pipeline_stages
idbigintPK
namestring
sort_orderint
is_wonboolean
is_lostboolean
is_activeboolean
lost_reasons
idbigintPK
namestring
is_activeboolean
room_categories
idbigintPK
namestring
configurationstring
base_occupancyint
max_occupancyint
total_roomsint
is_activeboolean
rooms
idbigintPK
room_category_idbigintFK
namestring
is_activeboolean
venues
idbigintPK
namestring
venue_typestring
area_sqftdecimal
length_ftdecimal
width_ftdecimal
height_ftdecimal
seating_theatreint
seating_clusterint
seating_ushapeint
is_activeboolean
meal_plans
idbigintPK
codestring
namestring
descriptionstring
is_activeboolean
rate_cards
idbigintPK
room_category_idbigintFK
meal_plan_idbigintFK
base_pricedecimal
extra_person_pricedecimal
child_pricedecimal
effective_fromdate
is_activeboolean
add_ons
idbigintPK
namestring
pricing_typestring
unitstring
ratedecimal
gst_ratedecimal
categorystring
is_activeboolean
occasions
idbigintPK
namestring
is_activeboolean
tax_rates
idbigintPK
namestring
percentagedecimal
is_activeboolean
users
idbigintPK
namestring
emailstringUK
phonestring
role_idbigintFK
is_activeboolean
created_atdatetime
roles
idbigintPK
namestring
descriptionstring
assignment_rules
idbigintPK
namestring
criteriajson
assign_to_user_idbigintFK
priorityint
is_activeboolean
audit_log
idbigintPK
user_idbigintFK
entity_tablestring
entity_idbigint
actionstring
changesjson
created_atdatetime
attachments
idbigintPK
entity_tablestring
entity_idbigint
file_namestring
file_urlstring
uploaded_bybigintFK
created_atdatetime
notifications
idbigintPK
user_idbigintFK
typestring
messagestring
is_readboolean
created_atdatetime