Report for crm_dev2 made in Moon Modeler

first_time_funnel_briefed (object)

Name

accts

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

country_id

string

Yes

currency_id

string

Yes

service_plan_id

objectId

Yes

acct_start_date

date

edm_end_date

date

funnel_end_date

date

billing_cycle

string

funnel_next_renewal_date

date

funnel_unsubscribed

bool

name

string

company

string

first_time_funnel_briefed

bool

tel

tel (object)

address

string

type

string

tax_id_number

string

cs_email

string

website

string

partner_id

objectId

Yes

business_hours

string

about_us

string

logo

logo (object)

dark_bg_logo

dark_bg_logo (object)

facebook

instagram

line

medium

tiktok

twitter

youtube

show_powered_by

bool

line_share_liff_id

string

line_share_oa

line_share_oa (object)

scope

string

Yes

is_master_template_acct

bool

enable_ai_translate

bool

first_time_funnel_briefed

created

date

modified

date

References

Name

Source

Target

payment_method_gateways

acct_membership_pages

edm_balance_breakdowns

point_balance_breakdowns

membership_daily_reminders

membership_payment_settings

membership_identity_settings

acct_auto_charge_profiles

acct_auto_charge_scenarios

acct_auto_charge_logs

need_retry_auto_charges

whatsapp_chat_messages

bulk_update_operations

ai_credit_balance_breakdowns

invitation_greeting (object)

Name

acct_x_users

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

x_user_id

objectId

Yes

owner

bool

role

string

status

string

created

date

modified

date

References

Name

Source

Target

Name

x_users

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

user_id

int

avatar

string

name

string

country_code

string

mobile

string

status

string

activation_key

string

activation_datetime

date

reg_medium

string

last_login

date

reset_password_link_end_datetime

string

created

date

modified

date

References

Name

Source

Target

Name

funnels

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

funnel_strategy_id

objectId

Yes

name

string

event_name

event_name (object)

sharing

sharing (object)

invitation_greeting

cs_active

bool

has_member_area

bool

step

int

status

string

Yes

active

bool

conversion_end_datetime

date

Description

conversion_end_datetime will be updated when hook's end_datetime changed.

langs

string

Yes

one_page

bool

start_register

string

start_datetime

date

evergreen

string

evergreen_funnel_id

objectId

end_register

string

end_datetime

date

countdown_to_start

bool

countdown_to_end

bool

staff_scan

string

runtime_medium

string

line_friend_only

bool

granted_mbr_level_id

objectId

Yes

need_login

bool

authorize_channel

string

Yes

liff_id

string

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"
}
)

References

Name

Source

Target

Name

page_users

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

country_code

string

mobile

string

gender

string

address

string

custom_fields

object

source

string

join_medium

string

line

internaltest

string

lang

string

submission_status

string

Description

P - Pending C - Completed

play_status

string

Description

used in redemption game page

grade_result

any

Description

used in hook_surveys int if hook_surveys.evaluation_approach - 'scoring' string if hook_surveys.evaluation_approach - 'categorization'

order_amount

order_amount (object)

Description

key: currency_id value: amount

reg_num

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"
}
)

References

Name

Source

Target

Name

page_user_activities

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

visit_footprint (object)

Yes

created

date

modified

date

References

Name

Source

Target

Name

funnel_screenplays

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

sys_screenplay_theme_id

objectId

Yes

acct_id

objectId

Yes

funnel_id

objectId

Yes

funnel_type_id

string

Yes

title

title (object)

followup_spec

followup_spec (object)

feature_spec

feature_spec (object)

theme

theme (object)

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"
}
)

Name

service_plans

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

mms_personalized_promo

bool

line_personalized_promo

bool

whatsapp_personalized_promo

bool

max_abandon_cart_notifications

int

unllimited_abandon_cart_notifications

bool

monthly_fee

monthly_fee (object)

yearly_fee

yearly_fee (object)

project_plan

bool

scope

string

Yes

References

Name

Source

Target

Name

countries

Fields

Name

Data type

Array

Key

Required

_id

string

Yes

country_code

string

continent_id

string

name_en

string

name_tc

string

name_sc

string

rank

int

active

bool

References

Name

Source

Target

Name

acct_settings

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

ufo_acct_id

ufo_acct_id (object)

Yes

favicon

favicon (object)

threshold

threshold (object)

fb_pixel

string

gtm

string

url_slug

string

timezone

string

drip

hook

sales

member

getbutton_script

string

lms_id

string

line

service_plan_name (object)

whatsapp (object)

default_lang

string

api_key

string

callback_url

string

langs

string

Yes

expired_default_status

string

Validation

I - Inactive S - Suspended P - Pending

login_redirect_action

string

login_redirect_url

string

jwt_secret_key

string

membership_module

bool

user_index_columns

string

Yes

Indexes

acct_settings_ix_1

Create statement

db.acct_settings.createIndex(
{
"acct_id": 1
},
 {
name: "acct_settings_ix_1"
}
)

References

Name

Source

Target

Name

acct_subscriptions

Description

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

acct_id

objectId

Yes

payment_history_id

objectId

Yes

service_plan_id

objectId

Yes

service_plan_name

start_date

date

end_date

date

subscription

string

monthly_fee

monthly_fee (object)

yearly_ssee

yearly_ssee (object)

pg_info

pg_info (object)

created

date

Description

When renew / upgrade plan, create one more entry for this account with new created date

Indexes

acct_services_ix_1

Create statement

db.acct_subscriptions.createIndex(
{
"acct_id": 1,
},
 {
name: "acct_services_ix_1"
}
)

acct_services_ix_2

Create statement

db.acct_subscriptions.createIndex(
{
"subscription.id": 1
},
 {
name: "acct_services_ix_2"
}
)

References

Name

Source

Target

Name

payment_histories

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

country_id

string

Yes

payment_type

string

service_type

string

invoice_num

string

receipt_num

string

currency_id

string

Yes

currency_rate

double

purchase_amt

double

service_fee

double

service_fee_percent

double

refund

double

order_total

double

Description

order_total = purchase_amt + service_fee, not including tax

tax_percent

double

Description

tax is based on order_total to calculate

tax_amt

double

Description

tax is based on order_total to calculate

final_amt

double

payment_method

string

Description

cc - Credit Card ep - Electronic Payment bt - Bank Transfer pm - Payme cod - Cash on Delivery we - WeChat Pay alipay - Alipay alipay-hk - Alipay HK tg - Tap and Go pp - PayPal

payment_gateway

string

payment_status

string

Description

P - Pending PIP - Payment in Progress WP - Waiting Payment WV - Waiting Verify S - Settled C - Cancelled

txn_id

string

payment_datetime

date

issue_tw_invoice

bool

tw_invoice

tw_invoice (object)

tw_invoice_callback

tw_invoice_callback (object)

service_plan_id

objectId

Yes

service_plan_info

service_plan_info (object)

Description

Only when type = funnel_subscription

edm_quota

int

edm_service_length

int

edm_end_date

date

Description

For edm_service_length

sms_points

int

billing_cycle

string

internal_test

string

description

string

stripe

stripe (object)

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(
)

References

Name

Source

Target

Name

currencies

Fields

Name

Data type

Array

Key

Required

_id

string

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"
}
)

Name

acct_user_tags

Fields

Name

Data type

Array

Key

Required

_id

objectId

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"
}
)

References

Name

Source

Target

acct_user_tags

Name

edm_domain_auths

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

domain

string

dkim_selector

string

status

string

Description

PE: Action required, please authorize this domain to send bulk emails FA: Failed VE: Sender domain has been verified

sg_data

sg_data (object)

ip_pool

string

created

date

modified

date

References

Name

Source

Target

ttl_sales_amount (object)

edm_domain_auths

Name

acct_stats

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

remaining_ai_points

double

ttl_sales_amount

Description

key: currency_id value: amount

created

date

modified

date

Indexes

acct_stats_ix_1

Create statement

db.acct_stats.createIndex(
{
"acct_id": 1
},
 {
name: "acct_stats_ix_1"
}
)

References

Name

Source

Target

acct_stats

Name

custom_domains

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

name

string

default

bool

status

string

Description

S: 已綁定 P: 正在設置中… F: 錯誤：請聯絡網絡管理員'

cloudflare_turnstile_id

string

Yes

Description

cloudflare acct_id

cloudflare_turnstile_site_key

string

created

date

modified

date

References

Name

Source

Target

cloudflare_turnstile_id

cloudflare_turnstiles

Name

edm_rate_cards

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

tier

int

quota

int

fee

fee (object)

Name

timezones

Fields

Name

Data type

Array

Key

Required

_id

string

Yes

GMT

string

name

country_id

string

Yes

References

Name

Source

Target

timezones

Name

point_rate_cards

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

tier

int

points

double

fee

string

Name

sms_costs

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

country_code

string

points

double

Name

hooks

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

set_id

objectId

Yes

funnel_screenplay_id

objectId

Yes

funnel_page_id

objectId

Yes

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"
}
)

Name

hook_sessions

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

hook_id

objectId

Yes

seq

int

name

subtitle

subtitle (object)

period_mode

string

show_time

bool

start_datetime

date

end_datetime

date

quota_control

string

Description

N - 沒有限制人數 A - 全場接受報名人數 T - 分門票接受報名人數

quota

int

show_remaining_quota

bool

threshold

int

show_actual_registrars

bool

fees

fees (object)

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"
}
)

References

Name

Source

Target

ttl_sales_amount (object)

Name

funnel_stats

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

funnel_id

objectId

Yes

num_online_sources

int

num_visitors

int

ttl_visitors

int

num_pages

int

num_users

int

num_reorder_users

int

num_new_customers

int

num_old_customers

int

ttl_sales_amount

Description

key: currency_id value: amount

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"
}
)

References

Name

Source

Target

Name

page_stats

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

funnel_id

objectId

Yes

funnel_page_id

objectId

Yes

num_visitors

int

ttl_visitors

int

num_users

int

ttl_sales_amount

ttl_sales_amount (object)

Description

key: currrency_id value: amount

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"
}
)

References

Name

Source

Target

Name

acct_users

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

entry_funnel_id

objectId

entry_funnel_name

string

name

string

country_code

string

mobile

string

gender

string

address

string

birthday

birthday (object)

user_tags

string

Yes

ta_tags

string

Yes

delivery_tags

delivery_tags (object)

Yes

cust_field_tags

string

Yes

recipient_tags

recipient_tags (object)

Yes

accumulated_order_amt

accumulated_order_amt (object)

Yes

last_sales_created

date

status

string

Description

IMP: 未參與漏斗活動 (inactive_member_progressing, not joined any hook or sales) HOC: 行銷上鉤 (hook_converted, joined hook) SAC: 轉化成交 (sales_converted, paid)

join_medium

string

Description

admin 管理員加入 webpage 漏斗加入 line LINE 加入 api API 加入

line

mbr_level_id

objectId

mbr_num

string

mbr_fee

double

mbr_join_date

date

mbr_expiry

date

mbr_status

string

Description

P - 待處理 (Pending) A - 有效 (Effective) I - 無效 (Invalid) S - 暫緩 (Deferred) PIP - 付款進行中 (Payment in Progress)

mbr_payment_date

date

custom_fields

custom_fields (object)

edm_subscribed

string

Description

N - Not subscribed S - Subscribed U - Unsubscribed

remark

string

reset_password_link_end_datetime

string

source

string

referrer

string

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"
}
)

Name

funnel_users

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

funnel_id

objectId

Yes

name

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"
}
)

References

Name

Source

Target

Name

payment_settings

Fields

Name

Data type

Array

Key

Required

_id

objectId

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"
}
)

References

Name

Source

Target

payment_settings

Name

shorten_link_mappings

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

References

Name

Source

Target

Name

acct_tandc

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

privacy

privacy (object)

sales_terms

sales_terms (object)

terms

terms (object)

Indexes

acct_tandc_ix_1

Create statement

db.acct_tandc.createIndex(
{
"acct_id": 1
},
 {
name: "acct_tandc_ix_1"
}
)

References

Name

Source

Target

acct_tandc

Name

acct_ta_tags

Fields

Name

Data type

Array

Key

Required

_id

objectId

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"
}
)

References

Name

Source

Target

tinymce_minified (object)

acct_ta_tags

Name

master_contents

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

hook_erms

hook_erms (object)

sales_terms

sales_terms (object)

privacy

privacy (object)

Name

