"CREATE" TABLE "markets" (
"PlatCode" text NOT NULL,
"PlatName" text NULL,
"PlatformType" text NULL,
"AgeDays" bigint NULL,
"OperStatus" text NULL,
"RepScore" text NULL,
"ConfidenceLevel" text NULL,
"SizeCat" text NULL,
"DayTxnVol" real NULL,
"ActiveUsersMo" text NULL,
"SellerCount" bigint NULL,
"AcqCount" bigint NULL,
"ItemListings" bigint NULL,
"lastUpdated" timestamp without time zone NULL,
"RefreshHrs" bigint NULL,
platform_compliance jsonb NULL,
    "PRIMARY" KEY (PlatCode)
);



"First" 3 rows:
PlatCode    PlatName    PlatformType      AgeDays  OperStatus           RepScore    ConfidenceLevel    SizeCat      DayTxnVol    ActiveUsersMo    SellerCount    AcqCount    ItemListings  lastUpdated            RefreshHrs  platform_compliance
----------  ----------  --------------  ---------  -------------------  ----------  -----------------  ---------  -----------  ---------------  -------------  ----------  --------------  -------------------  ------------  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
MK7747      Market_84   Forum                  59  Under Investigation              Medium             Mega               990             4178            985        6009           34834  2025-02-16 15:29:00             8  {'geo_dist_scr': '9.8 Transactions/user/day', 'laund_ve_score': '0.16 USD/risk/day', 'sec_audit_stat': 'Warning', 'sec_event_count': 0, 'vuln_inst_count': 28, 'data_ret_policy_stat': 'Deleted', 'protection_meas_count': 17}
MK9078      Market_35   Service                98  Active                           High               Medium             615             4761            249        2226           34208  2025-02-17 08:29:00             4  {'geo_dist_scr': '2.47 Transactions/user/day', 'laund_ve_score': '0.49 USD/risk/day', 'sec_audit_stat': 'Pass', 'sec_event_count': 1, 'vuln_inst_count': 1, 'data_ret_policy_stat': 'Deleted', 'protection_meas_count': 2}
MK5795      Market_91   Forum                 536  Suspended                        Low                Medium             670             1467            446        2678           38741  2025-02-14 22:29:00             4  {'geo_dist_scr': '9.48 Transactions/user/day', 'laund_ve_score': '0.48 USD/risk/day', 'sec_audit_stat': 'Warning', 'sec_event_count': 5, 'vuln_inst_count': 21, 'data_ret_policy_stat': 'Active', 'protection_meas_count': 12}
...


"CREATE" TABLE "vendors" (
"SellerKey" text NOT NULL,
"DaysActive" bigint NULL,
"PerformanceRating" real NULL,
"TotalTxns" text NULL,
"CompletedTxns" bigint NULL,
"DisputedEvents" bigint NULL,
"VerTier" text NULL,
"LastActiveDt" timestamp without time zone NULL,
"AccessLevel" text NULL,
"InvestigationFlag" text NULL,
"LE_Interest" text NULL,
"ComplianceRisk" text NULL,
"RegStandeff" text NULL,
vendor_compliance_ratings jsonb NULL,
    "PRIMARY" KEY (SellerKey)
);



