first_time_funnel_briefed
bool
advanced_search_id
objectId
NN
Documentation for project crm_dev2
Report
Generated
2024/3/28 | 下午6:47:36
collections
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
source
created
date
modified
date
Indexes
funnel_strategies_ix_1
Create statement
db.funnel_strategies.createIndex(
{
"acct_id": 1
},
{
name: "funnel_strategies_ix_1"
}
)
funnel_strategies_ix_2
Create statement
db.funnel_strategies.createIndex(
{
"funnel_id": 1
},
{
name: "funnel_strategies_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
objective_type_id
string
Yes
Yes
funnel_type_id
string
Yes
Yes
free_of_charge
bool
service_plan_id
objectId
Yes
Yes
title
string
description
property
hashtag
cover_img
flow_img
rank
int
active
bool
Indexes
sys_screenplays_ix_1
Create statement
db.sys_screenplays.createIndex(
{
"screenplay_type_id": 1,
"active": 1
},
{
name: "sys_screenplays_ix_1"
}
)
sys_screenplays_ix_2
Create statement
db.sys_screenplays.createIndex(
{
"screenplay_type_id": 1
},
{
name: "sys_screenplays_ix_2"
}
)
sys_screenplays_ix_3
Create statement
db.sys_screenplays.createIndex(
{
"rank": -1
},
{
name: "sys_screenplays_ix_3"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
sys_screenplay_id
objectId
acct_screenplay_id
objectId
funnel_screenplay_id
objectId
Yes
funnel_screenplay_set_id
objectId
Yes
seq
int
page_type_id
string
Yes
set_id
objectId
only got value when type = 'lead'
set_page_id
objectId
Yes
set_page_mvc_id
objectId
Yes
browser_title
join_mbr_level_id
objectId
runtime_medium
string
line_friend_only
bool
need_login
bool
granted_mbr_level_id
objectId
Yes
login_method
string
Yes
authorize_channel
string
Yes
tags
array
Yes
permalink
string
shorten_link
string
html
main_css
section_css
created
date
modified
date
Indexes
funnel_pages_ix_1
Create statement
db.funnel_pages.createIndex(
{
"acct_id": 1
},
{
name: "funnel_pages_ix_1"
}
)
funnel_pages_ix_2
Create statement
db.funnel_pages.createIndex(
{
"funnel_id": 1
},
{
name: "funnel_pages_ix_2"
}
)
funnel_pages_ix_3
Create statement
db.funnel_pages.createIndex(
{
"funnel_screenplay_chapter_id": 1
},
{
name: "funnel_pages_ix_3"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
country_id
string
Yes
currency_id
string
Yes
acct_start_date
date
company
string
first_time_funnel_briefed
bool
tel
address
string
type
string
tax_id_number
string
cs_email
string
website
string
business_hours
string
about_us
string
logo
string
dark_bg_logo
string
facebook
instagram
line
meidum
tiktok
twitter
whatsapp
youtube
show_powered_by
bool
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
teammate_id
objectId
Yes
user_id
string
owner
bool
role
string
status
string
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
avatar
string
name
string
email
string
country_code
string
mobile
string
status
string
activation_key
string
activation_datetime
date
reg_medium
string
last_login
date
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_strategy_id
objectId
Yes
name
string
sharing
payment_methods
payment_gateways
currencies
string
Yes
cs_active
bool
step
int
status
string
Yes
hook_strategy
bool
sales_strategy
bool
active
bool
conversion_end_datetime
date
langs
string
Yes
created
date
modified
date
Indexes
funnels_ix_1
Create statement
db.funnels.createIndex(
{
"acct_id": 1
},
{
name: "funnels_ix_1"
}
)
funnels_ix_2
Create statement
db.funnels.createIndex(
{
"modified": -1
},
{
name: "funnels_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
funnel_page_id
objectId
Yes
hook_id
objectId
sales_id
objectId
visitor_id
string
Yes
name
string
email
string
country_code
string
mobile
string
gender
string
address
string
custom_fields
object
source
string
join_medium
string
line
internaltest
string
lang
string
deleting
bool
created
date
modified
date
Indexes
page_users_ix_1
Create statement
db.page_users.createIndex(
{
"acct_id": 1
},
{
name: "page_users_ix_1"
}
)
page_users_ix_2
Create statement
db.page_users.createIndex(
{
"funnel_id": 1
},
{
name: "page_users_ix_2"
}
)
page_users_ix_3
Create statement
db.page_users.createIndex(
{
"hook_id": 1
},
{
name: "page_users_ix_3"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
page_user_id
objectId
funnel_id
objectId
funnel_name
string
funnel_page_id
objectId
visitor_id
string
Yes
visit_footprint
Yes
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
string
Yes
Yes
name
description
direction
string
rank
int
icon
active_icon
active
bool
Indexes
screenplay_types_ix_1
Create statement
db.objective_types.createIndex(
{
"rank": 1
},
{
name: "screenplay_types_ix_1"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
objective_type_id
string
Yes
Yes
funnel_type_id
string
Yes
Yes
sys_screenplay_id
objectId
Yes
name
string
Yes
rank
int
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
objective_type_id
string
Yes
Yes
free_of_charge
bool
funnel_type_id
string
Yes
Yes
title
created
date
modified
date
Indexes
funnel_screenplays_ix_1
Create statement
db.funnel_screenplays.createIndex(
{
"acct_id": 1
},
{
name: "funnel_screenplays_ix_1"
}
)
funnel_screenplays_ix_2
Create statement
db.funnel_screenplays.createIndex(
{
"funnel_id": 1
},
{
name: "funnel_screenplays_ix_2"
}
)
funnel_screenplays_ix_3
Create statement
db.funnel_screenplays.createIndex(
{
"screenplay_type_id": 1
},
{
name: "funnel_screenplays_ix_3"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
name
description
max_funnels
int
Yes
unlimited_funnels
bool
max_video_uploads
int
unlimited_video_uploads
bool
max_custom_domains
int
shorten_link
bool
unlimited_custom_domains
bool
lms
bool
max_new_registers
int
Yes
unlimited_new_registers
bool
max_unique_page_users
int
Yes
unlimited_unique_page_users
bool
limited_screenplay_templates
bool
tagging
bool
rfm
bool
page_user_journeys
bool
edm_personalized_promo
bool
sms_personalized_promo
bool
max_abandon_cart_notifications
int
unllimited_abandon_cart_notifications
bool
monthly_fee
annual_fee
project_plan
bool
scope
string
Yes
Fields
Name
Data type
Array
Key
Required
_id
string
Yes
Yes
country_code
string
continent_id
string
name_en
string
name_tc
string
name_sc
string
rank
int
active
bool
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
favicon
threshold
fb_pixel
string
gtm
string
url_slug
string
timezone
string
drip
ufo
facebook
whatsapp
lead
sales
getbutton_script
string
lms_id
string
line
default_lang
string
api_key
string
callback_url
string
Indexes
acct_settings_ix_1
Create statement
db.acct_settings.createIndex(
{
"acct_id": 1
},
{
name: "acct_settings_ix_1"
}
)
To query acct_services data:
select today where today >= start_date and today <= end_date, order by created desc limit 1
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
payment_history_id
objectId
Yes
service_plan_id
objectId
Yes
service_plan_name
start_date
date
end_date
date
billing_cycle
string
max_funnels
int
unlimited_funnels
bool
max_video_uploads
int
unlimited_video_uploads
bool
max_custom_domains
int
shorten_link
bool
unlimited_custom_domains
bool
lms
bool
max_new_registers
int
unlimited_new_registers
bool
max_unique_page_users
int
unlmited_unique_page_users
bool
tagging
bool
rfm
bool
page_user_journeys
bool
edm_personalized_promo
bool
sms_personalized_promo
bool
max_abandon_cart_notifications
int
unllimited_abandon_cart_notifications
bool
monthly_fee
annual_fee
allow_change_plan
bool
scope
string
Yes
subscription
created
date
When renew / upgrade plan, create one more entry for this account with new created date
Indexes
acct_services_ix_1
Create statement
db.acct_services.createIndex(
{
"acct_id": 1,
},
{
name: "acct_services_ix_1"
}
)
acct_services_ix_2
Create statement
db.acct_services.createIndex(
{
"subscription.id": 1
},
{
name: "acct_services_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
country_id
string
Yes
type
string
change_plan_direction
string
receipt_num
string
currency_id
string
Yes
currency_rate
double
amt_wo_tax
double
tax
double
amt
double
refund
double
payment_method
string
payment_status
string
txn_id
string
payment_datetime
date
issue_tw_invoice
bool
tw_invoice
tw_invoice_callback
service_plan_id
objectId
Yes
service_plan_info
Only when type = change_plan
edm_quota_to_add
int
Only when type="edm_quota"
sms_points_to_add
int
Only when type="add_sms_points"
billing_cycle
string
internal_test
string
description
string
created_by
string
created
date
Indexes
payment_histories_ix_1
Create statement
db.payment_histories.createIndex(
{
"acct_id": 1,
"payment_status": 1
},
{
name: "payment_histories_ix_1"
}
)
payment_histories_ix_2
Create statement
db.payment_histories.createIndex(
)
payment_histories_ix_3
Create statement
db.payment_histories.createIndex(
)
Fields
Name
Data type
Array
Key
Required
_id
string
Yes
Yes
name
string
rate
double
label
string
fullset_default_amt
double
acct_currency
bool
service_currency
bool
Indexes
currencies_ix_1
Create statement
db.currencies.createIndex(
{
"service_currency": 1
},
{
name: "currencies_ix_1"
}
)
currencies_ix_2
Create statement
db.currencies.createIndex(
{
"acct_currency": 1
},
{
name: "currencies_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
tag
string
num_occurences
int
Indexes
acct_user_tags_ix_1
Create statement
db.acct_user_tags.createIndex(
{
"acct_id": 1
},
{
name: "acct_user_tags_ix_1"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
domain
string
dkim_selector
string
status
string
PE: Action required, please authorize this domain to send bulk emails
FA: Failed
VE: Sender domain has been verified
sg_data
ip_pool
string
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
num_funnels
int
num_videos_uploaded
int
num_custom_domains
int
num_users
int
num_visitors
int
ttl_visitors
int
monthly_new_users
int
remaining_edm_quota
int
remaining_points
double
created
date
modified
date
Indexes
acct_stats_ix_1
Create statement
db.acct_stats.createIndex(
{
"acct_id": 1
},
{
name: "acct_stats_ix_1"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
name
string
default
bool
status
string
S: Successfully Bound
P: Pending Setup
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
tier
int
quota
int
fee
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
GMT
string
name
country_id
string
Yes
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
tier
int
points
double
fee
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
country_code
string
points
double
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
img_id
string
acct_id
objectId
Yes
funnel_id
objectId
Yes
funnel_page_id
objectId
Yes
desktop
mobile
Indexes
funnel_gjs_images_ix_1
Create statement
db.funnel_gjs_images.createIndex(
{
"acct_id": 1
},
{
name: "funnel_gjs_images_ix_1"
}
)
funnel_gjs_images_ix_2
Create statement
db.funnel_gjs_images.createIndex(
{
"funnel_id": 1
},
{
name: "funnel_gjs_images_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
set_id
objectId
Yes
funnel_screenplay_id
objectId
Yes
funnel_page_id
objectId
Yes
name
contact_fields
default_fields
custom_profile_fields
start_datetime
date
end_datetime
date
countdown_to_start
bool
countdown_to_end
bool
step
int
set_quota_limit
bool
ttl_quota
int
quota_threshold
int
created
date
modified
date
Indexes
leads_ix_1
Create statement
db.hooks.createIndex(
{
"acct_id": 1
},
{
name: "leads_ix_1"
}
)
leads_ix_2
Create statement
db.hooks.createIndex(
{
"lead_category_id": 1
},
{
name: "leads_ix_2"
}
)
hooks_ix_3
Create statement
db.hooks.createIndex(
{
"acct_id": 1,
"modified": -1
},
{
name: "hooks_ix_3"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
seq
int
type
string
name
Indexes
hook_categories_ix_1
Create statement
db.sets.createIndex(
{
"component_id": 1
},
{
name: "hook_categories_ix_1"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
hook_id
objectId
Yes
name
period_mode
string
show_time
bool
start_datetime
date
end_datetime
date
reg_period_mode
string
reg_show_time
bool
reg_start_datetime
date
reg_end_datetime
date
quota
int
threshold
int
active
bool
created
date
modified
date
Indexes
lead_sessions_ix_1
Create statement
db.hook_sessions.createIndex(
{
"acct_id": 1
},
{
name: "lead_sessions_ix_1"
}
)
lead_sessions_ix_2
Create statement
db.hook_sessions.createIndex(
{
"lead_id": 1
},
{
name: "lead_sessions_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
hook_id
objectId
Yes
default_select
bool
label
type
string
options
fieldname
string
not_inline
bool
required
bool
content
optin_text
file_upload_options
tags
array
Yes
rank
int
active
bool
created
date
modified
date
Indexes
lead_custom_fields_ix_1
Create statement
db.hook_custom_fields.createIndex(
{
"acct_id": 1
},
{
name: "lead_custom_fields_ix_1"
}
)
lead_custom_fields_ix_2
Create statement
db.hook_custom_fields.createIndex(
{
"lead_id": 1
},
{
name: "lead_custom_fields_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
num_online_sources
int
num_visitors
int
ttl_visitors
int
num_pages
int
created
date
modified
date
Indexes
funnel_stats_ix_1
Create statement
db.funnel_stats.createIndex(
{
"acct_id": 1
},
{
name: "funnel_stats_ix_1"
}
)
funnel_stats_ix_2
Create statement
db.funnel_stats.createIndex(
{
"funnel_id": 1
},
{
name: "funnel_stats_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
funnel_page_id
objectId
Yes
num_visitors
int
ttl_visitors
int
created
date
modified
date
Indexes
funnel_page_stats_ix_1
Create statement
db.page_stats.createIndex(
{
"acct_id": 1
},
{
name: "funnel_page_stats_ix_1"
}
)
funnel_page_stats_ix_2
Create statement
db.page_stats.createIndex(
{
"funnel_id": 1
},
{
name: "funnel_page_stats_ix_2"
}
)
funnel_page_stats_ix_3
Create statement
db.page_stats.createIndex(
{
"funnel_page_id": 1
},
{
name: "funnel_page_stats_ix_3"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
entry_funnel_id
objectId
Yes
entry_funnel_name
string
name
string
email
string
country_code
string
mobile
string
gender
string
address
string
birthday
user_tags
string
Yes
ta_tags
string
Yes
Yes
delivery_tags
Yes
cust_field_tags
string
Yes
recipient_tags
Yes
accumulated_order_amt
array
Yes
last_sales_created
date
status
string
IMP: 未參與漏斗活動 (inactive_member_progressing, not joined any hook or sales)
HOC: 行銷上鉤 (hook_converted, joined hook)
SAC: 轉化成交 (sales_converted, paid)
join_medium
string
admin 管理員加入
funnel 漏斗加入
line LINE 加入
api API 加入
line
mbr_level_id
objectId
mbr_expiry
date
mbr_status
string
PND - 待處理 (Pending)
EFF - 有效 (Effective)
INV - 無效 (Invalid)
DEF - 暫緩 (Deferred)
custom_fields
deleting
bool
created
date
modified
date
Indexes
acct_users_ix_1
Create statement
db.acct_users.createIndex(
{
"acct_id": 1
},
{
name: "acct_users_ix_1"
}
)
acct_users_ix_2
Create statement
db.acct_users.createIndex(
{
"modified": -1,
"acct_id": 1
},
{
name: "acct_users_ix_2"
}
)
acct_users_ix_3
Create statement
db.acct_users.createIndex(
{
"acct_id": 1,
"created": 1
},
{
name: "acct_users_ix_3"
}
)
acct_users_ix_4
Create statement
db.acct_users.createIndex(
{
"acct_id": 1,
"ta_tags": 1,
"modified": -1
},
{
name: "acct_users_ix_4"
}
)
acct_users_ix_5
Create statement
db.acct_users.createIndex(
{
"acct_id": 1,
"email": 1
},
{
name: "acct_users_ix_5"
}
)
acct_users_ix_6
Create statement
db.acct_users.createIndex(
{
"acct_id": 1,
"country_code": 1
},
{
name: "acct_users_ix_6"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
name
string
email
string
country_code
string
mobile
string
address
string
status
string
voted_items
array
Yes
join_medium
string
accumulated_order_amt
array
line
deleting
bool
created
date
modified
date
Indexes
funnel_users_ix_1
Create statement
db.funnel_users.createIndex(
{
"acct_id": 1
},
{
name: "funnel_users_ix_1"
}
)
funnel_users_ix_2
Create statement
db.funnel_users.createIndex(
{
"funnel_id": 1
},
{
name: "funnel_users_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
paypal
stripe
yedpay
eftpay
newebpay
Indexes
sales_settings_ix_1
Create statement
db.payment_settings.createIndex(
{
"acct_id": 1
},
{
name: "sales_settings_ix_1"
}
)
Name
shorten_link_mappings
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
orig_url
string
long_url
string
shorten_link
string
utm_active
bool
uto_campaign
string
utm_content
string
utm_medium
string
utm_source
string
utm_term
string
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
privacy
sales_terms
terms
Indexes
acct_tandc_ix_1
Create statement
db.acct_tandc.createIndex(
{
"acct_id": 1
},
{
name: "acct_tandc_ix_1"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
tag
string
num_users
int
last_added_user_datetime
date
created
date
modified
date
Indexes
acct_user_tags_ix_1
Create statement
db.acct_ta_tags.createIndex(
{
"acct_id": 1
},
{
name: "acct_user_tags_ix_1"
}
)
acct_ta_tags_ix_2
Create statement
db.acct_ta_tags.createIndex(
{
"acct_id": 1,
"modified": -1
},
{
name: "acct_ta_tags_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
hook_erms
sales_terms
privacy
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
editor
tinymce
tinymce_minified
xlead
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
hook_id
objectId
Yes
num_votes_allowed
int
force_vote_all_cat
bool
allow_daily_vote
bool
item_result_mode
string
show_result_after_vote
bool
user_verify_format
string
Indexes
hook_votings_ix_1
Create statement
db.hook_votings.createIndex(
{
"acct_id": 1,
"hook_id": 1
},
{
name: "hook_votings_ix_1"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
hook_id
objectId
Yes
hook_voting_item_cat_id
objectId
seq
int
name
description
images
Yes
created
date
modified
date
Indexes
hook_voting_items_ix_1
Create statement
db.hook_voting_items.createIndex(
{
"hook_voting_item_cat_id": 1
},
{
name: "hook_voting_items_ix_1"
}
)
hook_voting_items_ix_2
Create statement
db.hook_voting_items.createIndex(
{
"acct_id": 1
},
{
name: "hook_voting_items_ix_2"
}
)
hook_voting_items_ix_3
Create statement
db.hook_voting_items.createIndex(
{
"hook_id": 1
},
{
name: "hook_voting_items_ix_3"
}
)
hook_voting_items_ix_4
Create statement
db.hook_voting_items.createIndex(
{
"hook_voting_item_cat_id": 1,
"seq": 1
},
{
name: "hook_voting_items_ix_4"
}
)
hook_voting_items_ix_5
Create statement
db.hook_voting_items.createIndex(
{
"hook_voting_item_cat_id": 1,
"hook_id": 1
},
{
name: "hook_voting_items_ix_5"
}
)
Name
hook_voting_item_cats
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
hook_id
objectId
Yes
name
seq
string
Indexes
hook_voting_item_cats_ix_1
Create statement
db.hook_voting_item_cats.createIndex(
{
"acct_id": 1
},
{
name: "hook_voting_item_cats_ix_1"
}
)
hook_voting_item_cats_ix_2
Create statement
db.hook_voting_item_cats.createIndex(
{
"hook_id": 1
},
{
name: "hook_voting_item_cats_ix_2"
}
)
hook_voting_item_cats_ix_3
Create statement
db.hook_voting_item_cats.createIndex(
{
"hook_id": 1,
"seq": 1
},
{
name: "hook_voting_item_cats_ix_3"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
hook_id
objectId
Yes
intro
event_price_text
type
string
reg_limit
int
address
website
string
description
show_reg_figures
array
Yes
banner_style
string
banner_slogan
banner_bg_color
string
banner_text_color
string
location
form_display_type
string
waiting_list
bool
checkin
bool
checkin_method
string
Yes
Indexes
hook_free_events_ix_1
Create statement
db.hook_events.createIndex(
{
"acct_id": 1
},
{
name: "hook_free_events_ix_1"
}
)
hook_free_events_ix_2
Create statement
db.hook_events.createIndex(
{
"hook_id": 1
},
{
name: "hook_free_events_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
hook_id
objectId
Yes
image
tablet_img
mobile_img
Indexes
hook_main_banners_ix_1
Create statement
db.hook_main_banners.createIndex(
{
"acct_id": 1
},
{
name: "hook_main_banners_ix_1"
}
)
hook_main_banners_ix_2
Create statement
db.hook_main_banners.createIndex(
{
"hook_id": 1
},
{
name: "hook_main_banners_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
hook_id
objectId
Yes
type
string
sender
string
message
string
created
date
modified
date
Indexes
hook_sms_messages_ix_1
Create statement
db.hook_sms_messages.createIndex(
{
"acct_id": 1
},
{
name: "hook_sms_messages_ix_1"
}
)
hook_sms_messages_ix_2
Create statement
db.hook_sms_messages.createIndex(
{
"hook_id": 1
},
{
name: "hook_sms_messages_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
funnel_page_id
objectId
Yes
country_code
string
mobile
string
vercode
string
created
date
Indexes
sms_vercodes_ix_1
Create statement
db.sms_vercodes.createIndex(
{
"funnel_page_id": 1,
"country_code": 1,
"mobile": 1,
"created": 1
},
{
name: "sms_vercodes_ix_1"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
hook_id
objectId
Yes
hook_voting_item_cat_id
objectId
Yes
hook_voting_item_id
objectId
Yes
num_votes
int
num_votes_percent
double
ranking
int
created
date
modified
date
Indexes
hook_funnel_votes_ix_1
Create statement
db.hook_funnel_votes.createIndex(
{
"acct_id": 1
},
{
name: "hook_funnel_votes_ix_1"
}
)
hook_funnel_votes_ix_2
Create statement
db.hook_funnel_votes.createIndex(
{
"funnel_id": 1
},
{
name: "hook_funnel_votes_ix_2"
}
)
hook_funnel_votes_ix_3
Create statement
db.hook_funnel_votes.createIndex(
{
"funnel_id": 1,
"hook_voting_item_cat_id": 1
},
{
name: "hook_funnel_votes_ix_3"
}
)
hook_funnel_votes_ix_4
Create statement
db.hook_funnel_votes.createIndex(
{
"acct_id": 1,
"funnel_id": 1,
"hook_id": 1,
"hook_voting_item_cat_id": 1,
"hook_voting_item_id": 1
},
{
name: "hook_funnel_votes_ix_4",
unique: true
}
)
hook_funnel_votes_ix_5
Create statement
db.hook_funnel_votes.createIndex(
{
"hook_voting_item_cat_id": 1
},
{
name: "hook_funnel_votes_ix_5"
}
)
hook_funnel_votes_ix_6
Create statement
db.hook_funnel_votes.createIndex(
{
"hook_voting_item_id": 1
},
{
name: "hook_funnel_votes_ix_6"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
hook_id
objectId
Yes
hook_voting_item_cat_id
objectId
Yes
hook_voting_item_id
objectId
Yes
page_user_id
objectId
Yes
qualified
bool
vote_datetime
date
created
date
modified
date
Indexes
page_user_hook_votes_ix_1
Create statement
db.page_user_hook_votes.createIndex(
{
"acct_id": 1
},
{
name: "page_user_hook_votes_ix_1"
}
)
page_user_hook_votes_ix_2
Create statement
db.page_user_hook_votes.createIndex(
{
"funnel_id": 1
},
{
name: "page_user_hook_votes_ix_2"
}
)
page_user_hook_votes_ix_3
Create statement
db.page_user_hook_votes.createIndex(
{
"page_user_id": 1
},
{
name: "page_user_hook_votes_ix_3"
}
)
page_user_hook_votes_ix_4
Create statement
db.page_user_hook_votes.createIndex(
{
"acct_id": 1,
"funnel_id": 1,
"hook_id": 1,
"hook_voting_item_id": 1,
"hook_voting_item_cat_id": 1,
"page_user_id": 1
},
{
name: "page_user_hook_votes_ix_4",
unique: true
}
)
Name
hook_funnel_hourly_votes
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
hook_id
objectId
Yes
hook_voting_item_cat_id
objectId
Yes
date
date
year
int
month
int
day
int
hour
int
num_unique_users
int
num_votes
int
Indexes
hook_funnel_hourly_votes_ix_1
Create statement
db.hook_funnel_hourly_votes.createIndex(
{
"acct_id": 1
},
{
name: "hook_funnel_hourly_votes_ix_1"
}
)
hook_funnel_hourly_votes_ix_2
Create statement
db.hook_funnel_hourly_votes.createIndex(
{
"funnel_id": 1
},
{
name: "hook_funnel_hourly_votes_ix_2"
}
)
hook_funnel_hourly_votes_ix_3
Create statement
db.hook_funnel_hourly_votes.createIndex(
{
"hook_voting_item_cat_id": 1,
"year": 1,
"month": 1,
"day": 1,
"hour": 1
},
{
name: "hook_funnel_hourly_votes_ix_3"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
edm_sender_id
objectId
Yes
name
string
type
string
use_different_reply_to
bool
m_reply_to
string
status
string
cron_daily_trigger_time
string
step
int
num_subscribed
int
tags
Yes
active
bool
created
date
modified
date
Indexes
edm_campaigns_ix_1
Create statement
db.edm_campaigns.createIndex(
{
"acct_id": 1
},
{
name: "edm_campaigns_ix_1"
}
)
edm_campaigns_ix_2
Create statement
db.edm_campaigns.createIndex(
{
"acct_id": 1,
"type": 1
},
{
name: "edm_campaigns_ix_2"
}
)
edm_campaigns_ix_3
Create statement
db.edm_campaigns.createIndex(
{
"acct_id": 1,
"type": 1,
"modified": -1
},
{
name: "edm_campaigns_ix_3"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
edm_campaign_id
objectId
Yes
num_releases
int
num_scheduled
int
created
date
modified
date
Indexes
edm_campaign_stats_ix_1
Create statement
db.edm_campaign_stats.createIndex(
{
"acct_id": 1
},
{
name: "edm_campaign_stats_ix_1"
}
)
edm_campaign_stats_ix_2
Create statement
db.edm_campaign_stats.createIndex(
{
"edm_campaign_id": 1
},
{
name: "edm_campaign_stats_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
edm_campaign_id
objectId
Yes
edm_template_id
objectId
no_template
bool
Yes
type
string
preheader
string
seq
int
after_day
int
subject
string
html
string
css
string
client_html
string
delay
int
autosave_datetime
date
delay_unit
int
complie_datetime
date
status
string
created
date
modified
date
Indexes
edm_nodes_ix_1
Create statement
db.edm_nodes.createIndex(
{
"acct_id": 1
},
{
name: "edm_nodes_ix_1"
}
)
edm_nodes_ix_2
Create statement
db.edm_nodes.createIndex(
{
"edm_campaign_id": 1
},
{
name: "edm_nodes_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
edm_campaign_id
objectId
Yes
acct_user_tag
string
Yes
acct_ta_tag
string
Yes
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
edm_campaign_id
objectId
Yes
release_seq
int
send_method
string
SL - 儲存的名單
SI - 手動輸入
IM - 由檔案匯入
ME - Mockup (Email)
MG - Mockup (Mockup Group)
status
string
P - Pending
S - Scheduled
D - Delivered
ta_tags
string
import_file
delivery_datetime
date
created
date
modified
date
Indexes
edm_releases_ix_1
Create statement
db.edm_releases.createIndex(
{
"acct_id": 1,
"edm_campaign_id": 1
},
{
name: "edm_releases_ix_1"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
edm_campaign_id
objectId
Yes
edm_release_id
objectId
Yes
send_method
string
nun_sent
int
num_success
int
num_hard_bounces
int
num_soft_bounces
int
num_opens
int
ttl_opens
int
num_clicks
int
ttl_clicks
int
num_unsubscribed
int
num_spams
int
created
date
modified
date
Indexes
edm_release_stats_ix_1
Create statement
db.edm_release_stats.createIndex(
{
"acct_id": 1,
"edm_campaign_id": 1
},
{
name: "edm_release_stats_ix_1"
}
)
Name
edm_broadcast_recipients
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
edm_campaign_id
objectId
Yes
edm_node_id
objectId
Yes
edm_release_id
objectId
edm_massage_id
objectId
Yes
delivery_datetime
date
email
string
params
string
Yes
sg_status_id
string
sg_desc
string
status
string
PE: Pending
SC- Scheduled
SE: Sending
ST: Sent
num_opens
int
first_open_datetime
date
last_open_datetime
date
device
string
ip
string
delivery_status
string
delivery_failure_code
string
desc_code
string
IEF: Incorrect Email Format
DDE: Discontinued Domain Email
PWD: Probably wrong domain
description
string
ab_status
string
ab_rule_cat
string
stat_datetime
date
first_tier_status
string
created
date
modified
date
Indexes
edm_recipients_ix_1
Create statement
db.edm_broadcast_recipients.createIndex(
{
"acct_id": 1
},
{
name: "edm_recipients_ix_1"
}
)
edm_recipients_ix_2
Create statement
db.edm_broadcast_recipients.createIndex(
{
"edm_campaign_id": 1
},
{
name: "edm_recipients_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
edm_campaign_id
objectId
Yes
edm_node_id
objectId
Yes
edm_release_id
objectId
Yes
edm_recipient_id
objectId
Yes
email
string
link
string
device
string
ip
string
first_click_datetime
date
last_click_datetime
date
num_clicks
date
created
date
modified
date
Indexes
edm_links_ix_1
Create statement
db.edm_links.createIndex(
{
"acct_id": 1
},
{
name: "edm_links_ix_1"
}
)
edm_links_ix_2
Create statement
db.edm_links.createIndex(
{
"edm_campaign_id": 1
},
{
name: "edm_links_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
edm_campaign_id
objectId
Yes
import_file
num_users
int
num_valid
int
num_invalid
int
num_duplicates
int
num_unsubscribed
int
finished
bool
created
date
modified
date
Name
edm_massage_failed_emails
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
edm_campaign_id
objectId
Yes
edm_massage_id
objectId
Yes
xls_row_num
int
fail_type
string
email
string
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
name
string
num_rules
int
rules
finisahed
bool
created
date
modified
date
Indexes
advanced_searches_ix_1
Create statement
db.advanced_searches.createIndex(
{
"acct_id": 1
},
{
name: "advanced_searches_ix_1"
}
)
Fields
Name
Data type
Array
Key
Required
_id
string
Yes
Yes
name
description
rank
int
icon
active_icon
active
bool
Indexes
screenplay_types_ix_1
Create statement
db.funnel_types.createIndex(
{
"rank": 1
},
{
name: "screenplay_types_ix_1"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
name
html
string
css
string
orig_html_path
string
orig_css_path
string
thumbnail_path
string
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
name
string
email
string
sender_domain
string
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
type
string
email
string
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
edm_campaign_id
objectId
Yes
edm_node_id
objectId
Yes
edm_release_id
objectId
Yes
all_br
bool
all_dr
bool
dr_campaign_id
objectId
Yes
email
string
status
string
AB - Abuse
WA - Wrong Address
UU - User Unsubscribe
For status other that "UU", "all_br" and "all_dr" must be true
ab_status
string
desc_code
string
created
date
modified
date
Indexes
edm_unsend_lists_ix_1
Create statement
db.edm_unsend_lists.createIndex(
{
"acct_id": 1
},
{
name: "edm_unsend_lists_ix_1"
}
)
edm_unsend_lists_ix_2
Create statement
db.edm_unsend_lists.createIndex(
{
"acct_id": 1,
"email": 1,
"type": 1
},
{
name: "edm_unsend_lists_ix_2"
}
)
edm_unsend_lists_ix_3
Create statement
db.edm_unsend_lists.createIndex(
{
"acct_id": 1,
"type": 1
},
{
name: "edm_unsend_lists_ix_3"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
edm_campaign_id
objectId
Yes
edm_node_id
objectId
Yes
edm_release_id
objectId
Yes
send_method
string
year
int
month
int
day
int
hour
int
open
int
click
int
unsubscribe
int
complain
int
forward
int
created
date
modified
date
Indexes
edm_chart_stats_ix_1
Create statement
db.edm_chart_stats.createIndex(
{
"acct_id": 1
},
{
name: "edm_chart_stats_ix_1"
}
)
edm_chart_stats_ix_2
Create statement
db.edm_chart_stats.createIndex(
{
"edm_campaign_id": 1
},
{
name: "edm_chart_stats_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
string
Yes
Yes
name
string
seq
int
enable_tags
bool
icon
string
Name
page_user_hook_sessions
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
hook_id
objectId
Yes
page_user_id
objectId
Yes
session
qualified
bool
checkin_datetime
date
created
date
modified
date
Indexes
page_user_hook_votes_ix_1
Create statement
db.page_user_hook_sessions.createIndex(
{
"acct_id": 1
},
{
name: "page_user_hook_votes_ix_1"
}
)
page_user_hook_votes_ix_2
Create statement
db.page_user_hook_sessions.createIndex(
{
"funnel_id": 1
},
{
name: "page_user_hook_votes_ix_2"
}
)
page_user_hook_votes_ix_3
Create statement
db.page_user_hook_sessions.createIndex(
{
"page_user_id": 1
},
{
name: "page_user_hook_votes_ix_3"
}
)
page_user_hook_votes_ix_4
Create statement
db.page_user_hook_sessions.createIndex(
{
"acct_id": 1,
"funnel_id": 1,
"hook_id": 1,
"hook_voting_item_id": 1,
"hook_voting_item_cat_id": 1,
"page_user_id": 1
},
{
name: "page_user_hook_votes_ix_4",
unique: true
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
type
string
spu
string
name
intro
description
currency_id
string
Yes
default_price
double
special_price
double
default_stock
int
weight
double
have_options
bool
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
product_id
objectId
Yes
spu
string
sku
string
name
currency_id
string
Yes
price
double
speicial_price
double
stock
int
product_image_id
objectId
Yes
default_entry
bool
seq
int
active
bool
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
currenciy_id
string
funnel_screenplay_id
objectId
Yes
funnel_page_id
objectId
Yes
name
contact_fields
default_fields
start_datetime
date
end_datetime
date
countdown_to_start
bool
countdown_to_end
bool
shipping_country_id
string
Yes
Yes
step
int
created
date
modified
date
Indexes
leads_ix_1
Create statement
db.sales.createIndex(
{
"acct_id": 1
},
{
name: "leads_ix_1"
}
)
leads_ix_2
Create statement
db.sales.createIndex(
{
"lead_category_id": 1
},
{
name: "leads_ix_2"
}
)
hooks_ix_3
Create statement
db.sales.createIndex(
{
"acct_id": 1,
"modified": -1
},
{
name: "hooks_ix_3"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
funnel_name
string
funnel_page_id
objectId
Yes
sales_id
objectId
Yes
page_user_id
objectId
Yes
visitor_id
string
receipt_num
string
payment_method
string
payment_gateway
string
payment_status
string
payment_datetime
date
pg_txn_id
string
delivery_method
string
delivery_status
string
order_status
string
currency_id
string
Yes
order_amount
double
tax
double
coupon
string
discount_description
string
discount_type
string
discount_value
double
Yes
discount_total
double
ship_charge
double
final_amount
double
buyer_name
string
buyer_email
string
buyer_country_code
string
buyer_mobile
string
recipient_name
string
recipient_country_code
string
recipient_mobile
string
recipient_address
string
sys_shipper_id
objectId
Yes
shipping_country_id
string
Yes
pickup_venue_id
string
Yes
shipping_area_id
objectId
Yes
sp_point_id
objectId
Yes
internaltest
string
source
string
line
lang
string
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_Id
objectId
Yes
order_id
objectId
Yes
page_user_id
objectId
Yes
product_id
objectId
Yes
product_option_id
objectId
Yes
product
string
product_option
string
product_image_url
string
spu
string
sku
string
currency_id
string
Yes
o_price
double
coupon
string
discount_mode
string
discount_min_qty
int
discount_value
double
discount_total
double
discounted_price
double
qty
int
subtotal
double
orders_discount_value
double
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
page_user_id
objectId
Yes
order_id
objectId
Yes
type
string
currency_id
string
Yes
amount
double
created
date
modified
date
orders_discount_value
double
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
sales_id
objectId
Yes
visitor_id
string
Yes
product_id
objectId
Yes
product_option_id
objectId
Yes
currency_id
string
Yes
type
string
o_price
double
coupon
string
disocunt_mode
string
discount_min_qty
int
discount_value
double
discount_total
double
discounted_price
double
qty
int
subtotal
double
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
order_id
objectId
Yes
invoice_num
string
status
string
orders_discount_value
double
Name
sales_general_activities
discount_mode:
- DA: 價格折扣
- PO: 打折優惠
- QD: 數量折扣
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
sales_id
objectId
Yes
discount_mode
string
discount_min_qty
int
discount_value
double
addon_product_layout
string
created
date
modified
date
Name
sales_digital_services
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
sales_id
objectId
Yes
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
sales_id
objectId
Yes
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
product_id
objectId
Yes
image
rank
int
created
date
modified
date
Name
sales_collective_buyings
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
sales_id
objectId
Yes
default_price
decimal
price_tier
array
Yes
creaetd
date
modified
date
Name
sales_group_purchases
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
sales_id
objectId
Yes
free_ship_qty
int
Yes
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
sys_shipper_id
objectId
Yes
sys_shipping_group_id
objectId
Yes
sys_sp_shipping_venue_id
objectId
Yes
sys_shipping_countriy_id
objectId
Yes
sys_shipping_province_id
objectId
sys_shipping_city_id
objectId
sys_shipping_district_id
objectId
pt_code
string
pt_name
address
active
bool
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
shipper_id
objectId
Yes
shipping_group_id
objectId
Yes
shipping_countriy_id
objectId
Yes
shipping_province_id
objectId
shipping_city_id
objectId
shipping_district_id
objectId
pt_code
string
pt_name
address
active
bool
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
sys_shipper_id
objectId
sys_shipping_group_id
objectId
sys_shipping_country_id
objectId
sys_shipping_province_id
objectId
sys_shipping_city_id
objectId
sys_shipping_district_id
objectId
shipper_id
objectId
shipping_group_id
objectId
shipping_countriy_id
objectId
shipping_province_id
objectId
shipping_city_id
objectId
shipping_district_id
objectId
wt_from
double
wt_to
double
currency_id
string
Yes
fee
double
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
name
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
acct_user_id
objectId
Yes
order_id
objectId
Yes
acct_user_name
string
acct_user_email
string
tags
array
description
string
orders_discount_value
double
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
edm_campaign_id
objectId
Yes
edm_node_id
objectId
Yes
edm_massage_id
objectId
Yes
edm_release_id
objectId
Yes
schedule_send_seq
int
schedule_send_datetime
date
num_scheduled_users
int
send_method
string
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
funnel_user_id
objectId
Yes
order_id
objectId
Yes
currency_id
string
Yes
amount
double
created
date
modified
date
orders_discount_value
double
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
acct_user_id
objectId
Yes
order_id
objectId
Yes
currency_id
string
Yes
amount
double
created
date
modified
date
orders_discount_value
double
Name
payment_method_gateways
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
method
string
gateway
string
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
sms_campaign_id
objectId
Yes
schedule_send_seq
int
schedule_send_datetime
date
num_scheduled_users
int
num_scheduled_sms
int
created
date
modified
date
Name
edm_schedule_sends_copy
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
schedule_send_seq
int
schedule_send_datetime
date
num_scheduled_users
int
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
name
string
sender
string
content
string
status
string
step
int
word_count
int
sms_count
int
api
bool
created
date
modified
date
Indexes
edm_campaigns_ix_1
Create statement
db.sms_campaigns.createIndex(
{
"acct_id": 1
},
{
name: "edm_campaigns_ix_1"
}
)
edm_campaigns_ix_2
Create statement
db.sms_campaigns.createIndex(
{
"acct_id": 1,
"type": 1
},
{
name: "edm_campaigns_ix_2"
}
)
edm_campaigns_ix_3
Create statement
db.sms_campaigns.createIndex(
{
"acct_id": 1,
"type": 1,
"modified": -1
},
{
name: "edm_campaigns_ix_3"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
sms_campaign_id
objectId
Yes
release_seq
int
send_method
string
status
string
ta_tags
string
import_file
string
delivery_datetime
date
send_also_ofca_registers
bool
api_ref
string
created
date
modified
date
Indexes
edm_releases_ix_1
Create statement
db.sms_releases.createIndex(
{
"acct_id": 1,
"edm_campaign_id": 1
},
{
name: "edm_releases_ix_1"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
sms_campaign_id
objectId
Yes
num_releases
int
num_scheduled
int
created
date
modified
date
Indexes
edm_campaign_stats_ix_1
Create statement
db.sms_campaign_stats.createIndex(
{
"acct_id": 1
},
{
name: "edm_campaign_stats_ix_1"
}
)
edm_campaign_stats_ix_2
Create statement
db.sms_campaign_stats.createIndex(
{
"edm_campaign_id": 1
},
{
name: "edm_campaign_stats_ix_2"
}
)
Name
sms_massage_failed_mobiles
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
sms_campaign_id
objectId
Yes
sms_massage_id
objectId
Yes
xls_row_num
int
fail_type
string
country_code
string
mobile
string
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
sms_campaign_id
objectId
Yes
sms_release_id
objectId
Yes
send_method
string
year
int
month
int
day
int
hour
int
click
int
created
date
modified
date
Indexes
edm_chart_stats_ix_1
Create statement
db.sms_chart_stats.createIndex(
{
"acct_id": 1
},
{
name: "edm_chart_stats_ix_1"
}
)
edm_chart_stats_ix_2
Create statement
db.sms_chart_stats.createIndex(
{
"edm_campaign_id": 1
},
{
name: "edm_chart_stats_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
sms_campaign_id
objectId
Yes
sms_release_id
objectId
Yes
sms_recipient_id
objectId
Yes
country_code
string
mobile
string
link
string
device
string
ip
string
first_click_datetime
date
last_click_datetime
date
num_clicks
date
created
date
modified
date
Indexes
edm_links_ix_1
Create statement
db.sms_links.createIndex(
{
"acct_id": 1
},
{
name: "edm_links_ix_1"
}
)
edm_links_ix_2
Create statement
db.sms_links.createIndex(
{
"edm_campaign_id": 1
},
{
name: "edm_links_ix_2"
}
)
Name
sms_broadcast_recipients
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
sms_campaign_id
objectId
Yes
sms_massage_id
objectId
Yes
sms_release_id
objectId
Yes
delivery_datetime
date
country_code
string
mobile
string
word_count
int
sms_count
int
unit_cost
double
total_cost
double
params
string
Yes
status
string
device
string
ip
string
delivery_status
string
delivery_failure_code
string
callback_status
string
callback_reason_code
string
desc_code
string
description
string
stat_datetime
date
first_tier_status
string
num_replies
int
is_trial
bool
created
date
modified
date
Indexes
edm_recipients_ix_1
Create statement
db.sms_broadcast_recipients.createIndex(
{
"acct_id": 1
},
{
name: "edm_recipients_ix_1"
}
)
edm_recipients_ix_2
Create statement
db.sms_broadcast_recipients.createIndex(
{
"edm_campaign_id": 1
},
{
name: "edm_recipients_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
sms_campaign_id
objectId
Yes
sms_release_id
objectId
Yes
send_method
string
nun_sent
int
num_success
int
num_faiilure
int
num_unsubscribed
int
num_clicks
int
ttl_clicks
int
num_ofca
int
created
date
modified
date
Indexes
edm_release_stats_ix_1
Create statement
db.sms_release_stats.createIndex(
{
"acct_id": 1,
"edm_campaign_id": 1
},
{
name: "edm_release_stats_ix_1"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
country_id
string
Yes
sender
string
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
sms_campaign_id
objectId
Yes
sms_release_id
objectId
Yes
type
string
country_code
string
mobile
string
status
string
ab_status
string
webmaster_action
bool
desc_code
string
created
date
modified
date
Indexes
edm_unsend_lists_ix_1
Create statement
db.sms_unsend_lists.createIndex(
{
"acct_id": 1
},
{
name: "edm_unsend_lists_ix_1"
}
)
edm_unsend_lists_ix_2
Create statement
db.sms_unsend_lists.createIndex(
{
"acct_id": 1,
"email": 1,
"type": 1
},
{
name: "edm_unsend_lists_ix_2"
}
)
edm_unsend_lists_ix_3
Create statement
db.sms_unsend_lists.createIndex(
{
"acct_id": 1,
"type": 1
},
{
name: "edm_unsend_lists_ix_3"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
funnel_page_id
objectId
Yes
hook_category_id
objectId
country_id
string
Yes
sender
string
content
string
Indexes
funnel_page_emails_ix_1
Create statement
db.funnel_page_sms.createIndex(
{
"acct_id": 1
},
{
name: "funnel_page_emails_ix_1"
}
)
funnel_page_emails_ix_2
Create statement
db.funnel_page_sms.createIndex(
{
"funnel_id": 1
},
{
name: "funnel_page_emails_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
country_id
string
Yes
country_code
string
mobile
string
created
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
country_id
string
Yes
num_mobiles
int
modified
bool
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
hook_id
objectId
Yes
intro
event_price_text
address_mode
string
address
banner_style
string
banner_slogan
banner_bg_color
string
banner_text_color
string
location
display_shop_opening_hours
bool
shop_opening_hours
show_reg_figures
string
Yes
form_display_type
string
redeem_start_datetime
date
redeem_end_datetime
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
hook_id
objectId
Yes
passcode
string
unit
string
created
date
modified
date
Name
page_user_hook_passcodes
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
hook_id
objectId
Yes
page_user_id
objectId
Yes
hook_passcode_id
objectId
Yes
passcode
string
unit
string
redeem_datetime
date
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
set_page_mvc_id
objectId
Yes
step
int
name
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
level
string
code
string
medium
string
type
string
cron_mode
string
cron_value
any
If cron_mode = 'D' => input time
if cron_mode = 'H' => input min (0-60)
name
description
string
edm_subject
edm_content
sms_content
mms_subject
mms_content
mms_image
mms_add_redeem_qr
bool
line_msg_type
line_flex_alt_text
line_json
editor_wrapper_class
string
html
main_css
section_css
followup_scenario_id
objectId
person_in_charge
string
acitve
bool
Name
funnel_page_followup_components
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
funnel_page_id
objectId
Yes
followup_component_id
objectId
Yes
seq
int
code
string
name
medium
string
edm_sender_id
objectId
edm_subject
edm_content
edm_cc
bool
edm_cc_emails
string
sms_sender
string
sms_content
mms_sender
string
mms_subject
mms_content
mms_image
mms_add_redeem_qr
bool
line_flex_alt_text
line_msg_type
line_json
scenario
string
Yes
active
bool
created
date
modified
date
Name
funnel_screenplay_followup_components
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
set_id
objectId
Yes
funnel_id
objectId
Yes
funnel_screenplay_id
objectId
Yes
followup_component_id
objectId
Yes
funnel_screenplay_set_id
objectId
Yes
funnel_screenplay_set_followup_id
objectId
Yes
seq
int
code
string
name
medium
string
edm_sender_id
objectId
edm_subject
edm_content
sms_sender
string
sms_content
mms_sender
string
mms_subject
mms_content
mms_image
mms_add_redeem_qr
bool
line_msg_type
line_flex_alt_text
line_json
page_html
page_main_css
page_section_css
person_in_charge
string
active
bool
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
line_campaign_id
objectId
type
string
name
string
keyword
string
Yes
msg_type
string
flex_alt_text
string
json
string
seq
int
delay
int
only use when campaign type = 'M'
delay_unit
string
only use when campaign type = 'M'
status
string
Validation
D - Draft
P - Published
created
date
modified
date
tags_to_remove
Yes
tags_to_add
Yes
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
funnel_id
objectId
type
string
timestamp_rand
string
file_url
string
row_num
int
num_of_rows
int
num_users
int
num_valid
int
num_invalid
int
num_duplciates
int
finished
bool
err_code
string
replace_method
string
mbr_level_id
objectId
Yes
mbr_expiry
date
mbr_status
string
PND - 待處理 (Pending)
EFF - 有效 (Effective)
INV - 無效 (Invalid)
DEF - 暫緩 (Deferred)
user_tags
string
Yes
ta_tags
string
Yes
created
date
modified
date
Name
import_massage_results
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
import_massage_id
objectId
Yes
xls_row
int
type
string
name
string
email
string
country_code
string
mobile
string
status
string
failure_code
string
desc_code
string
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
type
string
timestamp_rand
string
row_num
int
num_of_rows
int
finished
bool
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
sales_id
objectId
Yes
product_id
objectId
Yes
seq
int
created
date
modifeid
date
Name
line_welcome_messages
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
msg_type
string
flex_alt_text
string
json
string
seq
int
delay
int
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
name
string
type
string
status
string
step
int
tags
array
Yes
only use when campaign type = 'M'
cron_daily_trigger_time
string
num_subscribed
int
active
bool
only use when campaign type = 'M'
created
date
modified
date
Indexes
line_campaigns_ix_1
Create statement
db.line_campaigns.createIndex(
{
"acct_id": 1
},
{
name: "line_campaigns_ix_1"
}
)
line_campaigns_ix_2
Create statement
db.line_campaigns.createIndex(
{
"acct_id": 1,
"type": 1
},
{
name: "line_campaigns_ix_2"
}
)
line_campaigns_ix_3
Create statement
db.line_campaigns.createIndex(
{
"acct_id": 1,
"type": 1,
"modified": -1
},
{
name: "line_campaigns_ix_3"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
line_campaign_id
objectId
Yes
line_massage_id
objectId
Yes
line_release_id
objectId
Yes
schedule_send_seq
int
schedule_send_datetime
date
num_scheduled_users
int
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
line_campaign_id
objectId
Yes
num_users
int
num_valid
int
num_invalid
int
num_duplicates
int
num_unsubscribed
int
finished
bool
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
line_campaign_id
objectId
Yes
release_seq
int
send_method
string
status
string
ta_tags
string
delivery_datetime
date
created
date
modified
date
Indexes
edm_releases_ix_1
Create statement
db.line_releases.createIndex(
{
"acct_id": 1,
"edm_campaign_id": 1
},
{
name: "edm_releases_ix_1"
}
)
Name
line_broadcast_recipients
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
line_campaign_id
objectId
Yes
line_node_id
objectId
Yes
line_release_id
objectId
Yes
line_massage_id
objectId
Yes
delivery_datetime
date
line_user_id
string
params
string
Yes
description
string
created
date
modified
date
Indexes
edm_recipients_ix_1
Create statement
db.line_broadcast_recipients.createIndex(
{
"acct_id": 1
},
{
name: "edm_recipients_ix_1"
}
)
edm_recipients_ix_2
Create statement
db.line_broadcast_recipients.createIndex(
{
"edm_campaign_id": 1
},
{
name: "edm_recipients_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
line_campaign_id
objectId
Yes
num_releases
int
num_scheduled
int
created
date
modified
date
Indexes
edm_campaign_stats_ix_1
Create statement
db.line_campaign_stats.createIndex(
{
"acct_id": 1
},
{
name: "edm_campaign_stats_ix_1"
}
)
edm_campaign_stats_ix_2
Create statement
db.line_campaign_stats.createIndex(
{
"edm_campaign_id": 1
},
{
name: "edm_campaign_stats_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
line_campaign_id
objectId
Yes
line_node_id
objectId
Yes
line_user_id
string
tags
array
Yes
delay
int
delay_unit
string
pickup_datetime
date
delivery_datetime
date
start_datetime
date
created
date
modified
date
Indexes
edm_recipients_ix_1
Create statement
db.line_drip_recipients.createIndex(
{
"acct_id": 1
},
{
name: "edm_recipients_ix_1"
}
)
edm_recipients_ix_2
Create statement
db.line_drip_recipients.createIndex(
{
"edm_campaign_id": 1
},
{
name: "edm_recipients_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
edm_campaign_id
objectId
Yes
edm_node_id
objectId
Yes
email
string
tags
array
Yes
delay
int
delay_unit
string
pickup_datetime
date
delivery_datetime
date
start_datetime
date
created
date
modified
date
Indexes
edm_recipients_ix_1
Create statement
db.edm_drip_recipients.createIndex(
{
"acct_id": 1
},
{
name: "edm_recipients_ix_1"
}
)
edm_recipients_ix_2
Create statement
db.edm_drip_recipients.createIndex(
{
"edm_campaign_id": 1
},
{
name: "edm_recipients_ix_2"
}
)
Name
addon_product_options
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
sales_id
objectId
Yes
addon_product_id
objectId
Yes
product_id
objectId
Yes
product_option_id
objectId
Yes
price
double
default_entry
bool
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
sales_id
objectId
Yes
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
sales_id
objectId
Yes
product_id
objectId
Yes
seq
int
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
hook_id
objectId
Yes
banner_slogan
intro
offer_name
offer_image
show_offer_url
bool
offer_url
reg_limlit
int
show_reg_figures
array
Yes
display_opening_hours
bool
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
line_campaign_id
objectId
Yes
line_node_id
objectId
Yes
line_release_id
objectId
Yes
all_br
bool
all_dr
bool
dr_campaign_id
objectId
Yes
email
string
status
string
ab_status
string
desc_code
string
created
date
modified
date
Indexes
edm_unsend_lists_ix_1
Create statement
db.line_unsend_lists.createIndex(
{
"acct_id": 1
},
{
name: "edm_unsend_lists_ix_1"
}
)
edm_unsend_lists_ix_2
Create statement
db.line_unsend_lists.createIndex(
{
"acct_id": 1,
"email": 1,
"type": 1
},
{
name: "edm_unsend_lists_ix_2"
}
)
edm_unsend_lists_ix_3
Create statement
db.line_unsend_lists.createIndex(
{
"acct_id": 1,
"type": 1
},
{
name: "edm_unsend_lists_ix_3"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
name
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
shipper_id
objectId
name
string
delviery_method
string
active
bool
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
set_id
objectId
Yes
page_type_id
string
Yes
set_page_template_id
objectId
Yes
seq
int
editor_wrapper_class
string
html
main_css
section_css
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
set_id
objectId
Yes
name
seq
int
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
sys_screenplay_id
objectId
Yes
set_id
objectId
Yes
seq
int
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
controller
string
Name
funnel_screenplay_sets
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
funnel_screenplay_id
objectId
Yes
set_id
objectId
Yes
set_page_template_id
objectId
Yes
seq
int
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
set_page_mvc_id
objectId
Yes
type
string
sender
string
message
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
name
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
set_id
objectId
Yes
followup_scenario_id
objectId
Yes
seq
int
followup_component_id
objectId
Yes
Yes
Name
funnel_screenplay_set_followups
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
funnel_id
objectId
Yes
funnel_screenplay_id
objectId
Yes
funnel_screenplay_set_id
objectId
Yes
followup_scenario_id
objectId
Yes
seq
string
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
hook_id
objectId
Yes
form_display_type
string
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
sys_shipper_id
objectId
Yes
name
string
delivery_method
string
Name
sys_shipping_countries
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
name
Name
sys_shipping_provinces
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
sys_shipping_country_id
objectId
Yes
name
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
sys_shipping_country_id
objectId
Yes
sys_shipping_province_id
objectId
name
Name
sys_shipping_districts
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
sys_shipping_country_id
objectId
Yes
sys_shipping_province_id
objectId
sys_shipping_city_id
objectId
name
Name
sys_sp_shipping_venues
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
sys_shipper_id
objectId
Yes
sys_shipping_group_id
objectId
Yes
name
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
name
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
shipping_country_id
objectId
Yes
name
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
shipping_country_id
objectId
Yes
shipping_province_id
objectId
name
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
shipping_country_id
objectId
Yes
shipping_province_id
objectId
shipping_city_id
objectId
name
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
shipper_id
objectId
Yes
shipping_group_id
objectId
Yes
name
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
set_id
objectId
Yes
page_type_id
string
Yes
seq
int
name
description
action_nature
string
tags
array
Yes
followup_component_id
objectId
Yes
Yes
set_page_mvc_id
objectId
Yes
set_page_mvc_feature_id
string
Yes
Yes
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
export_file_id
objectId
Yes
is_writing_results
bool
num_of_rows
int
row_num
int
timestamp_rand
string
download_center
bool
created
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
type
string
desc_params
string
export_in_progress
bool
filename
string
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
code
string
name
description
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
name
description
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
name
description
qualifications
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
res_venue_id
objectId
res_facility_id
objectId
res_professional_id
objectId
funnel_id
objectId
Yes
funnel_page_id
objectId
Yes
page_user_id
objectId
Yes
name
start_datetime
date
end_datetime
date
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
method
string
path
string
status
string
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
hook_id
objectId
Yes
banner_slogan
main_image
show_reg_figures
string
Yes
res_venue_id
objectId
Yes
res_venue_label
res_facilitiy_id
objectId
Yes
res_facility_label
res_professional_id
objectId
Yes
res_professional_label
timeslot_duration
int
timeslot_duration_unit
string
days_open
int
days_close
int
timeslots
excl_cond
Yes
exempt_excl_cond
Yes
Name
set_page_mvc_features
Fields
Name
Data type
Array
Key
Required
_id
string
Yes
Yes
set_page_mvc_id
objectId
Yes
card_title
card_subtitle
Name
set_page_spec_features
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
set_id
objectId
Yes
set_page_spec_id
objectId
Yes
set_page_mvc_feature_id
objectId
Yes
Name
advanced_search_result_emails
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
advanced_search_id
objectId
Yes
email
string
user_created
date
created
date
Name
tmp_edm_broadcast_recipients
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
edm_campaign_id
objectId
Yes
edm_node_id
objectId
Yes
edm_massage_id
objectId
Yes
email
string
params
string
Yes
delivery_status
string
delivery_failure_code
string
desc_code
string
created
date
modified
date
Indexes
edm_recipients_ix_1
Create statement
db.tmp_edm_broadcast_recipients.createIndex(
{
"acct_id": 1
},
{
name: "edm_recipients_ix_1"
}
)
edm_recipients_ix_2
Create statement
db.tmp_edm_broadcast_recipients.createIndex(
{
"edm_campaign_id": 1
},
{
name: "edm_recipients_ix_2"
}
)
Name
tmp_line_broadcast_recipients
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
line_campaign_id
objectId
Yes
line_node_id
objectId
Yes
line_release_id
objectId
Yes
line_massage_id
objectId
Yes
line_user_id
string
params
string
Yes
description
string
created
date
modified
date
Indexes
edm_recipients_ix_1
Create statement
db.tmp_line_broadcast_recipients.createIndex(
{
"acct_id": 1
},
{
name: "edm_recipients_ix_1"
}
)
edm_recipients_ix_2
Create statement
db.tmp_line_broadcast_recipients.createIndex(
{
"edm_campaign_id": 1
},
{
name: "edm_recipients_ix_2"
}
)
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
notation
string
lname
description
service_period
int
service_period_unit
string
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
name
string
Yes
redirect_url
runtime_medium
string
liff_id
string
line_friend_only
bool
need_login
bool
granted_mbr_level_id
objectId
Yes
authourize_channel
string
Yes
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
type
string
html
main_css
section_css
Name
acct_membership_pages
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
type
string
html
main_css
section_css
created
date
modified
date
Name
edm_service_rate_cards
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
tier
int
len
int
fee
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
date
date
credit
int
debit
int
balance
int
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
date
date
credit
double
debit
double
balance
double
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
sender
string
country_code
string
mobile
string
content
string
params
string
Yes
callback_url
string
ref_id
string
version
string
ip
string
swnd_also_ofca_registers
bool
status
string
delivery_status
string
delivery_failure_code
string
callback_status
string
callback_reason_code
string
desc_code
string
description
string
stat_datetime
date
word_count
int
sms_count
int
unit_cost
double
total_cost
double
api_ref
string
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
seq
int
type
string
fieldname
string
label
created
date
modified
date
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
date
date
type
string
Yes
name
string
quota
int
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
date
date
type
string
Yes
name
string
seq
int
ref_id
string
num_sent
int
num_sms_sent
int
points
int
Name
edm_balance_breakdowns
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
date
date
type
string
Yes
AQ - Add Quota
DQ - Deduct Quota
M - Mockup
R - Release
S - Scheduled
CS - Cancel Schedule
O - Others
description
string
credit
int
debit
int
balance
int
Name
point_balance_breakdowns
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
acct_id
objectId
Yes
date
date
type
string
Yes
AP - Add Points
DP - Deduct Points
M - Mockup
R - Release
S - Scheduled
CS - Cancel Schedule
O - Others
description
string
credit
int
debit
int
balance
int
documents
Fields
Name
Data type
Array
Key
Required
name
d22f6ed9-133d-489c-b8ae-62f00d80d20b
description
d22f6ed9-133d-489c-b8ae-62f00d80d20b
price
string
type
string
Fields
Name
Data type
Array
Key
Required
page_id
string
Fields
Name
Data type
Array
Key
Required
title
d22f6ed9-133d-489c-b8ae-62f00d80d20b
image
d22f6ed9-133d-489c-b8ae-62f00d80d20b
description
d22f6ed9-133d-489c-b8ae-62f00d80d20b
submit_btn
Fields
Name
Data type
Array
Key
Required
text
d22f6ed9-133d-489c-b8ae-62f00d80d20b
text_color
string
btn_bg_color
string
Name
hook_share_luckydraw_result_settings
Fields
Name
Data type
Array
Key
Required
annouce_date
date
handling_mehod
int
Fields
Name
Data type
Array
Key
Required
image
d22f6ed9-133d-489c-b8ae-62f00d80d20b
title
d22f6ed9-133d-489c-b8ae-62f00d80d20b
description
d22f6ed9-133d-489c-b8ae-62f00d80d20b
Fields
Name
Data type
Array
Key
Required
method
string
thank_you_text
d22f6ed9-133d-489c-b8ae-62f00d80d20b
Name
hook_free_sample_page_layout
Fields
Name
Data type
Array
Key
Required
title
d22f6ed9-133d-489c-b8ae-62f00d80d20b
submit_btn
Fields
Name
Data type
Array
Key
Required
id
string
user_id
string
subdomain
string
domain
string
username
string
ips
array
custom_spf
bool
default
bool
legacy
bool
automatic_security
bool
valid
bool
dns
Fields
Name
Data type
Array
Key
Required
mail_cname
dkim1
dkim2
Fields
Name
Data type
Array
Key
Required
valid
bool
type
string
host
string
data
string
Fields
Name
Data type
Array
Key
Required
active
bool
text
string
Fields
Name
Data type
Array
Key
Required
social_media
string
Yes
online
Yes
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
tc
sc
en
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
country_code
string
tel
string
Fields
Name
Data type
Array
Key
Required
active
bool
url
string
Fields
Name
Data type
Array
Key
Required
active
bool
url
string
Fields
Name
Data type
Array
Key
Required
active
bool
url
string
Fields
Name
Data type
Array
Key
Required
active
bool
url
string
Fields
Name
Data type
Array
Key
Required
active
bool
url
string
Fields
Name
Data type
Array
Key
Required
active
bool
url
string
Fields
Name
Data type
Array
Key
Required
active
bool
url
string
Fields
Name
Data type
Array
Key
Required
active
bool
url
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
site
string
creator
string
Fields
Name
Data type
Array
Key
Required
image
title
description
twit
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
price_id
string
Fields
Name
Data type
Array
Key
Required
plan_id
string
Fields
Name
Data type
Array
Key
Required
amt
double
stripe
paypal
Fields
Name
Data type
Array
Key
Required
price_id
string
Fields
Name
Data type
Array
Key
Required
plan_id
string
Fields
Name
Data type
Array
Key
Required
amt
double
stripe
paypal
Fields
Name
Data type
Array
Key
Required
price_id
string
Fields
Name
Data type
Array
Key
Required
plan_id
string
Fields
Name
Data type
Array
Key
Required
amt
double
stripe
paypal
Fields
Name
Data type
Array
Key
Required
HKD
TWD
USD
Fields
Name
Data type
Array
Key
Required
price_id
string
Fields
Name
Data type
Array
Key
Required
plan_id
string
Fields
Name
Data type
Array
Key
Required
amt
double
stripe
paypal
Fields
Name
Data type
Array
Key
Required
price_id
string
Fields
Name
Data type
Array
Key
Required
plan_id
string
Fields
Name
Data type
Array
Key
Required
amt
double
stripe
paypal
Fields
Name
Data type
Array
Key
Required
price_id
string
Fields
Name
Data type
Array
Key
Required
plan_id
string
Fields
Name
Data type
Array
Key
Required
amt
double
stripe
paypal
Fields
Name
Data type
Array
Key
Required
HKD
TWD
USD
Fields
Name
Data type
Array
Key
Required
dir
string
bucket
string
Fields
Name
Data type
Array
Key
Required
monthly_register
int
accumulate_users
int
edm_low_balance
double
sms_low_balance
double
Fields
Name
Data type
Array
Key
Required
account_name
string
api_key
string
Fields
Name
Data type
Array
Key
Required
sms
mms
Fields
Name
Data type
Array
Key
Required
page_id
string
Fields
Name
Data type
Array
Key
Required
page_id
string
Fields
Name
Data type
Array
Key
Required
reg_no_prefix
string
reg_no_base
int
Fields
Name
Data type
Array
Key
Required
order_no_prefix
string
order_no_base
int
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
price_id
string
Fields
Name
Data type
Array
Key
Required
plan_id
string
Fields
Name
Data type
Array
Key
Required
amt
double
stripe
paypal
Fields
Name
Data type
Array
Key
Required
price_id
string
Fields
Name
Data type
Array
Key
Required
plan_id
string
Fields
Name
Data type
Array
Key
Required
amt
double
stripe
paypal
Fields
Name
Data type
Array
Key
Required
price_id
string
Fields
Name
Data type
Array
Key
Required
plan_id
string
Fields
Name
Data type
Array
Key
Required
amt
double
stripe
paypal
Fields
Name
Data type
Array
Key
Required
HKD
TWD
USD
Fields
Name
Data type
Array
Key
Required
price_id
string
Fields
Name
Data type
Array
Key
Required
plan_id
string
Fields
Name
Data type
Array
Key
Required
amt
double
stripe
paypal
Fields
Name
Data type
Array
Key
Required
price_id
string
Fields
Name
Data type
Array
Key
Required
plan_id
string
Fields
Name
Data type
Array
Key
Required
amt
double
stripe
paypal
Fields
Name
Data type
Array
Key
Required
price_id
string
Fields
Name
Data type
Array
Key
Required
plan_id
string
Fields
Name
Data type
Array
Key
Required
amt
double
stripe
paypal
Fields
Name
Data type
Array
Key
Required
HKD
TWD
USD
Fields
Name
Data type
Array
Key
Required
payment_method
string
id
string
status
string
A -- Active
C - Cancelled
customer_id
string
charge_id
string
Stripe only, for refund if needed
txn_id
string
PayPal only, for refund if needed
internal_test
string
Fields
Name
Data type
Array
Key
Required
process_type
string
buyer_id
string
buyer_name
string
buyer_address
string
carrier_type
string
carrier_id_1
string
carrier_id_2
string
print_mark
bool
notify_email
string
Fields
Name
Data type
Array
Key
Required
statusCode
string
statusDesc
string
respData
string
invNo
string
invDate
string
invTime
string
randomNumber
string
Fields
Name
Data type
Array
Key
Required
start_date
date
end_date
date
length
int
Fields
Name
Data type
Array
Key
Required
valid
bool
type
string
host
string
data
string
Fields
Name
Data type
Array
Key
Required
valid
bool
type
string
host
string
data
string
Fields
Name
Data type
Array
Key
Required
valid
bool
type
string
host
string
data
string
Fields
Name
Data type
Array
Key
Required
mail_cname
dkim1
dkim2
Fields
Name
Data type
Array
Key
Required
id
int
user_id
int
subdomain
string
domain
string
username
string
ips
array
custom_apf
bool
default
bool
legacy
bool
automatic_security
bool
valid
bool
dns
Fields
Name
Data type
Array
Key
Required
HKD
double
TWD
double
USD
double
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
HKD
double
TWD
double
USD
double
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
label
active
bool
required
bool
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
label
active
bool
required
bool
Fields
Name
Data type
Array
Key
Required
email
mobile
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
label
active
bool
required
bool
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
label
active
bool
required
bool
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
label
active
bool
required
bool
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
label
active
bool
required
bool
Fields
Name
Data type
Array
Key
Required
name
address
gender
birthday
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
value
string
label
Fields
Name
Data type
Array
Key
Required
bdate
date
byear
int
bmonth
int
bday
int
age
int
Fields
Name
Data type
Array
Key
Required
type
string
campaign_id
objectId
Fields
Name
Data type
Array
Key
Required
type
string
campaign_id
objectId
Fields
Name
Data type
Array
Key
Required
active
bool
business
string
Fields
Name
Data type
Array
Key
Required
active
bool
publishable_key
string
secret_key
string
payment_methods
string
Yes
Fields
Name
Data type
Array
Key
Required
active
bool
sign_key
string
secret_key
string
Fields
Name
Data type
Array
Key
Required
user_confirm_key
string
secret
string
active
bool
Fields
Name
Data type
Array
Key
Required
user_confirm_key
string
secret
string
active
bool
Fields
Name
Data type
Array
Key
Required
user_confirm_key
string
secret
string
active
bool
Fields
Name
Data type
Array
Key
Required
alipay_hk
alipay
wechat_pay
Fields
Name
Data type
Array
Key
Required
active
bool
hash_key
string
hash_iv
string
merchant_id
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
terms
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
css
string
minified
string
url
string
Fields
Name
Data type
Array
Key
Required
css
string
minified
string
url
string
Fields
Name
Data type
Array
Key
Required
css
string
minified
string
url
string
Fields
Name
Data type
Array
Key
Required
css
string
minified
string
url
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
lat
double
lng
double
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
cond
Yes
filter
Yes
exclude
Yes
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
label
active
bool
required
bool
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
label
active
bool
required
bool
Fields
Name
Data type
Array
Key
Required
email
mobile
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
label
active
bool
required
bool
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
label
active
bool
required
bool
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
label
active
bool
required
bool
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
label
active
bool
required
bool
Fields
Name
Data type
Array
Key
Required
name
address
gender
birthday
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
datietime
date
source
string
device
string
user_agent
string
country_id
string
Fields
Name
Data type
Array
Key
Required
cc
bool
paypal
bool
alipay_hk
bool
alipay
bool
wechat_pay
bool
tap_and_go
bool
Fields
Name
Data type
Array
Key
Required
cc
string
paypal
string
alipay_hk
string
alipay
string
wechat_pay
string
tap_and_go
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
lat
string
lng
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
account_name
string
api_key
string
Fields
Name
Data type
Array
Key
Required
account_name
string
api_key
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
sc
en
Fields
Name
Data type
Array
Key
Required
tc
sc
en
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
sc
en
Fields
Name
Data type
Array
Key
Required
tc
sc
en
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
filename
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
filename
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
filename
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
filename
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
filename
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
filename
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
filename
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
filename
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
filename
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
name
period_mode
string
show_time
bool
start_datetime
date
end_datetime
date
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
login
messaging
Fields
Name
Data type
Array
Key
Required
client_id
string
secret
string
Fields
Name
Data type
Array
Key
Required
secret
string
bot_basic_id
string
access_tolen
string
Fields
Name
Data type
Array
Key
Required
user_id
string
pic
string
auth_time
string
Fields
Name
Data type
Array
Key
Required
user_id
string
Fields
Name
Data type
Array
Key
Required
user_id
string
Fields
Name
Data type
Array
Key
Required
user_id
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
img
doc
video
Fields
Name
Data type
Array
Key
Required
active
bool
file_size
int
Fields
Name
Data type
Array
Key
Required
active
bool
file_size
int
Fields
Name
Data type
Array
Key
Required
active
bool
file_size
int
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
value
string
Fields
Name
Data type
Array
Key
Required
value
string
Fields
Name
Data type
Array
Key
Required
value
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
sun
mon
tue
wed
thu
fri
sat
Fields
Name
Data type
Array
Key
Required
active
bool
boundaries
Yes
Fields
Name
Data type
Array
Key
Required
start
string
end
string
Fields
Name
Data type
Array
Key
Required
active
bool
boundaries
Yes
Fields
Name
Data type
Array
Key
Required
start
string
end
string
Fields
Name
Data type
Array
Key
Required
active
bool
boundaries
Yes
Fields
Name
Data type
Array
Key
Required
start
string
end
string
Fields
Name
Data type
Array
Key
Required
active
bool
boundaries
Yes
Fields
Name
Data type
Array
Key
Required
start
string
end
string
Fields
Name
Data type
Array
Key
Required
active
bool
boundaries
Yes
Fields
Name
Data type
Array
Key
Required
start
string
end
string
Fields
Name
Data type
Array
Key
Required
active
bool
boundaries
Yes
Fields
Name
Data type
Array
Key
Required
start
string
end
string
Fields
Name
Data type
Array
Key
Required
active
bool
boundaries
Yes
Fields
Name
Data type
Array
Key
Required
start
string
end
string
Fields
Name
Data type
Array
Key
Required
date
date
res_venue_id
objectId
res_professional_id
objectId
Fields
Name
Data type
Array
Key
Required
date
date
res_venue_id
objectId
res_professional_id
objectId
Fields
Name
Data type
Array
Key
Required
url
string
bucket
string
object
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
HKD
double
TWD
double
USD
double
Fields
Name
Data type
Array
Key
Required
tc
string
sc
string
en
string
Fields
Name
Data type
Array
Key
Required
Fields
Name
Data type
Array
Key
Required
Fields
Name
Data type
Array
Key
Required
type
string
match_text
string
criterias
Fields
Name
Data type
Array
Key
Required
Fields
Name
Data type
Array
Key
Required
type
string
match_text
string
criterias
Fields
Name
Data type
Array
Key
Required
Fields
Name
Data type
Array
Key
Required
type
string
match_text
string
criterias
Fields
Name
Data type
Array
Key
Required
references
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
one
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
Many to
one
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
one
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
one
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
one
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
Many to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
hook_voting_item_cat_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
one
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
hook_voting_item_cat_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
hook_voting_item_cat_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
hook_voting_item_cat_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
followup_component_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
followup_component_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
funnel_screenplay_set_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
funnel_screenplay_set_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
followup_component_id
Name
Source
Target
Cardinality type:
Many to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
funnel_screenplay_set_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
funnel_screenplay_set_followup_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
followup_scenariio_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
sys_shipping_country_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
sys_shipping_country_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
sys_shipping_province_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
sys_shipping_country_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
sys_shipping_province_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
sys_shipping_group_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
sys_shipping_group_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
sys_sp_shipping_venue_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
sys_shipping_country_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
sys_shipping_province_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
sys_shipping_district_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
sys_shipping_group_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
sys_shipping_country_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
sys_shipping_province_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
sys_shipping_district_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
followup_component_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
one
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
set_page_mvc_feature_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
set_page_mvc_features_set_page_specs
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
advanced_searches_advanced_search_result_emails
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Lines
Line name
note4-sys_screenplays
Line name
order_invoice-order_invoices
Line name
order_payments-order_payments
Line name
followup_components-followup_components
Line name
followup_components-funnel_page_followup_components
Notes
Note
multilingual field only occurs when data_type = TB or TA
options fieild only occures when data_type = SB or CB
Note
hook_strategy and sales_strategy values will be copied to funnel instead of funnel_screenplay
Note
conversion_end_datetime will be updated when hook's end_datetime changed.
Note
payment_medhod:
- CC - Credit Card
- EP - Electronic Payment
- BT - Bank Transfer
- PM - Payme
- COD - Cash o Delivery
- WE - Wechat Pay
- ALIPAY - Alipay
- ALIPAY-HK - Alipay HK
- TG - Tap and Go
payment_status:
- P - Pending
- PIP - Payment in Progress
- WV - Wating Verify
- WP - Waiting Payment
- S - Settled
- C - Cancelled
delivery_method:
- OD - Online Deliver
- SP - Self Pickup
- DD - Direct Deliver
delivery_status:
- SYS: 系統自動出貨 (System automatically shipped)
- ULS: 未出貨 (Unshipped)
- PRG: 處理中 (Processing)
- SNT: 已出貨 (Sent)
- CNC: 訂單取消 / 不成立 (Cancelled/Not Established)
- REF: 退款 / 退貨 (Refund/Return)
- CLS: 已結案 (Closed)
order_status:
discount_type:
- AD - Actual Deduction
- PO - Percentage Off
Note
edm_* fields: only appear when medium = edm
sms_* fields: only appear when medium = sms
mms_* fields: only appear when medium = mms
line_* fields: only appear when medium = line
html, main_css, section_css: only appear when medium = page