page_css

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

editor

editor (object)

tinymce

tinymce (object)

tinymce_minified

xlead

xlead (object)

Name

hook_votings

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

hook_id

objectId

Yes

enable_main_banner

bool

num_votes_allowed

int

force_vote_all_cat

bool

allow_daily_vote

bool

item_result_mode

string

show_result_before_vote

bool

show_result_after_vote

bool

user_verify_format

string

enable

string

Indexes

hook_votings_ix_1

Create statement

db.hook_votings.createIndex(
{
"acct_id": 1,
"hook_id": 1
},
 {
name: "hook_votings_ix_1"
}
)

References

Name

Source

Target

Name

hook_voting_items

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

hook_id

objectId

Yes

hook_voting_item_cat_id

objectId

seq

int

name

subtitle

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"
}
)

References

Name

Source

Target

Name

hook_voting_item_cats

Fields

Name

Data type

Array

Key

Required

_id

objectId

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"
}
)

References

Name

Source

Target

event_price_text (object)

Name

hook_events

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

hook_id

objectId

Yes

event_price_text

reg_limit

int

address

description

show_reg_figures

array

Yes

location

location (object)

waiting_list

bool

approval

bool

checkin

bool

checkin_users

string

checkin_method

string

Yes

location_type

string

Yes

one_session_display

bool

reg multiple_sessions

bool

reg_multiple_times

bool

reg_multiple_participants

bool

num_partipants

int

requires_friend_contacts

bool

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"
}
)

References

Name

Source

Target

Name

page_banners

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

page_type

string

membership_page_type

string

funnel_id

objectId

Yes

funnel_page_id

objectId

Yes

image

image (object)

tablet_img

tablet_img (object)

mobile_img

mobile_img (object)

Indexes

hook_main_banners_ix_1

Create statement

db.page_banners.createIndex(
{
"acct_id": 1
},
 {
name: "hook_main_banners_ix_1"
}
)

hook_main_banners_ix_2

Create statement

db.page_banners.createIndex(
{
"hook_id": 1
},
 {
name: "hook_main_banners_ix_2"
}
)

References

Name

Source

Target

Name

hook_sms_messages

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

hook_id

objectId

Yes

page_type

string

type

string

country_code

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"
}
)

References

Name

Source

Target

Name

sms_vercodes

Fields

Name

Data type

Array

Key

Required

_id

objectId

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"
}
)

References

Name

Source

Target

Name

hook_funnel_votes

Fields

Name

Data type

Array

Key

Required

_id

objectId

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"
}
)

References

Name

Source

Target

Name

page_user_hook_votes

Fields

Name

Data type

Array

Key

Required

_id

objectId

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
}
)

References

Name

Source

Target

Name

hook_funnel_hourly_votes

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

funnel_id

objectId

Yes

hook_id

objectId

Yes

hook_voting_item_cat_id

objectId

Yes

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"
}
)

References

Name

Source

Target

Name

edm_campaigns

Fields

Name

Data type

Array

Key

Required

_id

objectId

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"
}
)

Name

edm_campaign_stats

Fields

Name

Data type

Array

Key

Required

_id

objectId

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"
}
)

References

Name

Source

Target

Name

edm_nodes

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

num_langs

int

html

string

Yes

css

string

Yes

client_html

string

Yes

delay

int

autosave_datetime

date

delay_unit

int

complie_datetime

date

status

string

Description

D - Draft P - Published

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"
}
)

Name

tag_edm_campaigns

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

edm_campaign_id

objectId

Yes

acct_user_tag

string

Yes

acct_ta_tag

string

Yes

created

date

modified

date

References

Name

Source

Target

Name

edm_releases

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

edm_campaign_id

objectId

Yes

release_seq

int

send_method

string

Description

SL - 儲存的名單 SI - 手動輸入 IM - 由檔案匯入 ME - Mockup (Email) MG - Mockup (Mockup Group)

status

string

Description

P - Pending S - Scheduled D - Delivered

ta_tags

string

import_file

import_file (object)

delivery_datetime

date

is_schedule_send

bool

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"
}
)

Name

edm_release_stats

Fields

Name

Data type

Array

Key

Required

_id

objectId

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"
}
)

References

Name

Source

Target

Name

edm_broadcast_recipients

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

string

params

string

Yes

sg_status_id

string

sg_desc

string

status

string

Description

PE: Pending SC- Scheduled SE: Sending ST: Sent

num_opens

int

first_open_datetime

date

last_open_datetime

date

device

string

delivery_status

string

delivery_failure_code

string

desc_code

string

Description

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"
}
)

References

Name

Source

Target

edm_recipient_id

Name

edm_links

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

string

link

string

device

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"
}
)

References

Name

Source

Target

Name

edm_massages

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

edm_campaign_id

objectId

Yes

import_file

import_file (object)

num_users

int

num_valid

int

num_invalid

int

num_duplicates

int

num_unsubscribed

int

finished

bool

created

date

modified

date

References

Name

Source

Target

Name

edm_massage_failed_emails

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

edm_campaign_id

objectId

Yes

edm_massage_id

objectId

Yes

xls_row_num

int

fail_type

string

created

date

modified

date

References

Name

Source

Target

Name

advanced_searches

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

name

string

num_rules

int

rules

rules (object)

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"
}
)

References

Name

Source

Target

advanced_searches_advanced_search_result_emails

Name

funnel_types

Fields

Name

Data type

Array

Key

Required

_id

string

Yes

name

tagline

tagline (object)

description

rank

int

icon

icon (object)

active_icon

active_icon (object)

page_spec

page_spec (object)

followup_spec

followup_spec (object)

one_page_funnel_type

bool

gamification

bool

active

bool

Indexes

screenplay_types_ix_1

Create statement

db.funnel_types.createIndex(
{
"rank": 1
},
 {
name: "screenplay_types_ix_1"
}
)

References

Name

Source

Target

Name

edm_templates

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

name

html

string

css

string

orig_html_path

string

orig_css_path

string

thumbnail_path

string

References

Name

Source

Target

edm_template_id

edm_templates

Name

edm_senders

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

name

string

sender_domain

string

created

date

modified

date

References

Name

Source

Target

Name

acct_notifications

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

type

string

created

date

modified

date

References

Name

Source

Target

acct_notifications

Name

edm_unsend_lists

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

string

status

string

Description

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"
}
)

References

Name

Source

Target

Name

edm_chart_stats

Fields

Name

Data type

Array

Key

Required

_id

objectId

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"
}
)

References

Name

Source

Target

Name

page_types

Fields

Name

Data type

Array

Key

Required

_id

string

Yes

page_mvc_id

objectId

Yes

type

string

name

description

hook_session_fees (object)

opening_summary

bool

icon

string

index_css_class

string

page_content_css_class

string

contentbox_path

string

convert_action

convert_action (object)

page_json

page_json (object)

References

Name

Source

Target

Name

page_user_hook_sessions

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

funnel_id

objectId

Yes

funnel_page_id

objectId

Yes

hook_id

objectId

Yes

hook_session_id

objectId

Yes

hook_session_fees

Yes

page_user_id

objectId

Yes

session

session (object)

qualified

bool

checkin_datetime

date

Yes

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
}
)

Name

products

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

type

string

spu

string

name

intro

intro (object)

description

currency_id

string

Yes

default_price

double

special_price

double

default_stock

int

weight

double

have_options

bool

created

date

modified

date

Name

product_options

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

product_id

objectId

Yes

spu

string

sku

string

name

discount_applied (object)

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

Name

sales

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

funnel_screenplay_id

objectId

Yes

funnel_page_id

objectId

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"
}
)

Name

orders

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

type

string

Description

S - sales E - Events B - Bookings M - Membership

acct_id

objectId

Yes

funnel_id

objectId

Description

For type = 'S' / 'E'

funnel_name

string

Description

For type = 'S' / 'E'

funnel_page_id

objectId

Description

For type = 'S' / 'E'

sales_id

objectId

acct_user_id

objectId

Description

For type = 'M'

page_user_id

objectId

Description

For type = 'S' / 'E'

mbr_level_id

objectId

Description

For type = 'M'

mbr_level_name

mbr_level_name (object)

visitor_id

string

order_num

string

receipt_num

string

payment_method

string

Description

cc - Credit Card ep - Electronic Payment bt - Bank Transfer pm - Payme cod - Cash on Delivery we - WeChat Pay alipay - Alipay alipay-hk - Alipay HK tg - Tap and Go pp - PayPal

offline_payment_id

objectId

payment_gateway

string

payment_status

string

Description

P - Pending PIP - Payment in Progress WP - Waiting Payment WV - Waiting Verify S - Settled C - Cancelled

payment_datetime

date

pg_txn_id

string

pg_remark

string

delivery_method

string

Description

OD - Online Deliver SP - Self Pickup DD - Direct Deliver

delivery_status

string

Description

SYS: 系統自動出貨 (System automatically shipped) ULS: 未出貨 (Unshipped) PRG: 處理中 (Processing) SNT: 已出貨 (Sent) CNC: 訂單取消 / 不成立 (Cancelled/Not Established) REF: 退款 / 退貨 (Refund/Return) CLS: 已結案 (Closed)

order_status

string

Description

P - Pending C - Complete

currency_id

string

Yes

order_amount

double

tax

double

discount_applied

discount_method

string

Description

AD - Actual Deduction PO - Percentage Off

discount_value

double

discount_total

double

cod_charge

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

sys_shipping_country_id

string

Yes

sys_shipping_province_id

string

sys_shipping_city_id

string

sys_shipping_district_id

string

recipient_address

string

sys_shipper_id

objectId

Yes

pickup_venue_id

string

Yes

shipping_area_id

objectId

Yes

sp_point_id

objectId

Yes

tw_invoice

tw_invoice (object)

membership_start_date

date

Description

Only used when type = 'M'

membership_expiry_date

date

Description

Only used when type = 'M'

mbr_service

string

hook_session_fees

hook_session_fees (object)

Description

used in hook_events with tix

tw_invoice_callback

tw_invoice_callback (object)

internaltest

string

source

string

line

lang

string

applied_code

applied_code (object)

page_user_data

page_user_data (object)

Description

page user data to be saved in page_users after payment datafeed

referrer_id

objectId

created

date

modified

date

References

Name

Source

Target

Name

order_items

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

References

Name

Source

Target

Name

order_payments

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

page_user_id

objectId

Yes

order_id

objectId

Yes

type

string

Description

S - sales R - refund

currency_id

string

Yes

amount

double

created

date

modified

date

References

Name

Source

Target

Name

shopcarts

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

References

Name

Source

Target

Name

order_invoices

Description

For TW e-invoice

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

order_id

objectId

Yes

invoice_num

string

status

string

References

Name

Source

Target

Name

sales_general_activities

Description

discount_mode: - DA: 價格折扣 - PO: 打折優惠 - QD: 數量折扣

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

sales_id

objectId

Yes

enable_addon_products

bool

created

date

modified

date

References

Name

Source

Target

Name

product_images

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

product_id

objectId

Yes

image

image (object)

rank

int

created

date

modified

date

References

Name

Source

Target

Name

sales_collective_buyings

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

sales_id

objectId

Yes

default_price

decimal

price_tier

array

Yes

creaetd

date

modified

date

References

Name

Source

Target

Name

sys_sp_points

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

pt_name (object)

address

active

bool

Name

sp_points

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

pt_name (object)

address

active

bool

created

date

modified

date

Name

shipping_charges

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

details

details (object)

currency_id

string

Yes

cod_charge

bool

created

date

modified

date

Name

sys_shippers

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

name

References

Name

Source

Target

Name

order_remarks

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

created

date

modified

date

References

Name

Source

Target

Name

edm_schedule_sends

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

References

Name

Source

Target

Name

funnel_user_orders

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

References

Name

Source

Target

Name

acct_user_orders

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

type

string

Validation

Description

B - Booking E - Event S - Sales M - Membership

acct_id

objectId

Yes

funnel_id

objectId

Yes

funnel_name

funnel_name (object)

acct_user_id

objectId

Yes

order_id

objectId

Yes

order_num

string

session_fee

session_fee (object)

Description

For type = E

payment_method

string

currency_id

string

Yes

amount

double

num_items

int

Description

For type = S

mbr_level_id

objectId

Yes

Description

For type = 'M'

mbr_level_name

mbr_level_name (object)

Description

For type = 'M'

mbr_service_period

int

