🤝

P2P Trade Management

Monitor and manage peer-to-peer trades

🎯 Trade Overview

P2P trades represent executed transactions between users based on published offers. Each trade includes buyer and seller information, amount and pricing details, payment method selection, status tracking, and optional timeline management. The system provides administrative oversight for trade monitoring and dispute resolution.

🏗️ Trade Structure

Core Trade Information

Trade Identifiers

Trade ID UUID primary key for the trade
Offer ID Link to the original P2P offer
Buyer ID UUID of the purchasing user
Seller ID UUID of the selling user

Trade Details

Type BUY or SELL operation
Currency Cryptocurrency being traded (max 50 chars)
Amount Quantity of cryptocurrency (double, ≥0)
Price Unit price (double, ≥0)

Financial Information

Transaction Values

Total Total transaction value (amount × price)
Escrow Fee Platform fee (optional string)

Payment Information

Payment Method Selected payment method (max 50 chars)
Payment Details JSON object with payment specifics

Status and Timeline Management

Status Tracking

Status PENDING, PAYMENT_SENT, COMPLETED, CANCELLED, DISPUTED
Payment Confirmed At Timestamp of payment confirmation

Timeline and Terms

Timeline JSON object tracking trade progression
Terms Agreed trading terms (text field)

📊 Trade Status System

Available Status Types

PENDING

Trade initiated, awaiting payment

💸

PAYMENT_SENT

Payment marked as sent by buyer

COMPLETED

Trade successfully finished

CANCELLED

Trade cancelled by user

⚖️

DISPUTED

Trade under dispute resolution

🔄 Trade Lifecycle

Typical Trade Flow

1

Trade Creation (PENDING)

User accepts an offer, creating a trade record with buyer/seller assignments, amount, price, and payment method selection.

Trade record created with all essential information and PENDING status
2

Payment Process (PAYMENT_SENT)

Buyer sends payment via the agreed method and marks it as sent, updating status and adding payment reference.

Status updated to PAYMENT_SENT with payment confirmation timestamp
3

Trade Completion (COMPLETED)

Seller verifies payment and releases cryptocurrency, marking the trade as completed.

Final status set to COMPLETED, trade successfully finished

Alternative Outcomes

  • CANCELLED: Trade cancelled before completion by either party
  • DISPUTED: Issues arise requiring dispute resolution intervention

⚙️ Administrative Management

Admin Operations

Monitoring Functions

  • • View all active and completed trades
  • • Filter trades by status, currency, date range
  • • Monitor trade progression and timelines
  • • Track payment confirmations and delays
  • • Review user trading patterns

Support Actions

  • • Investigate disputed trades
  • • Review payment evidence and details
  • • Monitor compliance with platform rules
  • • Handle user reports and complaints
  • • Provide trade assistance when needed

💳 Payment and Timeline Tracking

Payment Details (JSON)

The paymentDetails field stores payment-specific information:

{
  "accountNumber": "***1234",
  "bankName": "Example Bank",
  "reference": "TXN789012",
  "notes": "Payment sent via mobile app"
}
  • • Flexible JSON structure
  • • Payment method specific fields
  • • Optional reference information
  • • User-provided notes

Timeline Tracking (JSON)

The timeline field tracks trade progression timestamps:

{
  "created": "2024-01-15T10:00:00Z",
  "paymentSent": "2024-01-15T10:15:00Z",
  "paymentConfirmed": "2024-01-15T10:45:00Z",
  "completed": "2024-01-15T11:00:00Z"
}
  • • Automatic timestamp tracking
  • • Key milestone recording
  • • Performance analysis data
  • • Dispute resolution timeline

🔒 Escrow and Security

Security Features

Escrow Management

  • • Escrow fee tracking (optional string field)
  • • Escrow time limits (optional string field)
  • • Automated fund holding during trade
  • • Secure release mechanisms
  • • Protection against fraud

Payment Security

  • • Payment reference tracking
  • • Confirmation timestamp recording
  • • Payment detail verification
  • • Dispute protection mechanisms
  • • Audit trail maintenance

🔗 Trade Associations

Database Relationships

Core Relationships

  • Buyer/Seller: Links to user records
  • Offer: Connected to originating P2P offer
  • Dispute: One-to-one dispute relationship
  • Reviews: One-to-many review system

Cascading Behavior

  • • Cascade delete on user removal
  • • Cascade delete on offer removal
  • • Automatic dispute cleanup
  • • Review system integration

💡 Best Practices

Trade Monitoring

  • • Monitor trades regularly for issues
  • • Track payment confirmation times
  • • Watch for unusual trading patterns
  • • Ensure proper timeline progression
  • • Maintain audit trails for disputes

Administrative Actions

  • • Investigate disputed trades promptly
  • • Verify payment details when requested
  • • Maintain clear communication records
  • • Follow escalation procedures for issues
  • • Update trade data accurately