{
    "database": "emaj4846_warungkite",
    "audit": {
        "users": {
            "exists": true,
            "missing_cols": [],
            "db_columns": [
                {
                    "field": "id",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "PRI",
                    "default": null
                },
                {
                    "field": "nama_lengkap",
                    "type": "varchar(100)",
                    "null": "NO",
                    "key": "",
                    "default": null
                },
                {
                    "field": "no_hp",
                    "type": "varchar(20)",
                    "null": "NO",
                    "key": "UNI",
                    "default": null
                },
                {
                    "field": "foto_profil",
                    "type": "varchar(255)",
                    "null": "YES",
                    "key": "",
                    "default": null
                },
                {
                    "field": "password_hash",
                    "type": "varchar(255)",
                    "null": "NO",
                    "key": "",
                    "default": null
                },
                {
                    "field": "fcm_token",
                    "type": "varchar(255)",
                    "null": "YES",
                    "key": "",
                    "default": null
                },
                {
                    "field": "role",
                    "type": "enum('owner','customer')",
                    "null": "YES",
                    "key": "",
                    "default": "customer"
                },
                {
                    "field": "created_at",
                    "type": "timestamp",
                    "null": "YES",
                    "key": "",
                    "default": "current_timestamp()"
                },
                {
                    "field": "alamat",
                    "type": "text",
                    "null": "YES",
                    "key": "",
                    "default": null
                },
                {
                    "field": "is_active",
                    "type": "tinyint(1)",
                    "null": "YES",
                    "key": "MUL",
                    "default": "1"
                },
                {
                    "field": "deleted_at",
                    "type": "datetime",
                    "null": "YES",
                    "key": "MUL",
                    "default": null
                },
                {
                    "field": "email_verification_token",
                    "type": "varchar(255)",
                    "null": "YES",
                    "key": "",
                    "default": null
                },
                {
                    "field": "is_email_verified",
                    "type": "tinyint(1)",
                    "null": "YES",
                    "key": "",
                    "default": "0"
                },
                {
                    "field": "email",
                    "type": "varchar(255)",
                    "null": "YES",
                    "key": "MUL",
                    "default": null
                },
                {
                    "field": "latitude",
                    "type": "decimal(10,8)",
                    "null": "YES",
                    "key": "",
                    "default": null
                },
                {
                    "field": "longitude",
                    "type": "decimal(11,8)",
                    "null": "YES",
                    "key": "",
                    "default": null
                },
                {
                    "field": "reset_token",
                    "type": "varchar(255)",
                    "null": "YES",
                    "key": "MUL",
                    "default": null
                },
                {
                    "field": "reset_token_expires_at",
                    "type": "datetime",
                    "null": "YES",
                    "key": "",
                    "default": null
                }
            ]
        },
        "kategori": {
            "exists": true,
            "missing_cols": [],
            "db_columns": [
                {
                    "field": "id",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "PRI",
                    "default": null
                },
                {
                    "field": "warung_id",
                    "type": "int(11)",
                    "null": "YES",
                    "key": "MUL",
                    "default": null
                },
                {
                    "field": "nama_kategori",
                    "type": "varchar(50)",
                    "null": "NO",
                    "key": "",
                    "default": null
                },
                {
                    "field": "created_at",
                    "type": "timestamp",
                    "null": "YES",
                    "key": "",
                    "default": "current_timestamp()"
                }
            ]
        },
        "products": {
            "exists": true,
            "missing_cols": [],
            "db_columns": [
                {
                    "field": "id",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "PRI",
                    "default": null
                },
                {
                    "field": "warung_id",
                    "type": "int(11)",
                    "null": "YES",
                    "key": "MUL",
                    "default": null
                },
                {
                    "field": "kategori_id",
                    "type": "int(11)",
                    "null": "YES",
                    "key": "MUL",
                    "default": null
                },
                {
                    "field": "nama",
                    "type": "varchar(150)",
                    "null": "NO",
                    "key": "",
                    "default": null
                },
                {
                    "field": "barcode",
                    "type": "varchar(100)",
                    "null": "YES",
                    "key": "UNI",
                    "default": null
                },
                {
                    "field": "harga_modal",
                    "type": "decimal(10,2)",
                    "null": "NO",
                    "key": "",
                    "default": "0.00"
                },
                {
                    "field": "harga_jual",
                    "type": "decimal(10,2)",
                    "null": "NO",
                    "key": "",
                    "default": "0.00"
                },
                {
                    "field": "stok",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "",
                    "default": "0"
                },
                {
                    "field": "min_stok",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "",
                    "default": "0"
                },
                {
                    "field": "is_public",
                    "type": "tinyint(1)",
                    "null": "YES",
                    "key": "MUL",
                    "default": "1"
                },
                {
                    "field": "foto_url",
                    "type": "varchar(255)",
                    "null": "YES",
                    "key": "",
                    "default": null
                },
                {
                    "field": "created_at",
                    "type": "timestamp",
                    "null": "YES",
                    "key": "",
                    "default": "current_timestamp()"
                }
            ]
        },
        "orders": {
            "exists": true,
            "missing_cols": [],
            "db_columns": [
                {
                    "field": "id",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "PRI",
                    "default": null
                },
                {
                    "field": "customer_id",
                    "type": "int(11)",
                    "null": "YES",
                    "key": "MUL",
                    "default": null
                },
                {
                    "field": "catatan_pesanan",
                    "type": "text",
                    "null": "YES",
                    "key": "",
                    "default": null
                },
                {
                    "field": "status",
                    "type": "enum('baru','diproses','dikirim','selesai','batal')",
                    "null": "YES",
                    "key": "MUL",
                    "default": "baru"
                },
                {
                    "field": "payment_method",
                    "type": "enum('cash','transfer','qris','ewallet','va')",
                    "null": "YES",
                    "key": "",
                    "default": "cash"
                },
                {
                    "field": "payment_status",
                    "type": "enum('pending','settlement','expire','cancel')",
                    "null": "YES",
                    "key": "",
                    "default": "pending"
                },
                {
                    "field": "requested_time",
                    "type": "varchar(100)",
                    "null": "YES",
                    "key": "",
                    "default": null
                },
                {
                    "field": "payment_gateway_ref",
                    "type": "varchar(100)",
                    "null": "YES",
                    "key": "",
                    "default": null
                },
                {
                    "field": "funds_escrow_status",
                    "type": "enum('held','released','refunded')",
                    "null": "NO",
                    "key": "",
                    "default": "held"
                },
                {
                    "field": "total_harga",
                    "type": "decimal(10,2)",
                    "null": "NO",
                    "key": "",
                    "default": "0.00"
                },
                {
                    "field": "shipping_cost_calculated",
                    "type": "decimal(10,2)",
                    "null": "YES",
                    "key": "",
                    "default": "0.00"
                },
                {
                    "field": "service_fee",
                    "type": "decimal(10,2)",
                    "null": "NO",
                    "key": "",
                    "default": "0.00"
                },
                {
                    "field": "courier_code",
                    "type": "varchar(50)",
                    "null": "YES",
                    "key": "",
                    "default": null
                },
                {
                    "field": "courier_service",
                    "type": "varchar(50)",
                    "null": "YES",
                    "key": "",
                    "default": null
                },
                {
                    "field": "tracking_number_api",
                    "type": "varchar(100)",
                    "null": "YES",
                    "key": "",
                    "default": null
                },
                {
                    "field": "created_at",
                    "type": "timestamp",
                    "null": "YES",
                    "key": "MUL",
                    "default": "current_timestamp()"
                },
                {
                    "field": "warung_promo_id",
                    "type": "int(11)",
                    "null": "YES",
                    "key": "MUL",
                    "default": null
                },
                {
                    "field": "warung_discount_amount",
                    "type": "decimal(15,2)",
                    "null": "YES",
                    "key": "",
                    "default": "0.00"
                }
            ]
        },
        "order_items": {
            "exists": true,
            "missing_cols": [],
            "db_columns": [
                {
                    "field": "id",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "PRI",
                    "default": null
                },
                {
                    "field": "order_id",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "MUL",
                    "default": null
                },
                {
                    "field": "product_id",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "MUL",
                    "default": null
                },
                {
                    "field": "jumlah",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "",
                    "default": null
                },
                {
                    "field": "harga_satuan",
                    "type": "decimal(10,2)",
                    "null": "NO",
                    "key": "",
                    "default": null
                },
                {
                    "field": "subtotal",
                    "type": "decimal(10,2)",
                    "null": "NO",
                    "key": "",
                    "default": null
                },
                {
                    "field": "variant_id",
                    "type": "int(11)",
                    "null": "YES",
                    "key": "MUL",
                    "default": null
                },
                {
                    "field": "variant_name",
                    "type": "varchar(255)",
                    "null": "YES",
                    "key": "",
                    "default": null
                },
                {
                    "field": "variant_price",
                    "type": "decimal(10,2)",
                    "null": "YES",
                    "key": "",
                    "default": "0.00"
                }
            ]
        },
        "cart_items": {
            "exists": true,
            "missing_cols": [],
            "db_columns": [
                {
                    "field": "id",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "PRI",
                    "default": null
                },
                {
                    "field": "user_id",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "MUL",
                    "default": null
                },
                {
                    "field": "product_id",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "MUL",
                    "default": null
                },
                {
                    "field": "quantity",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "",
                    "default": "1"
                },
                {
                    "field": "created_at",
                    "type": "timestamp",
                    "null": "YES",
                    "key": "",
                    "default": "current_timestamp()"
                },
                {
                    "field": "variant_id",
                    "type": "int(11)",
                    "null": "YES",
                    "key": "MUL",
                    "default": null
                }
            ]
        },
        "user_favorites": {
            "exists": true,
            "missing_cols": [],
            "db_columns": [
                {
                    "field": "id",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "PRI",
                    "default": null
                },
                {
                    "field": "user_id",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "MUL",
                    "default": null
                },
                {
                    "field": "product_id",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "MUL",
                    "default": null
                },
                {
                    "field": "created_at",
                    "type": "timestamp",
                    "null": "YES",
                    "key": "",
                    "default": "current_timestamp()"
                }
            ]
        },
        "user_addresses": {
            "exists": true,
            "missing_cols": [],
            "db_columns": [
                {
                    "field": "id",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "PRI",
                    "default": null
                },
                {
                    "field": "user_id",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "MUL",
                    "default": null
                },
                {
                    "field": "label",
                    "type": "varchar(50)",
                    "null": "NO",
                    "key": "",
                    "default": "Rumah"
                },
                {
                    "field": "address",
                    "type": "text",
                    "null": "NO",
                    "key": "",
                    "default": null
                },
                {
                    "field": "detail",
                    "type": "text",
                    "null": "YES",
                    "key": "",
                    "default": null
                },
                {
                    "field": "phone",
                    "type": "varchar(20)",
                    "null": "YES",
                    "key": "",
                    "default": null
                },
                {
                    "field": "is_primary",
                    "type": "tinyint(1)",
                    "null": "YES",
                    "key": "",
                    "default": "0"
                },
                {
                    "field": "created_at",
                    "type": "timestamp",
                    "null": "YES",
                    "key": "",
                    "default": "current_timestamp()"
                }
            ]
        },
        "notifications": {
            "exists": true,
            "missing_cols": [],
            "db_columns": [
                {
                    "field": "id",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "PRI",
                    "default": null
                },
                {
                    "field": "user_id",
                    "type": "int(11)",
                    "null": "NO",
                    "key": "MUL",
                    "default": null
                },
                {
                    "field": "type",
                    "type": "enum('order','promo','system')",
                    "null": "YES",
                    "key": "",
                    "default": "system"
                },
                {
                    "field": "title",
                    "type": "varchar(150)",
                    "null": "NO",
                    "key": "",
                    "default": null
                },
                {
                    "field": "message",
                    "type": "text",
                    "null": "NO",
                    "key": "",
                    "default": null
                },
                {
                    "field": "is_read",
                    "type": "tinyint(1)",
                    "null": "YES",
                    "key": "MUL",
                    "default": "0"
                },
                {
                    "field": "created_at",
                    "type": "timestamp",
                    "null": "YES",
                    "key": "",
                    "default": "current_timestamp()"
                }
            ]
        }
    },
    "extra_tables": [
        "akun_warung",
        "broadcasts",
        "chat_messages",
        "chat_rooms",
        "images",
        "jwt_blacklist",
        "login_attempts",
        "order_disputes",
        "owner_notifications",
        "payment_logs",
        "product_reviews",
        "product_variants",
        "reviews",
        "security_threat_logs",
        "superadmin",
        "superadmins",
        "support_tickets",
        "system_audit_log",
        "system_banners",
        "system_settings",
        "ticket_messages",
        "voucher_batches",
        "vouchers",
        "warung",
        "warung_promotions",
        "warung_verifications"
    ],
    "summary": {
        "total_required": 9,
        "missing_tables": [],
        "tables_with_missing_cols": [],
        "ok": [
            "users",
            "kategori",
            "products",
            "orders",
            "order_items",
            "cart_items",
            "user_favorites",
            "user_addresses",
            "notifications"
        ]
    }
}