mbr_service_period_unit

string

admin_action

bool

created

date

modified

date

References

Name

Source

Target

Name

payment_method_gateways

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

method

string

gateway

string

created

date

modified

date

References

Name

Source

Target

payment_method_gateways

Name

sms_schedule_sends

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

References

Name

Source

Target

Name

edm_schedule_sends_copy

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

schedule_send_seq

int

schedule_send_datetime

date

num_scheduled_users

int

created

date

modified

date

Name

sms_campaigns

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

type

string

name

string

sender

string

status

string

cron_daily_trigger_time

string

step

int

num_subscribed

int

tags

Yes

api

bool

created

date

modified

date

active

bool

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"
}
)

Name

sms_releases

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

queue_type

string

send_also_ofca_registers

bool

is_schedule_send

bool

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"
}
)

References

Name

Source

Target

sms_broadcast_recipient_id

Name

sms_campaign_stats

Fields

Name

Data type

Array

Key

Required

_id

objectId

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"
}
)

References

Name

Source

Target

Name

sms_chart_stats

Fields

Name

Data type

Array

Key

Required

_id

objectId

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"
}
)

References

Name

Source

Target

Name

sms_links

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

sms_campaign_id

objectId

Yes

sms_release_id

objectId

Yes

sms_broadcast_recipient_id

objectId

Yes

country_code

string

mobile

string

link

string

device

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"
}
)

References

Name

Source

Target

Name

sms_broadcast_recipients

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

sms_campaign_id

objectId

Yes

sms_release_id

objectId

Yes

api_ref

string

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

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"
}
)

References

Name

Source

Target

sms_broadcast_recipient_id

Name

sms_release_stats

Fields

Name

Data type

Array

Key

Required

_id

objectId

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"
}
)

References

Name

Source

Target

Name

sms_senders

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

country_id

string

Yes

sender

string

created

date

modified

date

References

Name

Source

Target

Name

ofca_dnc_lists

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

country_id

string

Yes

country_code

string

mobile

string

created

date

References

Name

Source

Target

ofca_dnc_lists

Name

ofca_stats

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

country_id

string

Yes

num_mobiles

int

modified

bool

References

Name

Source

Target

event_price_text (object)

ofca_stats

Name

hook_redeems

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

hook_id

objectId

Yes

event_price_text

address_mode

string

address

shop_opening_hours (object)

location

location (object)

display_shop_opening_hours

bool

branch_details

branch_details (object)

show_google_map

bool

shop_opening_hours

show_reg_figures

string

Yes

redeem_start_register

string

redeem_start_datetime

date

redeem_end_register

string

redeem_end_datetime

date

distribute_method

string

tandc

tandc (object)

one_offer_display

bool

enable_evergreen

bool

evergreen

int

References

Name

Source

Target

Name

hook_passcodes

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

funnel_id

objectId

Yes

passcode

string

unit

string

created

date

modified

date

References

Name

Source

Target

Name

page_user_hook_passcodes

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

funnel_id

objectId

Yes

hook_id

objectId

Yes

page_user_id

objectId

Yes

page_user_participant_id

objectId

hook_passcode_id

objectId

Yes

passcode

string

unit

string

checkin_datetime

date

Description

For "HookEvents" use

redeem_datetime

date

Description

For "HookRedeems" use

created

date

modified

date

References

Name

Source

Target

hook_passcode_id

page_user_participant_id

Name

page_mvc_steps

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

page_mvc_id

objectId

Yes

step

int

name

feature_spec_checking_field

string

References

Name

Source

Target

page_mvc_steps

Name

followup_components

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

level

string

code

string

medium

string

followup_scenario_id

string

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

html (object)

main_css

main_css (object)

section_css

section_css (object)

followup_scenario_id

objectId

acitve

bool

References

Name

Source

Target

Name

funnel_page_followup_components

Description

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

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

funnel_id

objectId

Yes

funnel_page_id

objectId

Yes

followup_component_id

string

Yes

seq

int

code

string

name

medium

string

edm_sender_id

objectId

edm_subject

edm_subject (object)

edm_content

edm_content (object)

edm_send_option

string

edm_cc_emails

string

sms_sender

string

sms_content

sms_content (object)

mms_sender

string

mms_subject

mms_subject (object)

mms_content

mms_content (object)

mms_image

mms_image (object)

mms_add_redeem_qr

bool

line_flex_alt_text

line_msg_type

line_json

wha_image

wha_image (object)

wha_manager_template_name

string

scene

string

Yes

schedules

schedules (object)

Yes

created

date

modified

date

Name

funnel_screenplay_followup_components

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

funnel_id

objectId

Yes

funnel_screenplay_id

objectId

Yes

followup_component_id

objectId

Yes

followup_scenario_id

string

Yes

screenplay_followup_schedules

objectId

seq

int

code

string

name

medium

string

cron_hour

int

edm_sender_id

objectId

edm_subject

edm_subject (object)

edm_content

edm_content (object)

sms_sender

string

sms_content

sms_content (object)

mms_sender

string

mms_subject

mms_subject (object)

mms_content

mms_content (object)

mms_image

mms_image (object)

mms_add_redeem_qr

bool

line_msg_type

line_flex_alt_text

line_json

page_section_css (object)

page_html

page_html (object)

page_main_css

page_main_css (object)

page_section_css

redeem_tags

redeem_tags (object)

Yes

redeem_add_to_funnel

bool

redeem_add_to_funnel_id

objectId

redeem_add_to_funnel_delay

int

redeem_add_to_funnel_delay_unit

string

schedules

string

Yes

active

bool

created

date

modified

date

References

Name

Source

Target

Name

line_nodes

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

line_campaign_id

objectId

line_node_template_id

string

type

string

Description

P - push R - reply

name

string

keyword

string

Yes

msg_type

string

flex_alt_text

string

json

string

seq

int

delay

int

Description

only use when campaign type = 'M'

delay_unit

string

Description

only use when campaign type = 'M'

status

string

Validation

D - Draft P - Published

created

date

modified

date

tags_to_remove

tags_to_remove (object)

Yes

tags_to_add

tags_to_add (object)

Yes

Name

import_massages

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

funnel_id

objectId

type

string

timestamp_rand

string

file_url

string

replace_method

string

Description

type = acct_users only

num_imported_updated_users

int

cols

cols (object)

Yes

default_values

default_values (object)

Description

type = acct_users only

funnel_page_id

objectId

Description

type = page_users only

hook_session_id

objectId

Description

Only for hook_events user imports

row_num

int

num_of_rows

int

num_users

int

num_valid

int

num_invalid

int

num_duplciates

int

num_unidentified

int

num_imported_new_users

int

num_exist_in_db_users

int

finished

bool

err_code

string

duplicate_cols

string

Yes

created

date

modified

date

Indexes

import_massages_ix_1

Create statement

db.import_massages.createIndex(
{

},
 {
name: "import_massages_ix_1",
expireAfterSeconds: 10800
}
)

References

Name

Source

Target

Name

import_massage_results

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

funnel_id

objectId

Yes

import_massage_id

objectId

Yes

xls_row

int

type

string

name

string

country_code

string

mobile

string

edm_subscribed

string

status

string

failure_code

string

desc_code

string

created

date

modified

date

References

Name

Source

Target

import_massage_id

Name

import_progresses

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

References

Name

Source

Target

Name

sales_products

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

sales_id

objectId

Yes

product_id

objectId

Yes

seq

int

set_qty_limit

string

qty_limit

int

discount_mode

string

discount_min_qty

int

discount_value

double

created

date

modifeid

date

References

Name

Source

Target

Name

line_welcome_messages

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

line_node_template_id

string

Yes

msg_type

string

flex_alt_text

string

json

string

seq

int

delay

int

active

bool

created

date

modified

date

References

Name

Source

Target

line_node_template_id

line_node_templates

Name

line_campaigns

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

name

string

type

string

Description

BR - Broadcast DR - Drip

status

string

step

int

tags

array

Yes

Description

only use when campaign type = 'M'

cron_daily_trigger_time

string

num_subscribed

int

active

bool

Description

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"
}
)

Name

line_schedule_sends

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

References

Name

Source

Target

Name

line_releases

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

line_campaign_id

objectId

Yes

release_seq

int

send_method

string

status

string

ta_tags

string

delivery_datetime

date

is_schedule_send

bool

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

acct_id

objectId

Yes

line_campaign_id

objectId

Yes

line_node_id

objectId

Yes

line_release_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"
}
)

References

Name

Source

Target

Name

line_campaign_stats

Fields

Name

Data type

Array

Key

Required

_id

objectId

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"
}
)

References

Name

Source

Target

Name

line_drip_recipients

Fields

Name

Data type

Array

Key

Required

_id

objectId

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"
}
)

References

Name

Source

Target

Name

edm_drip_recipients

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

edm_campaign_id

objectId

Yes

edm_node_id

objectId

Yes

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"
}
)

References

Name

Source

Target

Name

addon_product_options

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

References

Name

Source

Target

addon_product_id

Name

addon_products

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

sales_id

objectId

Yes

product_id

objectId

Yes

seq

int

created

date

modified

date

References

Name

Source

Target

Name

hook_offers

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

hook_id

objectId

Yes

reg_limlit

int

one_offer_display

bool

tandc

tandc (object)

References

Name

Source

Target

Name

shippers

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

name

created

date

modified

date

References

Name

Source

Target

Name

shipping_groups

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

sys_shipper_id

objectId

Yes

shipper_id

objectId

name

string

shipper_type

string

Description

sys - 系統 acct - 帳戶

self_pickup

bool

direct_deliver

bool

active

bool

created

date

modified

date

References

Name

Source

Target

Name

page_mvcs

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

controller

string

References

Name

Source

Target

Name

sys_sms_messages

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

country_code

string

page_mvc_id

objectId

Yes

type

string

sender

string

message

message (object)

References

Name

Source

Target

sys_sms_messages

Name

followup_scenarios

Fields

Name

Data type

Array

Key

Required

_id

string

Yes

name

level

string

page_mvc_id

objectId

Yes

allow_add_msg

bool

seq

int

References

Name

Source

Target

Name

hook_inquiries

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

hook_id

objectId

Yes

References

Name

Source

Target

Name

sys_shipping_groups

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

sys_shipper_id

objectId

Yes

name

string

delivery_method

string

References

Name

Source

Target

Name

sys_shipping_countries

Fields

Name

Data type

Array

Key

Required

_id

string

Yes

name

References

Name

Source

Target

Name

sys_shipping_provinces

Fields

Name

Data type

Array

Key

Required

_id

string

Yes

sys_shipping_country_id

string

Yes

name

References

Name

Source

Target

Name

sys_shipping_cities

Fields

Name

Data type

Array

Key

Required

_id

string

Yes

sys_shipping_country_id

string

Yes

sys_shipping_province_id

string

name

References

Name

Source

Target

Name

sys_shipping_districts

Fields

Name

Data type

Array

Key

Required

_id

string

Yes

sys_shipping_country_id

string

Yes

sys_shipping_province_id

string

sys_shipping_city_id

string

name

postal_code

string

References

Name

Source

Target

Name

sys_sp_shipping_venues

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

sys_shipper_id

objectId

Yes

sys_shipping_group_id

objectId

Yes

name

References

Name

Source

Target

sys_sp_shipping_venue_id

Name

shipping_countries

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

name

created

date

modified

date

References

Name

Source

Target

Name

shipping_provinces

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

shipping_country_id

objectId

Yes

name

created

date

modified

date

References

Name

Source

Target

Name

shipping_cities

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

shipping_country_id

objectId

Yes

shipping_province_id

objectId

name

created

date

modified

date

References

Name

Source

Target

Name

shipping_districts

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

shipping_country_id

objectId

Yes

shipping_province_id

objectId

shipping_city_id

objectId

name

postal_code

string

created

date

modified

date

References

Name

Source

Target

Name

sp_shipping_venues

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

shipper_id

objectId

Yes

shipping_group_id

objectId

Yes

name

created

date

modified

date

References

Name

Source

Target

Name

export_progresses

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

References

Name

Source

Target

Name

export_files

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

type

string

desc_params

string

export_in_progress

bool

picked

bool

filename

string

References

Name

Source

Target

Name

booking_items

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

booking_category_id

objectId

Yes

name

description

seq

int

created

date

modified

date

References

Name

Source

Target

Name

booked_resources

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

booking_item_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

References

Name

Source

Target