"First" 3 rows:
SellerKey      DaysActive    PerformanceRating  TotalTxns      CompletedTxns    DisputedEvents  VerTier    LastActiveDt         AccessLevel    InvestigationFlag    LE_Interest    ComplianceRisk    RegStandeff            vendor_compliance_ratings
-----------  ------------  -------------------  -----------  ---------------  ----------------  ---------  -------------------  -------------  -------------------  -------------  ----------------  ---------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
V63085                319                  4.5  $917                      28                33             NaT                                                                     Low               11.61 Score/violation  {'liq_rate': '783.97 USD/day', 'viol_count': 4, 'warn_count': 6, 'comm_trust_scr': 35.8, 'conflict_res_scr': None, 'id_ver_score_val': 50, 'prof_complete_pct': 82.4, 'escrow_adher_score': 12.8, 'reg_compliance_scr': 59.7873, 'penalty_event_count': 3, 'platform_engage_scr': 76.3, 'feedback_integrity_scr': 87.8}
V99720                426                  3.4  $82                       38                81             NaT                                 Active                              High              63.88 Score/violation  {'liq_rate': '218.16 USD/day', 'viol_count': 3, 'warn_count': 5, 'comm_trust_scr': 95.6, 'conflict_res_scr': None, 'id_ver_score_val': 50, 'prof_complete_pct': 35.9, 'escrow_adher_score': 55.5, 'reg_compliance_scr': 76.36598, 'penalty_event_count': 5, 'platform_engage_scr': 43, 'feedback_integrity_scr': 46.2}
V25559                 26                  4.1  $165                       7                34             2025-02-05 00:00:00                 Monitoring                          High              14.7 Score/violation   {'liq_rate': '289.98 USD/day', 'viol_count': 5, 'warn_count': 4, 'comm_trust_scr': 64, 'conflict_res_scr': None, 'id_ver_score_val': 50, 'prof_complete_pct': 67, 'escrow_adher_score': 97.6, 'reg_compliance_scr': 91.33712, 'penalty_event_count': 0, 'platform_engage_scr': 27.3, 'feedback_integrity_scr': 91.9}
...


"CREATE" TABLE "buyers" (
"AcqCode" text NOT NULL,
"ProfileAge" bigint NULL,
"PurchaseCount" bigint NULL,
"AuthLevel" text NULL,
buyer_risk_profile jsonb NULL,
    "PRIMARY" KEY (AcqCode)
);



"First" 3 rows:
AcqCode      ProfileAge    PurchaseCount  AuthLevel    buyer_risk_profile
---------  ------------  ---------------  -----------  ---------------------------------------------------------------------------------------------------------------------------------------------------------------------
B41538              326               10  Advanced     {'purchase_freq': 'Heavy', 'spend_pattern': 'Variable', 'risk_metric_scr': 8.421068, 'risk_dollar_ratio': '0.0644 RiskScore/USD', 'behavior_consistency_scr': 83.4}
B57052              166               40  Basic        {'purchase_freq': 'Regular', 'spend_pattern': 'High', 'risk_metric_scr': 6.1413317, 'risk_dollar_ratio': '0.1648 RiskScore/USD', 'behavior_consistency_scr': 28.8}
B79369               81               96  Basic        {'purchase_freq': 'One-time', 'spend_pattern': 'Variable', 'risk_metric_scr': 3.258246, 'risk_dollar_ratio': '0.184 RiskScore/USD', 'behavior_consistency_scr': 53.8}
...


"CREATE" TABLE "products" (
"ProdCat" text NOT NULL,
"Subcategory" text NOT NULL,
"ListingAge" bigint NOT NULL,
"SellerPointer" text NOT NULL,
product_availability jsonb NULL,
    "PRIMARY" KEY (ProdCat, Subcategory, ListingAge, SellerPointer),
    "FOREIGN" KEY ("SellerPointer") REFERENCES vendors(SellerKey)
);



"First" 3 rows:
ProdCat    Subcategory      ListingAge  SellerPointer    product_availability
---------  -------------  ------------  ---------------  -----------------------------------------
Digital    Type_B                  155  V63085           {'price_amt': 232.59462, 'qty_avail': 92}
Data       Type_C                  105  V25559           {'price_amt': 130.78629, 'qty_avail': 48}
Digital    Type_B                  116  V61030           {'price_amt': 248.43217, 'qty_avail': 59}
...


