{"table_name":"getpaid_customer_meta","full_table_name":"wp_getpaid_customer_meta","description":"Stores additional metadata (key-value pairs) for getpaid customer records.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_getpaid_customer_meta ( meta_id BIGINT(20) NOT NULL AUTO_INCREMENT, customer_id BIGINT(20) NOT NULL, meta_key VARCHAR(255) NOT NULL, meta_value LONGTEXT, PRIMARY KEY (meta_id), KEY customer_id (customer_id), KEY meta_key (meta_key(191)) ) $charset_collate;\"; // Anonymization Logs. $schema['anonymization_logs'] = \"CREATE TABLE wp_getpaid_anonymization_logs ( log_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT(20) UNSIGNED NOT NULL, action VARCHAR(50) NOT NULL, data_type VARCHAR(50) NOT NULL, timestamp DATETIME NOT NULL, additional_info TEXT, PRIMARY KEY (log_id), KEY user_id (user_id), KEY action (action), KEY data_type (data_type), KEY timestamp (timestamp) ) $charset_collate;\"; // Filter. $schema = apply_filters( 'getpaid_db_schema', $schema );","columns":[{"name":"meta_id","type":"BIGINT(20)","nullable":false,"primary_key":true},{"name":"customer_id","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"meta_key","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"meta_value","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"action","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"data_type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"timestamp","type":"DATETIME","nullable":false,"primary_key":false},{"name":"additional_info","type":"TEXT","nullable":true,"primary_key":false}],"plugin":{"slug":"invoicing","name":"Payment forms, Buy now buttons, and Invoicing System | GetPaid","active_installs":5000,"version":"2.8.54","wp_org_url":"https://wordpress.org/plugins/invoicing/"}}