Name

api_processes

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

method

string

path

string

status

string

created

date

modified

date

References

Name

Source

Target

exempt_excl_cond (object)

api_processes

Name

hook_bookings

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

hook_id

objectId

Yes

booking_category_id

objectId

booking_item_id

objectId

Yes

timeslot_duration

int

timeslot_duration_unit

string

days_open

int

days_close

int

timeslots

timeslots (object)

excl_cond

excl_cond (object)

Yes

exempt_excl_cond

Yes

References

Name

Source

Target

Name

set_page_spec_features

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

acct_id

objectId

Yes

advanced_search_id

objectId

Yes

string

user_created

date

created

date

References

Name

Source

Target

advanced_searches_advanced_search_result_emails

Name

tmp_edm_broadcast_recipients

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

edm_campaign_id

objectId

Yes

edm_node_id

objectId

Yes

edm_massage_id

objectId

Yes

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"
}
)

tmp_edm_broadcast_recipients_ix_3

Create statement

db.tmp_edm_broadcast_recipients.createIndex(
{
"created": 1
},
 {
"name": "tmp_edm_broadcast_recipients_ix_3",
"expireAfterSeconds": 10800
}
)

References

Name

Source

Target

Name

tmp_line_broadcast_recipients

Fields

Name

Data type

Array

Key

Required

_id

objectId

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"
}
)

tmp_line_broadcast_recipients_ix_3

Create statement

db.tmp_line_broadcast_recipients.createIndex(
{
"created": 1
},
 {
"name": "tmp_line_broadcast_recipients_ix_3",
"expireAfterSeconds": 10800
}
)

References

Name

Source

Target

Name

mbr_levels

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

seq

int

notation

string

name

description

enable_mobile_images (object)

service_period

int

service_period_unit

string

allow_signup

bool

allow_renew

bool

created

date

modified

date

References

Name

Source

Target

Name

membership_pages

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

type

string

html

main_css

section_css

page_spec

Description

For type - 'reg' and 'forgot_password' only

Name

acct_membership_pages

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

type

string

html

main_css

section_css

page_spec

Description

For type - 'reg' and 'forgot_password' only

enable_main_banner

bool

banner_style

string

enable_mobile_images

banner_bg_color

string

banner_text_color

string

intro

intro (object)

display_form_editor_fields

string

cta_follow_settings

bool

cta_bg_color

string

cta_text

cta_text (object)

cta_text_color

string

cta_hover_text_color

string

cta_hover_bg_color

string

show_ques_num

bool

submit_redirect

string

no_redirect_action

string

redirect_action

string

submit_redirect_funnel_id

objectId

submit_redirect_funnel_delay

int

submit_redirect_funnel_delay_unit

string

join_member_landing

string

enable_payment

bool

pwd_rules

string

created

date

modified

date

show_coupon_code_input

bool

References

Name

Source

Target

acct_membership_pages

Name

edm_service_rate_cards

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

tier

int

len

int

fee

fee (object)

Name

edm_balances

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

date

credit

int

debit

int

balance

int

References

Name

Source

Target

edm_balances

Name

point_balances

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

date

credit

double

debit

double

balance

double

References

Name

Source

Target

point_balances

Name

sms_api_calls

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

queue_type

string

swnd_also_ofca_registers

bool

status

string

Description

IM - Incorrect country code or mobile OFCA - In OFCA DNC and filtered (HK only) IUL - In unsend list, message did not send out IP - Insufficient points IS - Invalid sender, or sender id is not registered in your account

delivery_status

string

Description

DELIVRD - carrier has successfully delivered to the recipient's device EXPIRED - message is not delivered as processing exceeded the validity period UNDELIV - undelivered due to unreachable destination, network issues, or recipient's device being turned off REJECTD - rejected due to invalid content, blacklisted, or policy restrictions UNKNWN - carrier cannot determine the final delivery status of the message

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

References

Name

Source

Target

sms_api_calls

Name

profile_fields

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

seq

int

type

string

fieldname

string

label

label (object)

format

string

long_text

bool

show_date_year

bool

show_date_day

bool

created

date

modified

date

References

Name

Source

Target

profile_fields

Name

quota_changes

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

date

type

string

Yes

Description

M - Mockup R - Release

name

string

quota

int

References

Name

Source

Target

quota_changes

Name

point_usages

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

date

type

string

Yes

Description

M - Mockup R - Release

name

string

seq

int

ref_id

string

num_sent

int

num_sms_sent

int

points

int

References

Name

Source

Target

point_usages

Name

edm_balance_breakdowns

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

date

type

string

Yes

Description

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

References

Name

Source

Target

edm_balance_breakdowns

Name

point_balance_breakdowns

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

date

type

string

Yes

Description

AP - Add Points DP - Deduct Points M - Mockup R - Release S - Scheduled CS - Cancel Schedule FU - Funnel Usage O - Others

medium

string

description

string

credit

int

debit

int

balance

int

mockup

bool

References

Name

Source

Target

point_balance_breakdowns

Name

membership_followups

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

followup_component_id

objectId

Yes

followup_scenario_id

string

Yes

seq

int

code

string

name

medium

string

edm_sender_id

objectId

Yes

edm_subject

edm_subject (object)

edm_content

edm_content (object)

edm_cc

bool

edm_cc_emails

string

sms_sender

string

sms_content

sms_content (object)

mms_sender

string

mms_subject

mms_subject (object)

mms_content

mms_content (object)

mms_image

mms_image (object)

line_flex_alt_text

line_msg_type

line_json

active

bool

created

date

modified

date

References

Name

Source

Target

other_option_label (object)

Name

membership_payments

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

acct_user_id

objectId

Yes

date

receipt_num

string

payment_method

string

payment_gateway

string

currency_id

string

Yes

amount

double

payment_status

string

payment_datetime

date

pg_txn_id

string

internaltest

string

lang

string

created

date

modified

date

References

Name

Source

Target

Name

form_components

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

page_type

string

funnel_id

objectId

funnel_page_id

objectId

seq

int

format

string

Description

IN - input SE - section TE - text

te_style

string

Description

title -分組標題 desc - 內文補充 box - 框線 quota - 引言 line -分隔橫線

show_label

bool

label

label (object)

sub_label

sub_label (object)

default_text_type

string

default_text

default_text (object)

type

string

Description

CF - Contact Field SF - Standard Field CPF- Custom Profile Field PCU - Page Custom Field

sms_vercode

bool

input_type

string

fieldname

string

default_select

bool

limit_option_select

bool

max_options

int

options

options (object)

has_other_option

bool

other_option_label

option_display

bool

Description

1R1O - 一行顯示一個選項 1RMO - 一行顯示多個選項 OW - 下拉式，支援關鍵字搜尋

required

bool

content

content (object)

has_popup_tag

bool

tandc_content

tandc_content (object)

default_subscribe_edm

bool

optin_text

optin_text (object)

file_upload_options

file_upload_options (object)

show_date_year

bool

show_date_month

bool

show_date_day

bool

date_display

string

space_height

string

country_code_display_option

string

country_code_options

string

Yes

ban_duplicate_rating

bool

active

bool

created

date

modified

date

References

Name

Source

Target

Name

sys_screenplays

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

name

description

code

string

one_page_screenplay

bool

funnel_type_id

string

Yes

hashtag

hashtag (object)

seq

int

page_spec

page_spec (object)

followup_spec

followup_spec (object)

funnel_spec

funnel_spec (object)

gamification

bool

active

bool

References

Name

Source

Target

Name

hook_surveys

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

hook_id

objectId

Yes

evaluation_approach

string

References

Name

Source

Target

Name

hook_survey_scoring_summaries

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

hook_id

objectId

Yes

hook_survey_id

objectId

Yes

grade

any

Description

int if hook_surveys.evaluation_approach - 'scoring' string if hook_surveys.evaluation_approach - 'categorization'

description

result_url

string

seq

int

tags

Yes

References

Name

Source

Target

hook_survey_id

Name

booking_categories

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

name

payment_instructions (object)

seq

int

References

Name

Source

Target

Name

partners

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

partner_type_id

objectId

Yes

company

string

website

string

tel

string

rebate

double

edm_rebate

double

monthly_plan_rebate

double

reset_password_link_end_datetime

date

created

date

modified

date

References

Name

Source

Target

Name

partner_types

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

type

string

monthly_plain_rebate

double

edm_rebate

double

num_customers_required

string

created

date

modified

date

References

Name

Source

Target

partner_type_id

partner_types

partners

Name

offline_payments

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

bank_name

bank_name (object)

bank_acct_num

string

bank_acct_name

string

payment_instructions

created

date

modified

date

References

Name

Source

Target

Name

offer_coupons

Description

優惠碼頂層

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

name

offer

string

Description

BGD - buy_get_discount (購物折抵) BGFS - buy_get_free_shipping (購物免運費)

description

cover_img

cover_img (object)

purchase_amt

double

discount_value

double

use_in_platform

string

Description

xlead - 用於本平台消費 3rd_party: 用於第三方網店消費

distribute_channel

string

Description

xlead: 用戶從本平台漏斗登記索取 admin_share: 管理員自行分派

distribute_method

string

valid_from

date

valid_to

date

use_once

bool

code_source

string

manual_add_method

string

remark

remark (object)

created

date

modified

date

References

Name

Source

Target

Name

user_coupon_codes

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

funnel_id

objectId

Yes

funnel_page_id

objectId

Yes

offer_coupon_id

objectId

offer_coupon_code_id

objectId

referrer_id

objectId

referrer_coupon_id

objectId

referrer_coupon_code_id

objectId

acct_user_id

objectId

page_user_id

objectId

code

string

execution_time

date

created

date

Name

offer_coupon_codes

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

offer_coupon_id

objectId

Yes

code

string

created

date

References

Name

Source

Target

Name

offer_ebooks

Description

電子書

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

name

description

cover_img

pdf

created

date

modified

date

References

Name

Source

Target

Name

changed_identities

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

acct_user_id

objectId

Yes

fieldname

string

old_value

string

new_value

string

created

date

References

Name

Source

Target

Name

membership_daily_reminders

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

type

string

delay

int

created

date

References

Name

Source

Target

membership_daily_reminders

Name

funnel_daily_reminders

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

funnel_id

objectId

Yes

funnel_screenplay_set_id

objectId

Yes

followup_component_id

objectId

Yes

type

string

cron_daily_triiger_time

string

created

date

modified

date

References

Name

Source

Target

funnell_id

Name

line_share_oa_pages

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

html

html (object)

main_css

main_css (object)

section_css

section_css (object)

References

Name

Source

Target

line_share_oa_pages

Name

sys_emails

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

type

string

Description

T - Trigger C - Cron

subject

subject (object)

preheader

preheader (object)

content

content (object)

code

string

desc

string

active

bool

compile_datetime

date

modified

date

Name

e_invoice_settings

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

universal_ec

universal_ec (object)

created

date

modified

date

References

Name

Source

Target

e_invoice_settings

Name

import_settings

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

type

string

timestamp_rand

string

cols

cols (object)

Yes

err_code

string

created

date

modified

date

References

Name

Source

Target

import_settings

Name

hook_session_fees

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

hook_id

objectId

Yes

seq

string

name

fee

double

created

date

modified

date

References

Name

Source

Target

hook_session_fee_id

hook_session_fees_pip_reserved_hook_session_fees

Name

contentbox_snippet_categories

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

type

string

code

int

name

Name

dlink_destinations

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

code

string

destination

string

remark

string

References

Name

Source

Target

checkout_fill_in_instructions (object)

dlink_destinations

Name

sales_shops

Description

discount_mode: - DA: 價格折扣 - PO: 打折優惠 - QD: 數量折扣

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

sales_id

objectId

Yes

product_layout

string

enable_addon_products

bool

created

date

modified

date

References

Name

Source

Target

Name

line_unsend_lists

Fields

Name

Data type

Array

Key

Required

_id

objectId

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

line_user_ud

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"
}
)

References

Name

Source

Target

Name

membership_payment_settings

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

checkout_fill_in_instructions

payment_methods

payment_methods (object)

payment_gateways

payment_gateways (object)

offline_payments

offline_payments (object)

currencies

string

Yes

enable_online_payment

bool

enable_offline_payment

bool

created

date

modified

date

References

Name

Source

Target

membership_payment_settings

Name

sys_screenplay_themes

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

code

string

name

description

sys_screenplay_id

objectId

Yes