"CREATE" TABLE "transactions" (
"EventCode" text NOT NULL,
"RecordTag" text NULL,
"EventTimestamp" timestamp without time zone NULL,
"PlatformKey" text NULL,
"VendorLink" text NULL,
"AcqLink" text NULL,
"OriginRegion" text NULL,
"DestRegion" text NULL,
"CrossBorder" bigint NULL,
"RouteComplex" text NULL,
"Transaction_Velocity" text NULL,
"Border_cross_pre" text NULL,
"GeoDistScore" text NULL,
transaction_financials jsonb NULL,
    "PRIMARY" KEY (EventCode),
    "FOREIGN" KEY ("PlatformKey") REFERENCES markets(PlatCode),
    "FOREIGN" KEY ("VendorLink") REFERENCES vendors(SellerKey),
    "FOREIGN" KEY ("AcqLink") REFERENCES buyers(AcqCode)
);



"First" 3 rows:
EventCode    RecordTag    EventTimestamp       PlatformKey    VendorLink    AcqLink    OriginRegion    DestRegion      CrossBorder  RouteComplex    Transaction_Velocity    Border_cross_pre            GeoDistScore    transaction_financials
-----------  -----------  -------------------  -------------  ------------  ---------  --------------  ------------  -------------  --------------  ----------------------  --------------------------  --------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TX4833222    DN541412     2024-04-02 00:00:00  MK7747         V63085        B41538     Region_B        Region_Y                  1  Complex         30.8 USD/hour           137.66 USD/border-crossing  2140.32 km      {'fee_amt_usd': '$637.83 ', 'value_amt_usd': '78.03532317523569', 'pmt_method_type': 'Crypto_A', 'escrow_used_stat': 'No', 'process_time_hrs': 4, 'multisig_flag_stat': True, 'escrow_duration_hrs': None, 'shipping_method_type': 'Express', 'completion_state_stat': 'In Progress', 'shipping_cost_density': '1.95 USD/km'}
TX7875482    DN772007     2024-05-16 00:00:00  MK9078         V25559        B57052     Region_A        Region_Y                  1  Medium          68.45 USD/hour          194.23 USD/border-crossing  4340.25 km      {'fee_amt_usd': '$318.27 ', 'value_amt_usd': '190.38928974993365', 'pmt_method_type': None, 'escrow_used_stat': 'No', 'process_time_hrs': 11, 'multisig_flag_stat': False, 'escrow_duration_hrs': None, 'shipping_method_type': 'Standard', 'completion_state_stat': 'In Progress', 'shipping_cost_density': '1.51 USD/km'}
TX9295302    DN873987     2024-08-23 00:00:00  MK5795         V61030        B79369     Region_A        Unknown                   0  Medium          31.85 USD/hour          34.12 USD/border-crossing   3264.72 km      {'fee_amt_usd': '$193.46 ', 'value_amt_usd': '147.738818653224', 'pmt_method_type': None, 'escrow_used_stat': None, 'process_time_hrs': 18, 'multisig_flag_stat': None, 'escrow_duration_hrs': None, 'shipping_method_type': 'Express', 'completion_state_stat': 'Failed', 'shipping_cost_density': '0.2 USD/km'}
...


"CREATE" TABLE "transaction_products" (
"EventLink" text NOT NULL,
"ProdCat" text NOT NULL,
"Subcategory" text NOT NULL,
"ListingAge" bigint NOT NULL,
"SellerPointer" text NOT NULL,
"PriceAmt" real NULL,
"QtySold" bigint NULL,
    "PRIMARY" KEY (EventLink, ProdCat, Subcategory, ListingAge, SellerPointer),
    "FOREIGN" KEY ("EventLink") REFERENCES transactions(EventCode),
    "FOREIGN" KEY ("ProdCat") REFERENCES products("ProdCat"),
    "FOREIGN" KEY ("ProdCat") REFERENCES products(Subcategory),
    "FOREIGN" KEY ("ProdCat") REFERENCES products(ListingAge),
    "FOREIGN" KEY ("ProdCat") REFERENCES products(SellerPointer),
    "FOREIGN" KEY ("Subcategory") REFERENCES products(ProdCat),
    "FOREIGN" KEY ("Subcategory") REFERENCES products("Subcategory"),
    "FOREIGN" KEY ("Subcategory") REFERENCES products(ListingAge),
    "FOREIGN" KEY ("Subcategory") REFERENCES products(SellerPointer),
    "FOREIGN" KEY ("ListingAge") REFERENCES products(ProdCat),
    "FOREIGN" KEY ("ListingAge") REFERENCES products(Subcategory),
    "FOREIGN" KEY ("ListingAge") REFERENCES products("ListingAge"),
    "FOREIGN" KEY ("ListingAge") REFERENCES products(SellerPointer),
    "FOREIGN" KEY ("SellerPointer") REFERENCES products(ProdCat),
    "FOREIGN" KEY ("SellerPointer") REFERENCES products(Subcategory),
    "FOREIGN" KEY ("SellerPointer") REFERENCES products(ListingAge),
    "FOREIGN" KEY ("SellerPointer") REFERENCES products("SellerPointer")
);



