Referral Wodget

Tables (9)

Category (Untitled9)

  • categoryID (Key) — BIGINT — Primary key — NOT NULL

Untitled2

    order_referral_fee_snapshot (Untitled8)

    • order_referral_fee_snapshop_id (Key) — BIGINT — Primary key — NOT NULL
    • order_id (Field) — BIGINT
    • vendor_id (Field2) — BIGINT
    • vendor_contract_plan_id (Field3) — BIGINT
    • vendor_contract_history_id (Field4) — BIGINT
    • penalty_fee (Field5) — DECIMAL
    • fx_fee (Field6) — DECIMAL
    • fx_fee_waived (Field7) — BIT
    • payment_fee (Field8) — DECIMAL
    • payment_fee_waived (Field9) — BIGINT
    • vendor_referral_fee_vernsion_id (Field10) — BIGINT
    • is_vendor_referral_order (Field11) — BIGINT
    • created_on (Field12) — DATETIME

    vendor_contract_referral_fee_category_template (Untitled7)

    • vendor_contract_referral_fee_category_id (Key) — BIGINT — Primary key — NOT NULL
    • categoryID (Key2) — BIGINT — Foreign key → Category.categoryID — NOT NULL
    • category_order (Field2) — BIGINT
    • category_depth (Field3) — INT
    • plan_id (Field4) — BIGINT
    • created_on (Field5) — DATETIME
    • created_by (Field6) — NVARCHAR
    • modified_on (Field7) — DATETIME
    • modified_by (Field8) — NVARCHAR

    vendor_referral_buyer (Untitled)

    • vendor_referral_buyer_id (Key) — BIGINT — Primary key — NOT NULL
    • buyer_id (Field) — BIGINT
    • vendor_id (Field2) — BIGINT
    • registration_date (Field3) — DATETIME
    • referral_status_code (Field4) — INTEGER
    • first_order_id (Field5) — INTEGER
    • created_on (Field6) — DATETIME
    • created_by (Field7) — NVARCHAR
    • modified_on (Field8) — DATETIME
    • modified_by (Field9) — NVARCHAR

    vendor_referral_fee_version (Untitled3)

    • vendor_referral_fee_version_id (Key) — BIGINT — Primary key — NOT NULL
    • vendor_contract_plan_id (Field) — BIGINT
    • from_date (Field2) — DATETIME
    • to_date (Field3) — DATETIME
    • created_on (Field4) — DATETIME
    • created_by (Field5) — NVARCHAR
    • modified_on (Field6) — DATETIME
    • modifined_by (Field7) — NVARCHAR

    vendor_referral_fee_version_detail (Untitled4)

    • vendor_referral_fee_version_detail_id (Key) — BIGINT — Primary key — NOT NULL
    • categoryID (Key3) — BIGINT — Foreign key → Category.categoryID — NOT NULL
    • vendor_referral_fee_version_id (Key2) — BIGINT — Foreign key → vendor_referral_fee_version.vendor_referral_fee_version_id — NOT NULL
    • lvl (Field3) — INT
    • referral_fee_rate (Field4) — INT
    • sort (Field5) — INT
    • created_on (Field6) — LOCALDATE
    • created_by (Field7) — NVARCHAR

    vendor_referral_statistics (Untitled5)

      vendor_referral_status_log (Untitled6)