thumbnail

thumbnail (object)

master_content

master_content (object)

seq

int

active

bool

References

Name

Source

Target

sys_screenplay_id

sys_screenplay_theme_id

Name

funnel_links

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

type

string

from

objectId

Yes

objectId

Yes

created

date

modified

date

References

Name

Source

Target

Name

sms_nodes

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

sms_campaign_id

objectId

Yes

type

string

seq

int

after_day

int

num_langs

int

name

string

content

string

word_count

int

sms_count

int

delay

int

delay_unit

int

status

string

Description

D - Draft P - Published

created

date

modified

date

References

Name

Source

Target

Name

sms_drip_recipients

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

sms_campaign_id

objectId

Yes

sms_node_id

objectId

Yes

country_code

string

mobile

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.sms_drip_recipients.createIndex(
{
"acct_id": 1
},
 {
name: "edm_recipients_ix_1"
}
)

edm_recipients_ix_2

Create statement

db.sms_drip_recipients.createIndex(
{
"edm_campaign_id": 1
},
 {
name: "edm_recipients_ix_2"
}
)

References

Name

Source

Target

Name

hook_redeem_items

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

hook_id

objectId

Yes

type

string

offer_voucher_id

objectId

Yes

offer_gifts_id

objectId

Yes

seq

int

probability

int

symbol

string

created

date

modified

date

References

Name

Source

Target

Name

page_user_hook_redeem_items

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

funnel_id

objectId

Yes

funnel_page_id

objectId

Yes

hook_id

objectId

Yes

hook_redeem_item_id

objectId

Yes

page_user_id

objectId

Yes

offer_voucher_id

objectId

offer_gift_id

objectId

redeem_item

redeem_item (object)

created

date

modified

date

Indexes

page_user_hook_votes_ix_1

Create statement

db.page_user_hook_redeem_items.createIndex(
{
"acct_id": 1
},
 {
name: "page_user_hook_votes_ix_1"
}
)

page_user_hook_votes_ix_2

Create statement

db.page_user_hook_redeem_items.createIndex(
{
"funnel_id": 1
},
 {
name: "page_user_hook_votes_ix_2"
}
)

page_user_hook_votes_ix_3

Create statement

db.page_user_hook_redeem_items.createIndex(
{
"page_user_id": 1
},
 {
name: "page_user_hook_votes_ix_3"
}
)

page_user_hook_votes_ix_4

Create statement

db.page_user_hook_redeem_items.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

mms_api_calls

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

sender

string

country_code

string

mobile

string

subject

string

boundary

string

smil

string

image_url

string

text

string

params

string

Yes

callback_url

string

ref_id

string

version

string

swnd_also_ofca_registers

bool

queue_type

string

status

string

Description

delivery_status

string

Description

delivery_failure_code

string

callback_status

string

callback_reason_code

string

desc_code

string

description

string

stat_datetime

date

total_cost

double

api_ref

string

created

date

modified

date

References

Name

Source

Target

mms_api_calls

Name

mms_broadcast_recipients

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

mms_campaign_id

objectId

Yes

mms_release_id

objectId

Yes

delivery_datetime

date

country_code

string

mobile

string

total_cost

double

params

string

Yes

status

string

device

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

api_ref

string

created

date

modified

date

Indexes

edm_recipients_ix_1

Create statement

db.mms_broadcast_recipients.createIndex(
{
"acct_id": 1
},
 {
name: "edm_recipients_ix_1"
}
)

edm_recipients_ix_2

Create statement

db.mms_broadcast_recipients.createIndex(
{
"edm_campaign_id": 1
},
 {
name: "edm_recipients_ix_2"
}
)

References

Name

Source

Target

mms_broadcast_recipient_id

Name

mms_campaign_stats

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

mms_campaign_id

objectId

Yes

num_releases

int

num_scheduled

int

created

date

modified

date

Indexes

edm_campaign_stats_ix_1

Create statement

db.mms_campaign_stats.createIndex(
{
"acct_id": 1
},
 {
name: "edm_campaign_stats_ix_1"
}
)

edm_campaign_stats_ix_2

Create statement

db.mms_campaign_stats.createIndex(
{
"edm_campaign_id": 1
},
 {
name: "edm_campaign_stats_ix_2"
}
)

References

Name

Source

Target

Name

mms_campaigns

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

type

string

name

string

sender

string

status

string

cron_daily_trigger_time

string

step

int

num_subscribed

int

tags

Yes

api

bool

created

date

modified

date

active

bool

Indexes

edm_campaigns_ix_1

Create statement

db.mms_campaigns.createIndex(
{
"acct_id": 1
},
 {
name: "edm_campaigns_ix_1"
}
)

edm_campaigns_ix_2

Create statement

db.mms_campaigns.createIndex(
{
"acct_id": 1,
"type": 1
},
 {
name: "edm_campaigns_ix_2"
}
)

edm_campaigns_ix_3

Create statement

db.mms_campaigns.createIndex(
{
"acct_id": 1,
"type": 1,
"modified": -1
},
 {
name: "edm_campaigns_ix_3"
}
)

Name

mms_chart_stats

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

mms_campaign_id

objectId

Yes

mms_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.mms_chart_stats.createIndex(
{
"acct_id": 1
},
 {
name: "edm_chart_stats_ix_1"
}
)

edm_chart_stats_ix_2

Create statement

db.mms_chart_stats.createIndex(
{
"edm_campaign_id": 1
},
 {
name: "edm_chart_stats_ix_2"
}
)

References

Name

Source

Target

Name

mms_drip_recipients

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

mms_campaign_id

objectId

Yes

mms_node_id

objectId

Yes

country_code

string

mobile

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.mms_drip_recipients.createIndex(
{
"acct_id": 1
},
 {
name: "edm_recipients_ix_1"
}
)

edm_recipients_ix_2

Create statement

db.mms_drip_recipients.createIndex(
{
"edm_campaign_id": 1
},
 {
name: "edm_recipients_ix_2"
}
)

References

Name

Source

Target

Name

mms_nodes

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

mms_campaign_id

objectId

Yes

type

string

seq

int

after_day

int

num_langs

int

name

string

subject

string

content

string

image

image (object)

word_count

int

sms_count

int

delay

int

delay_unit

int

status

string

Description

D - Draft P - Published

created

date

modified

date

References

Name

Source

Target

Name

mms_schedule_sends

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

mms_campaign_id

objectId

Yes

schedule_send_seq

int

schedule_send_datetime

date

num_scheduled_users

int

num_scheduled_sms

int

created

date

modified

date

References

Name

Source

Target

Name

mms_release_stats

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

mms_campaign_id

objectId

Yes

mms_release_id

objectId

Yes

send_method

string

nun_sent

int

num_success

int

num_faiilure

int

num_unsubscribed

int

num_ofca

int

num_clicks

int

ttl_clicks

int

created

date

modified

date

Indexes

edm_release_stats_ix_1

Create statement

db.mms_release_stats.createIndex(
{
"acct_id": 1,
"edm_campaign_id": 1
},
 {
name: "edm_release_stats_ix_1"
}
)

References

Name

Source

Target

Name

mms_releases

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

mms_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

queue_type

string

is_schedule_send

bool

created

date

modified

date

Indexes

edm_releases_ix_1

Create statement

db.mms_releases.createIndex(
{
"acct_id": 1,
"edm_campaign_id": 1
},
 {
name: "edm_releases_ix_1"
}
)

References

Name

Source

Target

Name

join_next_funnel_queues

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

page_user_id

objectId

Yes

add_to_funnel_id

objectId

Yes

join_next_funnel_datetime

date

pickup_datetime

date

created

date

modified

date

References

Name

Source

Target

Name

send_page_followup_queues

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

page_user_id

objectId

Yes

funnel_page_followup_component_id

objectId

Yes

send_datetime

date

pickup_datetime

date

created

date

modified

date

References

Name

Source

Target

funnel_page_followup_component_id

Name

sys_gen_emial_counts

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

count

int

References

Name

Source

Target

sys_gen_emial_counts

Name

x_user_social_logins

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

x_user_id

objectId

Yes

social_media

string

social_id

string

mysql_user_id

string

social_email

string

created

date

References

Name

Source

Target

x_user_id

x_users

x_user_social_logins

Name

acct_user_social_logins

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

acct_user_id

objectId

Yes

social_media

string

social_id

string

Description

It's email address if social_media = 'email'

mysql_user_id

string

social_email

string

created

date

References

Name

Source

Target

Name

membership_identity_settings

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

native_identity

string

social_identity

string

Yes

created

date

modified

date

References

Name

Source

Target

membership_identity_settings

Name

whatsapp_campaigns

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

name

string

type

string

Description

BR - Broadcast DR - Drip

status

string

step

int

tags

array

Yes

Description

only use when campaign type = 'M'

cron_daily_trigger_time

string

num_subscribed

int

active

bool

Description

only use when campaign type = 'M'

created

date

modified

date

Indexes

line_campaigns_ix_1

Create statement

db.whatsapp_campaigns.createIndex(
{
"acct_id": 1
},
 {
name: "line_campaigns_ix_1"
}
)

line_campaigns_ix_2

Create statement

db.whatsapp_campaigns.createIndex(
{
"acct_id": 1,
"type": 1
},
 {
name: "line_campaigns_ix_2"
}
)

line_campaigns_ix_3

Create statement

db.whatsapp_campaigns.createIndex(
{
"acct_id": 1,
"type": 1,
"modified": -1
},
 {
name: "line_campaigns_ix_3"
}
)

Name

whatsapp_nodes

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

whatsapp_campaign_id

objectId

Yes

meta_template

meta_template (object)

Description

This is unique tempalte id from Meta

seq

int

delay

int

Description

only use when campaign type = 'M'

delay_unit

string

Description

only use when campaign type = 'M'

status

string

Validation

D - Draft P - Published

created

date

modified

date

References

Name

Source

Target

Name

whatsapp_campaign_stats

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

whatsapp_campaign_id

objectId

Yes

num_releases

int

num_scheduled

int

created

date

modified

date

Indexes

edm_campaign_stats_ix_1

Create statement

db.whatsapp_campaign_stats.createIndex(
{
"acct_id": 1
},
 {
name: "edm_campaign_stats_ix_1"
}
)

edm_campaign_stats_ix_2

Create statement

db.whatsapp_campaign_stats.createIndex(
{
"edm_campaign_id": 1
},
 {
name: "edm_campaign_stats_ix_2"
}
)

References

Name

Source

Target

Name

line_release_stats

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

line_campaign_id

objectId

Yes

line_release_id

objectId

Yes

send_method

string

nun_sent

int

created

date

modified

date

Indexes

edm_release_stats_ix_1

Create statement

db.line_release_stats.createIndex(
{
"acct_id": 1,
"edm_campaign_id": 1
},
 {
name: "edm_release_stats_ix_1"
}
)

References

Name

Source

Target

Name

whatsapp_release_stats

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

whatsapp_campaign_id

objectId

Yes

whatsapp_release_id

objectId

Yes

num_sent

int

send_method

string

created

date

modified

date

Indexes

edm_release_stats_ix_1

Create statement

db.whatsapp_release_stats.createIndex(
{
"acct_id": 1,
"edm_campaign_id": 1
},
 {
name: "edm_release_stats_ix_1"
}
)

References

Name

Source

Target

Name

whatsapp_releases

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

whatsapp_campaign_id

objectId

Yes

release_seq

int

send_method

string

status

string

ta_tags

string

delivery_datetime

date

is_schedule_send

bool

created

date

modified

date

Indexes

edm_releases_ix_1

Create statement

db.whatsapp_releases.createIndex(
{
"acct_id": 1,
"edm_campaign_id": 1
},
 {
name: "edm_releases_ix_1"
}
)

References

Name

Source

Target

Name

whatsapp_broadcast_recipients

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

whatsapp_campaign_id

objectId

Yes

whatsapp_node_id

objectId

Yes

whatsapp_release_id

objectId

Yes

delivery_datetime

date

country_code

string

mobile

string

params

string

Yes

description

string

error_data

error_data (object)

Description

Logs erors from whatsapp when cannot send

whatsapp_message_id

string

Description

To be used to grep db record in webhook

whatsapp_message_status

string

Description

To store the status returned by whatsapp when delivery

whatsapp_sent

bool

status

string

delivery_status

string

Description

SS – Sent Success (2 grey ticks) SF – Sent Fail (no ticks)