"First" 3 rows:
EventLink    ProdCat    Subcategory      ListingAge  SellerPointer      PriceAmt    QtySold
-----------  ---------  -------------  ------------  ---------------  ----------  ---------
TX4833222    Digital    Type_B                  155  V63085              232.595         92
TX7875482    Data       Type_C                  105  V25559              130.786         48
TX9295302    Digital    Type_B                  116  V61030              248.432         59
...


"CREATE" TABLE "vendor_markets" (
"VendorKey" text NOT NULL,
"PlatformID" text NOT NULL,
    "PRIMARY" KEY (VendorKey, PlatformID),
    "FOREIGN" KEY ("VendorKey") REFERENCES vendors(SellerKey),
    "FOREIGN" KEY ("PlatformID") REFERENCES markets(PlatCode)
);



"First" 3 rows:
VendorKey    PlatformID
-----------  ------------
V63085       MK7747
V25559       MK9078
V61030       MK5795
...


"CREATE" TABLE "vendor_countries" (
"SellerKey" text NOT NULL,
"OpRegions" text NOT NULL,
    "PRIMARY" KEY (SellerKey, OpRegions),
    "FOREIGN" KEY ("SellerKey") REFERENCES vendors("SellerKey")
);



"First" 3 rows:
SellerKey      OpRegions
-----------  -----------
V63085                 5
V25559                 5
V61030                10
...


"CREATE" TABLE "vendor_payment_methods" (
"VendorLink" text NOT NULL,
"AcceptedPmtTypes" text NOT NULL,
    "PRIMARY" KEY (VendorLink, AcceptedPmtTypes),
    "FOREIGN" KEY ("VendorLink") REFERENCES vendors(SellerKey)
);



"First" 3 rows:
VendorLink      AcceptedPmtTypes
------------  ------------------
V63085                         4
V25559                         5
V61030                         5
...


"CREATE" TABLE "risk_analytics" (
"TxnLink" text NOT NULL,
"RiskIndicatorCount" bigint NULL,
"FraudProb" real NULL,
"ML_Risk" text NULL,
"LinkedEvents" bigint NULL,
"ChainLength" bigint NULL,
wallet_risk_assessment jsonb NULL,
    "PRIMARY" KEY (TxnLink),
    "FOREIGN" KEY ("TxnLink") REFERENCES transactions(EventCode)
);



