Referral Wodget
Tables (9)
Category (Untitled9)
- categoryID (Key) — BIGINT — Primary key — NOT NULL
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)