delivery_failure_code

string

description

string

desc_code

string

stat_datetime

date

first_tier_status

string

first_open_datetime

date

last_open_datetime

date

num_opens

int

created

date

modified

date

Indexes

edm_recipients_ix_1

Create statement

db.whatsapp_broadcast_recipients.createIndex(
{
"acct_id": 1
},
 {
name: "edm_recipients_ix_1"
}
)

edm_recipients_ix_2

Create statement

db.whatsapp_broadcast_recipients.createIndex(
{
"edm_campaign_id": 1
},
 {
name: "edm_recipients_ix_2"
}
)

References

Name

Source

Target

Name

tmp_whatsapp_broadcast_recipients

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

whatsapp_campaign_id

objectId

Yes

whatsapp_node_id

objectId

Yes

country_code

string

mobile

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_whatsapp_broadcast_recipients.createIndex(
{
"acct_id": 1
},
 {
name: "edm_recipients_ix_1"
}
)

edm_recipients_ix_2

Create statement

db.tmp_whatsapp_broadcast_recipients.createIndex(
{
"edm_campaign_id": 1
},
 {
name: "edm_recipients_ix_2"
}
)

tmp_whatsapp_broadcast_recipients_ix_3

Create statement

db.tmp_whatsapp_broadcast_recipients.createIndex(
{
"created": 1
},
 {
"name": "tmp_whatsapp_broadcast_recipients_ix_3",
"expireAfterSeconds": 10800
}
)

References

Name

Source

Target

Name

tmp_sms_broadcast_recipients

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

sms_campaign_id

objectId

Yes

sms_node_id

objectId

Yes

country_code

string

mobile

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_sms_broadcast_recipients.createIndex(
{
"acct_id": 1
},
 {
name: "edm_recipients_ix_1"
}
)

edm_recipients_ix_2

Create statement

db.tmp_sms_broadcast_recipients.createIndex(
{
"edm_campaign_id": 1
},
 {
name: "edm_recipients_ix_2"
}
)

tmp_sms_broadcast_recipients_ix_3

Create statement

db.tmp_sms_broadcast_recipients.createIndex(
{
"created": 1
},
 {
"name": "tmp_sms_broadcast_recipients_ix_3",
"expireAfterSeconds": 10800
}
)

References

Name

Source

Target

sms_node_id

Name

whatsapp_schedule_sends

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

whatsapp_campaign_id

objectId

Yes

schedule_send_seq

int

schedule_send_datetime

date

num_scheduled_users

int

created

date

modified

date

References

Name

Source

Target

Name

whatsapp_chart_stats

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

whatsapp_campaign_id

objectId

Yes

whatsapp_release_id

objectId

Yes

send_method

string

year

int

month

int

day

int

hour

int

open

int

created

date

modified

date

Indexes

edm_chart_stats_ix_1

Create statement

db.whatsapp_chart_stats.createIndex(
{
"acct_id": 1
},
 {
name: "edm_chart_stats_ix_1"
}
)

edm_chart_stats_ix_2

Create statement

db.whatsapp_chart_stats.createIndex(
{
"edm_campaign_id": 1
},
 {
name: "edm_chart_stats_ix_2"
}
)

References

Name

Source

Target

Name

pip_reserved_coupons

Description

pip = Payment in Progress

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

offer_coupon_id

objectId

offer_coupon_code_id

objectId

referrer_id

objectId

referrer_coupon_id

objectId

referrer_coupon_code_id

objectId

order_id

objectId

Yes

acct_user_id

objectId

page_user_id

objectId

created

date

Indexes

pip_reserved_coupons_ix_1

Create statement

db.pip_reserved_coupons.createIndex(
{
"created": 1
},
 {
"name": "pip_reserved_coupons_ix_1",
"expireAfterSeconds": 1800
}
)

Name

pip_reserved_stocks

Description

pip = Payment in Progress

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

acct_id

objectId

Yes

product_id

objectId

Yes

product_option_id

objectId

Yes

order_id

objectId

Yes

acct_user_id

objectId

page_user_id

objectId

visitor_id

string

qty

int

created

date

Indexes

pip_reserved_coupons_ix_1

Create statement

db.pip_reserved_stocks.createIndex(
{
"created": 1
},
 {
"name": "pip_reserved_coupons_ix_1",
"expireAfterSeconds": 1800
}
)

References

Name

Source

Target

Name

whatsapp_costs

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

tags

Fields

Name

Data type

Array

Key

Required

value

string

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

description

Fields

Name

Data type

Array

Key

Required

string

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

timeslots

Fields

Name

Data type

Array

Key

Required

sun

mon

tue

wed

thu

fri

sat

Name

sun

Fields

Name

Data type

Array

Key

Required

active

bool

boundaries

Yes

Name

boundaries

Fields

Name

Data type

Array

Key

Required

start

string

end

string

Name

mon

Fields

Name

Data type

Array

Key

Required

active

bool

boundaries

Yes

Name

boundaries

Fields

Name

Data type

Array

Key

Required

start

string

end

string

Name

tue

Fields

Name

Data type

Array

Key

Required

active

bool

boundaries

Yes

Name

boundaries

Fields

Name

Data type

Array

Key

Required

start

string

end

string

Name

wed

Fields

Name

Data type

Array

Key

Required

active

bool

boundaries

Yes

Name

boundaries

Fields

Name

Data type

Array

Key

Required

start

string

end

string

Name

thu

Fields

Name

Data type

Array

Key

Required

active

bool

boundaries

Yes

Name

boundaries

Fields

Name

Data type

Array

Key

Required

start

string

end

string

Name

fri

Fields

Name

Data type

Array

Key

Required

active

bool

boundaries

Yes

Name

boundaries

Fields

Name

Data type

Array

Key

Required

start

string

end

string

Name

sat

Fields

Name

Data type

Array

Key

Required

active

bool

boundaries

Yes

Name

boundaries

Fields

Name

Data type

Array

Key

Required

start

string

end

string

Name

excl_cond

Fields

Name

Data type

Array

Key

Required

date

booking_item_id

objectId

Name

exempt_excl_cond

Fields

Name

Data type

Array

Key

Required

date

booking_item_id

objectId

Name

description

Fields

Name

Data type

Array

Key

Required

string

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

html

Fields

Name

Data type

Array

Key

Required

string

Name

main_css

Fields

Name

Data type

Array

Key

Required

string

Name

section_css

Fields

Name

Data type

Array

Key

Required

string

Name

html

Fields

Name

Data type

Array

Key

Required

string

Name

main_css

Fields

Name

Data type

Array

Key

Required

string

Name

section_css

Fields

Name

Data type

Array

Key

Required

string

Name

fee

Fields

Name

Data type

Array

Key

Required

HKD

double

TWD

double

USD

double

Name

label

Fields

Name

Data type

Array

Key

Required

string

Name

custom_fields

Fields

Name

Data type

Array

Key

Required

Name

cond

Fields

Name

Data type

Array

Key

Required

type

string

match_text

string

criterias

criterias (object)

Name

criterias

Fields

Name

Data type

Array

Key

Required

Name

filter

Fields

Name

Data type

Array

Key

Required

type

string

match_text

string

criterias

criterias (object)

Name

criterias

Fields

Name

Data type

Array

Key

Required

Name

exclude

Fields

Name

Data type

Array

Key

Required

type

string

match_text

string

criterias

criterias (object)

Name

criterias

Fields

Name

Data type

Array

Key

Required

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

edm_subject

Fields

Name

Data type

Array

Key

Required

string

Name

edm_content

Fields

Name

Data type

Array

Key

Required

string

Name

sms_content

Fields

Name

Data type

Array

Key

Required

string

Name

mms_subject

Fields

Name

Data type

Array

Key

Required

string

Name

mms_content

Fields

Name

Data type

Array

Key

Required

string

Name

mms_image

Fields

Name

Data type

Array

Key

Required

Name

Fields

Name

Data type

Array

Key

Required

url

string

bucket

string

object

string

filename

string

Name

Fields

Name

Data type

Array

Key

Required

url

string

bucket

string

object

string

filename

string

Name

Fields

Name

Data type

Array

Key

Required

url

string

bucket

string

object

string

filename

string

Name

line_flex_alt_text

Fields

Name

Data type

Array

Key

Required

string

Name

line_msg_type

Fields

Name

Data type

Array

Key

Required

string

Name

line_json

Fields

Name

Data type

Array

Key

Required

string

Name

label

Fields

Name

Data type

Array

Key

Required

string

Name

options

Fields

Name

Data type

Array

Key

Required

value

string

label

label (object)

tags

string

Yes

grade

string

Name

label

Fields

Name

Data type

Array

Key

Required

string

Name

content

Fields

Name

Data type

Array

Key

Required

string

Name

optin_text

Fields

Name

Data type

Array

Key

Required

string

Name

file_upload_options

Fields

Name

Data type

Array

Key

Required

img

img (object)

doc

doc (object)

video

video (object)

Name

img

Fields

Name

Data type

Array

Key

Required

active

bool

file_size

int

Name

doc

Fields

Name

Data type

Array

Key

Required

active

bool

file_size

int

Name

video

Fields

Name

Data type

Array

Key

Required

active

bool

file_size

int

Name

sub_label

Fields

Name

Data type

Array

Key

Required

string

Name

default_text

Fields

Name

Data type

Array

Key

Required

string

Name

subtitle

Fields

Name

Data type

Array

Key

Required

string

Name

hashtag

Fields

Name

Data type

Array

Key

Required

string

Name

description

Fields

Name

Data type

Array

Key

Required

string

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

other_option_label

Fields

Name

Data type

Array

Key

Required

string

Name

member

Fields

Name

Data type

Array

Key

Required

reg_no_length

string

reg_no_prefix

string

reg_no_base

int

Name

bank_name

Fields

Name

Data type

Array

Key

Required

string

Name

payment_instructions

Fields

Name

Data type

Array

Key

Required

string

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

description

Fields

Name

Data type

Array

Key

Required

string

Name

cover_img

Fields

Name

Data type

Array

Key

Required

url

string

bucket

string

object

string

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

description

Fields

Name

Data type

Array

Key

Required

string

Name

cover_img

Fields

Name

Data type

Array

Key

Required

url

string

bucket

string

object

string

Name

remark

Fields

Name

Data type

Array

Key

Required

string

Name

cta_text

Fields

Name

Data type

Array

Key

Required

string

Name

line_share_oa

Fields

Name

Data type

Array

Key

Required

liff_id

string

editor_wrapper_class

string

param

string

keyword

string

lac_shorten_link

string

Name

html

Fields

Name

Data type

Array

Key

Required

string

Name

main_css

Fields

Name

Data type

Array

Key

Required

string

Name

section_css

Fields

Name

Data type

Array

Key

Required

string

Name

logo

Fields

Name

Data type

Array

Key

Required

url

string

bucket

string

object

string

Name

dark_bg_logo

Fields

Name

Data type

Array

Key

Required

url

string

bucket

string

object

string

Name

accumulated_order_amt

Fields

Name

Data type

Array

Key

Required

Name

details

Fields

Name

Data type

Array

Key

Required

wt_from

int

wt_to

int

fee

double

Name

subject

Fields

Name

Data type

Array

Key

Required

string

Name

content

Fields

Name

Data type

Array

Key

Required

Name

Fields

Name

Data type

Array

Key

Required

html

string

css

string

client_html

string

Name

Fields

Name

Data type

Array

Key

Required

html

string

css

string

client_html

string

Name

Fields

Name

Data type

Array

Key

Required

html

string

css

string

client_html

string

Name

preheader

Fields

Name

Data type

Array

Key

Required

string

Name

tw_invoice

Fields

Name

Data type

Array

Key

Required

process_type

string

Description

C - 二聯式電子發票 B - 三聯式電子發票

print_mark

bool

carrier

string

Validation

M - 手機載具 E - Email 接收

buyer_id

string

buyer_name

string

buyer_address

string

carrier_type

string

carrier_id_1

string

carrier_id_2

string

notify_email

string

Name

tw_invoice_callback

Fields

Name

Data type

Array

Key

Required

statusCode

string

statusDesc

string

respData

string

invNo

string

invDate

string

invTime

string

randomNumber

string

Name

subtitle

Fields

Name

Data type

Array

Key

Required

string

Name

universal_ec

Fields

Name

Data type

Array

Key

Required

api_key

string

auth

string

companyID

string

userID

string