"First" 3 rows:
TxnLink      RiskIndicatorCount    FraudProb    ML_Risk    LinkedEvents    ChainLength  wallet_risk_assessment
---------  --------------------  -----------  ---------  --------------  -------------  --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TX4833222                     9         67.3    2.10192              29              4  {'wallet_age_days': 722, 'wallet_score_val': 34.4, 'wallet_value_usd': 98937.33, 'cluster_coeff_val': 0.695, 'turnover_rate_val': None, 'geo_dist_score_val': 27, 'conn_diversity_score': 63.6, 'network_centrality_val': 40.9, 'pattern_classification': 'High-risk', 'temporal_pattern_score': 5.8}
TX7875482                     3         78.8    3.23443               8              9  {'wallet_age_days': 307, 'wallet_score_val': 29.8, 'wallet_value_usd': 16240.76, 'cluster_coeff_val': 0, 'turnover_rate_val': 4.29, 'geo_dist_score_val': 87, 'conn_diversity_score': 85.4, 'network_centrality_val': 3.2, 'pattern_classification': 'High-risk', 'temporal_pattern_score': 73.9}
TX9295302                    10         76.1    8.19234              47            nan  {'wallet_age_days': 879, 'wallet_score_val': 47.4, 'wallet_value_usd': 26348.08, 'cluster_coeff_val': 0.364, 'turnover_rate_val': None, 'geo_dist_score_val': 97.6, 'conn_diversity_score': None, 'network_centrality_val': 58.5, 'pattern_classification': 'High-risk', 'temporal_pattern_score': 19.8}
...


"CREATE" TABLE "communications" (
"EventLink" text NOT NULL,
communication_details jsonb NULL,
    "PRIMARY" KEY (EventLink),
    "FOREIGN" KEY ("EventLink") REFERENCES transactions(EventCode)
);



"First" 3 rows:
EventLink    communication_details
-----------  -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TX4833222    {'sentiment_val': -0.69, 'comm_freq_type': 'Medium', 'encryption_type': 'Custom', 'msg_count_total': 59, 'suspic_index_scr': 14.7, 'comm_channel_type': 'Mixed', 'lang_pattern_type': 'Variable', 'keyword_match_count': 20}
TX7875482    {'sentiment_val': 0.27, 'comm_freq_type': 'High', 'encryption_type': 'Standard', 'msg_count_total': 271, 'suspic_index_scr': 46, 'comm_channel_type': 'External', 'lang_pattern_type': 'Suspicious', 'keyword_match_count': 15}
TX9295302    {'sentiment_val': 0.3, 'comm_freq_type': 'Low', 'encryption_type': 'Enhanced', 'msg_count_total': 170, 'suspic_index_scr': 81.5, 'comm_channel_type': 'External', 'lang_pattern_type': 'Consistent', 'keyword_match_count': 16}
...


"CREATE" TABLE "connection_security" (
"TxnPointer" text NOT NULL,
"OpSecMetric" real NULL,
"ThreatIntelIndex" real NULL,
"DetectionAvoidance" real NULL,
"AnonLevel" text NULL,
"TraceScore" real NULL,
"CorrelationValue" real NULL,
"PatternMatchScore" real NULL,
"BehaviorScore" real NULL,
"ML_Confidence" real NULL,
"AnomalyValue" real NULL,
"FalsePosProb" real NULL,
"Threat_handle_rate" text NULL,
"Data_proctecteff" text NULL,
encrytion_cost text NULL,
anonymity_cost text NULL,
"Bot_act_index" text NULL,
"Connection_duration" text NULL,
connection_security_metrics jsonb NULL,
    "PRIMARY" KEY (TxnPointer),
    "FOREIGN" KEY ("TxnPointer") REFERENCES transactions(EventCode)
);



