{"table_name":"cartright_carts","full_table_name":"wp_cartright_carts","description":"Stores cartright carts data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_cartright_carts ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, session_id VARCHAR(191) NOT NULL, product_id BIGINT UNSIGNED NOT NULL, status VARCHAR(20) NOT NULL, score SMALLINT NOT NULL, recoverable TINYINT(1) NOT NULL DEFAULT 0, reasons TEXT NULL, email VARCHAR(191) NULL, abandoned_at INT UNSIGNED NOT NULL, steps_sent TINYINT UNSIGNED NOT NULL DEFAULT 0, recovered TINYINT(1) NOT NULL DEFAULT 0, opted_out TINYINT(1) NOT NULL DEFAULT 0, updated INT UNSIGNED NOT NULL, PRIMARY KEY (id), UNIQUE KEY session_id (session_id), KEY status (status) ) $charset;\");","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"session_id","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"product_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"score","type":"SMALLINT","nullable":false,"primary_key":false},{"name":"recoverable","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"reasons","type":"TEXT","nullable":true,"primary_key":false},{"name":"email","type":"VARCHAR(191)","nullable":true,"primary_key":false},{"name":"abandoned_at","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"steps_sent","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"recovered","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"opted_out","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"updated","type":"INT UNSIGNED","nullable":false,"primary_key":false}],"plugin":{"slug":"cartright","name":"Cartright for WooCommerce","active_installs":0,"version":"0.1.1","wp_org_url":"https://wordpress.org/plugins/cartright/"}}