sellerID

string

Name

cols

Fields

Name

Data type

Array

Key

Required

col_name

string

type

string

Description

CON - 聯絡方式 BAS - 基本資料 MEM - 會員資料 CUST - 自訂欄位 CAT - 分類及屬性 IGN - 忽略此欄位

db_fieldname

string

Name

cols

Fields

Name

Data type

Array

Key

Required

col_name

string

type

string

Description

CON - 聯絡方式 BAS - 基本資料 MEM - 會員資料 CUST - 自訂欄位 CAT - 分類及屬性 IGN - 忽略此欄位

db_fieldname

string

Name

default_values

Fields

Name

Data type

Array

Key

Required

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

fees

Fields

Name

Data type

Array

Key

Required

hook_session_fee_id

objectId

fee

double

quota

string

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

payment_methods

Fields

Name

Data type

Array

Key

Required

bool

paypal

bool

alipay_hk

bool

alipay

bool

wechat_pay

bool

tap_and_go

bool

Name

payment_gateways

Fields

Name

Data type

Array

Key

Required

string

paypal

string

alipay_hk

string

alipay

string

wechat_pay

string

tap_and_go

string

Name

offline_payments

Fields

Name

Data type

Array

Key

Required

Name

invitation_greeting

Fields

Name

Data type

Array

Key

Required

string

Name

mbr_level_name

Fields

Name

Data type

Array

Key

Required

string

Name

funnel_name

Fields

Name

Data type

Array

Key

Required

string

Name

session_fee

Fields

Name

Data type

Array

Key

Required

name

currency_id

string

fee

string

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

mbr_level_name

Fields

Name

Data type

Array

Key

Required

string

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

description

Fields

Name

Data type

Array

Key

Required

string

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

description

Fields

Name

Data type

Array

Key

Required

string

Name

thumbnail

Fields

Name

Data type

Array

Key

Required

url

string

bucket

string

object

string

filename

string

Name

description

Fields

Name

Data type

Array

Key

Required

string

Name

master_content

Fields

Name

Data type

Array

Key

Required

acct_id

objectId

funnel_id

objectId

Name

title

Fields

Name

Data type

Array

Key

Required

string

Name

followup_spec

Fields

Name

Data type

Array

Key

Required

Name

theme

Fields

Name

Data type

Array

Key

Required

string

Name

feature_spec

Fields

Name

Data type

Array

Key

Required

Name

redeem_tags

Fields

Name

Data type

Array

Key

Required

Name

tags

Fields

Name

Data type

Array

Key

Required

value

string

Name

event_name

Fields

Name

Data type

Array

Key

Required

string

Name

pdf

Fields

Name

Data type

Array

Key

Required

url

string

bucket

string

object

string

orig_filename

string

Name

redeem_item

Fields

Name

Data type

Array

Key

Required

name

description

string

cover_img

bool

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

tags

Fields

Name

Data type

Array

Key

Required

value

string

Name

image

Fields

Name

Data type

Array

Key

Required

Name

Fields

Name

Data type

Array

Key

Required

url

string

bucket

string

object

string

filename

string

Name

Fields

Name

Data type

Array

Key

Required

url

string

bucket

string

object

string

filename

string

Name

Fields

Name

Data type

Array

Key

Required

url

string

bucket

string

object

string

filename

string

Name

followup_spec

Fields

Name

Data type

Array

Key

Required

Name

page_spec

Fields

Name

Data type

Array

Key

Required

Name

followup_spec

Fields

Name

Data type

Array

Key

Required

Name

page_spec

Fields

Name

Data type

Array

Key

Required

Name

schedules

Fields

Name

Data type

Array

Key

Required

time_type

string

Validation

R: Real-time S: Scheduled E: Expiration

type

string

delay

int

delay_unit

string

Name

tagline

Fields

Name

Data type

Array

Key

Required

string

Name

page_spec

Fields

Name

Data type

Array

Key

Required

Name

page_spec

Fields

Name

Data type

Array

Key

Required

Name

enable_mobile_images

Fields

Name

Data type

Array

Key

Required

main_banner

bool

Name

intro

Fields

Name

Data type

Array

Key

Required

string

Name

cta_text

Fields

Name

Data type

Array

Key

Required

string

Name

convert_action

Fields

Name

Data type

Array

Key

Required

string

Name

Fields

Name

Data type

Array

Key

Required

phone_number_id

string

business_account_id

string

access_token

string

Name

meta_template

Fields

Name

Data type

Array

Key

Required

Name

discount_applied

Fields

Name

Data type

Array

Key

Required

type

string

Description

CC - Coupon Code DC - Discount Code

code

string

Name

error_data

Fields

Name

Data type

Array

Key

Required

Name

hook_session_fees

Fields

Name

Data type

Array

Key

Required

Name

ufo_acct_id

Fields

Name

Data type

Array

Key

Required

sms

string

sms_nn

string

mms

string

mms_nn

string

Name

checkout_fill_in_instructions

Fields

Name

Data type

Array

Key

Required

string

Name

payment_methods

Fields

Name

Data type

Array

Key

Required

bool

paypal

bool

alipay_hk

bool

alipay

bool

wechat_pay

bool

tap_and_go

bool

Name

payment_gateways

Fields

Name

Data type

Array

Key

Required

string

paypal

string

alipay_hk

string

alipay

string

wechat_pay

string

tap_and_go

string

Name

delivery_methods

Fields

Name

Data type

Array

Key

Required

Name

shiipping_groups

Fields

Name

Data type

Array

Key

Required

Name

description

Fields

Name

Data type

Array

Key

Required

string

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

banner

Fields

Name

Data type

Array

Key

Required

url

string

bucket

string

object

string

Name

result_text

Fields

Name

Data type

Array

Key

Required

bingo

bingo (object)

fail

fail (object)

Name

bingo

Fields

Name

Data type

Array

Key

Required

string

Name

fail

Fields

Name

Data type

Array

Key

Required

string

Name

checkout_fill_in_instructions

Fields

Name

Data type

Array

Key

Required

string

Name

tandc

Fields

Name

Data type

Array

Key

Required

string

Name

contact_cs

Fields

Name

Data type

Array

Key

Required

enabled

bool

url_type

string

custom_url

string

link_text

link_text (object)

Name

link_text

Fields

Name

Data type

Array

Key

Required

string

Name

terms

Fields

Name

Data type

Array

Key

Required

enabled

bool

url_type

string

custom_url

string

link_text

link_text (object)

Name

link_text

Fields

Name

Data type

Array

Key

Required

string

Name

privacy

Fields

Name

Data type

Array

Key

Required

enabled

bool

url_type

string

custom_url

string

link_text

link_text (object)

Name

link_text

Fields

Name

Data type

Array

Key

Required

string

Name

floating_cta_text

Fields

Name

Data type

Array

Key

Required

string

Name

page_user_data

Fields

Name

Data type

Array

Key

Required

Name

offline_payments

Fields

Name

Data type

Array

Key

Required

Name

hook_session_fees

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

qty

int

name

currency_id

string

currency_rate

double

unit_cost

double

ttl_cost

double

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

hook_session_fee

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

qty

int

name

currency_id

string

currency_rate

double

unit_cost

double

ttl_cost

double

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

tags

Fields

Name

Data type

Array

Key

Required

value

string

Name

ttl_sales_amount

Fields

Name

Data type

Array

Key

Required

Name

ttl_sales_amount

Fields

Name

Data type

Array

Key

Required

Name

ttl_sales_amount

Fields

Name

Data type

Array

Key

Required

Name

order_amount

Fields

Name

Data type

Array

Key

Required

Name

offer_item

Fields

Name

Data type

Array

Key

Required

name

description

string

cover_img

bool

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

description

Fields

Name

Data type

Array

Key

Required

string

Name

cover_img

Fields

Name

Data type

Array

Key

Required

url

string

bucket

string

object

string

Name

remark

Fields

Name

Data type

Array

Key

Required

string

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

description

Fields

Name

Data type

Array

Key

Required

string

Name

cover_img

Fields

Name

Data type

Array

Key

Required

url

string

bucket

string

object

string

Name

funnel_spec

Fields

Name

Data type

Array

Key

Required

Name

tandc

Fields

Name

Data type

Array

Key

Required

string

Name

branch_details

Fields

Name

Data type

Array

Key

Required

string

Name

tandc_content

Fields

Name

Data type

Array

Key

Required

string

Name

ttl_sales_amt

Fields

Name

Data type

Array

Key

Required

Name

ttl_discounted_amt

Fields

Name

Data type

Array

Key

Required

Name

ttl_rebate_amt

Fields

Name

Data type

Array

Key

Required

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

description

Fields

Name

Data type

Array

Key

Required

string

Name

cover_img

Fields

Name

Data type

Array

Key

Required

url

string

bucket

string

object

string

Name

remark

Fields

Name

Data type

Array

Key

Required

string

Name

applied_code

Fields

Name

Data type

Array

Key

Required

type

string

code

string

discount_type

string

name

condition

string

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

stripe

Fields

Name

Data type

Array

Key

Required

customer_id

string

mode

string

Name

stripe

Fields

Name

Data type

Array

Key

Required

intent_id

string

Name

funnel_end_date

Fields

Name

Data type

Array

Key

Required

enabled

bool

value

int

Name

edm_end_date

Fields

Name

Data type

Array

Key

Required

enabled

bool

value

int

Name

edm_low_balance

Fields

Name

Data type

Array

Key

Required

enabled

bool

threshold

double

value

double

Name

point_low_balance

Fields

Name

Data type

Array

Key

Required

enabled

bool

threshold

double

value

double

Name

funnel_end_date

Fields

Name

Data type

Array

Key

Required

enabled

bool

value

int

Name

edm_end_date

Fields

Name

Data type

Array

Key

Required

enabled

bool

value

int

Name

edm_low_balance

Fields

Name

Data type

Array

Key

Required

enabled

bool

threshold

double

value

double

Name

point_low_balance

Fields

Name

Data type

Array

Key

Required

enabled

bool

threshold

double

value

double

Name

stripe

Fields

Name

Data type

Array

Key

Required

customer_id

string

mode

string

payment_intent_id

string

error

any

Name

funnel_end_date

Fields

Name

Data type

Array

Key

Required

enabled

bool

value

int

Name

edm_end_date

Fields

Name

Data type

Array

Key

Required

enabled

bool

value

int

Name

edm_low_balance

Fields

Name

Data type

Array

Key

Required

enabled

bool

threshold

double

value

double

Name

point_low_balance

Fields

Name

Data type

Array

Key

Required

enabled

bool

threshold

double

value

double

Name

wha_image

Fields

Name

Data type

Array

Key

Required

Name

Fields

Name

Data type

Array

Key

Required

url

string

bucket

string

object

string

filename

string

Name

Fields

Name

Data type

Array

Key

Required

url

string

bucket

string

object

string

filename

string

Name

Fields

Name

Data type

Array

Key

Required

url

string

bucket

string

object

string

filename

string

Name

error

Fields

Name

Data type

Array

Key

Required

Name

page_editor_json

Fields

Name

Data type

Array

Key

Required

string

Name

name

Fields

Name

Data type

Array

Key

Required

string

Name

meta_description

Fields

Name

Data type

Array

Key

Required

string

Name

first_time_funnel_briefed

Fields

Name

Data type

Array

Key

Required

funnel

bool

Name

page_json

Fields

Name

Data type

Array

Key

Required

string

Name

link_text

Fields

Name

Data type

Array

Key

Required

string

references

Name

acct_id

Name

Source

Target

acct_x_users

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

x_user_id

Name

Source

Target

x_user_id

x_users

acct_x_users

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_screenplay_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

country_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

acct_settings

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

acct_subscriptions

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

currency_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

acct_user_tags

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

edm_domain_auths

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

acct_stats

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

currency_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

country_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

service_plan_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

service_plan_id

Name

Source

Target

acct_subscriptions

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

payment_history_id

Name

Source

Target

payment_history_id

acct_subscriptions

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

country_id

Name

Source

Target

timezones

Cardinality type:

Many to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

funnel_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

funnel_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

page_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

page_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

page_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

funnel_users

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

funnel_users

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

payment_settings

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

acct_tandc

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

acct_ta_tags

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

hook_votings

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_voting_item_cat_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

hook_events

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

hook_events

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

hook_votings

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

page_banners

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

hook_sms_messages

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

hook_sms_messages

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

sms_vercodes

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