"First" 3 rows:
TxnPointer      OpSecMetric    ThreatIntelIndex    DetectionAvoidance    AnonLevel    TraceScore    CorrelationValue    PatternMatchScore    BehaviorScore    ML_Confidence    AnomalyValue    FalsePosProb  Threat_handle_rate    Data_proctecteff         encrytion_cost           anonymity_cost             Bot_act_index          Connection_duration    connection_security_metrics
------------  -------------  ------------------  --------------------  -----------  ------------  ------------------  -------------------  ---------------  ---------------  --------------  --------------  --------------------  -----------------------  -----------------------  -------------------------  ---------------------  ---------------------  -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TX4833222              95.7             14.4363               94.6513      1.00297          14.4                69.6                 36.5             15.8             97.2            38.9            10.4  0.12 Threats/hour     1.82 Vulnerabilities/GB  8.21 USD/encryption-bit  51.71 USD/anonymity-point  40.87 Actions/IP/hour  8.92 hours             {'ip_count_total': 2, 'tor_node_count': 4, 'privacy_score_val': 62.2, 'vpn_detect_status': 'No', 'auth_protocol_type': 'Basic', 'device_fp_risk_score': 63.7, 'browser_fp_unique_scr': 6.4, 'data_protection_class': '754.0646111300096', 'session_sec_rating_scr': 12.701034, 'conn_pattern_metric_scr': 48.1, 'encryption_strength_scr': '95'}
TX7875482              58.2             72.492                45.5951      5.25037          35.6                95.1                 42.6             83.3             38.9           nan              84.1  0.14 Threats/hour     0.95 Vulnerabilities/GB  8.19 USD/encryption-bit  30.98 USD/anonymity-point  32.55 Actions/IP/hour  11.34 hours            {'ip_count_total': 9, 'tor_node_count': 4, 'privacy_score_val': 50.8, 'vpn_detect_status': 'No', 'auth_protocol_type': 'Basic', 'device_fp_risk_score': None, 'browser_fp_unique_scr': 61.5, 'data_protection_class': '337.3957605153179', 'session_sec_rating_scr': 6.5542607, 'conn_pattern_metric_scr': 10.8, 'encryption_strength_scr': '81'}
TX9295302              24.1             84.9003               82.1625      1.26364          74.2                 3                    8.5             10.1             95.2            85.2            22.2  18.73 Threats/hour    0.36 Vulnerabilities/GB  5.99 USD/encryption-bit  82.7 USD/anonymity-point   42.24 Actions/IP/hour  7.87 hours             {'ip_count_total': 4, 'tor_node_count': None, 'privacy_score_val': 73.7, 'vpn_detect_status': 'Suspected', 'auth_protocol_type': '2FA', 'device_fp_risk_score': 17.9, 'browser_fp_unique_scr': 79, 'data_protection_class': '24.80841464750114', 'session_sec_rating_scr': 8.994444, 'conn_pattern_metric_scr': 86.9, 'encryption_strength_scr': '239'}
...


"CREATE" TABLE "alerts" (
"EventTag" text NOT NULL,
"ReviewFreq" text NULL,
"NextReviewDt" date NULL,
"AnnotationCount" bigint NULL,
alert_case_management jsonb NULL,
    "PRIMARY" KEY (EventTag),
    "FOREIGN" KEY ("EventTag") REFERENCES transactions(EventCode)
);



"First" 3 rows:
EventTag    ReviewFreq    NextReviewDt      AnnotationCount  alert_case_management
----------  ------------  --------------  -----------------  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TX4833222   Weekly        2025-03-17                      3  {'resolve_hours': 122, 'resp_time_min': 1411, 'alert_category': None, 'case_state_stat': 'Resolved', 'action_taken_stat': 'Termination', 'needs_followup_stat': False, 'severity_level_stat': 'High', 'escalation_tier_stat': 'Level3', 'invest_priority_stat': 'High', 'confidence_metric_val': 59.6}
TX7875482   Monthly       2025-03-13                      1  {'resolve_hours': 43, 'resp_time_min': 686, 'alert_category': 'Pattern', 'case_state_stat': 'Resolved', 'action_taken_stat': 'Warning', 'needs_followup_stat': False, 'severity_level_stat': 'Low', 'escalation_tier_stat': 'Level2', 'invest_priority_stat': 'Low', 'confidence_metric_val': 89.1}
TX9295302   Weekly        2025-03-19                      9  {'resolve_hours': 57, 'resp_time_min': 1068, 'alert_category': 'Transaction', 'case_state_stat': 'Resolved', 'action_taken_stat': 'Termination', 'needs_followup_stat': True, 'severity_level_stat': 'Low', 'escalation_tier_stat': 'Level2', 'invest_priority_stat': 'High', 'confidence_metric_val': 76.7}
...