sms_vercodes

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

sms_vercodes

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_voting_item_id

Name

Source

Target

hook_voting_item_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_voting_item_cat_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_voting_item_cat_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_voting_item_id

Name

Source

Target

hook_voting_item_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_voting_item_cat_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

edm_campaign_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_campaign_id

Name

Source

Target

edm_campaign_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

tag_edm_campaigns

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_campaign_id

Name

Source

Target

tag_edm_campaigns

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

edm_release_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_campaign_id

Name

Source

Target

edm_release_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_release_id

Name

Source

Target

edm_release_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_node_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_node_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_massage_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_recipient_id

Name

Source

Target

edm_recipient_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_type_id

Name

Source

Target

funnel_type_id

funnel_types

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_template_id

Name

Source

Target

edm_template_id

edm_templates

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

acct_notifications

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_release_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_release_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_node_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_release_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_node_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_release_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_massage_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_sender_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_type_id

Name

Source

Target

page_type_id

page_types

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

product_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

currency_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sales_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

currency_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sales_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

order_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

product_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

currency_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

order_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

currency_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

product_option_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

product_option_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

product_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

order_invoices

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

order_id

Name

Source

Target

order_invoices

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sales_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

product_images

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

product_id

Name

Source

Target

product_images

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sales_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

currency_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

product_image_id

Name

Source

Target

product_image_id

product_images

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

currency_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

currency_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sp_point_id

Name

Source

Target

sp_point_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sales_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipper_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipper_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

order_remarks

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

order_id

Name

Source

Target

order_remarks

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_user_id

Name

Source

Target

order_remarks

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnell_id

Name

Source

Target

funnell_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_release_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_massage_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_user_id

Name

Source

Target

funnel_user_id

funnel_users

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

currency_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

order_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

order_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

currency_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

payment_method_gateways

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

sms_schedule_sends

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sms_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

sms_campaign_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sms_campaign_id

Name

Source

Target

sms_campaign_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sms_campaign_id

Name

Source

Target

sms_schedule_sends

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

sms_chart_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sms_campaign_id

Name

Source

Target

sms_chart_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sms_release_id

Name

Source

Target

sms_chart_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sms_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sms_release_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sms_campaign_id

Name

Source

Target

sms_broadcast_recipient_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sms_broadcast_recipient_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sms_release_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sms_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sms_release_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

sms_senders

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

country_id

Name

Source

Target

sms_senders

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

country_id

Name

Source

Target

ofca_dnc_lists

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

country_id

Name

Source

Target

ofca_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

hook_redeems

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

hook_redeems

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_passcode_id

Name

Source

Target

hook_passcode_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_screenplay_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

followup_component_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

followup_component_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_sender_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_sender_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

import_massage_id

Name

Source

Target

import_massage_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

import_progresses

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

import_progresses

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

sales_products

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sales_id

Name

Source

Target

sales_products

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

product_id

Name

Source

Target

sales_products

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

line_campaign_id

Name

Source

Target

line_schedule_sends

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

line_schedule_sends

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

line_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

line_release_id

Name

Source

Target

line_schedule_sends

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

line_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

line_node_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

line_release_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

line_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

line_campaign_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

line_campaign_id

Name

Source

Target

line_campaign_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

line_drip_recipients

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

line_node_id

Name

Source

Target

line_drip_recipients

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

line_campaign_id

Name

Source

Target

line_drip_recipients

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

edm_drip_recipients

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_campaign_id

Name

Source

Target

edm_drip_recipients

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_node_id

Name

Source

Target

edm_drip_recipients

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sales_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

product_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

product_option_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sales_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

product_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

addon_product_id

Name

Source

Target

addon_product_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

hook_offers

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

hook_offers

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipper_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_screenplay_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_screenplay_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_mvc_id

Name

Source

Target

page_mvc_steps

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_mvc_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_mvc_id

Name

Source

Target

sys_sms_messages

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

hook_inquiries

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

hook_inquiries

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipper_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipper_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_country_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_country_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_province_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_country_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_province_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_city_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipper_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_group_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_group_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_sp_shipping_venue_id

Name

Source

Target

sys_sp_shipping_venue_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_country_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_province_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_city_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_district_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipping_country_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipping_country_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipping_province_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipping_country_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipping_province_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipping_city_id

Name

Source

Target

shipping_city_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

sp_shipping_venues

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipper_id

Name

Source

Target

sp_shipping_venues

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipping_group_id

Name

Source

Target

shipping_group_id

sp_shipping_venues

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipping_group_id

Name

Source

Target

shipping_group_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipping_country_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipping_province_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipping_city_id

Name

Source

Target

shipping_city_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipping_district_id

Name

Source

Target

shipping_district_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipper_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_group_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_country_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_city_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_province_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_district_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipper_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipping_group_id

Name

Source

Target

shipping_group_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipping_country_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipping_city_id

Name

Source

Target

shipping_city_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipping_province_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

shipping_district_id

Name

Source

Target

shipping_district_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_node_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

export_progresses

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

export_file_id

Name

Source

Target

export_file_id

export_files

export_progresses

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

export_files

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

api_processes

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

booking_item_id

Name

Source

Target

booking_item_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

advanced_searches_advanced_search_result_emails

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

advanced_searches_advanced_search_result_emails

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_node_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_massage_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

line_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

line_node_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

line_release_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

mbr_level_id

Name

Source

Target

mbr_level_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

acct_membership_pages

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

join_mbr_level_id

Name

Source

Target

join_mbr_level_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

edm_balances

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

point_balances

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

sms_api_calls

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

profile_fields

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

quota_changes

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

point_usages

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

edm_balance_breakdowns

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

point_balance_breakdowns

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

followup_component_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

edm_sender_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

membership_payments

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_user_id

Name

Source

Target

membership_payments

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

currency_id

Name

Source

Target

membership_payments

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

form_components

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

form_components

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

form_components

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_type_id

Name

Source

Target

funnel_type_id

funnel_types

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_survey_id

Name

Source

Target

hook_survey_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

booking_categories

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

booking_category_id

Name

Source

Target

booking_category_id

booking_categories

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

booking_category_id

Name

Source

Target

booking_category_id

booking_categories

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

partner_id

Name

Source

Target

partner_id

partners

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

partner_type_id

Name

Source

Target

partner_type_id

partner_types

partners

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

booking_item_id

Name

Source

Target

booking_item_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

offline_payments

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

offer_coupon_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

offer_coupon_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

offer_ebooks

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

changed_identities

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_user_id

Name

Source

Target

changed_identities

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

offer_coupon_code_id

Name

Source

Target

offer_coupon_code_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

membership_daily_reminders

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnell_id

Name

Source

Target

funnell_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

followup_component_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

followup_scenario_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

line_share_oa_pages

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

followup_scenario_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipper_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_country_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_province_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_city_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_shipping_district_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

e_invoice_settings

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

import_settings

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_session_fee_id

Name

Source

Target

hook_session_fee_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_session_id

Name

Source

Target

hook_session_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

dlink_destinations

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_session_id

Name

Source

Target

hook_session_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

sales_shops

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sales_id

Name

Source

Target

sales_shops

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

line_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

line_release_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

line_node_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

service_plan_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

membership_payment_settings

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

mbr_level_id

Name

Source

Target

mbr_level_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

mbr_level_id

Name

Source

Target

mbr_level_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_screenplay_id

Name

Source

Target

sys_screenplay_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_screenplay_id

Name

Source

Target

sys_screenplay_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_mvc_id

Name

Source

Target

page_types

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sys_screenplay_theme_id

Name

Source

Target

sys_screenplay_theme_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

funnel_links

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

funnel_links

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

funnel_links

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sms_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

sms_drip_recipients

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sms_campaign_id

Name

Source

Target

sms_drip_recipients

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sms_node_id

Name

Source

Target

sms_node_id

sms_drip_recipients

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_redeem_item_id

Name

Source

Target

hook_redeem_item_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

mms_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

mms_campaign_id

Name

Source

Target

mms_campaign_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

mms_campaign_id

Name

Source

Target

mms_schedule_sends

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

mms_campaign_id

Name

Source

Target

mms_chart_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

mms_campaign_id

Name

Source

Target

mms_release_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

mms_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

mms_campaign_id

Name

Source

Target

mms_drip_recipients

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

mms_node_id

Name

Source

Target

mms_node_id

mms_drip_recipients

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

mms_chart_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

mms_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

mms_release_id

Name

Source

Target

mms_chart_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

mms_release_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

mms_campaign_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

mms_schedule_sends

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

mms_drip_recipients

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

mms_api_calls

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

mms_release_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

mms_release_id

Name

Source

Target

mms_release_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

page_banners

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

page_banners

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_mvc_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

followup_scenario_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_user_id

Name

Source

Target

funnel_page_followup_component_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_followup_component_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

sys_gen_emial_counts

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

x_user_id

Name

Source

Target

x_user_id

x_users

x_user_social_logins

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

membership_identity_settings

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

whatsapp_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

whatsapp_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

line_release_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

line_campaign_id

Name

Source

Target

line_release_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

line_release_id

Name

Source

Target

line_release_stats

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

whatsapp_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

whatsapp_release_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

whatsapp_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

whatsapp_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

whatsapp_node_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

whatsapp_release_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

whatsapp_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

whatsapp_node_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sms_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

sms_node_id

Name

Source

Target

sms_node_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

whatsapp_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

whatsapp_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

whatsapp_release_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

offer_coupon_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

offer_coupon_code_id

Name

Source

Target

offer_coupon_code_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

order_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

product_of

Name

Source

Target

product_of

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

product_option_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

order_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

line_connects

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

mms_campaign_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

mms_node_id

Name

Source

Target

mms_node_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

ufo_acct_id

Name

Source

Target

ufo_acct_id

ufo_accts

acct_settings

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

mms_campaign_id

Name

Source

Target

mms_broadcast_recipient_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

mms_broadcast_recipient_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

mms_release_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

funnel_page_layouts

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

funnel_page_layouts

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

acct_page_styles

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

evergreen_funnel_id

Name

Source

Target

evergreen_funnel_id

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_user_participant_id

Name

Source

Target

page_user_participant_id

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

hook_session_fee_id

Name

Source

Target

hook_session_fee_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_offer_item_id

Name

Source

Target

hook_offer_item_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

offer_vouchers

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

offer_ebook_id

Name

Source

Target

offer_ebook_id

offer_ebooks

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

offer_ebook_id

Name

Source

Target

offer_ebook_id

offer_ebooks

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

offer_coupon_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

offer_coupon_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

offer_voucher_id

Name

Source

Target

offer_voucher_id

offer_vouchers

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

offer_voucher_id

Name

Source

Target

offer_voucher_id

offer_vouchers

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

offer_gift_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

offer_gift_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

offer_gift_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

offer_gift_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

granted_mbr_level_id

Name

Source

Target

granted_mbr_level_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

cloudflare_turnstile_id

Name

Source

Target

cloudflare_turnstile_id

cloudflare_turnstiles

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

referrer_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

referrer_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

referrer_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

referrer_coupon_id

Name

Source

Target

referrer_coupon_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

acct_user_sources

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

referrer_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

referrer_coupon_id

Name

Source

Target

referrer_coupon_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

referrer_coupon_code_id

Name

Source

Target

referrer_coupon_code_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

referrer_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

referrer_coupon_id

Name

Source

Target

referrer_coupon_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

referrer_coupon_code_id

Name

Source

Target

referrer_coupon_code_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

acct_auto_charge_profiles

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

acct_auto_charge_scenarios

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

acct_auto_charge_logs

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

service_plan_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

need_retry_auto_charges

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

whatsapp_chat_messages

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

line_chat_messages

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

bulk_update_operations

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_id

Name

Source

Target

funnel_page_followup_component_id

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

funnel_page_followup_component_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

offline_payment_id

Name

Source

Target

offline_payment_id

offline_payments

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

line_node_template_id

Name

Source

Target

line_node_template_id

line_node_templates

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

ai_credit_balances

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

ai_credit_balance_breakdowns

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

line_node_template_id

Name

Source

Target

line_node_template_id

line_node_templates

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

order_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

acct_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

page_user_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_session_id

Name

Source

Target

hook_session_id

hook_session_fees_pip_reserved_hook_session_fees

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

hook_session_fees_pip_reserved_hook_session_fees

Name

Source

Target